SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Venda{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCity = 'Venda' OR prZip = 'Venda' OR prStreet LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Venda{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCountry = 'Venda') AND (prLocation LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}do{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCity = 'do' OR prZip = 'do' OR prStreet LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}do{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCountry = 'do') AND (prLocation LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Pinheiro{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCity = 'Pinheiro' OR prZip = 'Pinheiro' OR prStreet LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Pinheiro{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCountry = 'Pinheiro') AND (prLocation LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Portugal{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCity = 'Portugal' OR prZip = 'Portugal' OR prStreet LIKE '{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}Portugal{d7e003dc2b404dd7a7acb67cb1c82ce1289ee43a6989fd0f878bad5d4acd788f}' OR prCountry = 'Portugal')