Difference between revisions of "Talk:OmegaWiki"
Jump to navigation
Jump to search
(SQL query: retrieves list of verbs from OW) |
|||
Line 1: | Line 1: | ||
+ | Example of translation es-pt with PoS: |
||
− | List of verbs... |
||
<pre> |
<pre> |
||
+ | mysql> |
||
− | select |
+ | select |
− | from uw_option_attribute_values as oav, uw_syntrans as st, uw_defined_meaning as dm, uw_expression_ns as e |
||
+ | 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 |
where |
||
⚫ | |||
− | oav.option_id = '409110' and |
||
+ | (l.wikimedia_key='es' or l.wikimedia_key='pt') and |
||
⚫ | |||
− | + | dm.defined_meaning_id = t.defined_meaning_id and |
|
⚫ | |||
⚫ | |||
+ | order by |
||
+ | t.defined_meaning_id ASC, l.wikimedia_key ASC |
||
</pre> |
</pre> |
||
+ | |||
− | --[[User:Ebenimeli|Enrique]] 12:30, 30 July 2007 (BST) |
||
+ | <pre> |
||
+ | 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; |
||
+ | </pre> |
Revision as of 15:01, 30 July 2007
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;