Gazon synthétique 30 - Exelgreen

Gazon synthétique : 30

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 '30' 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 (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =2 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 '30%' 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 (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =2 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 '30' AND s.active = 1 AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND (sx.points >= 8.5) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =2 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 '30%' AND YEAR(sx.review_date) >= YEAR(CURDATE())-1 AND s.active = 1 AND (sx.points >= 8.5) AND s.id_store NOT IN (811,674,196,854,61,708,44,91,732,1134,2356,938,1717,2327,1075,2332,2455,1077,2896,2687,1389,2981,1495,3001,1426,617,3100,768) AND cl.id_lang =2 ORDER BY sx.points + 0 DESC
JARDILAND NIMES
JARDILAND NIMES

67 rue Christino Garcia 30000 NIMES

Téléphone: 04 66 02 00 30
BOTANIC VILLENEUVE LES AVIGNON
BOTANIC VILLENEUVE LES AVIGNON

ZAC Raphael Garcin 30400 VILLENEUVE LES AVIGNON

Téléphone: 04 90 15 94 00
JARDILAND ALES
JARDILAND ALES

ZAC de Rieu 30100 ALES

Téléphone: 04 66 55 81 81
WELDOM AIGUES MORTES
WELDOM AIGUES MORTES

787 Route de N?mes 30220 AIGUES MORTES

Téléphone: 04 66 53 99 19
TRUFFAUT NIMES
TRUFFAUT NIMES

400, rue Michel Debre 30906 NIMES

Téléphone: 04 66 04 00 00
BRICOMARCHE CAVEIRAC
BRICOMARCHE CAVEIRAC

Lieu dit Les Roles 30820 CAVEIRAC

Téléphone: 04 66 81 86 30
WELDOM LES ANGLES
WELDOM LES ANGLES

300 avenue de Grand Angles 30133 LES ANGLES

Téléphone: 04 90 25 72 93