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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 0

Clear Filters

Mounting Type

,,713,,,713,,,713,,,713,,,713,,,713,,,713,,,714,,,713,,,713,,0,713,0,,0,713,0,0,713,0,0,714,0,0,713,0,0,713,0,0,713,0,0,713,0,

Wall Mounted(16)

,,713,,,713,,,713,,,713,,,713,,,713,,,713,,,714,,,713,,,713,,0,713,0,,0,713,0,0,713,0,0,714,0,0,713,0,0,713,0,0,713,0,0,713,0,

Wall Recessed(2)

Lamps Categories

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

LED SYSTEMS(12)

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

LED LAMPS(6)

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

HALOGEN LAMPS(4)

Control gear

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

Built-in electronic driver(19)

Housing

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Cast-pressed brass(1)

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Pressed brass(1)

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Pressed formed steel(18)

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Extruded aluminium(9)

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Extruded brass(1)

,,45,178,,,178,,,177,178,,,178,,,178,,,178,182,,,45,178,,,178,182,,,178,182,,,178,182,,0,45,178,0,0,45,178,0,0,176,780,0,0,178,182,0,0,178,182,0,0,178,182,0,0,178,182,0,0,45,178,0,0,178,182,0,

Cast-pressed aluminium(5)

Diffuser

Reflector

Colors

,0,1673,1674,1675,95,100,101,110,0,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,100,101,0,0,1673,1674,1675,100,101,0,0,1673,1674,1675,100,101,0,0,1673,1674,1675,100,101,0,0,1673,1674,1675,100,101,0,0,1673,1674,1675,0,0,1673,1674,1675,112,0,0,1673,1674,1675,112,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,100,101,968,0,0,1673,1674,1675,95,100,101,968,0,0,1673,1674,1675,0,0,1673,1674,1675,100,101,1598,1599,1600,1601,0,0,1673,1674,1675,95,96,101,968,0,

Gold
-40(9)

-75
Titanium(2)

Chrome
-50(13)

Nickel mat
-55(15)

-45
Bronze(1)

White/Gold(1)

White/Copper(1)

Black/Gold(1)

Black/Copper(1)

Uncolored
-00(2)

Copper
-26(4)

Textured
Black
-08(19)

Textured
White
-09(19)

Textured
Grey
-35(19)

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

20(3)

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

40(16)

,,231,,,227,,,227,,,227,,,227,,,231,,,231,,,231,,,231,,,231,,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,230,0,0,231,0,0,231,0,

01(4)

,,231,,,227,,,227,,,227,,,227,,,231,,,231,,,231,,,231,,,231,,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,230,0,0,231,0,0,231,0,

04(1)

,,231,,,227,,,227,,,227,,,227,,,231,,,231,,,231,,,231,,,231,,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,231,0,0,230,0,0,231,0,0,231,0,

05(14)

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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

FERUS

FERUS 20 IN SQ H.P.LED

FERUS 20 SQ H.P.LED

FERUS 20 SQ PA H.P.LED

FERUS 20 WALL 3

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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

PONOS

PONOS SQ 46 OUT H.P.LED

PONOS SQ 47 H.P.LED

PONOS SQ 49 H.P.LED

PONOS PA 42A 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 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("161",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON