Ceiling
Search
SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=297 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=297 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("126",Rat_MultipleSel6) <> 0
Clear Filters
Mounting Type
,,712,,0,710,713,0,0,710,0,0,710,0,0,710,0,
,,712,,0,710,713,0,0,710,0,0,710,0,0,710,0,
Suspended(1)
,,712,,0,710,713,0,0,710,0,0,710,0,0,710,0,
Wall Mounted(1)
Lamps Categories
,,696,698,,0,697,0,0,696,698,0,0,696,698,0,0,697,0,
LED SYSTEMS(2)
,,696,698,,0,697,0,0,696,698,0,0,696,698,0,0,697,0,
LED LAMPS(3)
,,696,698,,0,697,0,0,696,698,0,0,696,698,0,0,697,0,
Control gear
,,0,154,0,,,0,728,0,
,,0,154,0,,,0,728,0,
Housing
,,178,,0,182,0,0,178,0,0,178,0,0,780,0,
,,178,,0,182,0,0,178,0,0,178,0,0,780,0,
,,178,,0,182,0,0,178,0,0,178,0,0,780,0,
Diffuser
,,174,,0,1398,0,0,174,0,0,174,0,0,1296,0,
Opal PMMA(1)
,,174,,0,1398,0,0,174,0,0,174,0,0,1296,0,
,,174,,0,1398,0,0,174,0,0,174,0,0,1296,0,
Opal glass(3)
Reflector
,,,,,0,783,0,
LED lens(1)
Colors
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
Gold
-40(3)
-40(3)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
-75
Titanium(3)
Titanium(3)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
-10
White(1)
White(1)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
-20
Black(1)
Black(1)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
-30
Grey(1)
Grey(1)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
Uncolored
-00(1)
-00(1)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
Copper
-26(3)
-26(3)
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
,0,1673,1674,1675,95,96,101,968,0,0,1937,1674,1673,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,968,0,0,92,93,94,1678,101,112,0,
Brass
-00(1)
-00(1)
IP
,,126,,0,126,0,0,126,0,0,126,0,0,126,0,
40(5)
IK
SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 297 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 297 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=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102496 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102496 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102465 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102465 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101296 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101296 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102467 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102467 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102598 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102598 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101293 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101293 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102776 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102776 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101876 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101876 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101066 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101066 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101295 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101295 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101290 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101290 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
MINI AVOLO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2486 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2486 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101058 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101058 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101289 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101289 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
AVOLO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101054 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101054 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101083 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101083 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
VISO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101292 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101292 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
COMIS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101063 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101063 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101062 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101062 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101078 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101078 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101081 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101081 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101461 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101461 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101065 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101065 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101060 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101060 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101291 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101291 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101069 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101069 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101294 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101294 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101061 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101061 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101080 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101080 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101072 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101072 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101076 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101076 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101052 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101052 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101073 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101073 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101067 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101067 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101074 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101074 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101070 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101070 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101055 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101055 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101057 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101057 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101051 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101051 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101068 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101068 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101084 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101084 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101082 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101082 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101064 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101064 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101056 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101056 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101079 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101079 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101077 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101077 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101075 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101075 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101059 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101059 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101053 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101053 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101071 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101071 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102559 AND find_in_set("126",Rat_MultipleSel6) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=297 AND Page_ID='297' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102559 AND find_in_set("126",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc