I agree 100% with Justin, if you don't know how the CMOD database is structure, I WILL NEVER use such already made, and most probably wrong SQL.
CMOD use bits in its database field in order to define what needs to be done.
Maybe in your case the bit 256, or 8196 was the one setting the disable flag. If it was 8196, then with your query you will miss 8196+1, 8196+2, 8196+4, etc...
So please if you don't know what you are doing, don't query the database .... use arsxml instead, that way you will be future proof