Skip to content

Instantly share code, notes, and snippets.

@dampee
Created December 20, 2013 10:42
Show Gist options
  • Save dampee/8053121 to your computer and use it in GitHub Desktop.
Save dampee/8053121 to your computer and use it in GitHub Desktop.
get specific umbraco dictionary item
select d.pk, lt.pk, d.[key], lt.languageId, l.languageISOCode, lt.value
from cmsDictionary d inner join cmsLanguageText lt on d.id = lt.UniqueId
left join umbracoLanguage l on lt.languageId = l.id
where d.pk = 6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment