SELECT  sql_calc_found_rows
	      u.id,
          u.user_login,
          u.user_email,
          u.user_nicename,
          u.display_name,
          Unix_timestamp(u.user_registered) AS joindate,
          mu.membership_id,
          mu.initial_payment,
          mu.billing_amount,
          mu.cycle_period,
          mu.cycle_number,
          mu.billing_limit,
          mu.trial_amount,
          mu.trial_limit,
          Unix_timestamp(mu.startdate) AS startdate,
          Unix_timestamp(mu.enddate)   AS enddate,
          m.NAME                       AS membership,
          umf.meta_value               AS first_name,
          uml.meta_value               AS last_name
FROM      wp_users u
LEFT JOIN wp_usermeta umh
ON        umh.meta_key = 'pmpromd_hide_directory'
AND       u.id = umh.user_id
LEFT JOIN wp_usermeta umf
ON        umf.meta_key = 'first_name'
AND       u.id = umf.user_id
LEFT JOIN wp_usermeta uml
ON        uml.meta_key = 'last_name'
AND       u.id = uml.user_id
LEFT JOIN wp_usermeta um
ON        u.id = um.user_id
LEFT JOIN wp_pmpro_memberships_users mu
ON        u.id = mu.user_id
LEFT JOIN wp_pmpro_membership_levels m
ON        mu.membership_id = m.id
WHERE     mu.status = 'active'
AND       (
                    umh.meta_value IS NULL
          OR        umh.meta_value <> '1')
AND       mu.membership_id > 0
GROUP BY  u.id
ORDER BY  u.display_name ASC
LIMIT 	  0, 12