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 = '410' 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 'My-Serious-Game' ) ORDER BY user_registered DESC

My-Serious-Game

Site web www.my-serious-game.com
Pays France
Domaines d'activité Serious games industry | Gamification industry | E-Learning industry
Domaines d'expertise LEARNING GAMES | SIMULATION GAMES | COMMUNICATION GAMES | ELEARNING
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 contact@my-serious-game.com
Email de contact secondaire jenny.b@my-serious-game.com
Téléphone 0245340440


Hyperactive society with strong development, we are the one French market leader in designing high-end tailormade and turn key digital training solutions. Starting from your stakes and core values, we embark your trainees into an appealing, innovative, interactive and efficient training adventure. Proud of being part of La French Tech, we are dedicated to offer the most immersive and interactive training experiences, our team of experts is supported by common values of curiosity, agility and sharing of know-how. Let’s come in and visit our page ;)!
Société hyperactive rythmée d'une croissance soutenue, My-Serious-Game est le leader du marché français dans la conception de solutions de formations digitales haut de gamme et personnalisées selon vos challenges. À partir de vos enjeux et de vos valeurs fondamentales, nous embarquons vos apprenants dans une aventure de formation attrayante, innovante, interactive et efficace. Fier d'être membre de La French Tech, nous sommes dévoués à offrir les expériences de formation les plus immersives et interactives. Notre équipe d'experts est animée par des valeurs communes de curiosité, d'agilité et de partage de savoir-faire. Osez l'Innovation Pédagogique !
Plus d'informations sur ce membre