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-22 13:18:38' AND podcast.podcastID=podcast_tags.podcastID AND podcast_tags.tag_name='analyst updates' GROUP BY podcast.podcastID ORDER BY podcast.podcast_date DESC