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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0

Clear Filters

Mounting Type

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

Ceiling Recessed(49)

Lamps Categories

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

LED SYSTEMS(40)

LED LAMPS(15)

DISCHARGE LAMPS(2)

COMPACT FLUORESCENT LAMPS(7)

HALOGEN LAMPS(18)

Control gear

,,,160,,,158,159,,,,160,,,160,,,,160,,,158,159,,,158,159,,,158,159,,,158,159,,,160,,,157,163,,,160,,,158,159,,,158,159,,,158,159,,,158,,,157,160,,0,160,0,,157,,,158,,0,1383,0,,157,,,157,,,160,,,160,,,160,,,160,,,160,,,160,,,160,,,160,,,160,,,728,,,728,,,728,,,161,,,161,,,728,,,160,,0,160,0,0,161,0,0,160,0,0,160,0,0,160,0,0,160,0,0,160,0,

Remote electronic ballast(5)

Remote electronic transformer(10)

Remote magnetic transformer(8)

Remote electronic driver(24)

Built-in electronic driver(3)

Remote magnetic ballast(1)

Built-in electronic driver(4)

Remote electronic transformer / driver(1)

Housing

,,45,175,,,45,175,,,178,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,45,,,178,,,178,,,178,,,45,,,45,182,,0,45,0,,45,,,45,,,45,178,,,45,,,45,,,45,,,45,,0,182,0,0,182,0,0,182,0,,45,,,45,178,,,45,178,,,45,178,,,45,,,45,,,45,,,45,182,,,45,182,,,45,,,45,,0,45,0,0,178,0,0,182,0,0,182,0,0,45,0,0,1868,178,0,0,45,0,

Pressed aluminium(2)

Pressed formed steel(10)

Extruded aluminium(8)

Cast-pressed aluminium(38)

Aluminium(1)

Diffuser

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Matt opal cover of extruded PMMA(1)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Clear polycarbonate(1)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Opal PMMA(2)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Safety glass clear(7)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Safety glass sandblast(3)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Prismatic glass (white optic)(8)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Decorative sandblast glass(1)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Linear lens PMMA Clear | Matt | Stripe | Square(1)

,,,,,172,,,166,,,166,,,166,,,,,,,,,,,164,,,,164,,,,,0,1296,0,,166,,,,,5,,,164,,,166,,,166,,,,,,166,,,5,,,5,,,5,,,,,,5,,,5,,,166,,,5,,0,614,0,0,167,0,,,0,1296,0,0,2138,0,0,1899,0,

Prismatic(1)

Reflector

,,220,,,,,,623,,,623,,,204,,,,,,,,,623,,,623,,,,,,,0,1198,0,,623,,,,,623,,,623,,,623,,,623,,0,1245,0,0,1245,0,0,1245,0,,204,,,986,,,986,,,986,,,1168,,,1168,,,1168,,,1083,,,1083,,,1168,,,623,,0,1083,0,,0,1245,0,0,1245,0,0,1198,0,,0,1901,0,

Anodized aluminium(2)

Round white aluminium(1)

Vacuum aluminium(10)

Circular diamond aluminium (15°, 24°, 40°, 60°)(3)

Circular brightened spherical facets (90°)(4)

Asymmetric(2)

Circular (10°, 20°)(5)

Anti-glare PC screen and reflector 15°, 30°, 45°(1)

Colors

,0,1673,1674,1675,0,0,1673,1674,1675,0,,92,93,94,,,92,93,94,95,100,101,102,103,,0,95,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,1674,1673,1675,0,,92,93,94,100,101,103,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,,92,93,94,100,101,,0,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,,92,93,94,,,92,93,94,95,100,101,,,92,93,94,,0,1673,1674,1675,95,100,101,0,0,1674,1673,1675,0,0,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,,92,93,94,95,100,101,,0,100,101,1674,1673,1675,0,0,95,100,101,1674,1673,1675,0,0,95,100,101,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,100,101,103,1674,1673,1675,0,0,1937,93,92,0,0,1937,93,92,0,0,1937,93,92,0,0,100,101,1674,1673,1675,0,0,92,93,94,101,1018,0,0,92,93,94,101,1018,0,,92,93,94,101,1018,,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,1673,1674,1675,100,101,0,0,100,101,103,1674,1673,1675,0,0,92,93,94,0,0,92,0,0,1937,93,92,0,0,1937,93,92,0,0,1674,1673,1675,0,0,92,0,0,1674,1673,1675,0,

Gold
-40(7)

Chrome
-50(24)

Nickel mat
-55(27)

-60
Gold matt(1)

-70
Chrome matt(9)

-7022
Anthracite(3)

-10
White(23)

-20
Black(21)

-30
Grey(16)

Anodized
Grey
-227(5)

Textured
Black
-08(26)

Textured
White
-09(26)

Textured
Grey
-35(26)

,,124,,,124,,,124,,,124,,0,126,0,,126,,,127,,,124,,,124,,,124,,,124,,,124,,,124,,,124,,,126,,,124,,,124,,,124,,,124,,,124,,0,124,0,,126,,,124,,,124,,,124,,,126,,,624,,,624,,0,124,0,0,124,0,0,124,0,,126,,,124,,,124,,,124,,0,124,0,0,124,0,0,124,0,,124,,,124,,,126,,,126,,0,124,0,0,124,0,0,124,0,0,124,0,0,124,0,0,128,0,0,124,0,

20(37)

40(8)

44(1)

65(1)

23(2)

,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,0,230,0,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,,230,,0,230,0,0,230,0,0,230,0,0,230,0,0,230,0,0,230,0,0,230,0,

04(49)

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

BENE

BENE 5F IN ASYMMETRIC

BENE 4F ROUND IN

BENE 5F TRIMLESS ASYMMETRIC

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

STELLA

STELLA M.S.

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

ARTUS

MAX ARTUS TORRIS

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

MOBILIS

MOBILIS 05

MOBILIS M

MAX MOBILIS 3 U S.S.LED

MAX MOBILIS 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=2447 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

FLUXUS

FLUXUS L-T LED

FLUXUS M-T LED

FLUXUS S-T 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=100918 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

JAZZ

JAZZ MAX H.P.LED

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

NOVUS

NOVUS IN BOX 1x H.P.LED

NOVUS IN BOX 2x H.P.LED

NOVUS IN BOX 3x H.P.LED

NOVUS IN BOX 5x H.P.LED

NOVUS IN BOX 7x 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=2561 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

ORBIS

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

SITUS

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

TALUS

MINI TALUS 3F ASYMMETRIC

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

PENDO

MINOR 1F PENDO M 1R S.S.LED

MINOR 3F PENDO M 1R S.S.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=2456 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

ANULUS

ANULUS 1F S.S.LED

ANULUS 2F S.S.LED

ANULUS 3F S.S.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=2466 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

HONOR

HONOR L 00

HONOR L 01

HONOR L N WHITE OPTIC S.S.LED

HONOR L N4 S.S.LED

HONOR L WHITE OPTIC

HONOR L WHITE OPTIC SSL 165

HONOR L WHITE OPTIC SSL 210

HONOR M N WHITE OPTIC S.S.LED

HONOR M N0 S.S.LED

HONOR M N4

HONOR M-T FLUXUS WHITE OPTIC LED

HONOR S N WHITE OPTIC LED

HONOR S N WHITE OPTIC S.S.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=2461 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

LED PANEL

BACKLIGHT PANEL IN PRISMATIC UGR IP65

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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

POSCO

POSCO 2 IN 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=2464 AND find_in_set("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 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("230",Rat_MultipleSel7) <> 0 AND find_in_set("709",Rat_MultipleSel18) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON