Coastal Restoration & Preservation
Solid, Hazardous, and Recycling Waste
|
|
SELECT _section_title, title, url, request_module, request_page, request_query, _menu_new_window
FROM (
SELECT module_id AS _module_id, id AS _section_id, title AS _section_title, sort_order AS _section_sort_order
FROM Navigation_Menu
WHERE parent_id IS NULL AND show_on_internet=1
) AS _SectionListing
LEFT JOIN(
SELECT parent_id AS _section_id, title, url, module_name AS request_module, request_page, is_new_window as _menu_new_window,
request_query, sort_order AS _menu_sort_order
FROM Navigation_Menu
LEFT JOIN Navigation_Module ON Navigation_Module.module_id=request_module
WHERE parent_id IS NOT NULL AND show_on_internet=1
) AS _MenuListing ON _SectionListing._section_id=_MenuListing._section_id
WHERE _module_id=43 and title is NOT NULL
ORDER BY _section_sort_order, _menu_sort_order