This query is marked as a draft This query has been published by Matěj Suchánek.

SQL

AخA
 
USE cswiki_p;
SELECT
  eu_entity_id,
  amount,
  #sk.term_text AS sk,
  en.term_text AS en
FROM
  (
    SELECT
      eu_entity_id,
      COUNT(*) AS amount
    FROM
      wbc_entity_usage
      JOIN categorylinks ON cl_from = eu_page_id
    WHERE
      eu_aspect = 'L.sk'
      AND cl_to = 'Údržba:Doplnit_štítek_na_Wikidatech'
    GROUP BY
      eu_entity_id
    HAVING
      amount > 1
  ) AS most
  /*LEFT JOIN wikidatawiki_p.wb_terms AS sk ON sk.term_full_entity_id = eu_entity_id
  AND sk.term_type = 'label'
  AND sk.term_language = 'sk'*/
  LEFT JOIN wikidatawiki_p.wb_terms AS en ON en.term_full_entity_id = eu_entity_id
  AND en.term_type = 'label'
  AND en.term_language = 'en'
ORDER BY
  amount,
  #sk.term_text,
  en.term_text;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...