SELECT a.itemid,a.subject,c.filepath,b.message FROM supe_spaceitems a inner join supe_spacenews b on b.itemid=a.itemid inner join supe_attachments c on c.itemid = b.itemid WHERE a.haveattach = 1 and c.isimage = 1 and a.digest = 2 and c.aid = a.picid GROUP BY a.itemid ORDER BY a.dateline desc limit 0 ,5