WordPress :: Sample WPDB

wpdb-sample.php

<?php
global $wpdb;
$query = "SELECT $wpdb->posts.ID
    FROM $wpdb->posts  
    WHERE $wpdb->posts.post_type = 'facility' 
    ORDER BY RAND() 
    LIMIT 8";

$results = $wpdb->get_col($wpdb->prepare( $query ));
$ar_posts = array();

if($results) {
    foreach ( $results as $id ) {
        $post = get_post( intval( $id ) );
        setup_postdata( $post );

        $ar_posts[] = hb_2015_get_archive_lists();
    }
}   

// echo
require_once(get_stylesheet_directory() . '/template-parts/archive-facility-posts.php');