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 = '416' 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 'Serious Factory' ) ORDER BY user_registered DESC

Serious Factory

Site web http://www.seriousfactory.com/
Pays France
Domaines d'activité Serious games industry | Gamification industry | E-Learning industry
Domaines d'expertise INTERNAL_GAMIFICATION | EXTERNAL_GAMIFICATION | LOCALISATION | LEARNING GAMES | SIMULATION GAMES | COMMUNICATION GAMES | ADVERT GAMES | ELEARNING | ENGINE/TOOLS
Plateformes supportées PHONE APPS | WEB | LOCAL PC/MAC
Langues parlées ENGLISH | FRENCH | ITALIAN | SPANISH
Nombre de projets livrés > 20
Nombre d'employés 16 - 30 employees
Email de contact principal gruzzu@seriousfactory.com
Email de contact secondaire wperes@seriousfactory.com
Téléphone 0170719843


Serious Factory is an editor of innovative training program (immerisve simulators, Serious Games, digital solutions based on Gamification approach...), helps companies transform their customer relationships and managerial practices.
Serious Factory est éditeur de solutions pédagogiques innovantes pour la formation (simulateurs immersifs, Serious Games, solutions digitales basées sur le principe de Gamification...), afin d’accompagner les entreprises dans la transformation de leur relation client et des pratiques managériales.
Plus d'informations sur ce membre