Suspended
Search
SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=323 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=323 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("700",Rat_MultipleSel17) <> 0
Mounting Type
,,712,,,710,712,,,712,,,712,,,712,,,710,712,713,,,712,,
,,712,,,710,712,,,712,,,712,,,712,,,710,712,713,,,712,,
Suspended(7)
,,712,,,710,712,,,712,,,712,,,712,,,710,712,713,,,712,,
Wall Mounted(1)
Lamps Categories
,,700,700,,,700,,,700,,,700,,,698,696,700,,,700,,,698,696,700,,
LED LAMPS(2)
,,700,700,,,700,,,700,,,700,,,698,696,700,,,700,,,698,696,700,,
,,700,700,,,700,,,700,,,700,,,698,696,700,,,700,,,698,696,700,,
Control gear
,,155,,,155,,,155,,,155,,,154,155,,0,1882,0,,154,155,,
,,155,,,155,,,155,,,155,,,154,155,,0,1882,0,,154,155,,
,,155,,,155,,,155,,,155,,,154,155,,0,1882,0,,154,155,,
Housing
,,182,,,182,,,182,,,182,,,45,182,,,182,,,45,182,,
,,182,,,182,,,182,,,182,,,45,182,,,182,,,45,182,,
Diffuser
,,167,,,,,,,167,,,
Reflector
Colors
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
-30
Grey(4)
Grey(4)
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
White(6)
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,0,1146,1937,1674,1673,1675,0,0,1937,1466,1930,1146,1919,0,0,94,1937,1466,1930,1146,1919,0,
Black(6)
IP
,,126,,0,124,0,,124,,,124,,,124,,,126,,0,124,0,
20(5)
,,126,,0,124,0,,124,,,124,,,124,,,126,,0,124,0,
40(2)
IK
SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 323 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 323 AND Related_Rec_ID=Rec_ID AND Related_Page_ID=Page_ID order by Rec_Order
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101611 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101611 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101585 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101585 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101584 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101584 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101683 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101683 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101681 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101681 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101682 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101682 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101686 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101686 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101687 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101687 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101685 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101685 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
NOTUS 17 | screen 48mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101684 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101684 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101689 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101689 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101688 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101688 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
NOTUS 11
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101690 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101690 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101691 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101691 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101692 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101692 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
NOTUS 9 | screen 177mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101587 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101587 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101258 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101258 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101588 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101588 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101586 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101586 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101582 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101582 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100960 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100960 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102044 AND find_in_set("700",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=323 AND Page_ID='323' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102044 AND find_in_set("700",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc