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

Ground

products / outdoor

SELECT * FROM pages,records WHERE Page_Section= 'outdoor' AND Page_ID=268 AND Rec_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section= 'outdoor' AND Page_ID=268 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Title <> '' AND find_in_set("1675",Rat_MultipleSel9) <> 0

Clear Filters

Mounting Type

,,714,716,,,716,,,716,,,,0,716,0,0,716,0,,,

Wall Recessed(1)

,,714,716,,,716,,,716,,,,0,716,0,0,716,0,,,

Floor Recessed(5)

Lamps Categories

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

LED SYSTEMS(2)

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

LED LAMPS(2)

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

COMPACT FLUORESCENT LAMPS(2)

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

HALOGEN LAMPS(2)

Control gear

,,160,,,160,,0,1951,0,0,1543,0,0,160,0,0,160,0,0,160,0,0,160,0,0,160,0,

Remote electronic driver(7)

,,160,,,160,,0,1951,0,0,1543,0,0,160,0,0,160,0,0,160,0,0,160,0,0,160,0,

Remote 24V Constant Voltage LED Driver(1)

,,160,,,160,,0,1951,0,0,1543,0,0,160,0,0,160,0,0,160,0,0,160,0,0,160,0,

Built-in electronic driver for H.P. LED (1)

Housing

,,176,,,176,,,176,,0,780,0,0,176,0,0,176,0,0,1634,0,0,1634,0,0,780,0,

Cast-pressed brass(5)

,,176,,,176,,,176,,0,780,0,0,176,0,0,176,0,0,1634,0,0,1634,0,0,780,0,

Extruded brass(2)

,,176,,,176,,,176,,0,780,0,0,176,0,0,176,0,0,1634,0,0,1634,0,0,780,0,

Processed extruded brass(2)

Diffuser

,,5,,,5,,0,5,164,0,0,1138,0,0,5,0,0,5,0,0,1297,0,0,1297,0,0,5,0,

Opal plexiglass(1)

,,5,,,5,,0,5,164,0,0,1138,0,0,5,0,0,5,0,0,1297,0,0,1297,0,0,5,0,

Clear PMMA(2)

,,5,,,5,,0,5,164,0,0,1138,0,0,5,0,0,5,0,0,1297,0,0,1297,0,0,5,0,

Safety glass clear(6)

,,5,,,5,,0,5,164,0,0,1138,0,0,5,0,0,5,0,0,1297,0,0,1297,0,0,5,0,

Safety glass sandblast(1)

Reflector

Colors

,0,1673,1674,1675,101,112,0,0,1674,1673,1675,112,0,0,1674,1673,1675,112,0,0,1674,1673,1675,112,0,0,1673,1674,1675,101,112,0,0,1673,1674,1675,101,112,0,0,1673,1674,1675,101,112,0,0,1673,1674,1675,101,112,0,0,1673,1674,1675,101,111,112,0,

Nickel mat
-55(6)

Textured
Anthracite
-163(1)

Uncolored
-00(9)

Textured
Black
-08(9)

Textured
White
-09(9)

Textured
Grey
-35(9)

,,129,,0,129,0,0,129,0,0,129,0,0,129,0,0,129,0,0,129,0,0,129,0,0,129,0,

67(9)

,,588,,,588,,,588,,0,590,0,0,588,0,0,588,0,0,588,0,0,588,0,0,231,0,

05(1)

,,588,,,588,,,588,,0,590,0,0,588,0,0,588,0,0,588,0,0,588,0,0,231,0,

07(7)

,,588,,,588,,,588,,0,590,0,0,588,0,0,588,0,0,588,0,0,588,0,0,231,0,

08(1)

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

FAMA

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100719 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100719 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100681 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100681 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100715 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100715 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100724 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100724 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100723 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100723 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100739 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100739 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100742 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100742 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100726 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100726 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100744 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100744 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100721 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100721 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100730 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100730 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100722 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100722 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100741 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100741 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100733 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100733 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100737 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100737 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100713 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100713 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100734 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100734 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100728 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100728 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100735 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100735 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

TERES

MINI TERES 1 GROUND BRASS H.P.LED

MINI TERES 1 GROUND BRASS PLEXY H.P.LED

TERES 1 GROUND BRASS

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100731 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100731 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100727 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100727 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100718 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100718 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100745 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100745 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100712 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100712 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100729 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100729 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100743 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100743 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100725 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100725 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100717 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100717 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100740 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100740 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100738 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100738 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100736 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100736 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100720 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100720 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100714 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100714 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

SELECT pages.*,records.* FROM pages,records WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Scroll7=100732 AND find_in_set("1675",Rat_MultipleSel9) <> 0 UNION SELECT pages.*,records.* FROM pages, records, related_pages WHERE Page_Section = 'outdoor' AND Page_ID=268 AND Page_ID='268' AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Scroll7=100732 AND find_in_set("1675",Rat_MultipleSel9) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON