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
Wurgl
.
Toggle Highlighting
SQL
SELECT page_title, el_to_path, comment_text, actor_name, REGEXP_REPLACE(rev_timestamp, '\(....\)\(..\)\(..\)\(..\)\(..\)\(..\).*$', '\1-\2-\3 \4:\5:\6') AS timestamp FROM revision, comment, templatelinks AS NDt, linktarget AS NDl, templatelinks AS PDt, linktarget AS PDl, actor, page LEFT JOIN externallinks ON el_from = page_id AND el_to_domain_index = 'https://info.d-nb.' AND el_to_path LIKE '/gnd/%' WHERE page_namespace = 0 AND page_id = rev_page AND rev_comment_id = comment_id AND (comment_text = 'GND vorhanden' OR comment_text LIKE '%GND ist jetzt aber da' ) #AND el_from IS NULL AND NDt.tl_from = page_id AND NDt.tl_target_id = NDl.lt_id AND NDl.lt_title = 'Normdaten' AND NDl.lt_namespace = 10 AND PDt.tl_from = page_id AND PDt.tl_target_id = PDl.lt_id AND PDl.lt_title = 'Personendaten' AND PDl.lt_namespace = 10 AND rev_actor = actor_id ORDER BY rev_timestamp DESC
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...