Skip to content

Instantly share code, notes, and snippets.

@mistermarco

mistermarco/count-menu-items.sql

Created February 25, 2014 16:42
Show Gist options
  • Save mistermarco/9212692 to your computer and use it in GitHub Desktop.
Save mistermarco/9212692 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
count-menu-items.sql
# get a count of all items in Drupal's custom menus
select mc.title, count(mc.menu_name) from menu_custom as mc left join menu_links as ml using(menu_name) where ml.hidden = 0 group by mc.title order by mc.title;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment