get_results( $wpdb->prepare( "SELECT * FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'addressya_creditapp' AND post_status = 'publish' AND meta_key = '_billing_addressya_credit_status' AND meta_value = 'pending'" ) ); if(isset($_GET['status']) && $_GET['status'] !== ''){ //$results = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'addressya_creditapp' AND post_status = 'publish' ORDER BY post_date desc" ); $results = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'addressya_creditapp' AND post_status = 'publish' AND meta_key = '_billing_addressya_credit_status' AND meta_value = '".$_GET['status']."'" ) ); } else { $results = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'addressya_creditapp' AND post_status = 'publish' ORDER BY post_date desc" ); } ?>