Become an affiliate
Location: Athens, Ohio
Home » Ohio » Athens » Services » Car Rental - Lease - Taxi
See All
Banner Ads
Posted: 27 days ago
SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, COUNT(*) AS piccount, MIN(p.picfile) AS picfile, a.extendedtill AS extended, a.bumptill AS bumpedad, a.multicitytill AS allpaidad, scat.subcatname, cat.catid, cat.catname , axf.f1, axf.f2, axf.f3, axf.f4, axf.f5, axf.f6, axf.f7, axf.f8, axf.f9, axf.f10, axf.f11, axf.f12, axf.f13, axf.f14, axf.f15, axf.f16, axf.f17, axf.f18, axf.f19 FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN clf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN clf_adxfields axf ON a.adid = axf.adid LEFT OUTER JOIN clf_adpics p ON a.adid = p.adid AND p.isevent = '0' WHERE a.subcatid = 194 AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0' AND a.featuredadtill = 0 AND a.expireson > NOW() AND ( a.cityid = 289 OR (a.multicity_countryid = -1 AND a.multicitytill > NOW()) ) GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 0, 16Server shutdown in progress