Fork Copy (SELECT e.attribute_code, 'varchar' AS type, v.value FROM attribute_value_varchar v JOIN eav_attribute e ON e.id = v.attribute_id WHERE v.entity_id = 1) UNION (SELECT e.attribute_code, 'datetime' AS type, v.value FROM attribute_value_datetime v JOIN eav_attribute e ON e.id = v.attribute_id WHERE v.entity_id = 1) UNION (SELECT e.attribute_code, 'decimal' AS type, v.value FROM attribute_value_decimal v JOIN eav_attribute e ON e.id = v.attribute_id WHERE v.entity_id = 1) UNION (SELECT e.attribute_code, 'int' AS type, v.value FROM attribute_value_int v JOIN eav_attribute e ON e.id = v.attribute_id WHERE v.entity_id = 1) UNION (SELECT e.attribute_code, 'text' AS type, v.value FROM attribute_value_text v JOIN eav_attribute e ON e.id = v.attribute_id WHERE v.entity_id = 1) ORDER BY attribute_code;