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 -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/wikitech-l.lists.wikimedia.org/

Reply via email to