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-07-18 19:41:25' AND podcast.podcastID=podcast_tags.podcastID AND podcast_tags.tag_name='CSR' GROUP BY podcast.podcastID ORDER BY podcast.podcast_date DESC
Sustainability In Greece Series
