SELECT Pa.Paese_t_ID,  Pa.Paese_t FROM Principale as P, paese_t as Pa, cliente_t as C
	WHERE P.Cliente = C.Cliente_t_ID AND P.Paese = Pa.Paese_t_ID AND  Pa.Zona = "Liguria"  AND P.Tipo = "affitto" 
	AND P.Active = 1 AND C.visibile = 1
	GROUP BY Pa.Paese_t_ID ORDER BY Pa.Paese_t ASCQuery errata contattare la Backward