How can I correctly perform a MySQL multi-table join with potentially ambiguous columns

join shbcf.ru