Dave Jarvis' Repositories

select
  pp.id,
  pp.label_singular,
  pp.label_plural,
  --pp.uncountable,
  --pp.countable,
  pp.whole_pluralize,
  rin.id,
  rin.label,
  'http://en.wiktionary.org/wiki/'||rin.label as wiktionary,
  'http://en.wikipedia.org/wiki/'||rin.label as wikipedia
from
  pluralize.plural pp,
  recipe.ingredient_name_vw rin
where
  rin.label = pp.label_singular and
  pp.countable = true and
  pp.uncountable = false
order by
  pp.label_singular;