SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM p4_blog_index idx
JOIN p4_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID'
JOIN p4_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2026-11-02 21:02:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 24
Tel.: 0791 97 33 33
Tel.: 0791 97 33 44
StHörfunk was Gutes tun?
Jetzt Mitglied werden oder Spenden!
–
Förderverein Freies Radio StHörfunk e.V.
IBAN: DE70 6229 0110 0000 0020 03
BIC: GENODES1SHA
