I have tried searching for this one but haven't had much luck. I have over 15k products in my Magento store. At some point we set some of the product's weight to 999. Now I need to generate a list of all of the products that have that set for the weight. I have been trying to find which table in the mysql database that has this information but I can't seem to find it.
In the end I am trying to make a SQL statement that gives me all the product ids for products whose weight is set to 999.
Thank you in advance to anyone who can help.