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