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