Home > India >
Search Ads in India 
 
SELECT a.adid as adid,a.email as email, a.adtitle as adtitle, a.addesc as addesc, a.cityid as cityid, a.subcatid as subcatid, ct.cityname as cityname, UNIX_TIMESTAMP(a.timestamp) AS timestamp, UNIX_TIMESTAMP(a.createdon) AS createdon, UNIX_TIMESTAMP(a.expireson) AS expireson, p.picfile FROM clf_ads a INNER JOIN clf_subcats scat ON scat.subcatid = a.subcatid INNER JOIN clf_cities ct ON a.cityid = ct.cityid LEFT OUTER JOIN clf_adpics p ON a.adid = p.adid AND p.isevent = '0' WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() And a.email= 'greenbouncesalon25@gmail.com' GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 0, 25Got error 28 from storage engine