About us
Products
New Products
Lighting Tool
Catalogues
Design Lighting
Lighting News
Press Releases
Projects
Bright Plus
Bright Lab
Contact Us

Ceiling

products / indoor /

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0

Clear Filters

Mounting Type

,,709,710,713,,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,

Ceiling Recessed(1)

,,709,710,713,,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,

Ceiling Mounted(6)

,,709,710,713,,0,710,0,0,710,0,0,710,0,0,710,0,0,710,0,

Wall Mounted(1)

Lamps Categories

,,698,696,,0,696,0,0,696,698,0,0,696,0,0,697,0,0,698,696,0,

LED SYSTEMS(1)

,,698,696,,0,696,0,0,696,698,0,0,696,0,0,697,0,0,698,696,0,

LED LAMPS(5)

,,698,696,,0,696,0,0,696,698,0,0,696,0,0,697,0,0,698,696,0,

HALOGEN LAMPS(3)

Control gear

,,0,154,0,,,0,728,0,,

Built-in electronic transformer(1)

,,0,154,0,,,0,728,0,,

Built-in electronic driver (1)

Housing

,,178,,0,182,0,0,178,0,0,182,0,0,780,0,0,178,0,

Pressed formed steel(3)

,,178,,0,182,0,0,178,0,0,182,0,0,780,0,0,178,0,

Extruded aluminium(2)

,,178,,0,182,0,0,178,0,0,182,0,0,780,0,0,178,0,

Extruded brass(1)

Diffuser

,,,0,174,0,,0,1296,0,0,174,0,

Opal PMMA(1)

,,,0,174,0,,0,1296,0,0,174,0,

Opal glass(2)

Reflector

,,,,,0,783,0,,

LED lens(1)

Colors

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Gold
-40(3)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

-75
Titanium(2)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Chrome
-50(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Nickel mat
-55(6)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

-10
White(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

-20
Black(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

-30
Grey(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Uncolored
-00(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Copper
-26(4)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Textured
Black
-08(5)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Textured
White
-09(5)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Textured
Grey
-35(5)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,101,968,0,0,92,93,94,1678,101,112,0,0,96,968,95,101,1674,1673,1675,0,

Brass
-00(1)

,,124,,0,124,0,0,126,0,0,124,0,0,126,0,0,124,0,

20(4)

,,124,,0,124,0,0,126,0,0,124,0,0,126,0,0,124,0,

40(2)

,,229,,0,230,0,0,228,0,0,230,0,0,588,0,0,228,0,

02(2)

,,229,,0,230,0,0,228,0,0,230,0,0,588,0,0,228,0,

03(1)

,,229,,0,230,0,0,228,0,0,230,0,0,588,0,0,228,0,

04(2)

,,229,,0,230,0,0,228,0,0,230,0,0,588,0,0,228,0,

07(1)

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

VALEO

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

TORRIS

TORRIS 3 CEILING

TORRIS 3 CEILING LUX

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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=2486 AND find_in_set("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

AVOLO

AVOLO M A 4F

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

VISO

VISO 3 SP MINI 2F

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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=101063 AND find_in_set("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

FERUS

FERUS 3 STK

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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 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("101",Rat_MultipleSel9) <> 0 AND find_in_set("710",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON