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 FROM SGMwp_users u LEFT JOIN SGMwp_pmpro_memberships_users mu ON u.ID = mu.user_id LEFT JOIN SGMwp_pmpro_membership_levels m ON mu.membership_id = m.id WHERE mu.membership_id > 0 AND mu.status = 'active' AND mu.membership_id IN(3,11,12,13,14,15,16,17,18,19,20,21,22) ORDER BY user_registered DESC

Recherche prestataires

Champs d'expertise

Platformes supportées

Langue

Pays

Recherche par nom

Nom