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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 0

Mounting Type

,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,,709,,,,,,,,,,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,709,,,,709,,,709,,

Ceiling Recessed(39)

Lamps Categories

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

LED SYSTEMS(32)

LED LAMPS(41)

DISCHARGE LAMPS(18)

COMPACT FLUORESCENT LAMPS(52)

HALOGEN LAMPS(38)

Control gear

,,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,160,,,,,,,0,160,0,,,,,158,,,157,163,,,155,,,155,,,,,,,,,,,,,,158,,,158,,,160,,,157,163,,,157,,,157,,,157,,,160,,,160,,,158,,,,,158,,,158,,,158,,

Built-in electronic ballast(2)

,,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,160,,,,,,,0,160,0,,,,,158,,,157,163,,,155,,,155,,,,,,,,,,,,,,158,,,158,,,160,,,157,163,,,157,,,157,,,157,,,160,,,160,,,158,,,,,158,,,158,,,158,,

Remote electronic ballast(5)

,,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,160,,,,,,,0,160,0,,,,,158,,,157,163,,,155,,,155,,,,,,,,,,,,,,158,,,158,,,160,,,157,163,,,157,,,157,,,157,,,160,,,160,,,158,,,,,158,,,158,,,158,,

Remote electronic transformer(15)

,,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,160,,,,,,,0,160,0,,,,,158,,,157,163,,,155,,,155,,,,,,,,,,,,,,158,,,158,,,160,,,157,163,,,157,,,157,,,157,,,160,,,160,,,158,,,,,158,,,158,,,158,,

Remote electronic driver(5)

,,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,158,,,160,,,,,,,0,160,0,,,,,158,,,157,163,,,155,,,155,,,,,,,,,,,,,,158,,,158,,,160,,,157,163,,,157,,,157,,,157,,,160,,,160,,,158,,,,,158,,,158,,,158,,

Remote magnetic ballast(2)

Housing

,,45,175,,,45,175,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,178,,,45,178,,,45,180,,,45,180,,,45,180,,,45,180,,,45,180,,,45,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,180,,,180,,,180,,,180,,,180,,,180,,,180,,,180,,,180,,,180,,,180,,,45,178,,,45,178,,,45,178,,,45,,,45,,,45,,,45,,,45,178,,,45,178,,,45,,,180,,,180,,,45,,,45,,,45,,

Pressed aluminium(2)

Pressed formed steel(9)

Plaster(18)

Cast-pressed aluminium(35)

Diffuser

,,,,,,,,,,,,,,5,164,,,,,,,,,172,,,,,,,,,,,,,,,,,,,0,1408,0,,164,,,166,,,5,,,164,,,,,,,,,,

PMMA Lenses(1)

,,,,,,,,,,,,,,5,164,,,,,,,,,172,,,,,,,,,,,,,,,,,,,0,1408,0,,164,,,166,,,5,,,164,,,,,,,,,,

Safety glass clear(2)

,,,,,,,,,,,,,,5,164,,,,,,,,,172,,,,,,,,,,,,,,,,,,,0,1408,0,,164,,,166,,,5,,,164,,,,,,,,,,

Safety glass sandblast(3)

,,,,,,,,,,,,,,5,164,,,,,,,,,172,,,,,,,,,,,,,,,,,,,0,1408,0,,164,,,166,,,5,,,164,,,,,,,,,,

Prismatic glass (white optic)(1)

,,,,,,,,,,,,,,5,164,,,,,,,,,172,,,,,,,,,,,,,,,,,,,0,1408,0,,164,,,166,,,5,,,164,,,,,,,,,,

Decorative sandblast glass(1)

Reflector

,,220,,,220,,,,,,,,,,,,,213,,,,,,,,,,,623,,,215,,,215,,,,,,,,,,,,,,,,,623,,,623,,,623,,,623,,,,,,,,,,

Round matt aluminium(1)

,,220,,,220,,,,,,,,,,,,,213,,,,,,,,,,,623,,,215,,,215,,,,,,,,,,,,,,,,,623,,,623,,,623,,,623,,,,,,,,,,

Double indirect white(2)

,,220,,,220,,,,,,,,,,,,,213,,,,,,,,,,,623,,,215,,,215,,,,,,,,,,,,,,,,,623,,,623,,,623,,,623,,,,,,,,,,

Round white aluminium(2)

,,220,,,220,,,,,,,,,,,,,213,,,,,,,,,,,623,,,215,,,215,,,,,,,,,,,,,,,,,623,,,623,,,623,,,623,,,,,,,,,,

Vacuum aluminium(5)

Colors

,0,1673,1674,1675,0,0,1673,1674,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,1674,1673,1675,0,,92,93,94,,,92,93,94,,,92,,,92,,,92,,,92,,,92,,,92,93,94,95,100,101,102,103,,,92,93,94,100,101,,,92,93,94,,,92,93,94,95,100,101,102,103,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,,92,,,92,,,,,,,,,,,,,,,,,,,,,,,92,93,94,,,92,93,94,,0,1674,1673,1675,0,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,95,100,101,1674,1673,1675,0,0,95,100,101,1674,1673,1675,0,,92,93,94,,,92,93,94,,0,1673,1674,1675,95,0,,,,,0,1673,1674,1675,95,0,0,1673,1674,1675,95,0,0,1673,1674,1675,95,0,

Gold
-40(8)

Chrome
-50(8)

Nickel mat
-55(8)

-60
Gold matt(2)

-70
Chrome matt(3)

-10
White(17)

-20
Black(10)

-30
Grey(10)

Textured
Black
-08(20)

Textured
White
-09(20)

Textured
Grey
-35(20)

,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,,126,,,124,,,126,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,

20(47)

40(2)

,,230,,,229,,,588,,,588,,,588,,,588,,,588,,,588,,,588,,,231,,,588,,,228,,,228,,,228,,,228,,,228,,,229,,,229,,,229,,,230,,,588,,,230,,,582,,,582,,,228,,,228,,,228,,,228,,,228,,,228,,,228,,,228,,,228,,,228,,,228,,,231,,,231,,0,588,0,,,230,,,230,,,230,,,588,,,588,,,582,,,228,,,228,,,582,,,582,,,582,,

02(18)

03(4)

04(6)

05(3)

06(6)

07(12)

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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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=2443 AND find_in_set("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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=2446 AND find_in_set("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc

ARTUS

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

MOBILIS

MOBILIS 05

MOBILIS 2

MOBILIS SH

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

CERAM

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

JAZZ

MINI JAZZ

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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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=6536 AND find_in_set("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc

STATUS

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

PLANUS

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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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=2453 AND find_in_set("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 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("699",Rat_MultipleSel17) <> 0 order by Rec_Order ASC,Rec_Title Asc

MINOR

MINOR 1F H.P.LED

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

HONOR

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

INDIRECT

INDIRECT 1

INDIRECT 3

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

Site by OVERRON