Share of images uploaded by non-autoconfirmed users (huwiki)

SQL

use huwiki_p;

SELECT
    (user_registration IS NULL
      OR str_to_date(substr(img_timestamp, 1, 8), '%Y%m%d') > str_to_date(substr(user_registration, 1, 8), '%Y%m%d') + INTERVAL 4 DAY) was_confirmed,
    COUNT(*) count
  FROM image
    JOIN user ON img_user = user_id AND user_id != 0
  GROUP BY was_confirmed
;

SELECT
    (user_registration IS NULL
      OR str_to_date(substr(fa_timestamp, 1, 8), '%Y%m%d') > str_to_date(substr(user_registration, 1, 8), '%Y%m%d') + INTERVAL 4 DAY) was_confirmed,
    COUNT(*) count
  FROM filearchive
    JOIN user ON fa_user = user_id AND user_id != 0
  GROUP BY was_confirmed
;

SQL

Checking query status...