Gazon synthétique 44 - Exelgreen

Gazon synthétique : 44

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 '44' 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 =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 '44%' 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 =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 '44' 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 =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 '44%' 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 =1 ORDER BY sx.points + 0 DESC
BRICOMARCHE ANCENIS
BRICOMARCHE ANCENIS

Rue des Grands Champs 44150 ANCENIS

Téléphone: 02 40 96 33 33
TRUFFAUT ORVAULT
TRUFFAUT ORVAULT

258 route de Vannes 44700 ORVAULT

Téléphone: 02 51 77 82 50
TRUFFAUT CARQUEFOU
TRUFFAUT CARQUEFOU

Parc de la Charmeli 44470 CARQUEFOU

Téléphone: 02 28 01 81 30
BRICOMARCHE VALLET
BRICOMARCHE VALLET

Route d'Ancenis 44330 VALLET

Téléphone: 02 40 36 29 94
ESPRIT JARDILAND CARQUEFOU
ESPRIT JARDILAND CARQUEFOU

La Jalousie RN3 44483 CARQUEFOU

Téléphone: 02 40 30 16 96
JARDILAND BOUGUENAIS
JARDILAND BOUGUENAIS

La Chataignerais 44340 BOUGUENAIS

Téléphone: 02 28 00 12 10
JARDILAND ORVAULT
JARDILAND ORVAULT

Route Hélène Boucher 44700 ORVAULT

Téléphone: 02 28 01 75 75
JARDILAND SAINT NAZAIRE
JARDILAND SAINT NAZAIRE

ZAC de Savine 44570 TRIGNAC

Téléphone: 02 40 90 30 95
JARDILAND BASSE GOULAINE
JARDILAND BASSE GOULAINE

Zone Pole Sud 44115 BASSE GOULAINE

Téléphone: 02 40 34 02 44
JARDILAND GUERANDE
JARDILAND GUERANDE

Zac De Villejames 44350 GUERANDE

Téléphone: 02 40 11 25 70
JARDILAND PORNIC
JARDILAND PORNIC

ZAC de l'Europe 44210 PORNIC

Téléphone: 02 40 64 09 40