Differences

This shows you the differences between two versions of the page.

--- drupal:databank [2025/02/14 18:20] – [tabellen] admin
+++ drupal:databank [2025/02/18 18:35] (current) – [alle dagboekbladen die nog niet werden afgeprint] admin
@@ Line 19: / Line 19: @@
   * node_body: eigenlijke inhoud van de node
   * node_field_data: metadata over node: oa titel
-  * node_field_revision: info over revisies
+  * node_revision: info over revisies
   * node_revision_body: inhoud van elke revisie
   * node_field_revision: metadata over revisies
@@ Line 77: / Line 77: @@
 ====alle dagboekbladen die nog niet werden afgeprint====
-<code>SELECT title AS "Entries in schrift" FROM l7gh_node_field_data LEFT JOIN l7gh_node__field_geprint_ ON l7gh_node_field_data.nid = entity_id WHERE field_geprint__value IS NULL AND type = 'dagboek';</code>
+<code>SELECT title AS "Entries in schrift" FROM l7gh_node_field_data LEFT JOIN l7gh_node__field_geprint_ ON l7gh_node_field_data.nid = entity_id WHERE field_geprint__value = 0 AND type = 'dagboek';</code>
 ====idem maar de dit keer met de node ID====