THIS IS IT!!!SELECT *, date_format(podcast.podcast_date,'%M %d, %Y') AS podcast_date_info, date_format(podcast.podcast_date,'%h:%i %p') AS podcast_time FROM podcast, podcast_tags WHERE podcast.podcast_status='on' AND podcast.podcast_date<='2025-10-08 17:25:25' AND podcast.podcastID=podcast_tags.podcastID AND trim(podcast_tags.tag_name)='Greece' GROUP BY podcast.podcastID ORDER BY podcast.podcast_date DESC
