Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Stratified sample of edit intentions for cawiki
by
EpochFail
This query is marked as a draft
This query has been published
by
Gerardduenas
.
Toggle Highlighting
SQL
USE cawiki_p; (SELECT rev_id, rev_comment, "copy-editing" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(typo|puntuaci[oó]|millorar?|correcci[oó](ns)?|orto(grafia)?)\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "clarification" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(explic[ao](ció|r)?|exemples?|clarific[oa]r?)\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "simplification" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(simplific(o|ar)|redu(ir|eixo)|(es)?cur(t|ço))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "point-of-view" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(PVN|punt de vista|neutral|neutralitz(o|ar))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "refactoring" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(estructur[ao]|ree?scri(c|iure))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "fact-update" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(actualitz[ao](ció)?)\\b" ORDER BY RAND() LIMIT 200) /* I thing something here is duplicated The above query is the correct fact update and below we have another fact update with the elaboration rev_comment. */ UNION ALL (SELECT rev_id, rev_comment, "fact-update" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(afeg(ir|eixo|isc)|\\+|m[eé]s|info(rmaci[oó])?|nou|contingut|expansi[oó])\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "elaboration" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(ampli(o|ar|aci[oó])|afeg(ir|eixo|isc)|\\+|m[eé]s|info(rmaci[oó])?|nou|contingut|expansi[oó])\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "verifiability" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(refer[eè]nci(es|o|a|at)|verificab(ilitat|le))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "disambiguation" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(desambigu(aci[oó]|o))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "wikification" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(formato?|wiki|enllaço?|externs?|revisi[oó]|estil)\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "counter-vandalism" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(revert(ides|eixo?)|desf(à|er|etes))\\b" ORDER BY RAND() LIMIT 200) UNION ALL (SELECT rev_id, rev_comment, "process" AS explicit_intention FROM revision WHERE rev_timestamp BETWEEN "20151228" AND "20161228" AND LOWER(CAST(rev_comment AS CHAR)) RLIKE "\\b(fusi[oó]|etiquet[ao]|etiqueta(r|tge)|eborr(o|a[rt]))\\b" ORDER BY RAND() LIMIT 200)
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...