# Mon May  5 10:53:58 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 2  Rows_examined: 30
use theclari_rugDev;
SELECT a.*, SUM(b.home) AS home FROM jos_menu_types AS a LEFT JOIN jos_menu AS b ON b.menutype = a.menutype GROUP BY a.id