Downlights
Search
SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=58 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=58 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0
Clear Filters
Mounting Type
,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,0,709,0,
Ceiling Recessed(15)
Lamps Categories
,,698,698,696,699,,,696,697,698,,,696,697,698,699,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,698,698,696,696,,,696,697,698,,,696,698,701,,,696,697,698,,,696,697,,,696,697,,0,696,697,0,
LED SYSTEMS(12)
,,698,698,696,699,,,696,697,698,,,696,697,698,699,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,698,698,696,696,,,696,697,698,,,696,698,701,,,696,697,698,,,696,697,,,696,697,,0,696,697,0,
LED LAMPS(15)
,,698,698,696,699,,,696,697,698,,,696,697,698,699,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,698,698,696,696,,,696,697,698,,,696,698,701,,,696,697,698,,,696,697,,,696,697,,0,696,697,0,
,,698,698,696,699,,,696,697,698,,,696,697,698,699,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,698,698,696,696,,,696,697,698,,,696,698,701,,,696,697,698,,,696,697,,,696,697,,0,696,697,0,
,,698,698,696,699,,,696,697,698,,,696,697,698,699,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,696,697,698,,,698,698,696,696,,,696,697,698,,,696,698,701,,,696,697,698,,,696,697,,,696,697,,0,696,697,0,
HALOGEN LAMPS(12)
Control gear
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
,,,158,159,,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,158,159,,,157,160,,0,1383,0,,160,,,160,,0,161,0,
Housing
,,45,175,,,178,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,178,,,45,182,,,45,178,,,45,,,45,,0,178,0,
,,45,175,,,178,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,178,,,45,182,,,45,178,,,45,,,45,,0,178,0,
,,45,175,,,178,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,178,,,45,182,,,45,178,,,45,,,45,,0,178,0,
,,45,175,,,178,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,178,,,45,182,,,45,178,,,45,,,45,,0,178,0,
Diffuser
,,,,172,,,,,,,,,164,,,,,,166,,,166,,0,167,0,
,,,,172,,,,,,,,,164,,,,,,166,,,166,,0,167,0,
,,,,172,,,,,,,,,164,,,,,,166,,,166,,0,167,0,
,,,,172,,,,,,,,,164,,,,,,166,,,166,,0,167,0,
Reflector
,,220,,,,,,,,,,,,,,623,,,623,,,
,,220,,,,,,,,,,,,,,623,,,623,,,
Colors
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
Gold
-40(2)
-40(2)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
Chrome
-50(9)
-50(9)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
-60
Gold matt(1)
Gold matt(1)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
-10
White(10)
White(10)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
-20
Black(9)
Black(9)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
-30
Grey(9)
Grey(9)
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,92,0,
IP
,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,624,,,624,,0,124,0,
20(13)
,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,624,,,624,,0,124,0,
23(2)
IK
,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,0,230,0,
04(15)
SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 58 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 58 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=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6661 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6661 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6662 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6662 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6681 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6681 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6682 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6682 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6739 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6739 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6740 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6740 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6799 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6799 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6800 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6800 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6981 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6981 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6982 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6982 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7209 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7209 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7210 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7210 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7695 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7695 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7696 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7696 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=8279 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=8279 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=8280 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=8280 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=9741 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=9741 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=9742 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=9742 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=11669 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=11669 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=11670 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=11670 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=17583 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=17583 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=17584 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=17584 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=26101 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=26101 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=26102 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=26102 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=53299 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=53299 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=53300 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=53300 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=80473 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=80473 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=80474 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=80474 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101859 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101859 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102036 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102036 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102288 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102288 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2443 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2443 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102707 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102707 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6002 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6002 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102052 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102052 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101601 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101601 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2446 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2446 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
ARTUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2448 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2448 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
MOBILIS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2447 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2447 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2606 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2606 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100918 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100918 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2445 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2445 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
JAZZ
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6003 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6003 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6394 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6394 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2450 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2450 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6536 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6536 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102287 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102287 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6119 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6119 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2561 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2561 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100917 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100917 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2451 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2451 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
ORBIS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2452 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2452 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SITUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2453 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2453 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
TALUS
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2454 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2454 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2455 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2455 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2456 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2456 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2457 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2457 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2466 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2466 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2459 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2459 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2458 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2458 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2460 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2460 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
HONOR
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2461 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2461 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6004 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6004 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6378 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6378 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102542 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102542 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
POSCO
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2464 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2464 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2465 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2465 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2462 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2462 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2463 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2463 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2468 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2468 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2469 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2469 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2449 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2449 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc
SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2467 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2467 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("696",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc