SELECT
count(`classifieds_advertisement`.ownerId) count, `classifieds_advertisement`.`ownerId` id , replace(LCASE(`classifieds_classifiedsuser`.name),'postad','') as name, `classifieds_classifiedsuser`.email, FROM_UNIXTIME(`classifieds_classifiedsuser`.`creationtime`, '%d %m %Y') creationtime , FROM_UNIXTIME(`classifieds_classifiedsuser`.`lastClickTime`, '%d %m %Y') lastClickTime, classifieds_classifiedsuser.isPaid as isPaid,
( SELECT a1.id FROM `classifieds_advertisement` a1 where a1.active =1 and a1.id = `classifieds_advertisement`.`id` limit 0, 1 ) as adid
FROM
`classifieds_advertisement` left join `classifieds_classifiedsuser` on `classifieds_classifiedsuser`.id = `classifieds_advertisement`.`ownerId`
WHERE
`active` =1 and
ownerid not in (95391059, 1374212757) and
(1720476457- classifieds_advertisement.creationtime) < ( 2 * 24 * 60 * 60 )
GROUP BY
id, name, creationtime, lastClickTime
ORDER BY
`classifieds_classifiedsuser`.creationtime DESC