Gazon synthétique 83 - Exelgreen

Gazon synthétique : 83

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 '83' 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 '83%' 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 '83' 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 '83%' 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
VEGETALIS LA LONDE
VEGETALIS LA LONDE

La Pascalette 83250 LA LONDE LES MAURES

Téléphone: 04 94 00 41 00
BOTANIC SAINTE MAXIME
BOTANIC SAINTE MAXIME

RD N25 83120 STE MAXIME

Téléphone: 04 94 17 71 30
JARDILAND FREJUS
JARDILAND FREJUS

1586, avenue Jean Lachenaud 83600 FREJUS

Téléphone: 04 98 12 14 10
BOTANIC LA SEYNE SUR MER
BOTANIC LA SEYNE SUR MER

Rue de Lisbonne 83500 LA SEYNE SUR MER

Téléphone: 04 94 10 88 60
JARDINERIE EDIOSMO
JARDINERIE EDIOSMO

1251, Route de Saint Tropez 83310 GRIMAUD

Téléphone: 04 94 43 22 72
JARDILAND TOULON
JARDILAND TOULON

232, all?e des 4 chemins 83130 LA GARDE

Téléphone: 04 94 08 55 65
GAMM VERT OLLIOULES
GAMM VERT OLLIOULES

546 Avenue Jean Monnet 83190 OLLIOULES

Téléphone: 04 94 63 21 49