Query: SELECT `Listing`.`id`, `Listing`.`reference`, `Listing`.`photoflag`, `Listing`.`dateentered`, `Listing`.`datelastupdated`, `Listing`.`agent_id`, `Listing`.`listclass_id`, `Listing`.`provider`, `Listing`.`officeref`, `Listing`.`coagent_id`, `Listing`.`coofficeref`, `Listing`.`suburb_id`, `Listing`.`publishedsuburb`, `Listing`.`streetno`, `Listing`.`streetname`, `Listing`.`saletype_id`, `Listing`.`pricecode_id`, `Listing`.`pricecurrent`, `Listing`.`pricesort`, `Listing`.`pricemax`, `Listing`.`pricemin`, `Listing`.`auctiondatetime`, `Listing`.`floorarea`, `Listing`.`landarea`, `Listing`.`landareahectare`, `Listing`.`yearbuilt`, `Listing`.`newconst`, `Listing`.`storey_id`, `Listing`.`unitnumber`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`cars`, `Listing`.`ensuites`, `Listing`.`teaser`, `Listing`.`remarks`, `Listing`.`virtualtour`, `Listing`.`othersite`, `Listing`.`thumbnail`, `Listing`.`hideaddress`, `Storey`.`id`, `Storey`.`description`, `Listclass`.`id`, `Listclass`.`listclass`, `Listclass`.`listtype_id`, `Listclass`.`description`, `Listclass`.`sortpos`, `Pricecode`.`id`, `Pricecode`.`description`, `Saletype`.`id`, `Saletype`.`description`, `Suburb`.`id`, `Suburb`.`subarea_id`, `Suburb`.`area_id`, `Suburb`.`suburb_name`, `Agent`.`id`, `Agent`.`accesstype_id`, `Agent`.`code`, `Agent`.`title`, `Agent`.`firstname`, `Agent`.`lastname`, `Agent`.`position`, `Agent`.`homephone`, `Agent`.`homefax`, `Agent`.`mobilephone`, `Agent`.`extension`, `Agent`.`emailaddress`, `Agent`.`website`, `Agent`.`photolarge`, `Agent`.`photosmall`, `Agent`.`profile`, `Agent`.`display`, `Agent`.`showhomedetails`, `Agent`.`pssword`, `Agent`.`displayrow`, `Agent`.`displaycolumn`, `Agent`.`displayrow3`, `Agent`.`displaycol3`, `Coagent`.`id`, `Coagent`.`accesstype_id`, `Coagent`.`code`, `Coagent`.`title`, `Coagent`.`firstname`, `Coagent`.`lastname`, `Coagent`.`position`, `Coagent`.`homephone`, `Coagent`.`homefax`, `Coagent`.`mobilephone`, `Coagent`.`extension`, `Coagent`.`emailaddress`, `Coagent`.`website`, `Coagent`.`photolarge`, `Coagent`.`photosmall`, `Coagent`.`profile`, `Coagent`.`display`, `Coagent`.`showhomedetails`, `Coagent`.`pssword`, `Coagent`.`displayrow`, `Coagent`.`displaycolumn`, `Coagent`.`displayrow3`, `Coagent`.`displaycol3` FROM `listings` AS `Listing` LEFT JOIN `storeys` AS `Storey` ON (`Listing`.`storey_id` = `Storey`.`id`) LEFT JOIN `listclasses` AS `Listclass` ON (`Listing`.`listclass_id` = `Listclass`.`id`) LEFT JOIN `pricecodes` AS `Pricecode` ON (`Listing`.`pricecode_id` = `Pricecode`.`id`) LEFT JOIN `saletypes` AS `Saletype` ON (`Listing`.`saletype_id` = `Saletype`.`id`) LEFT JOIN `suburbs` AS `Suburb` ON (`Listing`.`suburb_id` = `Suburb`.`id`) LEFT JOIN `agents` AS `Agent` ON (`Listing`.`agent_id` = `Agent`.`id`) LEFT JOIN `agents` AS `Coagent` ON (`Listing`.`coagent_id` = `Coagent`.`id`) WHERE agent_id= or coagent_id= ORDER BY `Listclass`.`sortpos` ASC, `pricesort` DESC
Warning: SQL Error: 1064: 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 'or coagent_id= ORDER BY `Listclass`.`sortpos` ASC, `pricesort` in /home/dastle/public_html/cake/libs/model/datasources/dbo_source.php on line 463
