Lock wait timeout exceeded; try restarting transactionSELECT a.adid, a.user_id, ct.cityname, a.adtitle, a.subcatid, scat.subcatname, cat.catid, cat.catname, UNIX_TIMESTAMP(feat.featuredtill) AS timestamp, p.picfile, urg.adid AS isurgent, red.adid AS isreduced FROM clf_ads a LEFT JOIN clf_featured feat ON a.adid = feat.adid LEFT JOIN clf_cities ct ON a.cityid = ct.cityid LEFT JOIN clf_subcats scat ON a.subcatid = scat.subcatid LEFT JOIN clf_cats cat ON scat.catid = cat.catid LEFT JOIN clf_adpics p ON a.adid = p.adid LEFT JOIN clf_urgent urg ON a.adid = urg.adid LEFT JOIN clf_reduced red ON a.adid = red.adid WHERE a.subcatid = '18' AND a.cityid = '575' AND feat.featuredtill >= NOW() AND a.expireson >=NOW() AND a.enabled = '1' AND a.verified = '1' GROUP BY adid ORDER BY a.createdon DESC LIMIT 150