A compound of the formula or a tautomer, stereoisomer, enantiomer, diastereomer, salt, or N-oxide thereof, wherein D is substituted or unsubstituted monocyclic aryl, substituted with one to five substituents selected from halogen, substituted or unsubstituted alkyl or - CONR x R y; each occurrence of R x and R y is independently selected from hydrogen, hydroxy, substituted or unsubstituted alkyl, substituted or unsubstituted alkoxy, substituted or unsubstituted cycloalkyl, substituted or unsubstituted heterocyclic ring, substituted or unsubstituted aryl, substituted or unsubstituted arylalkyl, substituted or unsubstituted heteroaryl, and substituted or unsubstituted heteroarylalkyl, or any two of R x, and R y which are directly bound to a common atom may be joined to form (i) an oxo (C=O), thio (C=S) or imino (C=NR) group (where R' is H or alkyl) or (ii) a substituted or unsubstituted, saturated or unsaturated 3-14 membered ring, which may optionally include one or more heteroatoms which may be the same or different and are selected from O, NR (where R' is H or alkyl) or S; each occurrence of R 2 is hydrogen; L 2 is -CR a R b -; X is N; Cy 2 is each occurrence of R a and R b may be same or different and are independently selected from hydrogen, halogen, substituted or unsubstituted C 1-6 alkyl, substituted or unsubstituted C 2-6 alkenyl, substituted or unsubstituted C 2-6 alkynyl, substituted or unsubstituted C 3-6 cycloalkyl, substituted or unsubstituted C 3-6 cycloalkylalkyl, and substituted or unsubstituted C 3-6 cycloalkenyl, or when two R a and/or R b substituents are directly bound to a common atom, they may be joined to form a substituted or unsubstituted, saturated or unsaturated 3-10 member ring, which may optionally include one or more heteroatoms which may be same or different and are selected from O, NR c or S; and each occurrence of R c is independently selected from hydrogen, nitro, hydroxy, cyano, halogen, substituted or unsubstituted C 1-6 alkyl, substituted or unsubstituted C 2-6 alkenyl, substituted or unsubstituted C 2-6 alkynyl, substituted or unsubstituted C 3-6 cycloalkyl, substituted or unsubstituted C 3-6 cycloalkylalkyl, and substituted or unsubstituted C 3-6 cycloalkenyl. D is substituted or unsubstituted monocyclic aryl, substituted with one to five substituents selected from halogen, substituted or unsubstituted alkyl or - CONR x R y; each occurrence of R x and R y is independently selected from hydrogen, hydroxy, substituted or unsubstituted alkyl, substituted or unsubstituted alkoxy, substituted or unsubstituted cycloalkyl, substituted or unsubstituted heterocyclic ring, substituted or unsubstituted aryl, substituted or unsubstituted arylalkyl, substituted or unsubstituted heteroaryl, and substituted or unsubstituted heteroarylalkyl, or any two of R x, and R y which are directly bound to a common atom may be joined to form (i) an oxo (C=O), thio (C=S) or imino (C=NR) group (where R' is H or alkyl) or (ii) a substituted or unsubstituted, saturated or unsaturated 3-14 membered ring, which may optionally include one or more heteroatoms which may be the same or different and are selected from O, NR (where R' is H or alkyl) or S; each occurrence of R 2 is hydrogen; L 2 is -CR a R b -; X is N; Cy 2 is each occurrence of R a and R b may be same or different and are independently selected from hydrogen, halogen, substituted or unsubstituted C 1-6 alkyl, substituted or unsubstituted C 2-6 alkenyl, substituted or unsubstituted C 2-6 alkynyl, substituted or unsubstituted C 3-6 cycloalkyl, substituted or unsubstituted C 3-6 cycloalkylalkyl, and substituted or unsubstituted C 3-6 cycloalkenyl, or when two R a and/or R b substituents are directly bound to a common atom, they may be joined to form a substituted or unsubstituted, saturated or unsaturated 3-10 member ring, which may optionally include one or more heteroatoms which may be same or different and are selected from O, NR c or S; and each occurrence of R c is independently selected from hydrogen, nitro, hydroxy, cyano, halogen, substituted or unsubstituted C 1-6 alkyl, substituted or unsubstituted C 2-6 alkenyl, substituted or unsubstituted C 2-6 alkynyl, substituted or unsubstituted C 3-6 cycloalkyl, substituted or unsubstituted C 3-6 cycloalkylalkyl, and substituted or unsubstituted C 3-6 cycloalkenyl.