All pastes #745393 Raw Edit

Anonymous

public text v1 · immutable
·published 2007-10-22 11:24 UTC
rendered paste body
SELECT k.kanji,  GROUP_CONCAT(DISTINCT CONCAT( ex.word, ' [', ex.reading, '] ')  SEPARATOR ', ' ) AS example
FROM kanjis k
LEFT JOIN `kanji2word` k2w ON k2w.kanji_id = k.id
LEFT JOIN `jmdict` ex ON ex.id = k2w.word_id
WHERE k.jlpt >= '4' GROUP BY k.id
HAVING COUNT(k2w.kanji_id) < 3
LIMIT 0 , 30