SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}Halsenbach{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}' OR prCity = 'Halsenbach' OR prZip = 'Halsenbach' OR prStreet LIKE '{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}Halsenbach{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}' OR prCountry = 'Halsenbach') AND (prLocation LIKE '{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}Germany{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}Germany{3b78acac0f7321e0ee937a98a5b8673d8dd7b41448ea253e37c97a4c986da5b2}' OR prCountry = 'Germany')