Custom Query With Multiple Meta Key Value

Try this:
<?php
    $querydetails = "
        SELECT wposts.*             
          FROM $wpdb->posts wposts
        INNER
          JOIN ( SELECT post_id
                   FROM $wpdb->postmeta wpostmeta
                        WHERE ( 
                            ( wpostmeta.meta_key = 'type' AND wpostmeta.meta_value LIKE '%Collection1%' )
                        OR 
                            ( wpostmeta.meta_key = 'type'AND wpostmeta.meta_value LIKE '%Collection2%' )
                        OR 
                            ( wpostmeta.meta_key = 'type'AND wpostmeta.meta_value LIKE '%Collection3%' )
                        OR
                            ( wpostmeta.meta_key = 'type'AND wpostmeta.meta_value LIKE '%Collection4%' )
                        OR
                            ( wpostmeta.meta_key = 'type'AND wpostmeta.meta_value LIKE '%Collection5%' )
                        )
                        GROUP BY post_id
                ) AS t
            ON t.post_id = wposts.ID
            WHERE wposts.post_status="publish"
            AND wposts.post_type="book"
            ORDER BY wposts.post_date DESC
         ";
    $pageposts = $wpdb->get_results($querydetails, OBJECT)
?>

<?php 
    if ($pageposts):
        foreach ($pageposts as $post):
            setup_postdata($post); 
?>
            <h2><a href="https://wordpress.stackexchange.com/questions/136790/<?php the_permalink() ?>"><?php the_title(); ?></a></h2>

<?php endforeach; endif; ?>
I hope this will works for you 🙂
Related Posts:
