File size: 282 Bytes
13812dc | 1 2 3 4 5 6 7 8 9 10 11 | SELECT w.word_ix, w.lang, w.lexeme, w.sense
FROM words w
LEFT JOIN links l ON l.source = w.word_ix
WHERE lower(w.lexeme) = lower(?)
GROUP BY w.word_ix, w.lang, w.lexeme, w.sense
ORDER BY
CASE WHEN w.lang = 'en' THEN 0 ELSE 1 END,
COUNT(l.target) DESC,
w.word_ix
LIMIT 1
|