 |
Thursday, 31 May, 2012
|
| Home |
| Post Ad |
| Search |
|---|
|
|
| Home / UK CITIES / Sheffield / |
| Got error 12 from storage engineSELECT ct.cityid, c.countryid, COUNT(*) as adcnt FROM classifieds_ads a INNER JOIN classifieds_cities ct ON ct.cityid = a.cityid AND (a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0') INNER JOIN classifieds_countries c ON ct.countryid = c.countryid WHERE ct.enabled = '1' AND c.enabled = '1' GROUP BY ct.cityid |