giovani

[relatorio_progresso_alunos_avancado]

SELECT c.post_title AS curso_nome, a.post_title AS aula_nome, u.display_name AS aluno_nome, u.user_email AS aluno_email, CONCAT( LPAD(FLOOR(tv.tempo / 3600), 2, ‘0’), ‘:’, LPAD(FLOOR((tv.tempo % 3600) / 60), 2, ‘0’), ‘:’, LPAD((tv.tempo % 60), 2, ‘0’) ) AS tempo_assistido, CONCAT( LPAD(FLOOR(tv.duracao_total / 3600), 2, ‘0’), ‘:’, LPAD(FLOOR((tv.duracao_total % 3600) / 60), 2, ‘0’), ‘:’, LPAD((tv.duracao_total % 60), 2,

SELECT u.display_name AS ‘Nome Completo’, u.user_email AS ‘Email’, (SELECT post_title FROM wp_posts WHERE ID = 29816) AS ‘Nome do Curso’ FROM wp_users u WHERE u.ID IN (SELECT user_id FROM wp_usermeta WHERE meta_key = ‘course_29816_access_from’);