It is really embarrassing, but it looks like we are having a small technical issue.
Please, click here to see if it has been resolved.
If the issue has been resolved you will not see this message. If you still see this message, please, wait for a couple minutes and try again.
TOP
User qwikadbu_qwikadb already has more than 'max_user_connections' active connections
Server shutdown in progressSELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, a.extendedtill AS extended, a.bumptill AS bumpedad, a.multicitytill AS allpaidad,
COUNT(*) AS piccount, MIN(p.picfile) AS picfile,
scat.subcatname, cat.catid, cat.catname
FROM clf_ads a
INNER JOIN clf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW()
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 = 312
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0'
AND (
a.cityid = 1592
OR
(a.multicity_countryid = -1 AND a.multicitytill > NOW())
)
GROUP BY a.adid
ORDER BY a.createdon DESC
