I&#39;m using the web API and db42. <div><br></div><div>API example:  <a href="http://en.wikipedia.org/w/api.php?action=query&amp;prop=revisions&amp;titles=User:EpochFail&amp;rvprop=ids|sha1&amp;format=jsonfm&amp;rvlimit=2&amp;rvdir=older&amp;rvstartid=488033783">http://en.wikipedia.org/w/api.php?action=query&amp;prop=revisions&amp;titles=User:EpochFail&amp;rvprop=ids|sha1&amp;format=jsonfm&amp;rvlimit=2&amp;rvdir=older&amp;rvstartid=488033783</a></div>

<div><br></div><div>MySQL example:</div><div><div><font face="&#39;courier new&#39;, monospace">mysql&gt; select rev_id, rev_sha1 from revision where rev_page = 15661504 and rev_id &lt;= 488033783 order by rev_timestamp desc limit 2;</font></div>

<div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div><div><font face="&#39;courier new&#39;, monospace">| rev_id    | rev_sha1                        |</font></div>

<div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div><div><font face="&#39;courier new&#39;, monospace">| 488033783 | i8x0e29kxs2t1o9f1h03ks7q59yyyrv |</font></div>

<div><font face="&#39;courier new&#39;, monospace">| 485404713 |                                 |</font></div><div><font face="&#39;courier new&#39;, monospace">+-----------+---------------------------------+</font></div>

<div><font face="&#39;courier new&#39;, monospace">2 rows in set (0.00 sec)</font></div><div><br></div><div>-Aaron</div><br><div class="gmail_quote">On Thu, May 10, 2012 at 4:03 PM, Diederik van Liere <span dir="ltr">&lt;<a href="mailto:dvanliere@wikimedia.org" target="_blank">dvanliere@wikimedia.org</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Which machine are you accessing?<br>D<br><br><div class="gmail_quote"><div><div class="h5">On Thu, May 10, 2012 at 4:58 PM, Aaron Halfaker <span dir="ltr">&lt;<a href="mailto:aaron.halfaker@gmail.com" target="_blank">aaron.halfaker@gmail.com</a>&gt;</span> wrote:<br>


</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">Hey guys,<div><br></div><div>I&#39;m trying to use the sha1 hashes of Wiki content for the first time (woot!  Props to D et al. for seeing it through) but I&#39;m having some trouble actually getting them out of the API/databases.  It looks like the checksums only go back to April 19th.  Is this true of all pages?  Is there any plan to propagate the metric backwards?</div>


<span><font color="#888888">


<div><br></div><div>-Aaron</div>
</font></span><br></div></div>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br>
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="mailto:Analytics@lists.wikimedia.org">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div>