Hot 100

Database error: Error Executing SQL: select distinct c.*, m.*, r.*, s.teaser from compositions c, movements m, composers r, section_items s where m.pc_track_id=s.pc_track_id and c.composition_id=m.composition_id and r.composer_id=c.composer_id and s.section_name='hot100' order by sort_order
MySQL Error: 3065 (Expression #1 of ORDER BY clause is not in SELECT list, references column 'pc.s.sort_order' which is not in SELECT list; this is incompatible with DISTINCT)
Session halted.