SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Pinar{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCity = 'Pinar' OR prZip = 'Pinar' OR prStreet LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Pinar{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCountry = 'Pinar') AND (prLocation LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}de{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCity = 'de' OR prZip = 'de' OR prStreet LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}de{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCountry = 'de') AND (prLocation LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Campoverde{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCity = 'Campoverde' OR prZip = 'Campoverde' OR prStreet LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Campoverde{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCountry = 'Campoverde') AND (prLocation LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Spain{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}Spain{4578fa4bd95686b05901dea2f19ffed52aae727e8d4385b27a8b130b8a434f7f}' OR prCountry = 'Spain')