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 = '415' 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 'Interaction Games' ) ORDER BY user_registered DESC

Interaction Games

Site web www.interaction-games.com
Pays France
Domaines d'activité Serious games industry
Domaines d'expertise INTERNAL_GAMIFICATION | EXTERNAL_GAMIFICATION | LEARNING GAMES | SIMULATION GAMES | COMMUNICATION GAMES | ADVERT GAMES
Plateformes supportées PHONE APPS | WEB | LOCAL PC/MAC | SOCIAL NETWORKS | CLOUD
Langues parlées ENGLISH | FRENCH
Nombre de projets livrés > 20
Nombre d'employés 31 - 50 employees
Email de contact principal jordane.paquet@interaction-games.com
Email de contact secondaire info@interaction-games.com
Téléphone 0141059040


Interaction Games is a communication, awareness and fun interactive training specialist by serious games. Created in 2004, Interaction Games has made more than a hundred serious games in the field of health, transport, agribusiness, banks & insurance, in sustainable development and agriculture .
Interaction Games est un spécialiste de la communication, de la sensibilisation et de la formation ludique et interactive par les serious games. Créée en 2004, Interaction Games a réalisé plus d'une centaine de serious games dans le domaine de la santé, du transport, de l'agro-alimentaire, des banques & assurances ou encore dans le développement durable et dans l'agriculture.
Plus d'informations sur ce membre