Sorry, the ad you were looking for, Golden Retriever Puppies, is no longer available.
You may also want to look at...
SELECT Subject, MIN( Pics.PicID ) , Posts.PostID, Posts.MemberID, Posts.Posted
FROM Posts, Pics
WHERE Pics.PostID = Posts.PostID
AND (DATE_SUB( CURDATE( ) , INTERVAL 30 DAY ) <= Pics.Uploaded)
AND Posts.PostID > 2304929
AND Pics.PicID > 370000
AND Pics.Approved = 1
AND Posts.BoardID = 7
GROUP BY Posts.MemberID DESC
ORDER BY Posts.PostID DESC
LIMIT 16;