日本語講師在籍、または日本語利用が可能なオンライン英会話スクール

MySQLでエラーが発生しました。
SELECT *,sum(bit) as rank FROM eikaiwa_school LEFT JOIN eikaiwa_ad ON eikaiwa_school.id=eikaiwa_ad.school_id WHERE adtype = 'タイプ別' and shurui = '日本語' and '2021-09-23' > end and id <> '' and flag is null Group by id ORDER by end DESC,bit DESC
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank FROM eikaiwa_school LEFT JOIN eikaiwa_ad ON eikaiwa_school.id=eikaiwa_ad.sc' at line 1