File: /renet/sites/renet3/Backend/src/Core/Query2/AbstractSearch.php
Line: 261

/renet/sites/renet3/Backend/src/Core/Query2/AbstractSearch.php:261 -> debug
/renet/sites/renet3/Backend/src/Core/Query2/AbstractSearch.php:232 -> _getResults
/renet/sites/renet3/Backend/src/SmartWeb/Pages/Agency/Office/Office.php:117 -> query
/renet/sites/renet3/Backend/src/SmartWeb/Pages/Agency/Office/Office.php:19 -> getListings
/renet/sites/renet3/Backend/src/SmartWeb/Pages/Page.php:38 -> init
/renet/sites/renet3/Backend/src/SmartWeb/Pages/Service.php:169 -> __construct
/renet/sites/renet3/Backend/src/SmartWeb/IndexController.php:205 -> getPage
: -> indexAction
: -> callActionMethod
: -> dispatch
/renet/sites/renet3/Backend/src/Core/Mvc/AbstractApplication.php:43 -> handle
/renet/sites/renet3/Backend/src/Core/init.php:94 -> main
/renet/sites/renet3/Public/smartweb/index.php:122 -> require_once

^ "Syntax error, unexpected token ), near to ' OR ListingsAgentsOfficeId.office_id IS NULL) GROUP BY Listings.id ORDER BY Listings.id DESC LIMIT :APL0:', when parsing: SELECT [Listings].[id] AS [listingID], [Listings].[prop_address_nu] AS [streetNumber], [Listings].[prop_address_st] AS [street], [Listings].[location] AS [suburb], [Listings].[state] AS [state], [Listings].[postcode] AS [postcode], [Listings].[thum_img] AS [thumbnail], [Listings].[main_img] AS [mainImage], [Listings].[for_sale] AS [forSale], [Listings].[for_rent] AS [forRent] FROM [\Renet\Models\Db\properties\Listings] AS [Listings] LEFT JOIN [\Renet\Models\Db\properties\ListingsAgentsOfficeId] AS [ListingsAgentsOfficeId] ON Listings.id = ListingsAgentsOfficeId.prop_id WHERE (((Listings.agents_id = :agencyID:) AND (Listings.for_sale = '1')) AND (Listings.archived != '1' AND Listings.sold != '1' AND Listings.sold != '4')) AND (ListingsAgentsOfficeId.office_id IN () OR ListingsAgentsOfficeId.office_id IS NULL) GROUP BY Listings.id ORDER BY Listings.id DESC LIMIT :APL0: (879)"