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