Running a SQL Query using TypoScript
Comments Off
Apr.23, 2013 by
spabhat
Well, after using this feature for quite long time, I though I should post this info:Consider the following Query: SELECT DISTINCT FROM_UNIXTIME(`datetime`, ‘%Y’) AS `year` FROM tt_news where pid=113 order by datetime limit 1 My main goal was to get the latest year from the tt_news records, that is then going to be pushed to [...]
