SELECT words.id, words.definition
  FROM words 
  JOIN types ON words.typeID = types.id
  JOIN stockmatch ON words.id = stockmatch.wordID
  JOIN stock ON stockmatch.stockID = stock.id 
  JOIN languages ON stock.languageID = languages.id
WHERE stock.word = ? 
  AND languages.name = ? 
  AND types.name = ?