The Ivermectin Debate

Is ivermectin highly effective or totally useless against covid? And why is there still no agreement on this question?