I would like to list all attributes options that our products don't uses. I prefer to use SQL to do that to learn how to work with.
Right now i use this query to get the ID of my attributs
select * from eav_attribute where attribute_code = 'color_shoes';
After i list all the attributes options with this query.
select * from eav_attribute_option eao join eav_attribute_option_value eaov on eao.option_id = eaov.option_id where attribute_id = 2294 and eaov.store_id = 1;
It's here where i dont know to fetch all product based on the current list of attributes options.
What is the relation between EAV tables and Catalog product? right now in the 'catalog_product_entity' table, i have a ATTRIBUTE_ID column but there's no product with attribute_id = 2294.
Someone have hint where i need to look for?