The present invention provides benzothiophene carboxamide compounds of formula I, their polymorphs, stereoisomers, prodrugs, solvates, pharmaceutically acceptable salts and formulations thereof, which are useful as COX-2 inhibitors and PfENR inhibitors.The invention further relates to pharmaceutical compositions containing such compounds and methods for their application as COX-2 inhibitors for treating inflammation and pain and PfENR inhibitors for use as anti-malarials.