I know that MAGENTO has an entity called catalog_product
When a new attribute is created there will be an entry in eav_attribute and if you check this entry there will be a column as entity_type_id
eav_attribute table also has a column known as attribute_code which is nothing but a value of Attribute Code entered while making a new attribute from admin.
I dont know which tables i need to "join" in order to obtain what i want. Query?
I am using MAGENTO 1.9 and MYSQL
Database diagram:
Thanks!
Best Answer
Do you really want / need to build an SQL query? That can get complicated really fast with EAV.
To filter all products by specific attributes in Magento you can use the collections.
For example to get all Products with a name containing 'XYZ':
http://www.beckin.com/the-official-cheat-sheet-for-magento-developers/
You can also print the Select statement of a prepared collection like this:
The same (mostly) in sql would look like:
EDIT: Not sure what you are exactly trying but you really should ask the other side for a proper API Endpoint (for example a rest api) instead of going directly on the database.
I tried to add some Comments for further explaining the query. Although it's mostly SQL knowledge and getting out of scope (=magento) here.
EDIT2: adding two more attributes, one of type text to make it more clear