Table 'wppharm_live.properties' doesn't existSELECT `properties`.`ID`, `properties`.`BRANCH_ID`, `AGENT_REF`, `DISPLAY_ADDRESS`, `BEDROOMS`, `PRICE`, `PRICE_QUALIFIER`, `TOWN`, `LET_FURN_ID`, `PROP_SUB_ID`, `STATUS_ID`, `CREATE_DATE`, `offices`.`name` AS `office` FROM `properties`, `offices` WHERE `PUBLISHED_FLAG`=1 AND `properties`.`CREATE_DATE` > '2012-02-09 00:00:00' AND `offices`.`branch_id`=`properties`.`BRANCH_ID`  GROUP BY `AGENT_REF`  ORDER BY `CREATE_DATE` DESC