SELECT w.word_id, w.word,
(SELECT frequeny FROM analyses a WHERE a.word_id = w.word_id ORDER BY `date` DESC LIMIT 1) as cpos,
(SELECT `date` FROM analyses a WHERE a.word_id = w.word_id ORDER BY `date` DESC LIMIT 1) as cdate,
(SELECT frequeny FROM analyses a WHERE a.word_id = w.word_id ORDER BY `date` DESC LIMIT 1,1) as ppos,
(SELECT `date` FROM analyses a WHERE a.word_id = w.word_id ORDER BY `date` DESC LIMIT 1,1) as pdate
FROM words w