Gazon synthétique 13 - Exelgreen

Gazon synthétique : 13

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 '13' 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 '13%' 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 '13' 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 '13%' 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
BOTANIC ST MITRE LES REMPARTS
BOTANIC ST MITRE LES REMPARTS

ZAC des Etangs 13920 ST MITRE LES REMPART

Téléphone: 04 42 49 15 00
TRUFFAUT CABRIES
TRUFFAUT CABRIES

ZAC de Grande Campagne 13480 CABRIES

Téléphone: 04 42 34 37 60
BRICOMARCHE VENELLES
BRICOMARCHE VENELLES

96 Avenue des Logissons 13770 VENELLES

Téléphone: 04 42 54 98 40
TRUFFAUT AUBAGNE
TRUFFAUT AUBAGNE

ZI Les Paluds 13400 AUBAGNE

Téléphone: 04 42 84 21 22
JARDINERIE TIRAND
JARDINERIE TIRAND

Chemin des Gall?gues 13400 AUBAGNE

Téléphone: 04 42 70 38 79
BOTANIC AIX EN PROVENCE
BOTANIC AIX EN PROVENCE

RD 9 13290 LES MILLES

Téléphone: 04 42 52 52 52
JARDIPASSION ISTRES
JARDIPASSION ISTRES

16, avenue Clément Ader 13800 ISTRES

Téléphone: 04 42 56 10 10
BRICOMARCHE GARDANNE
BRICOMARCHE GARDANNE

Avenue d'Arménie 13120 GARDANNE

Téléphone: 04 42 12 40 97
WELDOM MARSEILLE 12
WELDOM MARSEILLE 12

90 rue Scaramelli 13012 MARSEILLE 12

Téléphone: 04 91 49 27 27
JARDIPASSION GRANS
JARDIPASSION GRANS

2943 chemin des Crozes 13450 GRANS

Téléphone: 04 90 17 08 30
BOTANIC VENELLES
BOTANIC VENELLES

1 rond point de la Gare 13770 VENELLES

Téléphone: 04 42 54 18 04