🏆 ยอดนิยม: 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,
  p.page_len AS bytes,
  CONVERT(ptrp.ptrp_created USING utf8mb4) AS created,
  GROUP_CONCAT(
    DISTINCT CONVERT(pap.pap_project_title USING utf8mb4)
    ORDER BY pap.pap_project_title
    SEPARATOR ', '
  ) AS top_importance_projects
FROM pagetriage_page ptrp
JOIN page p
  ON p.page_id = ptrp.ptrp_page_id
JOIN page_assessments pa
  ON pa.pa_page_id = p.page_id
JOIN page_assessments_projects pap
  ON pap.pap_project_id = pa.pa_project_id
WHERE ptrp.ptrp_reviewed = 0
  AND ptrp.ptrp_deleted = 0
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
  AND pa.pa_importance = 'Top'
GROUP BY
  p.page_id,
  p.page_title,
  p.page_len,
  ptrp.ptrp_created
ORDER BY ptrp.ptrp_created ASC;
SQL

Checking query status...
