SELECT id,type,AVG(mark) as rating,COUNT(mark) as reviewcount, country, state, pr_subcat
FROM radlance_users
LEFT JOIN radlance_special ON radlance_users.username=radlance_special.username
LEFT JOIN radlance_reviews ON radlance_reviews.user=radlance_users.id
WHERE id>100 GROUP BY id ORDER BY radlance_special.level DESC, rating DESC, reviewcount DESC
Table 'radlance_users' is marked as crashed and should be repaired
