Gazon synthétique 77 - Exelgreen

Gazon synthétique : 77

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 '77' 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 '77%' 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 '77' 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 '77%' 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 DAMMARIE
JARDILAND DAMMARIE

ZAC du Plateau de Biere 77190 DAMMARIE LES LYS

Téléphone: 01 64 37 49 97
TRUFFAUT  JARDINS DE COUTEVROULT
TRUFFAUT JARDINS DE COUTEVROULT

La Mare Aux Poissons Route D?partementale 406 77580 COUTEVROULT

Téléphone: 01 64 17 19 90
JARDILAND CLAYE
JARDILAND CLAYE

13 rue Jean Monnet 77410 CLAYE SOUILLY

Téléphone: 01 60 27 26 36
BOTANIC PONTAULT COMBAULT
BOTANIC PONTAULT COMBAULT

ZAC du Pontillaut 77340 PONTAULT COMBAULT

Téléphone: 01.60.18.11.60
JARDILAND LIEUSAINT
JARDILAND LIEUSAINT

ZAC du Carre Senart 77127 LIEUSAINT

Téléphone: 01 60 60 84 48
TRUFFAUT VILLEPARISIS
TRUFFAUT VILLEPARISIS

RN3 route de Villevaud 77270 VILLEPARISIS

Téléphone: 01 64 27 59 49
TRUFFAUT PONTHIERRY
TRUFFAUT PONTHIERRY

RN7 77310 PONTHIERRY

Téléphone: 01 60 65 45 08
TRUFFAUT SERVON
TRUFFAUT SERVON

Ferme de Servon 77170 SERVON

Téléphone: 01 60 62 52 52