Here is the way to make them alphabetical
PHP Code:
$plugins = $db->query_read("
SELECT plugin.*, product.active AS productactive, product.productid
FROM " . TABLE_PREFIX . "plugin AS plugin
LEFT JOIN " . TABLE_PREFIX . "product AS product ON (product.productid=plugin.product)
ORDER BY product.title, plugin.hookname, plugin.title
");
I also made it go by hook name after af that is how vB sorts the list and usually people look for certain hooks instead of the name.