views not showing fields revisions

* create a "revision" view
* add some "historical data" fields (here: textfield and db-based-computedfield)

=> view does show title and revision creation date, but no fields data.

trying to debug i get this sql which cannot work:

SELECT 
  node_revision.vid AS vid, 
  node_revision.nid AS node_revision_nid, 
  node_revision.timestamp AS node_revision_timestamp, 
  node_revision.title AS node_revision_title, 
  
  'node' AS field_revision_field_paket_monat_node_entity_type, 
  'node' AS field_revision_field_title_node_entity_type 

FROM node_revision node_revision 
LEFT JOIN node node ON node_revision.nid = node.nid 
WHERE (( (node.status = :db_condition_placeholder_0) AND (node.type IN (:db_condition_placeholder_1)) )) 
ORDER BY node_revision_timestamp DESC LIMIT 10 OFFSET 0

do i miss something here, maybe a relation? (did not findt sth promising there)

btw: is devel the only way to show sql nowadays?