1
edit
Changes
no edit summary
<td>select count(*) from bugs where product_id=37;</td>
<td>572</td>
</tr>
<tr>
<td>Testopia</td>
<td>select count(*) from bugs where product_id=38;</td>
<td>423</td>
</tr>
<tr>
<td>Penelope</td>
<td>select count(*) from bugs where product_id=39;</td>
<td>375</td>
</tr>
<tr>
<td>Mozilla Labs</td>
<td>select count(*) from bugs where product_id=40;</td>
<td>588</td>
</tr>
<tr>
<td>Sumo</td>
<td>select count(*) from bugs where product_id=42;</td>
<td>570</td>
</tr>
<tr>
<td>Tamarin</td>
<td>select count(*) from bugs where product_id=43;</td>
<td>426</td>
</tr>
<tr>
<td>Extend Firefox</td>
<td>select count(*) from bugs where product_id=44;</td>
<td>5</td>
</tr>
<tr>
<td>Fennec</td>
<td>select count(*) from bugs where product_id=46;</td>
<td>27</td>
</tr>
<tr>
<th>How many bugs are currently NEW vs. ASSIGNED vs. RESOLVED, etc.</th>
</tr>
<tr>
<td>New</td>
<td>select count(*) from bugs where bug_status='NEW';</td>
<td>44,568</td>
</tr>
<tr>
<td>Assigned</td>
<td>select count(*) from bugs where bug_status='ASSIGNED';</td>
<td>4,697</td>
</tr>
<tr>
<td>Resolved</td>
<td>select count(*) from bugs where bug_status='RESOLVED';</td>
<td>207,496</td>
</tr>
<tr>
<td>Verified</td>
<td>select count(*) from bugs where bug_status='VERIFIED';</td>
<td>148,747</td>
</tr>
<tr>
<td>Closed</td>
<td>select count(*) from bugs where bug_status='CLOSED';</td>
<td>1,496</td>
</tr>
<tr>
<td>Reopened</td>
<td>select count(*) from bugs where bug_status=REOPENED';</td>
<td>962</td>
</tr>
<tr>
<td>Unconfirmed</td>
<td>select count(*) from bugs where bug_status='UNCONFIRMED';</td>
<td>18,026</td>
</tr>
</table>
