text: DROP VIEW IF EXISTS website.menu_item_view;
  
  CREATE VIEW website.menu_item_view
  AS
  SELECT
      website.menus.menu_id,
      website.menus.menu_name,
      website.menus.description,
      website.menu_items.menu_item_id,
      website.menu_items.sort,
      website.menu_items.title,
      website.menu_items.url,
      website.menu_items.target,
      website.menu_items.content_id,
      website.contents.alias AS content_alias
  FROM website.menu_items
  INNER JOIN website.menus
  ON website.menus.menu_id = website.menu_items.menu_id
  LEFT JOIN website.contents
  ON website.contents.content_id = website.menu_items.content_id
  WHERE NOT website.menu_items.deleted;