SQL
AخA
SELECT
COUNT(wbit_item_id) AS "Number of edits remaining",
COUNT(wbit_item_id)/5016 /*edits per hour*/ AS "Hours remaining (est.)"
FROM wbt_item_terms
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_type ON wbtl_type_id = wby_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id
WHERE wbtl_type_id = 2 # Description
AND wbxl_language = 'sl'
AND wbx_text = "kategorija Wikimedije";
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.