SELECT * FROM podcast_series WHERE series_dirname='Shipping-Forums'
SELECT podcast.*, 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 JOIN podcast_tags ON podcast_tags.podcastID = podcast.podcastID WHERE podcast_tags.tag_name IN ('Shipping','Forums','') GROUP BY podcast.podcastID HAVING COUNT(DISTINCT podcast_tags.tag_name) = 2 ORDER BY podcast.podcast_date DESC
SELECT podcast.*, 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 JOIN podcast_tags ON podcast_tags.podcastID = podcast.podcastID WHERE podcast_tags.tag_name IN ('Shipping','Forums','') GROUP BY podcast.podcastID HAVING COUNT(DISTINCT podcast_tags.tag_name) = 2 ORDER BY podcast.podcast_date DESC