1
edit
Changes
no edit summary
</tr>
<tr>
<td>Core(ID=1)</td>
<td>select count(*) from bugs where product_id=1;</td>
<td>176,713</td>
</tr>
<tr>
<td>Calendar</td>
<td>select count(*) from bugs where product_id=2;</td>
<td>8,059</td>
</tr>
<tr>
<td>CCK</td>
<td>select count(*) from bugs where product_id=3;</td>
<td>694</td>
</tr>
<tr>
<td>Directory</td>
<td>select count(*) from bugs where product_id=4;</td>
<td>630</td>
</tr>
<tr>
<td>Grendel</td>
<td>select count(*) from bugs where product_id=5;</td>
<td>87</td>
</tr>
<tr>
<td>MozillaClassic</td>
<td>select count(*) from bugs where product_id=7;</td>
<td>480</td>
</tr>
<tr>
<td>Webtools</td>
<td>select count(*) from bugs where product_id=8;</td>
<td>2,207</td>
</tr>
<tr>
<td>NSPR</td>
<td>select count(*) from bugs where product_id=9;</td>
<td>1,299</td>
</tr>
<tr>
<td>mozilla.org</td>
<td>select count(*) from bugs where product_id=10;</td>
<td>11,086</td>
</tr>
<tr>
<td>Rhino</td>
<td>select count(*) from bugs where product_id=11;</td>
<td>697</td>
</tr>
<tr>
<td>Derivatives</td>
<td>select count(*) from bugs where product_id=12;</td>
<td>28</td>
</tr>
<tr>
<td>Documentation</td>
<td>select count(*) from bugs where product_id=13;</td>
<td>651</td>
</tr>
<tr>
<td>Tech Evangelism</td>
<td>select count(*) from bugs where product_id=15;</td>
<td>9,461</td>
</tr>
<tr>
<td>NSS</td>
<td>select count(*) from bugs where product_id=16;</td>
<td>3,761</td>
</tr>
<tr>
<td>Mozilla Localizations</td>
<td>select count(*) from bugs where product_id=17;</td>
<td>3,250</td>
</tr>
<tr>
<td>JSS</td>
<td>select count(*) from bugs where product_id=18;</td>
<td>316</td>
</tr>
<tr>
<td>Bugzilla</td>
<td>select count(*) from bugs where product_id=19;</td>
<td>12,957</td>
</tr>
<tr>
<td>Camino</td>
<td>select count(*) from bugs where product_id=20;</td>
<td>8,239</td>
</tr>
<tr>
<td>Firefox</td>
<td>select count(*) from bugs where product_id=21;</td>
<td>71,596</td>
</tr>
<tr>
<td>Other Applications</td>
<td>select count(*) from bugs where product_id=28;</td>
<td>3,003</td>
</tr>
<tr>
<td>addons.mozilla.org</td>
<td>select count(*) from bugs where product_id=31;</td>
<td>3,743</td>
</tr>
<tr>
<td>Composer</td>
<td>select count(*) from bugs where product_id=27;</td>
<td>37</td>
</tr>
<tr>
<td>Marketing</td>
<td>select count(*) from bugs where product_id=22;</td>
<td>316</td>
</tr>
<tr>
<td>Thunderbird</td>
<td>select count(*) from bugs where product_id=23;</td>
<td>19,955</td>
</tr>
<tr>
<td>Minimo</td>
<td>select count(*) from bugs where product_id=24;</td>
<td>445</td>
</tr>
<tr>
<td>Mozilla Application Suite</td>
<td>select count(*) from bugs where product_id=25;</td>
<td>79,698</td>
</tr>
<tr>
<td>Toolkit</td>
<td>select count(*) from bugs where product_id=30;</td>
<td>2,181</td>
</tr>
<tr>
<td>AUS</td>
<td>select count(*) from bugs where product_id=34;</td>
<td>83</td>
</tr>
<tr>
<td>Websites</td>
<td>select count(*) from bugs where product_id=36;</td>
<td>1,331</td>
</tr>
<tr>
<td>Mozilla Developer Center</td>
<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>