🏆 ยอดนิยม: query/

SQL

SELECT
  p.page_id,
  CONVERT(p.page_title USING utf8mb4) AS title,
  ptrp.ptrp_created AS created,
  CONCAT('https://en.wikipedia.org/wiki/', REPLACE(CONVERT(p.page_title USING utf8mb4), ' ', '_')) AS url
FROM pagetriage_page ptrp
JOIN page p
  ON p.page_id = ptrp.ptrp_page_id
WHERE ptrp.ptrp_reviewed = 0
  AND ptrp.ptrp_deleted = 0
  AND p.page_namespace = 0
  AND p.page_is_redirect = 0
  AND EXISTS (
    SELECT 1
    FROM categorylinks cl
    JOIN linktarget lt ON lt.lt_id = cl.cl_target_id
    WHERE cl.cl_from = p.page_id
      AND lt.lt_namespace = 14
      AND lt.lt_title = 'All_articles_lacking_sources'
  )
ORDER BY ptrp.ptrp_created DESC;
SQL

Checking query status...
