gistfile1.txt

mysql> select * from release_summary where uploadid = 257874;
+-------------------------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
| dist                                | version | id       | guid                                 | oncpan | distmat | perlmat | patched | pass | fail | na   | unknown | uploadid |
+-------------------------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
| Log-Dispatch-Scribe                 | 0.05    | 72845160 | 871570d0-72d6-11e6-87fd-ef1f6f1c15c2 |      1 |       1 |       2 |       1 |   11 |    9 |    0 |       0 |   257874 |
| CMS-Drupal-Modules-MembershipEntity | 0.96    | 67390109 | 5ddb7101-6c0c-1014-839c-59612b99e85d |      1 |       1 |       2 |       1 |    5 |    0 |    0 |       0 |   257874 |
+-------------------------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
2 rows in set (0.10 sec)

mysql> select * from uploads where uploadid="257874";
+----------+------+--------+-------------------------------------+---------+-------------------------------------------------+------------+
| uploadid | type | author | dist                                | version | filename                                        | released   |
+----------+------+--------+-------------------------------------+---------+-------------------------------------------------+------------+
|   257874 | cpan | TONKIN | CMS-Drupal-Modules-MembershipEntity | 0.96    | CMS-Drupal-Modules-MembershipEntity-0.96.tar.gz | 1438595965 |
+----------+------+--------+-------------------------------------+---------+-------------------------------------------------+------------+
1 row in set (0.08 sec)

mysql> select * from uploads where dist="Log-Dispatch-Scribe" and version="0.05";
+----------+------+----------+---------------------+---------+---------------------------------+------------+
| uploadid | type | author   | dist                | version | filename                        | released   |
+----------+------+----------+---------------------+---------+---------------------------------+------------+
|   128937 | cpan | JJSCHUTZ | Log-Dispatch-Scribe | 0.05    | Log-Dispatch-Scribe-0.05.tar.gz | 1269393900 |
+----------+------+----------+---------------------+---------+---------------------------------+------------+
1 row in set (0.09 sec)

mysql> select * from cpanstats where guid="871570d0-72d6-11e6-87fd-ef1f6f1c15c2";
+----------+--------------------------------------+-------+----------+--------------------------------------+---------------------+---------+---------------+--------+---------+--------------+--------------+------+----------+
| id       | guid                                 | state | postdate | tester                               | dist                | version | platform      | perl   | osname  | osvers       | fulldate     | type | uploadid |
+----------+--------------------------------------+-------+----------+--------------------------------------+---------------------+---------+---------------+--------+---------+--------------+--------------+------+----------+
| 72845160 | 871570d0-72d6-11e6-87fd-ef1f6f1c15c2 | fail  | 201609   | srezic@iconmobile.net (Slaven Rezic) | Log-Dispatch-Scribe | 0.05    | amd64-freebsd | 5.25.4 | freebsd | 10.1-release | 201609041933 |    2 |   128937 |
+----------+--------------------------------------+-------+----------+--------------------------------------+---------------------+---------+---------------+--------+---------+--------------+--------------+------+----------+
1 row in set (0.10 sec)

mysql> select * from release_summary where uploadid = 128937;
+---------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
| dist                | version | id       | guid                                 | oncpan | distmat | perlmat | patched | pass | fail | na   | unknown | uploadid |
+---------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
| Log-Dispatch-Scribe | 0.05    | 58883974 | 94d28fc2-4367-11e5-a773-d5d2e01f12bc |      1 |       1 |       1 |       2 |  139 |   12 |    0 |       0 |   128937 |
+---------------------+---------+----------+--------------------------------------+--------+---------+---------+---------+------+------+------+---------+----------+
1 row in set (0.10 sec)