--------------------------------------------------------
-- 2018-12-11 10:59:32
-- /cikkek/beszamolok.php
-- 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 ('3') AND DATE_FORMAT(datetime,'%Y. %m. %d.') >= '2018. 09. 18.' AND DATE_FORMAT(datetime,'%Y. %m. %d.') <= '2018. 11. 30.'
ORDER BY
`article`.`date_time` DESC
) AS article
LEFT JOIN
shortlink
ON
shortlink.table_name='article'
AND
shortlink.table_id=article.id;
Hírek
