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