SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Lloret{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCity = 'Lloret' OR prZip = 'Lloret' OR prStreet LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Lloret{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCountry = 'Lloret') AND (prLocation LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}de{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}de{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCountry = 'de') AND (prLocation LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Mar{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCity = 'Mar' OR prZip = 'Mar' OR prStreet LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Mar{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCountry = 'Mar') AND (prLocation LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Spain{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}Spain{dcbeb970c4e69fbba8a1ea25a1d397f33c902d3d978bc6fa72964896becbd1f8}' OR prCountry = 'Spain')