Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Ivi104
.
Toggle Highlighting
SQL
SET @ime_kat = 'Kemija_po_godinama'; -- promijeniti naziv kategorije po želji use hrwiki_p; SELECT DISTINCT c.cat_id, c.cat_pages, page.page_title, page.page_len , count( distinct(page.page_title)) -- otkomentirati za broj umjesto popisa from category as c inner join categorylinks as cl on c.cat_title = cl.cl_to inner join page on cl.cl_from = page.page_id inner join revision_userindex as r_ui on r_ui.rev_page = page.page_id inner join actor_revision as a_rev on r_ui.rev_actor = a_rev.actor_id where c.cat_title = @ime_kat and page.page_namespace = 0 and page.page_is_new = 0 and page.page_is_redirect = 0 -- and actor_name != "Kubura" limit 300; SELECT DISTINCT c.cat_id, c.cat_pages, page.page_title, page.page_len as 'page_len BEZ KUBURE' , count( distinct(page.page_title)) -- otkomentirati za broj umjesto popisa from category as c inner join categorylinks as cl on c.cat_title = cl.cl_to inner join page on cl.cl_from = page.page_id inner join revision_userindex as r_ui on r_ui.rev_page = page.page_id inner join actor_revision as a_rev on r_ui.rev_actor = a_rev.actor_id where c.cat_title = @ime_kat -- promijeniti naziv kategorije po želji and page.page_namespace = 0 and page.page_is_new = 0 and page.page_is_redirect = 0 and actor_name != "Kubura" limit 300
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...