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' AND idx.itemID IN (2740, 2741, 2745, 2747, 2758, 2762, 2772, 2854, 2859, 2882, 2895, 2896, 2897, 2898, 2899, 2900, 2901, 2902, 2903, 2904, 2905, 2906, 2907, 2911, 2912, 2913, 2914, 2924, 2927, 2928, 2931, 2932, 2936, 2939, 2941, 2942, 2943) 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:04: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
