We are simply one of the best free classifieds sites on the net and one of the most effective ones, Advertise free in a couple of ways, Enjoy a series of techniques all on one site things like A link directory,banner placement,Instant Article postings, free advertising forum,simple fast message board and of course classifieds.
We receive THOUSANDS of visits a month and growing daily you can be sure what ever your selling it will get you views and hopefully sells. We like to keep things simple here and were known for it.
So get started with your free advertisement in any way you feel from the the above left side menu and start selling/Buying online fast.
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 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_adpics p ON a.adid = p.adid AND p.isevent = '0'
WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW()
AND ct.countryid = 6
GROUP BY a.adid
ORDER BY a.createdon DESC
LIMIT 40Table './porkypost/clf_ads' is marked as crashed and should be repaired