Learn more on featured ads

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