wpdb queries with meta data

wpdb-queries-with-meta-data.php

<?php
$results = $wpdb->get_results(
"
SELECT key2.meta_value as cat_id, $wpdb->posts.ID as action_id -- , $wpdb->posts.post_title as title
FROM $wpdb->posts
   INNER JOIN $wpdb->postmeta key1
      ON $wpdb->posts.ID = key1.post_id
   INNER JOIN $wpdb->postmeta key2
      ON $wpdb->posts.ID = key2.post_id
WHERE key1.meta_key = 'active' 
   AND key1.meta_value = '1' 
   AND key2.meta_key = 'term4action' 
   AND key2.meta_value != 0
ORDER BY $wpdb->posts.post_date
"
); 

$actions = array();
foreach ($results as $result) {
   $actions[] = $result;
}

dump($actions);



$results = $wpdb->get_results(
"
SELECT key2.meta_value as cat_id, $wpdb->posts.ID as action_id -- , $wpdb->posts.post_title as title
FROM $wpdb->posts
   INNER JOIN $wpdb->postmeta key1
      ON $wpdb->posts.ID = key1.post_id
   INNER JOIN $wpdb->postmeta key2
      ON $wpdb->posts.ID = key2.post_id
WHERE key1.meta_key = 'active' 
   AND key1.meta_value = '1' 
   AND key2.meta_key = 'term4action' 
   AND key2.meta_value = 14
ORDER BY $wpdb->posts.post_date DESC
"
); 

$actions = array();
foreach ($results as $result) {
   $actions[] = $result;
}

dump($actions);