Talk:OmegaWiki

Example of translation es-pt with PoS:

mysql> 
select 
  t.defined_meaning_id as id, e.spelling as expression, l.wikimedia_key as lang, oav.option_id
from 
  uw_defined_meaning as dm, uw_expression_ns as e, uw_syntrans as t, language as l, 
  uw_option_attribute_values as oav, uw_option_attribute_options as oao
where 
  t.expression_id=e.expression_id and l.language_id=e.language_id and 
  (l.wikimedia_key='es' or l.wikimedia_key='pt') and 
  dm.defined_meaning_id = t.defined_meaning_id and 
  t.syntrans_sid = oav.object_id
order by 
  t.defined_meaning_id ASC, l.wikimedia_key ASC

mysql> 
select 
  option_id,spelling,l.wikimedia_key 
from 
  uw_option_attribute_options,uw_defined_meaning,uw_expression_ns, language as l 
where 
  attribute_id = '409106' and  uw_option_attribute_options.language_id = l.language_id and  
  (l.wikimedia_key='es' or l.wikimedia_key='pt') and uw_defined_meaning.defined_meaning_id = option_mid and 
  uw_expression_ns.expression_id = uw_defined_meaning.expression_id;