SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Roth{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCity = 'Roth' OR prZip = 'Roth' OR prStreet LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Roth{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCountry = 'Roth') AND (prLocation LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}an{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCity = 'an' OR prZip = 'an' OR prStreet LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}an{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCountry = 'an') AND (prLocation LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}der{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCity = 'der' OR prZip = 'der' OR prStreet LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}der{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCountry = 'der') AND (prLocation LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Our{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCity = 'Our' OR prZip = 'Our' OR prStreet LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Our{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCountry = 'Our') AND (prLocation LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Germany{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}Germany{1cffd47b87a42b710b609226e7684f820eecd03972d988f1d6c2f2404c1dd369}' OR prCountry = 'Germany')