Trimless
Search
SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=326 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=326 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> ''
Mounting Type
,,709,,,709,,,709,,,709,,,709,,,709,,0,709,0,0,709,0,0,709,0,0,709,0,0,709,0,0,710,0,0,709,0,0,709,0,,,,,,
Ceiling Recessed(13)
,,709,,,709,,,709,,,709,,,709,,,709,,0,709,0,0,709,0,0,709,0,0,709,0,0,709,0,0,710,0,0,709,0,0,709,0,,,,,,
Lamps Categories
,,698,696,,,700,,,697,,,,,697,,,697,,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,,,,,,
LED SYSTEMS(11)
,,698,696,,,700,,,697,,,,,697,,,697,,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,,,,,,
LED LAMPS(1)
,,698,696,,,700,,,697,,,,,697,,,697,,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,,,,,,
,,698,696,,,700,,,697,,,,,697,,,697,,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,,,,,,
Control gear
,,158,,,155,,,728,,,728,,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,158,0,0,158,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,161,0,0,1882,0,0,158,0,0,158,0,
,,158,,,155,,,728,,,728,,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,158,0,0,158,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,161,0,0,1882,0,0,158,0,0,158,0,
,,158,,,155,,,728,,,728,,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,158,0,0,158,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,161,0,0,1882,0,0,158,0,0,158,0,
,,158,,,155,,,728,,,728,,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,158,0,0,158,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,161,0,0,1882,0,0,158,0,0,158,0,
,,158,,,155,,,728,,,728,,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,158,0,0,158,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,1882,0,0,161,0,0,1882,0,0,158,0,0,158,0,
Housing
,,45,182,,,182,,,182,,,182,,,182,,,182,,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,
,,45,182,,,182,,,182,,,182,,,182,,,182,,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,
Diffuser
,,,,,,167,,,167,,0,1398,0,0,1398,0,0,1398,0,0,1398,0,0,167,0,0,167,0,0,167,0,0,167,0,0,167,0,0,167,0,,0,1398,0,0,1398,0,
,,,,,,167,,,167,,0,1398,0,0,1398,0,0,1398,0,0,1398,0,0,167,0,0,167,0,0,167,0,0,167,0,0,167,0,0,167,0,,0,1398,0,0,1398,0,
Reflector
,,,615,,,,,,,,,,,,,,,,0,1949,0,,,
,,,615,,,,,,,,,,,,,,,,0,1949,0,,,
Colors
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
Anoxal
Matt
-90(13)
Matt
-90(13)
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
-10
White(4)
White(4)
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
-20
Black(2)
Black(2)
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
White(13)
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
,0,1466,1930,98,0,0,1466,1930,98,0,,92,93,98,,,92,93,98,,0,1466,1930,98,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,98,1674,1673,0,0,98,1674,1673,0,0,1466,1930,98,0,0,1466,1930,98,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1937,1466,1930,0,0,1466,1930,98,0,0,1466,1930,98,0,0,92,0,0,92,0,
Black(13)
IP
,,124,,,124,,,124,,,124,,,126,,,126,,0,944,0,0,944,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,127,0,0,127,0,0,124,0,0,126,0,0,126,0,
20(5)
,,124,,,124,,,124,,,124,,,126,,,126,,0,944,0,0,944,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,127,0,0,127,0,0,124,0,0,126,0,0,126,0,
40(10)
,,124,,,124,,,124,,,124,,,126,,,126,,0,944,0,0,944,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,127,0,0,127,0,0,124,0,0,126,0,0,126,0,
44(2)
,,124,,,124,,,124,,,124,,,126,,,126,,0,944,0,0,944,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,126,0,0,127,0,0,127,0,0,124,0,0,126,0,0,126,0,
54(2)
IK
SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 326 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 326 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=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101591 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101591 order by Rec_Order ASC,Rec_Title Asc
FUGA
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101742 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101742 order by Rec_Order ASC,Rec_Title Asc
NOTUS 25 | screen 46mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101743 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101743 order by Rec_Order ASC,Rec_Title Asc
NOTUS 16 | screen 54mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101744 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101744 order by Rec_Order ASC,Rec_Title Asc
NOTUS 3 | screen 82mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101745 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101745 order by Rec_Order ASC,Rec_Title Asc
NOTUS 1 | screen 85mm
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101746 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101746 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101747 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101747 order by Rec_Order ASC,Rec_Title Asc
COMIS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101593 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101593 order by Rec_Order ASC,Rec_Title Asc
NOVUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101592 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=326 AND Page_ID='326' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101592 order by Rec_Order ASC,Rec_Title Asc