Fatal error: SELECT t.ccode, t.country, j.city, j.title, p.company_company, r2.countjobs, DATE_FORMAT(r1.mindate1, '%d-%m-%Y') registred1, DATE_FORMAT(r1.maxdate, '%d-%m-%Y') registred2, j.city, j.title, p.company_company, r2.countjobs FROM job_list_country t, jobcontent_jobs j, jobcontent_company p, ( SELECT ccode, MAX( jobcontent_id ) jobcontent_id, MIN(registred) mindate1, MAX(registred) maxdate FROM jobcontent_jobs WHERE registred >= DATE_SUB(NOW(), INTERVAL 120 DAY) AND enabled = 1 GROUP BY ccode ) r1, ( SELECT COUNT(jobcontent_id) countjobs, ccode FROM jobcontent_jobs WHERE registred >= DATE_SUB(NOW(), INTERVAL 120 DAY) AND enabled = 1 GROUP BY ccode ) r2 WHERE r2.ccode = r1.ccode AND r1.jobcontent_id = j.jobcontent_id AND r1.ccode = t.ccode AND j.company_id = p.company_idORDER BY t.country ASC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY t.country ASC' at line 1 in /home/khalman/public_html/contactcv.com/class_php/class.jobs.grid.php on line 46