Answer 1

SELECT t2.table1_id , t2.id AS table2_id , t2.table3_id_1 , t2.table3_id_2 , t31.value AS x , t32.value AS y FROM table2 t2 LEFT JOIN table3 t31 ON t31.id = t2.table3_id_1 LEFT JOIN table3 t32 ON t32.id = t2.table3_id_2;