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 data_vendita > DATE_ADD(CURDATE(), INTERVAL 15 DAY) AND ((offerta_minima BETWEEN 0 AND ) OR ( offerta_minima BETWEEN 0 AND ) ) GROUP BY immobili.ID ORDER BY immobili.`data_ins` DESC LIMIT 0 , 20