--------------------------------------------------------
-- 2019-02-17 06:23:10
-- /cikkek/hirek.php?page=3
-- Unknown column 'article.date_time' in 'order clause'
SELECT
article.*,
IF(shortlink.name IS NOT NULL,shortlink.name,article.article_url) AS url
FROM
(
SELECT
article.id,
article.title,
DATE_FORMAT(datetime,'%Y. %m. %d.') AS date,
DATE_FORMAT(datetime,'%Y-%m-%d %H:%i:%s') AS date_time,
CONCAT_WS('','/cikkek/cikk.php?id=',article.id) AS article_url
FROM
article
WHERE
article.shown=1 AND article.datetime<=NOW() AND article.article_section_id IN ('1','1') AND DATE_FORMAT(datetime,'%Y. %m. %d.') >= '2019. 01. 18.' AND DATE_FORMAT(datetime,'%Y. %m. %d.') <= '2019. 01. 27.'
ORDER BY
`article`.`date_time` DESC
) AS article
LEFT JOIN
shortlink
ON
shortlink.table_name='article'
AND
shortlink.table_id=article.id;
Hírek
