Page: /Company/index.php?page=11&agent=32

Browser: CCBot/2.0


DB Error: syntax error


SELECT
	l.id AS id,
	l.title AS title,
	l.address AS address,
	l.municipality AS municipality,
	l.original_price AS original_price,
	l.confidential AS confidential,
	l.sold AS sold,
	l.under_contract AS under_contract,
	l.rental AS rental,
	l.price_reduced AS price_reduced,
	l.category_id AS category_id,
	c.name AS category
FROM
	listings l,
	listing_categories c
WHERE
	l.agent_id =  AND
	c.id = l.category_id AND
	l.active = 1 AND
	expiration_date > '2013-05-23' AND
	( (l.sold = 0) OR (l.sold = 1 AND l.sold_date > '2013-03-23') )
ORDER BY
	dateCrtd DESC
 
[nativecode=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 'AND c.id = l.category_id AND l.active = 1 AND expiration_date > '2013-05-23' ' at line 18]

An error has occurred. Please email the developer (or call 610.762.4002). Include as much detail as possible so that the error can be recreated. Copy and paste any error messages and describe the steps taken before the error occurred. Sorry for the inconvenience and thank you for your cooperation. We will look into this issue immediately.