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 ')) ORDER by `malyshevss_ido_ulstu`.`idotestrmod_news`.news_date' at line 19 » | ||
SQL: SELECT
`malyshevss_ido_ulstu`.`idotestrmod_news`.id,
`malyshevss_ido_ulstu`.`idotestrmod_news`.title,
`malyshevss_ido_ulstu`.`idotestrmod_news`.show_preview,
`malyshevss_ido_ulstu`.`idotestrmod_news`.news_body,
`malyshevss_ido_ulstu`.`idotestrmod_news`.news_date,
`malyshevss_ido_ulstu`.`idotestrmod_news`.autor,
`malyshevss_ido_ulstu`.`idotestrmod_news`.full_link,
`malyshevss_ido_ulstu`.`idotestrmod_news`.publish,
`malyshevss_ido_ulstu`.`idotestrmod_news`.catid,
`malyshevss_ido_ulstu`.`idotestrmod_newscat`.cat_name
FROM
`malyshevss_ido_ulstu`.`idotestrmod_newscat`,
`malyshevss_ido_ulstu`.`idotestrmod_news`
WHERE
(`malyshevss_ido_ulstu`.`idotestrmod_news`.catid = `malyshevss_ido_ulstu`.`idotestrmod_newscat`.id)
AND
(`malyshevss_ido_ulstu`.`idotestrmod_news`.publish = 1)
AND (`malyshevss_ido_ulstu`.`idotestrmod_news`.catid IN ())
ORDER by
`malyshevss_ido_ulstu`.`idotestrmod_news`.news_date DESC
[Copy SQL to ClipBoard] | ||
Parser timing | ||
MySQL: | 0.0010 s | (6 Requests) |
PHP: | 0.0466 s | |
Total: | 0.0476 s |