Query: SELECT immobili.*, province.*, pvp_desc.descrizione as descr FROM immobili LEFT JOIN province ON immobili.provincia = province.siglaprovincia INNER JOIN pvp_desc ON pvp_desc.id_immobile = immobili.ID WHERE immobili.descrizione = 1 AND indirizzo IS NOT NULL AND ( tipologia LIKE "%immobile%" OR tipologia LIKE "%altra%") AND (asta = 0 OR data_vendita > DATE_ADD(CURDATE(), INTERVAL 5 DAY) ) AND visibile = 1 AND ((prezzo_base BETWEEN 0 AND ) OR ( prezzo_base BETWEEN 0 AND ) ) GROUP BY immobili.ID ORDER BY immobili.`data_ins` DESC LIMIT 0 , 20