mysql> select product_type.description type, vendor.description vendor, product.description product,version.description version from product left join vendor on vendor.id = product.vendor_id left join product_type on product_type.id = product.type_id left join version on version.product_id = product.id order by type,vendor,product,version;
+------------------+--------------------+--------------------------+----------------------------+
| type | vendor | product | version |
+------------------+--------------------+--------------------------+----------------------------+
| Control Panel | cPanel | cPanel | STABLE |
| Control Panel | Ensim Corporation | Ensim Pro for Linux | 10 |
| Control Panel | Ensim Corporation | Ensim Pro for Windows | 10 |
| Control Panel | SWsoft | Plesk for Linux/Unix | NULL |
| Control Panel | SWsoft | Plesk for Windows | NULL |
| Control Panel | WebHost Automation | Helm | 3 |
| Control Panel | WebHost Automation | Helm | 4 |
| Operating System | CentOS Project | CentOS | 4 |
| Operating System | CentOS Project | CentOS | 5 |
| Operating System | Debian Project | Debian | 3 |
| Operating System | Debian Project | Debian | 4 |
| Operating System | FreeBSD Foundation | FreeBSD | 5.4 |
| Operating System | FreeBSD Foundation | FreeBSD | 5.5 |
| Operating System | FreeBSD Foundation | FreeBSD | 6.0 |
| Operating System | FreeBSD Foundation | FreeBSD | 6.1 |
| Operating System | FreeBSD Foundation | FreeBSD | 6.2 |
| Operating System | Microsoft | Windows | 2000 Advanced Server |
| Operating System | Microsoft | Windows | 2000 Server |
| Operating System | Microsoft | Windows | 2003 Enterprise Edition |
| Operating System | Microsoft | Windows | 2003 Small Business Server |
| Operating System | Microsoft | Windows | 2003 Standard Edition |
| Operating System | Red Hat | Enterprise Linux | 3 AS |
| Operating System | Red Hat | Enterprise Linux | 3 ES |
| Operating System | Red Hat | Enterprise Linux | 4 AS |
| Operating System | Red Hat | Enterprise Linux | 4 ES |
| Operating System | Red Hat | Enterprise Linux | 5 |
| Operating System | Red Hat | Enterprise Linux | 5 Advanced Platform |
| Operating System | Red Hat | Fedora | Core 5 |
| Operating System | Red Hat | Fedora | Core 6 |
| Operating System | Red Hat | Fedora | Core 7 |
| Statistics | Google | Urchin | 5 |
| Virtualization | SWsoft | Virtuozzo for Linux/Unix | NULL |
| Virtualization | SWsoft | Virtuozzo for Windows | NULL |
+------------------+--------------------+--------------------------+----------------------------+
33 rows in set (0.00 sec)