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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=299 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0

Clear Filters

Mounting Type

,,713,,,714,,

Wall Mounted(1)

,,713,,,714,,

Wall Recessed(1)

Lamps Categories

,,698,698,697,,,698,697,,

LED SYSTEMS(2)

,,698,698,697,,,698,697,,

HALOGEN LAMPS(2)

Control gear

,,160,,,160,,

Remote electronic driver | On – Off | Dimmable DALI 2.0 – Casambi Ready | (2)

Housing

,,177,178,,,177,178,,

Pressed brass(2)

,,177,178,,,177,178,,

Pressed formed steel(2)

Diffuser

Reflector

Colors

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

Gold
-40(2)

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

Chrome
-50(2)

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

Nickel mat
-55(2)

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

Textured
Black
-08(2)

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

Textured
White
-09(2)

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

Textured
Grey
-35(2)

,,124,,,126,,

20(1)

,,124,,,126,,

40(1)

,,227,,,227,,

01(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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

PONOS

PONOS SQ 43 H.P.LED

PONOS SQ 46 IN H.P.LED

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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=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("160",Rat_MultipleSel4) <> 0 AND find_in_set("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON