SELECT a.id, a.zid, title, c.name as cName, a.expirationTime, email, a.ownerId FROM classifieds_advertisement AS a, classifieds_classifiedsuser AS u, classifieds_classifiedscategory AS c WHERE a.expEmailSent='0' AND a.ownerId=u.id AND a.active='1' AND 1720913330>a.expirationTime AND a.cid=c.id order by a.id desc limit 0, 1<br><br>