SELECT responses.id,responses.category, answers2.description AS column_2, answers3.description AS column_3, answers4.description AS column_4, answers5.description AS column_5, answers6.description AS column_6, answers7.description AS column_7, answers8.description AS column_8, answers9.description AS column_9, answers10.description AS column_10, answers11.description AS column_11, answers12.description AS column_12, answers13.description AS column_13, answers14.description AS column_14, answers15.description AS column_4radio, answers16.description AS column_18 FROM responses LEFT JOIN answers AS answers2 ON responses.id=answers2.response AND (answers2.option_id=2) LEFT JOIN answers AS answers3 ON responses.id=answers3.response AND (answers3.option_id=3) LEFT JOIN answers AS answers4 ON responses.id=answers4.response AND (answers4.option_id=4) LEFT JOIN answers AS answers5 ON responses.id=answers5.response AND (answers5.option_id=5) LEFT JOIN answers AS answers6 ON responses.id=answers6.response AND (answers6.option_id=6) LEFT JOIN answers AS answers7 ON responses.id=answers7.response AND (answers7.option_id=7) LEFT JOIN answers AS answers8 ON responses.id=answers8.response AND (answers8.option_id=8) LEFT JOIN answers AS answers9 ON responses.id=answers9.response AND (answers9.option_id=9) LEFT JOIN answers AS answers10 ON responses.id=answers10.response AND (answers10.option_id=10) LEFT JOIN answers AS answers11 ON responses.id=answers11.response AND (answers11.option_id=11) LEFT JOIN answers AS answers12 ON responses.id=answers12.response AND (answers12.option_id=12) LEFT JOIN answers AS answers13 ON responses.id=answers13.response AND (answers13.option_id=13) LEFT JOIN answers AS answers14 ON responses.id=answers14.response AND (answers14.option_id=14) LEFT JOIN answers AS answers15 ON responses.id=answers15.response AND (answers15.option_id=15 OR answers15.option_id=16 OR answers15.option_id=17) LEFT JOIN answers AS answers16 ON responses.id=answers16.response AND (answers16.option_id=18) WHERE responses.inquiry=1