SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}La{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'La' OR prZip = 'La' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}La{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'La') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Finca{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'Finca' OR prZip = 'Finca' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Finca{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'Finca') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Golf{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'Golf' OR prZip = 'Golf' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Golf{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'Golf') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}and{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'and' OR prZip = 'and' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}and{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'and') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Spa{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'Spa' OR prZip = 'Spa' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Spa{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'Spa') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Resort{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'Resort' OR prZip = 'Resort' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Resort{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'Resort') AND (prLocation LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Spain{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}Spain{6bdc8bff8c1c88c7154aee16c12190b2a7f7ec8e84e1a73d8ae4a4e0d4342fc3}' OR prCountry = 'Spain')