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
