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

Bollards

products / outdoor

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

Clear Filters

Mounting Type

,,715,,,,715,,,715,,,715,,,715,,,715,,,715,,

Floor(7)

Lamps Categories

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

LED LAMPS(4)

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

DISCHARGE LAMPS(1)

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

COMPACT FLUORESCENT LAMPS(3)

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

HALOGEN LAMPS(4)

Control gear

,,155,,,,,,,,,

Built-in electronic ballast(1)

Housing

,,45,182,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,

Extruded aluminium(1)

,,45,182,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,

Concrete(7)

,,45,182,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,,45,1115,,

Cast-pressed aluminium(8)

Diffuser

,,164,,,164,,,164,,,164,,,164,,,164,,,164,,,164,,

Safety glass sandblast(8)

Reflector

,,204,,,204,,,204,,,204,,,204,,,204,,,204,,,204,,

Anodized aluminium(8)

Colors

,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,

White Matt
-44(8)

,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,

Grey matt
-132(8)

,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,

Black matt
-119(8)

,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,,104,105,106,111,,

Textured
Anthracite
-163(8)

,,128,,,128,,,128,,,128,,,128,,,128,,,128,,,128,,

65(8)

,,590,,,588,,,588,,,588,,,588,,,588,,,588,,,588,,

07(7)

,,590,,,588,,,588,,,588,,,588,,,588,,,588,,,588,,

08(1)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

COPIA

COPIA SH 1F

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

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

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

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

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

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

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

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

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

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

CONTO

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

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

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

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

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

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

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

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

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

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

Site by OVERRON