Shoutbox

code:

---

SELECT a.`notes`, a.`itemid`
FROM yass_log a
JOIN
   (SELECT MAX(`logid`) AS logid
   FROM yass_log
   GROUP BY `itemid`) b
ON a.`logid` = b.`logid`
JOIN yass_image_items c
ON a.`itemid` = c.`itemid`
WHERE c.`uid` = 1
AND a.`notes` <> ''

---