I need to list all disabled products by using mysqla MySQL query.
TooI have too many products onin my database to be using something like this (creating a collection, loading it and looping over it): http://www.srikanth.me/get-all-disabled-products-on-magento/