mauriciowho

Oh, and here’s my query:

Query:
SELECT <code>submit_time</code> AS 'Submitted',
 max(if(<code>field_name</code>='your-name', <code>field_value</code>, null )) AS 'your-name',
 max(if(<code>field_name</code>='your-email', <code>field_value</code>, null )) AS 'your-email',
 max(if(<code>field_name</code>='your-cpf', <code>field_value</code>, null )) AS 'your-cpf',
 max(if(<code>field_name</code>='your-fone', <code>field_value</code>, null )) AS 'your-fone',
 max(if(<code>field_name</code>='CategoriaDeInscricao', <code>field_value</code>, null )) AS 'CategoriaDeInscricao',
 max(if(<code>field_name</code>='Minicursos', <code>field_value</code>, null )) AS 'Minicursos',
 max(if(<code>field_name</code>='Page Title', <code>field_value</code>, null )) AS 'Page Title',
 max(if(<code>field_name</code>='Page URL', <code>field_value</code>, null )) AS 'Page URL',
 max(if(<code>field_name</code>='Submitted from Page URL', <code>field_value</code>, null )) AS 'Submitted from Page URL',
 max(if(<code>field_name</code>='Submitted Login', <code>field_value</code>, null )) AS 'Submitted Login',
 max(if(<code>field_name</code>='Submitted From', <code>field_value</code>, null )) AS 'Submitted From',
 GROUP_CONCAT(if(<code>file</code> is null or length(<code>file</code>) = 0, null, <code>field_name</code>)) AS 'fields_with_file'
FROM <code>452988c_cf7dbplugin_submits</code> 
WHERE <code>form_name</code> = 'Confirma??o'  
GROUP BY <code>submit_time</code> 
ORDER BY <code>submit_time</code> DESC
LIMIT 0,100