SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Sal{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCity = 'Sal' OR prZip = 'Sal' OR prStreet LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Sal{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCountry = 'Sal') AND (prLocation LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Cape{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCity = 'Cape' OR prZip = 'Cape' OR prStreet LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Cape{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCountry = 'Cape') AND (prLocation LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Verde{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCity = 'Verde' OR prZip = 'Verde' OR prStreet LIKE '{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}Verde{49a1ff7607b37eed2298c057315b1ce53d5a8b54306679732585be6f1200d2dd}' OR prCountry = 'Verde')