ack! query failed:
  • errorno=1064
  • error=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 28
  • query=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)