SELECT SQL_CALC_FOUND_ROWS t1.*,GROUP_CONCAT(t3.Tag) AS Tag,GROUP_CONCAT(t3.TagHash) AS TagHash,t4.ID AS UserId,t4.Name AS UserName,Rating/RateCount AS Rate
FROM mb_mails AS t1
LEFT JOIN mb_mails_to_tags AS t2 ON t1.ID = t2.MailId
LEFT JOIN mb_tags AS t3 ON t3.ID = t2.TagId
LEFT JOIN mb_users AS t4 ON t1.User = t4.ID
WHERE Approve='1'
GROUP BY t1.ID
ORDER BY Rate DESC, RateCount DESC
LIMIT 40,10 --- No database selected
SELECT t1.ID,t1.Tag,t1.TagHash, COUNT(t1.ID) AS MyCount FROM mb_tags AS t1
LEFT JOIN mb_mails_to_tags AS t2 ON t1.ID = t2.TagId
GROUP BY t1.ID
ORDER BY MyCount DESC
LIMIT 26 --- No database selected
Najboljši emaili - 6minut.com
