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 = '411' 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 'DOWiNO' ) ORDER BY user_registered DESC

DOWiNO

Site web www.dowino.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
Plateformes supportées PHONE APPS | WEB | LOCAL PC/MAC | SOCIAL NETWORKS
Langues parlées ENGLISH | FRENCH | SPANISH
Nombre d'employés 6 - 15 employees
Email de contact principal contact@dowino.com
Email de contact secondaire contact@dowino.com
Téléphone +33 (0)4 27 86 49 89


DOWiNO is a serious games, mobiles apps and short educationnal films creative studio. We are specialised in informing, educating and instructing people on sustainable development, social responsibility, public health and solidarity issues. These complex subjects require easy-to-use tools which spark emotions, pleasure and commitment. We custom-design such tools for public and private organisations. We are convinced that digital technology and gamification encourage reflection on behavior and habits, especially to do with ethical, social and environmental issues. We have more than 10 years experience in the serious game industry and worked with several global companies (ADECCO, Air Liquide, JC Decaux, EDF...) but also small associations (Enfant Bleu, FNATH, BGE...).
DOWiNO est un studio de création de serious games, applications ludiques et films d\'animation didactiques, à forte portée sociale. Nous concevons et développons ces outils sur-mesure pour le compte d\'organisations publiques ou privées afin de sensibiliser, éduquer, former à des problématiques telles que le développement durable, la santé publique, le handicap, la citoyenneté etc... Nous sommes convaincus que le numérique et la ludification invitent à la réflexion, à la remise en cause, au changement des comportements et des habitudes, tout particulièrement sur ces questions éthiques, sociales ou environnementales. Nous avons plus de 10 années d\'expérience dans le serious game et travaillons à la fois avec des grands comptes (ADECCO, Air Liquide, EDF, JC Decaux) mais également avec des plus petites structures associatives telles que Enfant Bleu, la FNATH, BGE etc...
Plus d'informations sur ce membre