I need to find the
attribute_id values of the attributes
thumbnail. I know them for my database - 85, 86 and 87, but I need to make my query dynamic, instead of with hard-coded values. What I struggle with is to find in which table the attributes are stored. I checked
catalog_product_attribute but there is no column with the
name/code of the attributes.
I need to acquire them as an SQL query, not as
Mage::... PHP code.
A sample SQL query code or any other guidance will be very helpful.