On 8/10/09 9:28 AM, Aaron L Halfaker wrote: > I'm using data from a snapshot of the English Wikipedia and would like > to run a query similar to the following: > > SELECT * FROM revision > WHERE rev_id> some_rev_id; > > Can I be confident that all revisions returned were saved after some_rev_id?
Yes, in the sense that they were added to the database afterwards. No, in the sense that rev_timestamp may not always show a later date for a later rev_id: * Page histories imported from pre-conversion UseModWiki archives * Anything imported via Special:Import * Anything undeleted before ar_rev_id column was added * Anything saved on a server that had a mis-configured clock -- brion _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
