「タイプ別オンライン英会話スクール」の記事一覧(2 / 5ページ)

ビジネス英会話に特化した対策コースがあるオンライン英会話スクール

ビジネス英会話
MySQLでエラーが発生しました。
SELECT *,sum(bit) as rank FROM eikaiwa_school LEFT JOIN eikaiwa_ad ON eikaiwa_school.id=eikaiwa_ad.school_id WHERE stype like '%ビジネス%' and ('2021-06-23' <= end and '2021-06-23' >= eikaiwa_ad.start) and id <> '206' and id <> '23' and id <> '135' and id <> '137' and id <> '43' and id <> '' and flag is null Group by id ORDER by rank 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