SELECT
submit_time` AS ‘Submitted’,
max(if(field_name
=’free-food-entry’, field_value
, null )) AS ‘free-food-entry’,
max(if(field_name
=’catering-entry’, field_value
, null )) AS ‘catering-entry’,
max(if(field_name
=’first-name’, field_value
, null )) AS ‘first-name’,
max(if(field_name
=’last-name’, field_value
, null )) AS ‘last-name’,
max(if(field_name
=’street-address’, field_value
, null )) AS ‘street-address’,
max(if(field_name
=’city’, field_value
, null )) AS ‘city’,
max(if(field_name
=’state’, field_value
, null )) AS ‘state’,
max(if(field_name
=’zip’, field_value
, null )) AS ‘zip’,
max(if(field_name
=’your-email’, field_value
, null )) AS ‘your-email’,
max(if(field_name
=’phone’, field_value
, null )) AS ‘phone’,
max(if(field_name
=’eighteen-years-old’, field_value
, null )) AS ‘eighteen-years-old’,
max(if(field_name
=’agree-to-rules’, field_value
, null )) AS ‘agree-to-rules’,
max(if(field_name
=’text-message’, field_value
, null )) AS ‘text-message’,
max(if(field_name
=’email-promotions’, field_value
, null )) AS ’email-promotions’,
max(if(field_name
=’coupon-mailers’, field_value
, null )) AS ‘coupon-mailers’,
max(if(field_name
=’Submitted From’, field_value
, null )) AS ‘Submitted From’,
GROUP_CONCAT(if(file
is null or length(file
) = 0, null, field_name
)) AS ‘fields_with_file’
FROM wp_cf7dbplugin_submits
WHERE form_name
= ‘Dinos Free Food For A Year Signup’
GROUP BY submit_time
ORDER BY submit_time
DESC
LIMIT 0,100`