select count(*) from lang_messages lm1 left outer join lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key), lang_message_keys lmk where lm1.locale = :default_locale and lm1.package_key = :package_key and lm1.message_key = lmk.message_key and lm1.package_key = lmk.package_key $where_clause select count(*) from lang_messages lm where package_key = :package_key and locale = :default_locale $where_clause select lm1.message_key, lm1.message as default_message, lm2.message as translated_message, lmk.description, coalesce(lm1.deleted_p, 'f') as deleted_p, coalesce(lm2.deleted_p, 'f') as translation_deleted_p from lang_messages lm1 left outer join lang_messages lm2 on (lm2.locale = :locale and lm2.message_key = lm1.message_key and lm2.package_key = lm1.package_key), lang_message_keys lmk where lm1.locale = :default_locale and lm1.package_key = :package_key and lm1.message_key = lmk.message_key and lm1.package_key = lmk.package_key $where_clause order by upper(lm1.message_key), lm1.message_key select lm.message_key, lm.message as default_message, lmk.description, coalesce(lm.deleted_p, 'f') as deleted_p, coalesce(lm.deleted_p, 'f') as translation_deleted_p from lang_messages lm, lang_message_keys lmk where lm.locale = :default_locale and lm.package_key = :package_key and lm.message_key = lmk.message_key and lm.package_key = lmk.package_key $where_clause_default order by upper(lm.message_key), lm.message_key