California, Berkshire
Post or view free local announcements, notices, classified ads, events and images on the California local community noticeboard! Hundreds of people are visiting daily so reach out to your local community and get the word out!
|
Latest Ads
SELECT a.*, ct.cityname, UNIX_TIMESTAMP(a.createdon) AS timestamp, feat.adid AS isfeat,
COUNT(*) AS piccount, p.picfile AS picfile, scat.subcatname, scat.catid, cat.catname
FROM xzclf_ads a
INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid
INNER JOIN xzclf_subcats scat ON a.subcatid = scat.subcatid
INNER JOIN xzclf_cats cat ON scat.catid = cat.catid
LEFT OUTER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' AND feat.featuredtill >= NOW()
LEFT OUTER JOIN xzclf_adpics p ON a.adid = p.adid AND p.isevent = '0'
WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW()
AND a.cityid = 201
GROUP BY a.adid
ORDER BY a.createdon DESC
LIMIT 10Got error 28 from storage engine |
|
