SELECT * FROM podcast_series WHERE series_dirname='Invest-in-Cyprus'
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-08-12 04:28:38' AND podcast.podcastID=podcast_tags.podcastID AND trim(podcast_tags.tag_name)='investinCyprus' GROUP BY podcast.podcastID ORDER BY podcast.podcast_date DESC