gistfile1.txt

SELECT DISTINCT s.paper_id AS 'Submissao ID', s.setting_value AS 'Titulo',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 6 and review_id = a.paper_id) AS '1',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 7 and review_id = a.paper_id) AS '2',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 8 and review_id = a.paper_id) AS '3',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 9 and review_id = a.paper_id) AS '4',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 10 and review_id = a.paper_id) AS '1',
(SELECT response_value FROM review_form_responses WHERE review_form_element_id = 11 and review_id = a.paper_id) AS 'Comentário'
FROM paper_settings s JOIN paper_authors a ON s.paper_id = a.paper_id 
WHERE s.setting_name LIKE 'title' AND a.paper_id = 415
ORDER BY s.setting_value;