how to select for revisions of one language?

Matoeil

6/14/23, 3:49 PM

the node revision delete module do not distinguish the language of the revisions.

The sql query for candidate revisions of each node is :

SELECT t.vid AS vid
FROM
(SELECT r.vid AS vid, r.revision_timestamp AS revision_timestamp
FROM
node_field_data n
INNER JOIN node_revision r ON r.nid = n.nid
WHERE (n.nid = '7459') AND ("changed" < '1644848132') AND ((n.vid > r.vid))
GROUP BY n.nid, r.vid, r.revision_timestamp
ORDER BY "revision_timestamp" DESC
LIMIT 9223372036854775807 OFFSET 4) t

i can retrieve the active languages of the site

 // Getting the list of enabled languages
    $langcodes = \Drupal::languageManager()->getLanguages();
    $langcodesList = array_keys($langcodes);

I did not find how to iterate that query for each languages, selecting each time only the revisionf for that language

0 + 0

nodes