SELECT * FROM soggiorni.operatorixy_ap T1 WHERE T1.id_ap='PNCIR' ORDER BY Epagosp DESC, CAP, kcomune, etipologia, Stelle DESC, knominativo