|
Tuesday, 22 May, 2012
| |
| free classified ads - free ads - classified ads - free online classifieds - free classifieds - free advertising - job classifieds - housing, jobs, employment, career, apartments, vacation rental, rental, real estate, roommate, calendar, sale, wanted, resumes, personals, romance, community, gigs, events |
Home
Post Ad
|
| Pacific / Australia / |
|
Account Sign Up |
Categories »
Table './perfectdone/xzclf_ads' is marked as crashed and last (automatic?) repair failedSELECT scat.subcatid, scat.catid, COUNT(*) as adcnt
FROM xzclf_ads a
INNER JOIN xzclf_subcats scat ON scat.subcatid = a.subcatid AND (a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW())
INNER JOIN xzclf_cats cat ON cat.catid = scat.catid
INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid
WHERE scat.enabled = '1'
AND a.cityid = 99
GROUP BY a.subcatid