SELECT
vocabulary_list.id,
vocabulary_list.word,
vocabulary_list.lemma,
vocabulary_list.syllables,
vocabulary_list.synsetid,
vocabulary_list.definition,
sentences.sentence,
vocabulary_list.pos,
(SELECT Avg(tmp.lexile) FROM `vocabulary_list` AS tmp WHERE tmp.lemma=vocabulary_list.lemma and tmp.synsetid=vocabulary_list.synsetid) AS lex_avg,
vocabulary_list.lexile,
abs(vocabulary_list.lexile-(SELECT Avg(tmp.lexile) FROM `vocabulary_list` AS tmp WHERE tmp.lemma=vocabulary_list.lemma and tmp.synsetid=vocabulary_list.synsetid)) AS abs_val,
vocabulary_list.title,
vocabulary_list.`subject`,
vocabulary_list.frequency,
vocabulary_list.passageid,
vocabulary_list.sentenceid,
vocabulary_list.source,
vocabulary_list.notused
FROM
vocabulary_list
INNER JOIN sentences ON vocabulary_list.sentenceid = sentences.id
WHERE vocabulary_list.passageid in (125, 126, 127, 128, 129) and notused is null
GROUP BY
vocabulary_list.passageid,
vocabulary_list.lemma,
vocabulary_list.synsetid
ORDER BY
vocabulary_list.passageid,
abs_val,
vocabulary_list.lemma

/*************************/

passage id's

125, 126, 127, 128, 129

2060, 2061, 2062, 2063, 2064

790, 791, 792, 793, 794

624, 625, 626, 627, 628

300, 301, 302, 303, 304