Ceiling Mounted Lights
Search
SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=62 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=62 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0
Clear Filters
Mounting Type
,,710,,,710,,,710,,,710,,,710,,0,710,0,,710,,0,710,0,0,710,0,,710,,,710,,,710,,,710,,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,712,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,
Ceiling Mounted(31)
,,710,,,710,,,710,,,710,,,710,,0,710,0,,710,,0,710,0,0,710,0,,710,,,710,,,710,,,710,,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,712,0,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,
Suspended(1)
Lamps Categories
,,698,698,696,,,698,696,,0,696,698,0,,698,696,699,,0,696,698,0,0,697,0,,698,696,,0,697,0,0,697,0,,696,698,,,696,698,,,696,698,,,697,,0,696,698,0,0,696,698,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,
LED SYSTEMS(16)
,,698,698,696,,,698,696,,0,696,698,0,,698,696,699,,0,696,698,0,0,697,0,,698,696,,0,697,0,0,697,0,,696,698,,,696,698,,,696,698,,,697,,0,696,698,0,0,696,698,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,
LED LAMPS(15)
,,698,698,696,,,698,696,,0,696,698,0,,698,696,699,,0,696,698,0,0,697,0,,698,696,,0,697,0,0,697,0,,696,698,,,696,698,,,696,698,,,697,,0,696,698,0,0,696,698,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,
,,698,698,696,,,698,696,,0,696,698,0,,698,696,699,,0,696,698,0,0,697,0,,698,696,,0,697,0,0,697,0,,696,698,,,696,698,,,696,698,,,697,,0,696,698,0,0,696,698,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,0,697,0,0,697,0,0,697,0,0,697,0,0,696,0,0,696,0,0,697,0,
HALOGEN LAMPS(11)
Control gear
,,154,,,,,,,156,,0,154,0,0,161,0,,,,161,,0,728,0,,,,,728,,,,0,161,0,0,161,0,0,161,0,0,160,0,0,160,0,0,160,0,,,0,160,0,0,161,0,0,161,0,0,161,0,0,161,0,0,154,0,,,
,,154,,,,,,,156,,0,154,0,0,161,0,,,,161,,0,728,0,,,,,728,,,,0,161,0,0,161,0,0,161,0,0,160,0,0,160,0,0,160,0,,,0,160,0,0,161,0,0,161,0,0,161,0,0,161,0,0,154,0,,,
,,154,,,,,,,156,,0,154,0,0,161,0,,,,161,,0,728,0,,,,,728,,,,0,161,0,0,161,0,0,161,0,0,160,0,0,160,0,0,160,0,,,0,160,0,0,161,0,0,161,0,0,161,0,0,161,0,0,154,0,,,
,,154,,,,,,,156,,0,154,0,0,161,0,,,,161,,0,728,0,,,,,728,,,,0,161,0,0,161,0,0,161,0,0,160,0,0,160,0,0,160,0,,,0,160,0,0,161,0,0,161,0,0,161,0,0,161,0,0,154,0,,,
,,154,,,,,,,156,,0,154,0,0,161,0,,,,161,,0,728,0,,,,,728,,,,0,161,0,0,161,0,0,161,0,0,160,0,0,160,0,0,160,0,,,0,160,0,0,161,0,0,161,0,0,161,0,0,161,0,0,154,0,,,
Housing
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
ABS(1)
,,45,,,175,,,175,,,182,,,182,,0,182,0,,182,,,182,,0,182,0,,182,,,182,,,45,182,,,45,175,,0,45,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,182,0,0,175,0,0,175,0,0,45,0,0,45,0,0,1532,0,0,1868,0,0,45,0,0,182,0,0,182,0,0,178,0,
Aluminium(1)
Diffuser
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
Opal PMMA(3)
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
,,,,,5,,,0,614,0,,5,164,,0,614,0,,5,,,5,164,,,,,,,0,614,0,0,614,0,0,1899,0,0,1899,0,0,1899,0,0,1899,0,,,0,1296,0,0,1296,0,0,1296,0,0,2233,0,0,1899,0,,,0,169,0,
Reflector
,,,,,,0,806,0,,0,1083,0,0,1168,0,,,,,1168,,,,0,806,0,0,806,0,0,1901,0,0,1901,0,0,1901,0,0,1901,0,,,0,1198,0,0,1198,0,,,0,1901,0,,,,
,,,,,,0,806,0,,0,1083,0,0,1168,0,,,,,1168,,,,0,806,0,0,806,0,0,1901,0,0,1901,0,0,1901,0,0,1901,0,,,0,1198,0,0,1198,0,,,0,1901,0,,,,
,,,,,,0,806,0,,0,1083,0,0,1168,0,,,,,1168,,,,0,806,0,0,806,0,0,1901,0,0,1901,0,0,1901,0,0,1901,0,,,0,1198,0,0,1198,0,,,0,1901,0,,,,
,,,,,,0,806,0,,0,1083,0,0,1168,0,,,,,1168,,,,0,806,0,0,806,0,0,1901,0,0,1901,0,0,1901,0,0,1901,0,,,0,1198,0,0,1198,0,,,0,1901,0,,,,
Asymmetric(2)
,,,,,,0,806,0,,0,1083,0,0,1168,0,,,,,1168,,,,0,806,0,0,806,0,0,1901,0,0,1901,0,0,1901,0,0,1901,0,,,0,1198,0,0,1198,0,,,0,1901,0,,,,
Colors
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
Gold
-40(3)
-40(3)
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
Chrome
-50(2)
-50(2)
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
Copper
-26(2)
-26(2)
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
Textured
Black
-08(31)
Black
-08(31)
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
Textured
Grey
-35(29)
Grey
-35(29)
,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,100,101,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1673,1674,1675,95,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1673,1674,1675,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,0,0,1674,1673,0,0,1674,1673,1675,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,101,968,0,0,1696,111,1674,1673,1675,0,
IP
,,124,,,124,,,124,,,124,,0,124,0,0,124,0,,126,,,124,,0,124,0,,126,,,124,,,124,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,,0,126,0,0,124,0,0,124,0,0,124,0,0,124,0,
20(27)
,,124,,,124,,,124,,,124,,0,124,0,0,124,0,,126,,,124,,0,124,0,,126,,,124,,,124,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,,0,126,0,0,124,0,0,124,0,0,124,0,0,124,0,
40(3)
IK
,,229,,,228,,,228,,,229,,0,588,0,0,588,0,,229,,0,588,0,0,229,0,,229,,,229,,,229,,0,230,0,0,582,0,0,228,0,0,229,0,0,228,0,0,230,0,0,230,0,0,230,0,0,230,0,0,582,0,0,582,0,0,230,0,0,230,0,,,0,230,0,0,230,0,0,230,0,0,229,0,
02(4)
,,229,,,228,,,228,,,229,,0,588,0,0,588,0,,229,,0,588,0,0,229,0,,229,,,229,,,229,,0,230,0,0,582,0,0,228,0,0,229,0,0,228,0,0,230,0,0,230,0,0,230,0,0,230,0,0,582,0,0,582,0,0,230,0,0,230,0,,,0,230,0,0,230,0,0,230,0,0,229,0,
03(9)
,,229,,,228,,,228,,,229,,0,588,0,0,588,0,,229,,0,588,0,0,229,0,,229,,,229,,,229,,0,230,0,0,582,0,0,228,0,0,229,0,0,228,0,0,230,0,0,230,0,0,230,0,0,230,0,0,582,0,0,582,0,0,230,0,0,230,0,,,0,230,0,0,230,0,0,230,0,0,229,0,
04(10)
,,229,,,228,,,228,,,229,,0,588,0,0,588,0,,229,,0,588,0,0,229,0,,229,,,229,,,229,,0,230,0,0,582,0,0,228,0,0,229,0,0,228,0,0,230,0,0,230,0,0,230,0,0,230,0,0,582,0,0,582,0,0,230,0,0,230,0,,,0,230,0,0,230,0,0,230,0,0,229,0,
06(3)
,,229,,,228,,,228,,,229,,0,588,0,0,588,0,,229,,0,588,0,0,229,0,,229,,,229,,,229,,0,230,0,0,582,0,0,228,0,0,229,0,0,228,0,0,230,0,0,230,0,0,230,0,0,230,0,0,582,0,0,582,0,0,230,0,0,230,0,,,0,230,0,0,230,0,0,230,0,0,229,0,
07(3)
SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 62 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 62 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=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101858 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101858 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
BENE
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102428 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102428 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SONO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102581 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102581 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101444 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101444 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101713 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101713 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102497 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102497 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
CURA
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' 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("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101876 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101838 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101838 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' 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("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2486 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
PENDO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' 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("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101293 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
FIRMUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101445 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101445 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' 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("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101066 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2488 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2488 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
ROLLY
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' 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("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101295 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
TORRIS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2487 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2487 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
ROLLER
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102357 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102357 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
FIGO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2484 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2484 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SALUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2485 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2485 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2491 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2491 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102066 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102066 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2492 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=62 AND Page_ID='62' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2492 AND find_in_set("710",Rat_MultipleSel18) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc