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
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