SELECT SQL_CALC_FOUND_ROWS t1.*,t3.Tag,t3.TagHash,t4.ID AS UserId,t4.Name AS UserName
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' AND TitleHash LIKE 'fwd:_hammer_meister'; --- No database selected
SELECT t2.MailId,t1.Tag,t1.ID,t3.TitleHash,t3.Title FROM mb_tags AS t1
LEFT JOIN mb_mails_to_tags AS t2 ON t1.ID = t2.TagId
LEFT JOIN mb_mails AS t3 ON t2.MailId=t3.ID
LIMIT 300 --- No database selected
SELECT *,Rating/RateCount AS Rate
FROM mb_mails WHERE User= AND Approve=1
ORDER BY Rate
LIMIT 8; --- No database selected