Human Resources in / Free ads

SELECT a.adid, a.adtitle, SUBSTRING(a.addesc,1,300) AS addesc, a.price, a.area, a.sitio, a.thumbfile, UNIX_TIMESTAMP(a.createdon) AS timestamp, a.canonicalUrl, a.stateid, st.statename, a.subcatid, scat.subcatname, a.catid, cat.catname, loc.locationslug, loc.locationname FROM xzclf_ads a USE INDEX (countryid,catid,subcatid,stateid,expireson,PRIMARY) INNER JOIN xzclf_cats cat ON a.catid = cat.catid INNER JOIN xzclf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN xzclf_states st ON a.stateid = st.stateid LEFT JOIN xzclf_location loc ON (LOWER(a.area) = LOWER(loc.locationname) AND loc.stateid = a.stateid) WHERE a.countryid = AND a.verified = '1' AND a.enabled = '1' AND a.catid = 2 AND a.subcatid = 30 AND a.stateid = 1108 AND a.expireson >= '2017-07-22' ORDER BY a.adid DESC LIMIT 0,15