Sorry, I made a variable mistake. The query is correct.
Don't notice this email, problem solved. Kind regards Martin Am Mi., 12. Feb. 2025 um 15:21 Uhr schrieb Martin Domdey <dr.ta...@gmail.com>: > > Hi, > > with this I only get the actual timestamp of just this daytime second > but not the timestamp of the revision. What's wrong? > > using dewiki_p > > SELECT DISTINCT page_title, rev_timestamp, comment_text > FROM page > JOIN revision ON rev_page = page_id > JOIN comment ON comment_id = rev_comment_id > WHERE !page_namespace AND !page_is_redirect; > > Thank you > Martin ... _______________________________________________ Wikitech-l mailing list -- wikitech-l@lists.wikimedia.org To unsubscribe send an email to wikitech-l-le...@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/
