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

Downlights

products / indoor /

SELECT * FROM pages,records WHERE Page_Section= 'indoor' AND Page_ID=58 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'indoor' AND Page_ID=58 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0

Clear Filters

Mounting Type

,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,,709,,,709,,,,,0,709,0,0,709,0,0,709,0,

Ceiling Recessed(17)

Lamps Categories

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

LED SYSTEMS(6)

LED LAMPS(10)

DISCHARGE LAMPS(1)

COMPACT FLUORESCENT LAMPS(4)

HALOGEN LAMPS(16)

Control gear

,,158,,,158,159,,,158,159,,,158,159,,,158,,,158,,,158,,,158,159,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,0,158,0,0,158,0,0,158,0,0,158,0,0,158,0,0,158,0,

Remote electronic transformer(21)

,,158,,,158,159,,,158,159,,,158,159,,,158,,,158,,,158,,,158,159,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,0,158,0,0,158,0,0,158,0,0,158,0,0,158,0,0,158,0,

Remote magnetic transformer(4)

Housing

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

Pressed formed steel(3)

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

Extruded aluminium(1)

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

Cast-pressed aluminium(17)

Diffuser

,,,,,164,,,,,,164,,,,172,,,,,,,,,,,,,

Safety glass sandblast(2)

,,,,,164,,,,,,164,,,,172,,,,,,,,,,,,,

Decorative sandblast glass(1)

Reflector

,,,,,,,,,,,,,,,,,,,0,1956,0,0,1956,0,0,783,0,

LED lens(1)

,,,,,,,,,,,,,,,,,,,0,1956,0,0,1956,0,0,783,0,

20°, 40°, 60°(2)

Colors

,,92,93,94,95,100,101,102,103,,0,92,93,94,95,100,101,102,103,0,,92,93,94,95,100,101,,,92,93,94,95,100,101,,0,1673,1674,1675,95,100,101,0,0,95,100,101,96,1674,1673,1675,0,0,95,100,101,96,1674,1673,1675,0,,92,93,94,95,100,101,,,92,93,94,95,100,101,,,92,93,94,95,100,101,,0,1673,1674,1675,95,100,101,0,0,1673,1674,1675,95,0,0,1673,1674,1675,95,0,0,1673,1674,1675,95,0,0,1673,1674,1675,95,0,0,1673,1674,1675,95,968,1596,1598,1599,1600,1601,0,0,1673,1674,1675,95,968,1596,1598,1599,1600,1601,0,0,1673,1674,1675,95,968,1596,1598,1599,1600,1601,0,0,95,1674,1673,1675,0,0,95,1674,1673,1675,0,0,95,1674,1673,1675,0,

Gold
-40(21)

-75
Titanium(2)

Chrome
-50(11)

Nickel mat
-55(11)

-60
Gold matt(2)

-70
Chrome matt(2)

White/Black(3)

White/Gold(3)

White/Copper(3)

Black/Gold(3)

Black/Copper(3)

-10
White(7)

-20
Black(7)

-30
Grey(7)

Copper
-26(3)

Textured
Black
-08(14)

Textured
White
-09(14)

Textured
Grey
-35(14)

,,124,,,124,,,,,124,,,124,,,124,,,124,,,606,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,

20(19)

,,124,,,124,,,,,124,,,124,,,124,,,124,,,606,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,

30(1)

,,229,,,231,,,229,,,230,,,230,,,231,,,231,,,229,,,230,,,229,,,231,,,582,,,582,,,582,,,582,,0,582,0,0,582,0,0,582,0,0,231,0,0,231,0,0,231,0,

03(4)

,,229,,,231,,,229,,,230,,,230,,,231,,,231,,,229,,,230,,,229,,,231,,,582,,,582,,,582,,,582,,0,582,0,0,582,0,0,582,0,0,231,0,0,231,0,0,231,0,

04(3)

,,229,,,231,,,229,,,230,,,230,,,231,,,231,,,229,,,230,,,229,,,231,,,582,,,582,,,582,,,582,,0,582,0,0,582,0,0,582,0,0,231,0,0,231,0,0,231,0,

05(7)

,,229,,,231,,,229,,,230,,,230,,,231,,,231,,,229,,,230,,,229,,,231,,,582,,,582,,,582,,,582,,0,582,0,0,582,0,0,582,0,0,231,0,0,231,0,0,231,0,

06(7)

SELECT * FROM pages,records WHERE Page_Section = 'Series' AND Page_GenVar= 58 AND Rec_Page_ID=Page_ID UNION SELECT pages.*,records.* FROM pages,records,related_pages WHERE Page_Section='Series' AND Page_GenVar= 58 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=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6661 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6661 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6662 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6662 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6681 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6681 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6682 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6682 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6739 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6739 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6740 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6740 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6799 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6799 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6800 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6800 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6981 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6981 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6982 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6982 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7209 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7209 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7210 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7210 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7695 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7695 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=7696 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=7696 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=8279 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=8279 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=8280 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=8280 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=9741 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=9741 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=9742 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=9742 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=11669 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=11669 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=11670 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=11670 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=17583 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=17583 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=17584 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=17584 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=26101 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=26101 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=26102 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=26102 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=53299 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=53299 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=53300 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=53300 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=80473 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=80473 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=80474 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=80474 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101859 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101859 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102036 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102036 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102288 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102288 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

LEGATUS

LEGATUS SPOT 20 IN

LEGATUS SPOT 25 IN

LEGATUS SPOT 25 L IN

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2443 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2443 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

STELLA

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102707 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102707 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6002 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6002 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102052 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102052 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=101601 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=101601 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2446 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2446 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2448 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2448 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

MOBILIS

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2447 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2447 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2606 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2606 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100918 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100918 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2445 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2445 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6003 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6003 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6394 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6394 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2450 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2450 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

FIXUS

MINI FIXUS

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6536 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6536 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102287 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102287 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6119 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6119 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2561 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2561 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100917 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100917 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2451 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2451 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2452 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2452 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SITUS

SITUS 01

SITUS 04

SITUS CROSS

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2453 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2453 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2454 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2454 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2455 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2455 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2456 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2456 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2457 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2457 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2466 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2466 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2459 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2459 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2458 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2458 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2460 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2460 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2461 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2461 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6004 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6004 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=6378 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=6378 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=102542 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=102542 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2464 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2464 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2465 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2465 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2462 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2462 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2463 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2463 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2468 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2468 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2469 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2469 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2449 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2449 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=2467 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'indoor' AND Page_ID=58 AND Page_ID='58' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=2467 AND find_in_set("95",Rat_MultipleSel9) <> 0 AND find_in_set("158",Rat_MultipleSel4) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON