# Tue May 27 13:00:27 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use theclari_rugProd;
SELECT m.*, c.`option` as component FROM jos_menu AS m LEFT JOIN jos_components AS c ON m.componentid = c.id WHERE m.published = 1 ORDER BY m.sublevel, m.parent, m.ordering