--------------------------------------------------------
-- 2018-12-11 11:15:06
-- /cikkek/meghallgattuk.php?page=9
-- 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 ('2','3','11','12','13') AND DATE_FORMAT(datetime,'%Y. %m. %d.') >= '2017. 07. 28.' AND DATE_FORMAT(datetime,'%Y. %m. %d.') <= '2017. 09. 20.'
ORDER BY
`article`.`date_time` DESC
) AS article
LEFT JOIN
shortlink
ON
shortlink.table_name='article'
AND
shortlink.table_id=article.id;
Hírek
