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