Gazon synthétique 06 - Exelgreen

Gazon synthétique : 06

SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '06' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points between 6 and 8.4) AND s.id_store NOT IN (196,854,61,91,2356,2896,1426) AND cl.id_lang =1 ORDER BY sx.points DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '06%' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points between 6 and 8.4) AND s.id_store NOT IN (196,854,61,91,2356,2896,1426) AND cl.id_lang =1 ORDER BY sx.points DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '06' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points >= 8.5) AND s.id_store NOT IN (196,854,61,91,2356,2896,1426) AND cl.id_lang =1 ORDER BY sx.points + 0 DESC SELECT s.*,sx.points,sx.review_date,cl.name country, st.iso_code state, cl.id_country id_country FROM xgr_store s INNER JOIN xgr_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LEFT JOIN xgr_country_lang cl ON (cl.id_country = s.id_country AND s.id_country=8) LEFT JOIN xgr_state st ON (st.id_state = s.id_state) INNER JOIN xgr_store_extrafields sx ON (sx.id_store= s.id_store) WHERE s.postcode like '06%' AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND s.active = 1 AND (sx.points >= 8.5) AND s.id_store NOT IN (196,854,61,91,2356,2896,1426) AND cl.id_lang =1 ORDER BY sx.points + 0 DESC
LES BRICONAUTES NICE
LES BRICONAUTES NICE

22-24 avenue Gorbella 06100 NICE

Téléphone: 04 92 09 10 91
PEPINIERE SAINTE MARGUERITE
PEPINIERE SAINTE MARGUERITE

146, route du Plan 06130 LE PLAN DE GRASSE

Téléphone: 04 93 70 63 86
JARDINERIE PETRUCCIOLI/TRUFFAUT
JARDINERIE PETRUCCIOLI/TRUFFAUT

528 boulevard du Mercantour 06200 NICE

Téléphone: 04 93 29 88 82
JARDILAND NICE
JARDILAND NICE

742 Bd de Mercantour 06200 NICE

Téléphone: 04 93 29 87 78
BOTANIC CAGNES SUR MER
BOTANIC CAGNES SUR MER

119 avenue des Alpes 06800 CAGNES SUR MER

Téléphone: 04 22 17 02 40
VILLAVERDE ANTIBES
VILLAVERDE ANTIBES

1165 Chemin des Combes 06600 ANTIBES

Téléphone: 04 97 21 21 77
LES BRICONAUTES GRASSE
LES BRICONAUTES GRASSE

Route de Marigarde 06130 GRASSE

Téléphone: 04 92 42 44 44
BOTANIC MOUANS SARTOUX
BOTANIC MOUANS SARTOUX

999 chemin des Gourettes 06370 MOUANS SARTOUX

Téléphone: 04 92 28 31 00