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

Find Your Local Masjid
ISNA Convention 2019
Date: August 30 to Sept 2, 2019 Location Name: George R. Brown Convention Center Address:1001 Avenida de las Americas, Houston, TX 77010 US We are inviting superpeople of all ages to join us in the biggest gathering of soc...  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
Great surprise that suits all the lifestyles (Muslim Center, Auburn) Apr 19, 2019
MSI Summer Program (Council of Islamic Organizations of Greater Chicago (CIOGC), Chicago) Jun 10, 2019
Summer Hifz Program (Chicago) Jun 17, 2019
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