SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Cala{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCity = 'Cala' OR prZip = 'Cala' OR prStreet LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Cala{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCountry = 'Cala') AND (prLocation LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Major{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCity = 'Major' OR prZip = 'Major' OR prStreet LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Major{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCountry = 'Major') AND (prLocation LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Spain{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}Spain{0368d1567de8b1001d98931dabea3d76dfc85eff54d7d3b374d62aea30c320a7}' OR prCountry = 'Spain')