$query = 'SELECT  '.$wpdb->prefix.'posts.ID FROM '.$wpdb->prefix.'posts
            INNER JOIN '.$wpdb->prefix.'postmeta ON ( '.$wpdb->prefix.'posts.ID = '.$wpdb->prefix.'postmeta.post_id )
            INNER JOIN '.$wpdb->prefix.'postmeta AS mt1 ON ( '.$wpdb->prefix.'posts.ID = mt1.post_id )
            INNER JOIN '.$wpdb->prefix.'postmeta AS mt2 ON ( '.$wpdb->prefix.'posts.ID = mt2.post_id AND mt2.meta_key = "casino_active" )
            WHERE
                ((
                    ('.$wpdb->prefix.'postmeta.meta_key = "netent_local_jackpots" AND '.$wpdb->prefix.'postmeta.meta_value = "Yes")
                AND
                    (mt1.meta_key = "netent_local_jackpots_select" AND mt1.meta_value LIKE "%Arabian Nights Jackpot%"))
                OR (
                    ('.$wpdb->prefix.'postmeta.meta_key = "netent_pooled_jackpots" AND '.$wpdb->prefix.'postmeta.meta_value = "Yes" )
                AND
                    (mt1.meta_key = "netent_pooled_jackpot_select" AND mt1.meta_value LIKE "%Arabian Nights Jackpot%"))
                )
            AND '.$wpdb->prefix.'posts.post_type = "casino_reviews"
            AND mt2.meta_value != "no"
            AND ('.$wpdb->prefix.'posts.post_status = "publish") ORDER BY '.$wpdb->prefix.'posts.post_date DESC';