SELECT w.id, w.definition
FROM words w, stock s, languages l, stockmatch m, types t
WHERE s.word = ? AND l.name = ? AND s.languageID = l.id AND
m.stockID = s.id AND w.id = m.wordID AND t.name = ? AND
w.typeID = t.id;

##</code><code>##

words[
    id = stockmatch[
        stockID = stock[
            word = ?,
            languageID = languages[name = ?](id)
        ](id)
    ](wordID),
    typeID = types[name = ?](id)
](id, definition)