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 (meetings.Status = 'display' OR meetings.Status IS NULL)' at line 28query=SELECT
`Contact Name` as ContactName,
`Clerk` as Clerk,
`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,
`Email` as Email,
`Website` as Web,
meeting_stable.`Organisation Name` as MeetingName,
meeting_stable.`Country Name` as Country,
Date_Format(`Date of Info`,'%M %Y') as InfoDate,
Date_Format(`YM Start Date`,'%M %e, %Y') as SDate,
Date_Format(`YM End Date`,'%M %e, %Y') as EDate,
EXTRACT(YEAR FROM `YM Start Date`) as SYear,
EXTRACT(YEAR FROM `YM End Date`) as EYear,
Date_Format(`YM Start Date`,'%M %e') as SDateNY,
`YM Date Comment` as DateComm,
`YM Place` as YMPlace,
`Variety`,
`Web Meeting Type` as Type,
`Name in own Language` as NameOL
FROM ( meeting_stable )
LEFT OUTER JOIN meetings ON CONCAT_WS('-',meetings.`Organisation Name`,meetings.`Country Name`) = CONCAT_WS('-',meeting_stable.`Organisation Name`,meeting_stable.`Country Name`)
WHERE meeting_stable.id = AND (meetings.Status = 'display' OR meetings.Status IS NULL)