I am often cutting and pasting this in wordpress plugins $query = “SELECT id, post_title FROM ” . $wpdb->prefix . “posts WHERE post_type = ‘wpf_venue’ AND post_status=’publish’”; $venues = $wpdb->get_results ( $query, ARRAY_A );