SELECT
a.subject AS predmet,
a.id AS ID,e.item_guid,
b.name AS odesilatel,
c.name AS prijemce,
f.name AS nazev_itemu,
CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(g.data, ' ', 15), ' ', -1) AS UNSIGNED) as Pocet
FROM characters.mail AS a
JOIN characters.characters AS b ON b.guid = a.sender
JOIN characters.characters AS c ON c.guid = a.receiver
RIGHT JOIN characters.mail_items AS e ON a.id = e.mail_id
LEFT JOIN mangos.item_template AS f on f.entry =  e.item_template
LEFT JOIN characters.item_instance AS g ON g.guid = e.item_guid
WHERE a.has_items =0