NAVIGATION
This shows you the differences between two versions of the page.
deutsch:ersetzer_rts:frontend_render:datum-letztes-update [2018/11/14 10:53] Uwe Tholey |
deutsch:ersetzer_rts:frontend_render:datum-letztes-update [2020/03/23 11:05] (current) Uwe Tholey |
||
---|---|---|---|
Line 235: | Line 235: | ||
if( ! (strpos($content["all"],'{DATE_UPDATE')===false)) { | if( ! (strpos($content["all"],'{DATE_UPDATE')===false)) { | ||
- | $sql = 'SELECT UNIX_TIMESTAMP(latest_ts) AS latest_ts FROM( | + | $sql = 'SELECT UNIX_TIMESTAMP(latest_ts) AS latest_ts FROM(( |
- | SELECT MAX(article_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_article WHERE article_deleted=0 AND article_public=1 LIMIT 1 | + | SELECT MAX(article_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_article WHERE article_deleted=0 AND article_public=1 LIMIT 1) |
UNION | UNION | ||
- | SELECT MAX(acat_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_articlecat WHERE acat_trash=0 AND acat_aktiv=1 LIMIT 1 | + | (SELECT MAX(acat_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_articlecat WHERE acat_trash=0 AND acat_aktiv=1 LIMIT 1) |
UNION | UNION | ||
- | SELECT MAX(acontent_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_articlecontent WHERE acontent_visible=1 AND acontent_trash=0 LIMIT 1 | + | (SELECT MAX(acontent_tstamp) AS latest_ts FROM '.DB_PREPEND.'phpwcms_articlecontent WHERE acontent_visible=1 AND acontent_trash=0 LIMIT 1) |
) AS t1 LIMIT 1'; | ) AS t1 LIMIT 1'; | ||