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

Reading Lights

products / indoor /

SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=299 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=299 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0

Clear Filters

Mounting Type

,,714,,0,714,0,

Wall Recessed(2)

Lamps Categories

,,697,,0,696,0,

LED SYSTEMS(1)

,,697,,0,696,0,

LED LAMPS(1)

Control gear

,0,161,0,0,161,0,

Built-in electronic driver | On – Off | Dimmable DALI 2.0 – Casambi Ready | (2)

Housing

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

Pressed formed steel(2)

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

Extruded aluminium(2)

Diffuser

Reflector

Colors

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Gold
-40(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Chrome
-50(2)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Nickel mat
-55(2)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Copper
-26(1)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Textured
Black
-08(2)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Textured
White
-09(2)

,0,1673,1674,1675,100,101,0,0,1673,1674,1675,95,100,101,968,0,

Textured
Grey
-35(2)

,,126,,0,126,0,

40(2)

,,231,,0,231,0,

05(2)

SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 299 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 299 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=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101331 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101331 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101330 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101330 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101334 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101334 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

FERUS

FERUS 20 IN H.P.LED

FERUS 60

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101335 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101335 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101332 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101332 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101336 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101336 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101126 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101126 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101333 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101333 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101122 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101122 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101131 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101131 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101130 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101130 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101146 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101146 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101149 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101149 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101133 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101133 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101151 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101151 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101128 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101128 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101137 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101137 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101129 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101129 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101148 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101148 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101140 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101140 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101144 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101144 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101120 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101120 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101141 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101141 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101135 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101135 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101142 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101142 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101138 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101138 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101134 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101134 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101123 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101123 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101125 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101125 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101119 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101119 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101136 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101136 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101152 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101152 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101150 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101150 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101132 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101132 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101124 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101124 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101147 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101147 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101145 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101145 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101143 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101143 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101127 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101127 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101121 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101121 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101139 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=299 AND Page_ID='299' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101139 AND find_in_set("714",Rat_MultipleSel18) <> 0 AND find_in_set("182",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON