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