Sociétés

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.status = 'active' AND u.ID = '419' AND mu.membership_id IN(3,11,12,13,14,15,16,17,18,19,20,21,22)
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_usermeta um5 ON u.ID = um5.user_id LEFT JOIN SGMwp_usermeta um7 ON (u.ID = um7.user_id AND um7.meta_key = 'directory') 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(2,3,10,23) OR ( mu.membership_id IN(11,12,13,14,15,16,17,18,19,20,21,22) AND um7.meta_key = 'directory' AND um7.meta_value = 1 ) ) AND ( um5.meta_key = 'company' AND um5.meta_value LIKE 'OnMap' ) ORDER BY user_registered DESC

OnMap

Site web www.onmap-visual.com
Pays France
Domaines d'activité Serious games industry | Gamification industry | E-Learning industry
Domaines d'expertise INTERNAL_GAMIFICATION | EXTERNAL_GAMIFICATION | LEARNING GAMES | SIMULATION GAMES | COMMUNICATION GAMES | ELEARNING | ENGINE/TOOLS
Plateformes supportées PHONE APPS | WEB | LOCAL PC/MAC | CLOUD
Langues parlées ENGLISH | FRENCH
Nombre de projets livrés > 20
Nombre d'employés 16 - 30 employees
Email de contact principal y.jouannin@onmap-visual.com
Email de contact secondaire p.guitteny@onmap-visaul.com
Téléphone +33(0)140139385



OnMap est l'éditeur de la solution de même nom, une plateforme Saas de production d'e-learning et de serious games dédiés à l'accompagnement des transformations et à la formation métier. OnMap s'appuie sur un simulateur universel de situations professionnelles capable de reproduire et de simuler la variété et la complexité de tout métier dans tout secteur d'activité.
Plus d'informations sur ce membre