All non-stub service pages without Revenue, PPR + DHS

service_query.php

<?php

$args = array(
  'post_type' => array(
    'service_page',
  ),
  'post_status' => 'any',
  'posts_per_page' => -1,
  'category__not_in'  => array('2', '234', '230'),
  'meta_query' => array(
    array(
      'key'     => 'phila_template_select',
      'value'   => 'service_stub',
      'compare' => 'NOT IN',
      ),
    )
);
$the_query = new WP_Query( $args );

// The Loop
if ( $the_query->have_posts() ) {
	echo '<table>';
	while ( $the_query->have_posts() ) {
		$the_query->the_post();
		echo '<tr><td>' . get_the_title(). '</td><td>' .  get_permalink() .'</td> <td>';

      if( get_the_category()  != null ) {
        foreach((get_the_category()) as $category){
          echo $category->name;
          }
      }

    '</td></tr>';
	}
	echo '</table>';
	/* Restore original Post Data */
	wp_reset_postdata();
} else {
	// no posts found
}?>