SELECT COUNT(*) AS cnt
FROM sentences s
JOIN sentence_metadata sm ON sm.sentence_id = s.id
WHERE sm.variant_id = (
    SELECT variant_id
    FROM variants v
    WHERE v.variant_token = 'ug-Arab'
)

SELECT COUNT(*) AS cnt
FROM sentences s
JOIN sentence_metadata sm ON sm.sentence_id = s.id
WHERE sm.variant_id = (
    SELECT variant_id
    FROM variants v
    WHERE v.variant_token = 'ug-Arab'
)

      UPDATE sentence_metadata sm
      JOIN sentences s on s.id = sm.sentence_id
      SET sm.variant_id= (SELECT id FROM variants WHERE variant_token = 'ug-Arab')
      WHERE locale_id = (SELECT id FROM locales WHERE name='ug')
        AND variant_id IS NULL

      INSERT INTO sentence_metadata (sentence_id, variant_id, created_at)
        SELECT 
          s.id,
          v.id,
          NOW()
        FROM 
          sentences s,
          variants v,
          locales l
        WHERE 
          l.name = 'ug'
          AND s.locale_id = l.id
          AND v.variant_token = 'ug-Arab'

common-voice  | [BE] [INFO] Processed migration 02505082230990-set-empty-ug-variants-to-arab
common-voice  | [BE] [INFO] Done

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('fffb7a7b400a2677092451fb8dd4852915b833478bff75e59b0028807805d283', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('fff9f1d40b87002c1e17f5d0cbf8579b72f438f1d9b88cf03a2ea346ea8e0a2c', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('fff09b3c774316891ae9179c8350ca0dc83e9ddf5c30fc2df7dbe357225fa565', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffeed1f099fc9ee842859f6240bc53a307bc3bd31c6bbe9bf271ab088ce7ac52', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffed42e558076d9e017b174fe82e5618cf31719afdf511c9ca6fbb6d60ec9a78', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffe98cab65a55efc87b2b5e4cac528e74dded9ca3939eed86aa0eadae0ebd9a5', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffe01ec16e9a9d6553a3d0685142fea357f57ce97b53dbe699b0204dba3545ce', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffde1c90813b233ea8d1a3a0760634fa4f350f207802fbc12dd18d0b3159ec89', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffd5b2fdf9933c4f6107c70629a93e0d714437a2ccf8d85b7415af6cc7fe4bd5', NOW())

INSERT INTO sentence_metadata (sentence_id, created_at)
VALUES ('ffd5954b414f497871f305847b2cdda9527fda728fce787c1662372c3ffd580b', NOW())

common-voice  | [BE] [INFO] Processed migration 02505082230990-set-empty-ug-variants-to-arab
common-voice  | [BE] [INFO] Done

SELECT COUNT(*) AS CNT 
FROM sentence_metadata sm 
JOIN variants v on v.variant_token = 'ug-Arab'
WHERE v.id = sm.variant_id