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()) AND (sx.points between 6 and 8.4) 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()) AND (sx.points between 6 and 8.4) AND cl.id_lang =1 ORDER BY sx.points DESCSELECT 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()) AND (sx.points >= 8.5) 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()) AND s.active = 1 AND (sx.points >= 8.5) AND cl.id_lang =1 ORDER BY sx.points + 0 DESC