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
Peter Bowman
.
This query retrieves the count/list of Hebrew entries with vocalization marks created before/after the first revision of [[Wikipedysta:Olafbot/SK/nagłówki]]. https://pl.wiktionary.org/w/index.php?title=Wikis%C5%82ownik:Bar&oldid=4840816#Nag.C5.82.C3.B3wki_sekcji_.C5.82aci.C5.84skich
Toggle Highlighting
SQL
USE plwiktionary_p; SET @category = "hebrajski_(indeks)"; SET @pbbot_pageid = 578025; SET @timestamp = 20100919000000; -- Resultset 1: before @timestamp SELECT COUNT(DISTINCT page_title) as "count" FROM page RIGHT JOIN categorylinks ON cl_from = page_id RIGHT JOIN pagelinks ON pl_title = page_title JOIN revision ON rev_page = page_id WHERE cl_to = @category AND pl_from = @pbbot_pageid AND rev_timestamp < @timestamp ; -- Resultset 2: after @timestamp /* SELECT DISTINCT page_title, MIN(rev_timestamp) FROM page RIGHT JOIN categorylinks ON cl_from = page_id RIGHT JOIN pagelinks ON pl_title = page_title JOIN revision ON rev_page = page_id WHERE cl_to = @category AND pl_from = @pbbot_pageid AND rev_timestamp > @timestamp ORDER BY rev_timestamp ;*/
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...