We served 13 Million Classified Ads & 32 Million Visitors!
Home  | My Backyard | Signup | Login

Find Your Local Masjid
  Distance:   
 
55th Annual ISNA Convention
55TH ANNUAL ISNA CONVENTION IN GOD WE TRUST AUGUST 31 – SEPTEMBER 3, 2018 George R. Brown Convention Center – 1001 Avenida De Las Americas, Houston, TX 77010 http://www.isna.net/convention/  Read more
55th Annual ISNA Convention
55TH ANNUAL ISNA CONVENTION IN GOD WE TRUST AUGUST 31 – SEPTEMBER 3, 2018 George R. Brown Convention Center – 1001 Avenida De Las Americas, Houston, TX 77010 http://www.isna.net/convention/  Read more
Local Events Post Event | View All Events
Recumbent bike for exercise 2018 (Los Angeles) May 31, 2018
A FUN FILLED SUMMER EXPERIENCE (1785 Bloomingdale Rd, Glendale Heights IL 60139) Jul 9, 2018
THE QUEST FOR EXCELLENCE (8531 Epworth Forest Rd, North Webster, IN 46555) Jul 27, 2018
 
Latest Listings
SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, c.countryname, COUNT(*) AS piccount, p.picfile, scat.subcatname, cat.catid, cat.catname FROM xzclf_ads a INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid INNER JOIN xzclf_countries c ON ct.countryid = c.countryid INNER JOIN xzclf_subcats scat ON a.subcatid = scat.subcatid INNER JOIN xzclf_cats cat ON scat.catid = cat.catid LEFT OUTER JOIN xzclf_adxfields axf ON a.adid = axf.adid LEFT OUTER JOIN xzclf_adpics p ON a.adid = p.adid AND p.isevent = '0' LEFT OUTER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'A' WHERE p.picfile <>'' AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0' AND (feat.adid IS NULL OR feat.featuredtill < NOW()) AND ct.countryid = GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 3You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY a.adid ORDER BY a.createdon DESC LIMIT 3' at line 17