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
				(1720477198- classifieds_advertisement.creationtime)  < ( 2 * 24 * 60 * 60 )  
		GROUP BY 
				id, name, creationtime, lastClickTime
		ORDER BY 
				`classifieds_classifiedsuser`.creationtime DESC<br><br>