🏆 ยอดนิยม: query/

SQL

SELECT
  CONVERT(p.page_title USING utf8mb4) AS article,
  CONCAT('https://en.wikipedia.org/wiki/', CONVERT(p.page_title USING utf8mb4)) AS article_url,
  COUNT(*) AS interlanguage_links,
  p.page_len AS bytes,
  CONVERT(ptrp.ptrp_created USING utf8mb4) AS created
FROM pagetriage_page ptrp
JOIN page p
  ON p.page_id = ptrp.ptrp_page_id
JOIN langlinks ll
  ON ll.ll_from = p.page_id
WHERE ptrp.ptrp_reviewed = 0
  AND ptrp.ptrp_deleted = 0
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
GROUP BY
  p.page_id,
  p.page_title,
  p.page_len,
  ptrp.ptrp_created
ORDER BY interlanguage_links DESC, ptrp.ptrp_created ASC;
SQL

Checking query status...
