MODx Content Manager »

Agent Name	Price	Details

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 `db200474090`.cmsx_site_prices.stateid = '999' AND `db200474 »
SQL: SELECT `db200474090`.cmsx_site_prices.price,`db200474090`.cmsx_site_prices.agentid,`db200474090`.cmsx_site_agents.name,`db200474090`.cmsx_site_agents.status,`db200474090`.cmsx_site_agents.expire from `db200474090`.cmsx_site_prices LEFT JOIN `db200474090`.cmsx_site_agents ON `db200474090`.cmsx_site_prices.agentid=`db200474090`.cmsx_site_agents.id WHERE `db200474090`.cmsx_site_prices.stateid = OR `db200474090`.cmsx_site_prices.stateid = '999' AND `db200474090`.cmsx_site_agents.prices = 0 AND `db200474090`.cmsx_site_agents.expire > NOW() ORDER BY `db200474090`.cmsx_site_agents.name ASC [Copy SQL to ClipBoard]

Parser timing
MySQL:	0.0145 s s	(9 Requests)
PHP:	0.0278 s s
Total:	0.0423 s s