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.taxon@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 ...