Hallo,

ich habe folgendes Query:

SELECT `applicantFirstname`, `applicantSurname`, `jobGroupID`, `jobGroupStatus`, COUNT(`jobFileGroup`) AS `CountApplications`, `jobGroupDate` FROM `ij_applicant` LEFT JOIN `ij_jobFile` jF ON (`jobFileGroup` = `jobGroupID`) LEFT JOIN `ij_jobGroup` jG ON ( `jobGroupApplicant` = `applicantID` AND `jobGroupStatus` BETWEEN '2' AND '4' AND `jobGroupDate` > '1126735200' ) WHERE `applicantAgency` = '3' GROUP BY `jobGroupID` ORDER BY `jobGroupDate` DESC LIMIT 0, 20

und bekomme obigen Fehler... Was bedeutet das?

Vielen Dank schon jetzt