Open jbrzusto opened 6 years ago
for both SG-0613BB000613 and SG-1013BB000626:
$ sqlite3 /sgm/recv/SG-1013BB000626.motus "select * from batches where tsStart > tsEnd" 1|563|20|1375287879.7987|1375201220.0|0|1501082014.78781|||500 2|563|21|1375370272.3986|1375288220.3679|0|1501082016.65138|||501 3|563|22|1375802220.97505|1375802118.8031|0|1501082017.54335|||502 6|563|25|1404760676.0104|1404760413.454|0|1501082035.25084|||505 8|563|27|1404837582.2199|1404767416.459|0|1501082046.19594|||507 9|563|28|1408394568.381|1404837977.5922|2|1501082047.01168|||508 12|563|31|1438711483.1729|1437851224.599|0|1501082111.17509|||511 13|563|32|1438888232.6616|1437852042.0609|12|1501082112.21114|||512 14|563|33|1438891610.0628|1438711644.923|16|1501082113.27629|||513 15|563|34|1441821315.4491|1438888662.4686|85|1501082114.36323|||514 16|563|35|1441824117.8272|1441820713.0|344941|1501082115.6833|||515 17|563|36|1446560647.48|1441823991.3413|236|1501082144.85925|||516 19|563|38|1468896333.3478|1446866710.9468|0|1501082192.60518|||518 $ sqlite3 /sgm/recv/SG-0613BB000613.motus "select * from batches where tsStart > tsEnd" 1|547|19|1375809000.6522|1375807313.8254|0|1501082714.63783|||548 4|547|22|1402932564.3308|1402506299.8625|299|1501082802.69001|||551 5|547|23|1402933744.66575|1402932928.2702|0|1501082803.54671|||552 6|547|24|1404761885.21425|1402933806.4615|0|1501082804.29885|||553 7|547|25|1404929312.2422|1404761972.8544|0|1501082805.87485|||554 11|547|29|1437853609.7178|1437853423.0142|0|1501083044.42873|||558 12|547|30|1468897008.4672|1437853689.9148|0|1501083045.37573|||559 14|547|32|1470144819.2549|1469999841.9029|0|1501083048.72241|||561 15|547|33|1470492354.2403|1470390077.2829|430|1501083050.51593|||562 16|547|34|1471005243.0703|1470867676.1534|2988|1501083052.74595|||563 18|547|36|1471783974.0604|1471687030.3648|3011|1501083061.09428|||565 19|547|37|1472040988.3204|1471941684.6282|2447|1501083063.84529|||566 20|547|38|1472386458.8572|1472292253.7012|2131|1501083066.26775|||567 21|547|39|1472818979.5329|1472689580.1719|1758|1501083069.06107|||568 22|547|40|1473259050.329|1473054495.4723|787|1501083071.85336|||569 23|547|41|1473509560.0288|1473387541.0454|1106|1501083074.19975|||570 25|547|43|1473775308.3217|1473756015.106|13|1501083078.86759|||572 26|547|44|1473941138.3454|1473845407.7868|97|1501083080.80054|||573 28|547|46|1474719132.6323|1474540380.3939|14|1501083085.41748|||575 31|547|49|1475421298.3232|1475292539.1288|0|1501083092.28095|||578 32|547|50|1475502400.5708|1475459913.4338|0|1501083094.45876|||579 34|547|52|1475672707.1305|1475631391.1127|0|1501083098.86736|||581 35|547|53|1475760497.7064|1475715748.6762|0|1501083101.06482|||582 36|547|54|1475929934.8859|1475802762.7435|0|1501083103.55889|||583 37|547|55|1476104922.7437|1476003834.7646|0|1501083105.9104|||584
for both SG-0613BB000613 and SG-1013BB000626: