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

The output:

...
| id     | expression                                                          | lang |    PoS    |
...
| 696046 | cuadrangular                                                        | es   |    410505 |
| 696046 | quadrangular                                                        | pt   |    435971 |
...

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;

+-----------+--------------------+---------------+
| option_id | spelling           | wikimedia_key |
+-----------+--------------------+---------------+
|    410497 | verb               | es            |
|    410503 | noun               | es            |
|    410504 | adverb             | es            |
|    410505 | adjective          | es            |
|    413808 | contraction        | es            |
|    413809 | contraction        | pt            |
|    435968 | noun               | pt            |
|    435971 | adjective          | pt            |
|    435974 | verb               | pt            |
|    436004 | bepaald lidwoord   | pt            |
|    436005 | onbepaald lidwoord | pt            |
|    436011 | preposition        | pt            |
|    629277 | adverb             | pt            |
|    639365 | article            | es            |
|    639375 | pronoun            | es            |
|    639390 | preposition        | es            |
|    639393 | voegwoord          | es            |
|    639396 | tussenwerpsel      | es            |
+-----------+--------------------+---------------+

--Enrique 17:23, 30 July 2007 (BST)