SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Hagen{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCity = 'Hagen' OR prZip = 'Hagen' OR prStreet LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Hagen{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCountry = 'Hagen') AND (prLocation LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}/{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCity = '/' OR prZip = '/' OR prStreet LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}/{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCountry = '/') AND (prLocation LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Emst{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCity = 'Emst' OR prZip = 'Emst' OR prStreet LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Emst{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCountry = 'Emst') AND (prLocation LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Germany{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}Germany{c42a9e64ed9d21854db245f8c6d175a3dfd631ce499bd72c48ce98e688235718}' OR prCountry = 'Germany')