100

Die letzten 100 Tage


SELECT a.id AS article_id, a.name AS article_name, a.art_kind_of, date_format(a.createdate, '%d.%m.%Y') as cdate, a.art_comment_allowed, s.value1, s.value2, s.value3, s.value4, s.value5, s.value19, s.value20, s.media1, s.media2 FROM rex_article a LEFT JOIN rex_article_slice s ON a.id = s.article_id WHERE a.clang_id = '1' AND a.status = '1' AND a.parent_id = '1' AND s.priority = '1' AND s.revision= '0' AND a.createdate <= '2020-10-29' AND a.createdate > '2020-07-20' AND INSTR(s.value20, 'Musik') > 0 ORDER BY a.createdate DESC, a.priority DESC LIMIT 0, 7;