Skip to content

Instantly share code, notes, and snippets.

@chx
Last active August 29, 2015 14:18
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save chx/3612ac536e195f93dc02 to your computer and use it in GitHub Desktop.
Save chx/3612ac536e195f93dc02 to your computer and use it in GitHub Desktop.
Get translatable entity menu paths
SELECT path
FROM menu_router
WHERE load_functions IN
(SELECT DISTINCT concat('a:1:{i:1;s:', length(concat(entity_type, '_load')), ':"', entity_type, '_load";}')
FROM field_config fc
INNER JOIN field_config_instance fci ON fci.field_id=fc.id
WHERE fc.active=1 AND fc.translatable=1)
AND path NOT LIKE '%/%/%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment