SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}Haan{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}' OR prCity = 'Haan' OR prZip = 'Haan' OR prStreet LIKE '{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}Haan{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}' OR prCountry = 'Haan') AND (prLocation LIKE '{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}Germany{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}Germany{4a0897bd7189810e56b3d92ce648da7df0107ac705020ef7a76166fe4edcafda}' OR prCountry = 'Germany')