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