Pasted

SELECT COUNT(*)
 
FROM civicrm_contact contact_civireport   
         
               INNER JOIN civicrm_membership membership_civireport
                          ON contact_civireport.id =
                             membership_civireport.contact_id AND membership_civireport.is_test = 0
               LEFT  JOIN civicrm_membership_status mem_status_civireport
                          ON mem_status_civireport.id =
                             membership_civireport.status_id 
 
 
WHERE ( membership_civireport.membership_type_id IN (1) ) AND ( mem_status_civireport.id IN (1, 2, 3, 12) )  
 
ORDER BY membership_civireport.membership_type_id DESC