SELECT *, (total_rate/cnt)*1.0 as rate FROM (SELECT c.cus_id, c.cus_lat, c.cus_lon, c.cus_businessname, c.cus_businessmail, c.cus_phone1, c.cus_businesssite, c.cus_details, c.cus_businessaddress, c.cus_tk, c.cus_businesscity, c.cus_businessstate, t.cat_id, t.cat_name, t.cat_icon, s.sub_id, s.sub_name, tt.cat_id as cat_id_2, tt.cat_name as cat_name_2, tt.cat_icon as cat_icon_2, ss.sub_id as sub_id_2, ss.sub_name as sub_name_2, ttt.cat_id as cat_id_3, ttt.cat_name as cat_name_3, ttt.cat_icon as cat_icon_3, sss.sub_id as sub_id_3, sss.sub_name as sub_name_3, su.pack_id, su.pack_exp_date, IF(su.pack_exp_date>=now(),su.pack_id,1)*1 as order_col, IF(INSTR(sp.features,'"top":"1"')>0,1,0) as order_col2, IF(NOW()<=su.pack_exp_date,1,0) as order_col3, SUM(r.rate) as total_rate, COUNT(*) as cnt, sc.cat_features, sc.sub_features FROM customers c
JOIN categories t ON (c.cat_id_fk=t.cat_id)
JOIN subcategories s ON (c.sub_id_fk=s.sub_id)
LEFT JOIN site_customers sc ON (c.cus_id=sc.cus_id)
LEFT JOIN categories tt ON (sc.cat_id_2=tt.cat_id)
LEFT JOIN subcategories ss ON (sc.sub_id_2=ss.sub_id)
LEFT JOIN categories ttt ON (sc.cat_id_3=ttt.cat_id)
LEFT JOIN subcategories sss ON (sc.sub_id_3=sss.sub_id)
LEFT JOIN site_reviews r ON (c.cus_id=r.cus_id AND (r.parent_id IS NULL OR r.parent_id=0) AND r.status=1)
JOIN site_users su ON (sc.site_user_id=su.id)
JOIN site_packages sp ON (su.pack_id=sp.id)
WHERE c.cus_status*1>0 AND c.database_id_fk=7 AND c.cus_lat>0 AND c.cus_lon>0 AND (s.sub_id=4368 OR ss.sub_id=4368 OR sss.sub_id=4368)
GROUP BY c.cus_id ) a
ORDER BY order_col3 DESC, order_col2 DESC, order_col DESC, rate DESC, cnt DESC
LIMIT 10 OFFSET 0
Μηχανήματα-πλαστικών-βιομηχανίας
Εισαγάγετε τη διεύθυνση ηλεκτρονικού ταχυδρομείου σας (email) και θα σας στείλουμε ένα μήνυμα ηλεκτρονικού ταχυδρομείου σχετικά με τον τρόπο επαναφοράς του κωδικού πρόσβασής σας.
