Comment 9 for bug 737649

QA notes: (no, I won't be doing this for each bug I QA, this one was just quite important)

The details are attached to the bug. The following 12 software items were identified beforehand as items which would be deleted on the daily server by querying for software items without related reviews (https://pastebin.canonical.com/45013/):

stellarium
calibre (2x with different app names)
pdfmod
fretsonfire
tuxpaint
gimp
p7zip-full
arista
armagetronad
webservice-office-zoho
aclock.app

The migration result shows that only ten were deleted, the
exceptions being:

p7zip-full
aclock.app

===============================
Calculating the number of items
===============================

This is because these packagenames had multiple software items
(as can be seen in the review_stats_all_before.json), and only
one of those had no associated reviews (p7zip-full had 3 entries,
and aclock.app only 2.). When the duplicate software items were
reconciled, we expect p7zip-full to go from 3 records to 1, and
aclock.app to go from 2 to 1.

So regarding the number of items:
Before: 60
After: 47

which is correct as:

60 - 10 (deletions due to no reviews) - 2 (2 redundant pk7zip-full) - 1 (redundant aclock.app) = 47

Stats: Once the items without reviews for pk7zip-full and aclock.app were removed, the re-calculated stats also work out correctly:

p7zip-full: 3 (4.33) + 3 (3.00) = 6 (3.67)