mysql> select count(*) from serial;
+----------+
| count(*) |
+----------+
|    56810 |
+----------+


mysql> select count(*) from serialitems;
+----------+
| count(*) |
+----------+
|    42113 |
+----------+

mysql> select count(*) from items;
+----------+
| count(*) |
+----------+
|    52475 |
+----------+

select count(*) from serial, items where serialseq = itemnotes ;
+----------+
| count(*) |
+----------+
|    56194 |
+----------+