I want to generate a query, which returns me all of the attributes from a specific group. In the image below you can see the wanted result:D
This is my try:
select ea.attribute_code from eav_attribute ea
inner join eav_entity_attribute eav
on ea.entity_type_id = eav.entity_type_id
inner join eav_entity_type t
on ea.entity_type_id = t.entity_type_id
where eav.attribute_group_id = 26
and t.entity_type_code = 'catalog_product'
26 is the General id.
What should i change with my query ?