SELECT * FROM (select * from tb_calendario where id1 = 1 ORDER BY punteggio1 DESC) T1
UNION
SELECT * FROM (select * from tb_calendario where id2 = 1 ORDER BY punteggio2 DESC) T2