and then making a query to get all the strings where the locale is 3 and get "Hej", "Bye" as the result (assuming 2 is the default locale).
If this is not possible maybe I should make sure that the default locale really is a default locale and always dummy in it's strings for the other locales (in my opinion a much dirtier sollution)
select s.* from
pl_strings s, pl_identifiers i, pl_contexts c
where
(c.context="general")
and
(i.context_id=c.id)
and
(s.identifier_id=i.id)
and
(
(s.locale_id = 29)
or
(s.locale_id = 31)
)
group by s.identifier_id
;
It would be nice though if some guru could verify this...