| 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 ') AND tv.id = tvcv.tmplvarid GROUP BY tvc' at line 12 » | ||
| SQL: SELECT
MIN(CONCAT(SUBSTRING(tvcv.value,7,4),'-',SUBSTRING(tvcv.value,4,2),'-',SUBSTRING(tvcv.value,1,2))) AS startDate
FROM
`cvm_www_modx0961`.`modx09_site_tmplvar_contentvalues` AS tvcv,
`cvm_www_modx0961`.`modx09_site_tmplvars` AS tv,
`cvm_www_modx0961`.`modx09_site_content` AS sc
WHERE
tv.name = 'EasyEvents_Start'
AND
tvcv.contentid = sc.id
AND
sc.parent IN ()
AND
tv.id = tvcv.tmplvarid
GROUP BY tvcv.tmplvarid
[Copy SQL to ClipBoard] | ||
| Parser timing | ||
| MySQL: | 0.0023 s | (3 Requests) |
| PHP: | 0.1522 s | |
| Total: | 0.1546 s | |