| 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 'AS' at line 5 » | ||
| SQL: SELECT DISTINCT sc.id,sc.published,sc.pub_date,sc.createdon FROM `dengdeng_hakko`.`modx_site_content` sc
LEFT JOIN `dengdeng_hakko`.`modx_document_groups` dg on dg.document = sc.id
WHERE (sc.id IN (51,58,59,69,137,181,182,186,187,188,189,192,211,212) AND sc.published=1 AND sc.deleted=0 )
AND (sc.privateweb=0)
GROUP BY sc.id ORDER BY sc.id AS
[Copy SQL to ClipBoard] | ||
| Parser timing | ||
| MySQL: | 0.8532 s | (30 Requests) |
| PHP: | 0.1634 s | |
| Total: | 1.0166 s | |