Task #816
Updated by Aaron Marcuse-Kubitza over 10 years ago
* this will fix the 1.3 million[1] names scrubbed while TNRS was broken[2], when it wasn't populating the critical field @Name_matched_accepted_family@ fn1(((. +1337539+ <pre><code class="SQL"> SELECT @SELECT COUNT(*) FROM "TNRS".tnrs "TNRS".tnrs@ WHERE @WHERE "Name_matched_accepted_family" IS NULL AND "Family_matched" IS NOT NULL NULL@ Total @Total query runtime: 5090 ms. </code></pre> ms.@ fn2(((. starting on 2013-5-23 <pre><code class="SQL"> SELECT @SELECT min(batch), max(batch) FROM "TNRS".tnrs "TNRS".tnrs@ WHERE @WHERE "Name_matched_accepted_family" IS NULL AND "Family_matched" IS NOT NULL NULL@ Total @Total query runtime: 4548 ms. ms.@ "2013-05-23 @"2013-05-23 15:48:28.970796-07","2013-11-18 17:43:18.114637-08" </code></pre> 17:43:18.114637-08"@