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("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("1674",Rat_MultipleSel9) <> 0

Clear Filters

Mounting Type

,,713,,,713,,,713,,,713,,,714,,,713,,,713,,,713,,,713,,,713,,,713,,,,713,,,713,,,713,,,713,,,713,,,714,,,713,,,713,,0,713,0,,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(25)

,,713,,,713,,,713,,,713,,,714,,,713,,,713,,,713,,,713,,,713,,,713,,,,713,,,713,,,713,,,713,,,713,,,714,,,713,,,713,,0,713,0,,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(3)

Lamps Categories

,,696,698,699,,,697,,,698,698,697,,,696,698,,,698,697,,,698,697,,,696,698,,,696,698,699,,,697,698,,,697,698,,,697,,,,698,,,697,698,,,697,,,698,,,698,,,697,,,697,,,697,,0,697,0,,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(17)

LED LAMPS(8)

COMPACT FLUORESCENT LAMPS(2)

HALOGEN LAMPS(13)

Control gear

,,,,161,,,160,,,161,,,160,,,161,,,161,,,,,161,,,,,161,,,,,,,,161,,,,0,161,0,0,161,0,,161,,0,1382,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,,,0,161,0,

Built-in electronic transformer / driver(1)

,,,,161,,,160,,,161,,,160,,,161,,,161,,,,,161,,,,,161,,,,,,,,161,,,,0,161,0,0,161,0,,161,,0,1382,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,,,0,161,0,

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

,,,,161,,,160,,,161,,,160,,,161,,,161,,,,,161,,,,,161,,,,,,,,161,,,,0,161,0,0,161,0,,161,,0,1382,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,,,0,161,0,

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

Housing

,,175,178,,,45,178,,,177,178,,,178,,,177,178,,,177,178,,,178,,,178,,,178,,,178,,,178,182,,0,178,182,0,,178,,,178,,,45,178,,,178,,,178,,,178,182,,,178,182,,,178,182,,0,178,182,0,0,178,182,0,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,0,0,178,0,0,178,182,0,

Pressed aluminium(1)

Cast-pressed brass(1)

Pressed brass(3)

Pressed formed steel(32)

Extruded aluminium(12)

Extruded brass(1)

Cast-pressed aluminium(5)

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

Gold
-40(20)

-75
Titanium(7)

Chrome
-50(17)

Nickel mat
-55(24)

-45
Bronze(1)

White/Gold(1)

White/Copper(1)

Black/Gold(1)

Black/Copper(1)

Textured
Anthracite
-163(1)

Uncolored
-00(2)

Copper
-26(11)

Yellow Matt
-330(2)

Textured
Black
-08(33)

Textured
White
-09(33)

Textured
Grey
-35(33)

Red Matt
-317(2)

Blue Matt
-308(2)

Beige
Matt
-210(2)

Green Matt
-329(2)

,,124,,,126,,,124,,,124,,,126,,,126,,,124,,,124,,,124,,,124,,,126,,0,124,0,,124,,,124,,,126,,,124,,,124,,,126,,,126,,,126,,0,124,0,0,124,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,0,124,0,0,124,0,0,126,0,

20(16)

40(17)

,,227,,,231,,,227,,,227,,,227,,,227,,,227,,,227,,,227,,,230,,,231,,0,230,0,,230,,,230,,,231,,,230,,,230,,,231,,,231,,,231,,0,231,0,0,230,0,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,230,0,0,230,0,0,231,0,

01(8)

04(10)

05(15)

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

PONOS

PONOS SQ 46 IN H.P.LED

PONOS SQ 46 OUT 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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("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("1674",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON