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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 0

Clear Filters

Mounting Type

,,715,,,715,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,

Floor(2)

,,715,,,715,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,,716,,

Floor Recessed(9)

Lamps Categories

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

LED SYSTEMS(5)

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

LED LAMPS(6)

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

DISCHARGE LAMPS(2)

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

COMPACT FLUORESCENT LAMPS(1)

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

HALOGEN LAMPS(8)

Control gear

,,161,,,161,,,161,,0,160,0,0,1951,0,,161,,0,1882,0,,0,1951,0,0,1951,0,0,1882,0,

Remote electronic driver(1)

,,161,,,161,,,161,,0,160,0,0,1951,0,,161,,0,1882,0,,0,1951,0,0,1951,0,0,1882,0,

Built-in electronic driver(4)

,,161,,,161,,,161,,0,160,0,0,1951,0,,161,,0,1882,0,,0,1951,0,0,1951,0,0,1882,0,

Built-in LED driver(2)

,,161,,,161,,,161,,0,160,0,0,1951,0,,161,,0,1882,0,,0,1951,0,0,1951,0,0,1882,0,

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

Housing

,,176,,,176,,,45,176,,,176,,,176,,,176,,,176,,,176,,,176,,,176,,0,176,0,

Cast-pressed brass(11)

,,176,,,176,,,45,176,,,176,,,176,,,176,,,176,,,176,,,176,,,176,,0,176,0,

Cast-pressed aluminium(1)

Diffuser

,,164,,,164,,,,,5,164,,,,164,,,164,,,164,,,5,,,5,,

Safety glass clear(3)

,,164,,,164,,,,,5,164,,,,164,,,164,,,164,,,5,,,5,,

Safety glass sandblast(6)

Reflector

Colors

,,101,104,105,106,112,,,101,104,105,106,112,,,104,105,106,,0,104,105,106,112,0,,104,105,106,112,,,104,105,106,112,,,104,105,106,112,,,104,105,106,112,,,104,105,106,112,,0,104,105,106,111,112,0,0,104,105,106,111,112,0,

Nickel mat
-55(2)

White Matt
-44(11)

Grey matt
-132(11)

Black matt
-119(11)

Textured
Anthracite
-163(2)

Uncolored
-00(10)

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

67(11)

,,750,,,750,,,749,,,590,,,588,,,749,,,749,,,588,,,749,,,590,,,590,,

07(2)

,,750,,,750,,,749,,,590,,,588,,,749,,,749,,,588,,,749,,,590,,,590,,

08(3)

,,750,,,750,,,749,,,590,,,588,,,749,,,749,,,588,,,749,,,590,,,590,,

09(4)

,,750,,,750,,,749,,,590,,,588,,,749,,,749,,,588,,,749,,,590,,,590,,

10(2)

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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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=100719 AND find_in_set("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

NEPA

NEPA GROUND BRASS

NEPA GROUND OUT BRASS LED

NEPA MAX GROUND BRASS

NEPA MAX GROUND BRASS DIR

NEPA STEPS 02 BRASS

NEPA STEPS 02 LED BRASS

NEPA STEPS 04 LED

NEPA STEPS BRASS

NEPA STEPS OUT LED 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=100730 AND find_in_set("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

NEXUS

NEXUS GROUND BRASS

NEXUS GROUND BRASS H.P.LED

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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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=100731 AND find_in_set("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 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("104",Rat_MultipleSel9) <> 0 AND find_in_set("176",Rat_MultipleSel1) <> 0 order by Rec_Order ASC,Rec_Title Asc

Site by OVERRON