When setting $wgMiserMode = false and $wgCommentTableSchemaMigrationStage = MIGRATION_WRITE_NEW the builded sql is invalid on Special:ListFiles:
Query: SELECT img_timestamp,img_name,img_name AS thumb,img_size,img_user_text,COUNT(oi_archive_name) AS count,img_user AS img_user,COALESCE( comment_img_description.comment_text, img_description ) AS `img_description_text`,comment_img_description.comment_data AS `img_description_data`,comment_img_description.comment_id AS `img_description_cid`,'img_description' AS `description_field` FROM `image`,`image_comment_temp` `temp_img_description`,`comment` `comment_img_description` LEFT JOIN `oldimage` ON ((oi_name = img_name)) GROUP BY img_user,img_timestamp,img_name,img_size,img_user_text,img_description ORDER BY img_timestamp DESC LIMIT 52 Function: IndexPager::buildQueryInfo (ImageListPager) Error: 1054 Unknown column 'img_name' in 'on clause' (localhost)
The additional join to the oldimage table for counting makes problems here