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 = '420' 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 '1995' ) ORDER BY user_registered DESC

1995

Site web http://www.itycom.com
Pays France
Domaines d'activité Serious games industry | E-Learning industry
Domaines d'expertise INTERNAL_GAMIFICATION | EXTERNAL_GAMIFICATION | LEARNING GAMES | SIMULATION GAMES | COMMUNICATION GAMES | ADVERT GAMES | ELEARNING | ENGINE/TOOLS | SPOC/MOOC
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 16 - 30 employees
Email de contact principal timothe.enault@itycom.com
Email de contact secondaire thibaut.yven@itycom.com
Téléphone 0450699971


ITycom, Digital Learning solutions expert, was founded in Geneva and is based in Switzerland and France. The group has grown strongly thanks to the quality and innovation of its solutions in national and international markets. It is a leader in the European market and was named one of the Top 20 most innovative European e-Learning companies. 2015 winner of Deloitte in Extenso Technology Fast 50 ranking, ITycom is one of the Top 50 fastest-growing technology companies.
ITycom, expert en solutions Digital Learning, a été créé en 2008 en Suisse et est basé à Paris, Lyon, Annecy et Genève. Le groupe a fortement progressé grâce à la qualité et l’innovation de ses solutions sur le marché national et international. Il s’impose dans le Top 20 des entreprises européennes les plus innovantes dans le domaine du e-Learning. Lauréat 2015 du classement Deloitte in extenso Technology Fast 50, ITycom entre dans le Top 50 des entreprises technologiques à forte croissance. En 2015 puis 2016, ITycom est classé 2ème de la catégorie « Excellent » des meilleurs acteurs de Serious Games en France. En 2016, ITycom devient lauréat Top 500 des Entreprises du Numérique. En 2016, ITycom devient le partenaire stratégique du groupe Visiativ et fait l’acquisition de son activité e-Learning. La symbiose de leurs forces respectives augure d’accélérer leur développement au service de la transformation numérique, promesse de ces deux entreprises du futur.
Plus d'informations sur ce membre