Home  | My Backyard | Signup | Login

Find Your Local Masjid
I Heart Halal Festival this weekend.
The inaugural I Heart Halal Festival is just one day away! The IFANCA's IHH team has been working hard to provide an INDOOR festival that reflects the wide variety of tastes and interests in the Muslim community. Check out the ...  Read more
52nd Annual ISNA Convention in Chicago
We invite you to join us at the 52nd Annual ISNA Convention in Rosemont, Illinois. ISNA Annual Convention is a four-day family program with a full variety of activities. This year's theme is Stories of Resilience: Strengthening the Ame...  Read more
Chicago Classified
IT Jobs/Training
Used Cars
Services   More
.Net/Java/J2EE/SAP Training
Arabic Class or Programs
Certification Programs
Degree Programs
Featured IT Jobs/Training/Arabic Class
Best Web Design Training Institutes in N...
Best Python Training Institute in Noida
CCNA Summer Training in Noida
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