SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Calvià{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCity = 'Calvià' OR prZip = 'Calvià' OR prStreet LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Calvià{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCountry = 'Calvià') AND (prLocation LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}/{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}/{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCountry = '/') AND (prLocation LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Magaluf{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCity = 'Magaluf' OR prZip = 'Magaluf' OR prStreet LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Magaluf{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCountry = 'Magaluf') AND (prLocation LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Spain{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}Spain{9c4fde257e3d77b01f7bca0c376cf31f4f1947178be8eebe0ab455865a616e99}' OR prCountry = 'Spain')
