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("124",Rat_MultipleSel6) <> 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("124",Rat_MultipleSel6) <> 0

Clear Filters

Mounting Type

,,713,,,713,,,713,,,713,,,713,,,713,,,713,,,,713,,,713,,,713,,,713,,0,713,0,,,,0,713,0,

Wall Mounted(13)

Lamps Categories

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

LED SYSTEMS(5)

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

LED LAMPS(5)

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

COMPACT FLUORESCENT LAMPS(2)

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

HALOGEN LAMPS(11)

Control gear

,,,,160,,,161,,,161,,,,,161,,,,,,,,,,,0,1382,0,,,,,

Built-in electronic transformer / driver(1)

,,,,160,,,161,,,161,,,,,161,,,,,,,,,,,0,1382,0,,,,,

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

,,,,160,,,161,,,161,,,,,161,,,,,,,,,,,0,1382,0,,,,,

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

Housing

,,175,178,,,177,178,,,178,,,178,,,178,,,178,,,178,,0,178,182,0,,178,,,178,,,178,,,178,,0,178,182,0,0,178,182,0,0,178,0,0,178,0,0,1868,0,

Pressed aluminium(1)

,,175,178,,,177,178,,,178,,,178,,,178,,,178,,,178,,0,178,182,0,,178,,,178,,,178,,,178,,0,178,182,0,0,178,182,0,0,178,0,0,178,0,0,1868,0,

Pressed brass(1)

,,175,178,,,177,178,,,178,,,178,,,178,,,178,,,178,,0,178,182,0,,178,,,178,,,178,,,178,,0,178,182,0,0,178,182,0,0,178,0,0,178,0,0,1868,0,

Pressed formed steel(16)

,,175,178,,,177,178,,,178,,,178,,,178,,,178,,,178,,0,178,182,0,,178,,,178,,,178,,,178,,0,178,182,0,0,178,182,0,0,178,0,0,178,0,0,1868,0,

Extruded aluminium(3)

,,175,178,,,177,178,,,178,,,178,,,178,,,178,,,178,,0,178,182,0,,178,,,178,,,178,,,178,,0,178,182,0,0,178,182,0,0,178,0,0,178,0,0,1868,0,

Aluminium(1)

Diffuser

,,,,,,,,1030,,,,1030,,,1030,,,1030,,,1030,,,,,,,

Lampshade fabric(5)

Reflector

Colors

,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,95,100,101,0,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,95,96,101,968,0,0,1673,1674,1675,0,0,1673,1674,1675,95,968,0,0,1698,1673,1674,1699,1700,1701,1702,1675,0,0,1698,1673,1674,1699,1700,1701,1702,1675,0,0,1930,1466,0,

Gold
-40(13)

-75
Titanium(5)

Chrome
-50(6)

Nickel mat
-55(11)

Copper
-26(7)

White(1)

Yellow Matt
-330(2)

Textured
Black
-08(16)

Textured
White
-09(16)

Textured
Grey
-35(16)

Red Matt
-317(2)

Blue Matt
-308(2)

Beige
Matt
-210(2)

Green Matt
-329(2)

Black(1)

,,124,,,124,,,124,,,124,,,124,,,124,,,124,,0,124,0,,124,,,124,,,124,,,124,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,

20(17)

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

01(6)

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

04(9)

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

05(1)

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

CUP

CUP WALL 3

CUP WALL SMALL 3

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

ARIES

ARIES WALL 1

ARIES WALL 2

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("124",Rat_MultipleSel6) <> 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("124",Rat_MultipleSel6) <> 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=102963 AND find_in_set("124",Rat_MultipleSel6) <> 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=102963 AND find_in_set("124",Rat_MultipleSel6) <> 0 order by Rec_Order ASC,Rec_Title Asc

VALLO

VALLO 5 SPOT ►

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

PENNA

PENNA 10

PENNA 10 + FERUS H.P.LED

PENNA 10 1F H.P.LED

PENNA 12 WALL

PENNA 13

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

COMIS

COMIS 4 FERUS 20 SQUARE

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

PONOS

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

Site by OVERRON