We're using SQLite version 3.6.20 - somehow SQLite throws on this left join: 

LEFT JOIN analysis_base a USING(analysis_id)

However, this explicit LEFT join works for us and our SQLite installation: 

LEFT JOIN analysis_base a ON a.analysis_id = r.analysis_id