SELECT * FROM soggiorni.operatorixy_ap T1 WHERE T1.id_ap='PN5TR' AND T1.localita = 'Manarola'  ORDER BY T1.id_eco1 DESC, pagosp DESC, CAP, localita, Tipologia, Stelle DESC, knominativo