20220628094431

This is the query I’ve been using for qc-analysis.rmd.

SELECT
  r.timestamp AS timestamp,
  userID,
  cardID,
IF
  (reviewMarking="remembered",
    TRUE,
    FALSE) AS result,
  beforeInterval,
  nextDueTimestamp,
  sessionID,
  isRetry,
  schedule
FROM
  `logs.reviews` AS r
JOIN
  `logs.registeredUsers`
USING
  (userID)