ack! query failed:
errorno=1064error=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 'AND fwcc_sections.`Country Name` = projects.`Country Name` AND (Status = 'Displa' at line 34query=SELECT
`Organisation Name` as OrgName,
`Contact Name` as ContactName,
`Building Name` as Addr1,
`Street Address` as Addr2,
`Locality` as Addr3,
`Post Town` as Town,
`State/Co/Prov` as State,
`Postal Code` as Zip,
`Business Phone` as Phone,
`US toll free number` as TFPhone,
`Email` as Email,
`Website` as Web,
projects.`Country Name` as Country,
Date_Format(`Date of Info`,'%M %Y') as InfoDate,
`Territory` as Territory,
`Project Supporting Agency` as Agency,
DATE_FORMAT(`Project Start Date`,'%M %Y') as SDate,
DATE_FORMAT(`Project End Date`,'%M %Y') as EDate,
TO_DAYS(`Project End Date`) - TO_DAYS(NOW()) as DaysLeft,
`Project Volunteer Skills Needed` as Skills,
`Project Volunteer Skills-Other` as SkillsText,
`Project Donations Needed` as Donations,
`Project Description` as Descrip,
`Project Type` as Type,
`Project Volunteers Needed` as Vols,
`Project Staff Vacancy` as Vacancy,
`Project Expertise Offered` as Expertise,
`Project Budget` as Budget,
`Project Report` as Report,
`Project Photo` as Photo,
`FWCC Section` as Section
FROM ( projects, fwcc_sections )
WHERE projects.id = AND fwcc_sections.`Country Name` = projects.`Country Name` AND (Status = 'Display')