i'm using following code export custom post type member, custom fields, csv file. member list includes users not of member type "member" value of 0 or 1. filter list export "member" equals 1, cannot figure out how modify statement below so.
global $wpdb; $sql = $wpdb->get_results( "select * wp_posts ( select #`wp_posts`.`id`, max( case when `wp_postmeta`.`meta_key` = 'first_name' `wp_postmeta`.`meta_value` end ) `first name`, max( case when `wp_postmeta`.`meta_key` = 'last_name' `wp_postmeta`.`meta_value` end ) `last name`, max( case when `wp_postmeta`.`meta_key` = 'phone_number' `wp_postmeta`.`meta_value` end ) `phone number`, max( case when `wp_postmeta`.`meta_key` = 'email_address' `wp_postmeta`.`meta_value` end ) `email address`, max( case when `wp_postmeta`.`meta_key` = 'member' `wp_postmeta`.`meta_value` end ) `member` `wp_posts` left join `wp_postmeta` on ( `wp_posts`.`id` = `wp_postmeta`.`post_id` ) `wp_posts`.`post_status` = 'publish' , `wp_posts`.`post_type` = 'member' group `wp_posts`.`id` order `wp_posts`.`post_title` asc ) `t` 1 =1 ");
did try add
having max( case when `wp_postmeta`.`meta_key` = 'member' `wp_postmeta`.`meta_value`else 0 end ) = 1 after
group its hard tell structure wp_posts table assume has row every property of post meta_key = property name , mety_value = value
