Podcasts in archive listing template creation question

Thanks for your work on this plugin. Since your update I have been struggling to make sense of things.

1) I would like to keep podcast episodes quarantined in the “Podcasts” section of the back end rather than using regular posts with podcasting features. However, my template is apparently one that does not honor the setting “include podcast in main blog”… While podcast episodes show up in series on the front page, they do not show up in my archives list of all posts on the site. The code for the archives page is:

<table id=arc>
			<?php
			$query = "SELECT YEAR(post_date) AS <code>year</code>, MONTH(post_date) as <code>month</code>, DAYOFMONTH(post_date) as <code>dayofmonth</code>, ID, post_name, post_title FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' ORDER BY post_date DESC";
			$key = md5($query);
			$cache = wp_cache_get( 'mp_archives' , 'general');
			if ( !isset( $cache[ $key ] ) ) {
			  $arcresults = $wpdb->get_results($query);
			  $cache[ $key ] = $arcresults;
			  wp_cache_add( 'mp_archives', $cache, 'general' );
			} else {
			  $arcresults = $cache[ $key ];
			}
			if ($arcresults) {
			  $last_year = 0;
			  $last_month = 0;
			  foreach ( $arcresults as $arcresult ) {
			    $year = $arcresult->year;
			    $month = $arcresult->month;
			    if ($year != $last_year) {
			      $last_year = $year;
			      $last_month = 0;
			?>
			<tr class=year><th><br /><br /><?php echo $arcresult->year; ?></th></tr>
				<?php
				    }
				    if ($month != $last_month) {
				      $last_month = $month;
				?>
			<tr class=archive><th><?php echo $wp_locale->get_month($arcresult->month); ?></th><td></td></tr>
				<?php
				    }
				?>
			<tr class=archive>
				<th><?php echo $arcresult->dayofmonth; ?></th>
				<td id=p<?php echo $arcresult->ID; ?>>
					<a href="/<?php echo $arcresult->post_name; ?>">
					<?php echo strip_tags(apply_filters('the_title', $arcresult->post_title)); ?></a>
				</td>
			</tr>
		</table>

I’m a php novice so I don’t know where to start in including podcast post types as part of this list.

2) I have been searching your site/support forum for information on how to build a replacement template to list podcast episodes in a list format like your older version did, but have been unable to find this information. Can you provide any directions on what code snippets to use to generate such a list in a new template?

Forgive the ignorance, but your plugin is called “seriously simple”… Any help would be appreciated. Thanks again, I’ve tried all the major podcasting plugins and yours is still the best candidate for it actually working for our website.

https://wordpress.org/plugins/seriously-simple-podcasting/