| 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 tvcv.t' 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
`atacsite`.`modx_site_tmplvar_contentvalues` AS tvcv,
`atacsite`.`modx_site_tmplvars` AS tv,
`atacsite`.`modx_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.0126 s | (0 Requests) |
| PHP: | 0.2700 s | |
| Total: | 0.2826 s | |