Untitled query #32751

SQL

export LOGS_DAY='2018-07-12'; export LOGS_SUBJECT="Consultation on the creation of a separate user group for editing sitewide CSS/JS"; curl -s 'https://meta.wikimedia.org/w/api.php?action=sitematrix&format=json&smtype=special%7Clanguage&smstate=all&smlangprop=site&smsiteprop=url&smlimit=max' | jq --raw-output '(.sitematrix[]["site"]?[] | select(has("closed") or has ("private") or has("fishbowl") or has("nonglobal") | not).url), (.sitematrix.specials[].url)' | parallel --no-notice -P5 -I @ "curl -s '@/w/api.php?action=query&format=json&list=logevents&leprop=ids%7Ctitle%7Cdetails%7Ctimestamp|type&letype=massmessage&lestart=${LOGS_DAY}T00%3A00%3A00.000Z&leend=${LOGS_DAY}T23%3A59%3A59.000Z&ledir=newer' | jq --raw-output '.query.logevents[]? | select(.params.subject == \"${LOGS_SUBJECT}\") | \"@/w/index.php?title=Special:Log&type=massmessage&offset=\(.timestamp | fromdateiso8601 | . - 1 | strftime(\"%Y%m%d%H%M%S\") )&dir=prev&limit=1 \(.logid) \(.params.reason // .action // \"\")\"'"
SQL

Checking query status...
