SELECT
t.nid, t.field_trns_value
FROM content_type_termo t, node n, term_data td, term_node tn,
node_revisions nr, users u
WHERE
t.field_trns_value is not null and
t.field_trns_value > "-" and
t.vid=n.vid and
n.type='termo' and
tn.nid=n.nid and
tn.tid=td.tid and
nr.nid=n.nid and
nr.vid = n.vid and
n.uid=u.uid
order by t.field_trns_value desc
SELECT t.nid, t.field_trns_value,
t.field_trad_castelan_value,
t.field_trad_ingls_value,
t.field_trad_portugues_value,
t.field_trad_frances_value,
t.field_trad_aleman_value,
t.field_trad_italiano_value
FROM content_type_termo t, node n, term_data td, term_node tn, node_revisions nr, users u
WHERE t.field_trns_value IS NOT NULL
AND t.field_trns_value < "-"
AND t.vid = n.vid
AND n.type = 'termo'
AND tn.nid = n.nid
AND tn.tid = td.tid
AND nr.nid = n.nid
AND nr.vid = n.vid
AND n.uid = u.uid
ORDER BY t.field_trns_value DESC
