[管理画面]顧客管理：MySQLの場合、顧客CSVダウンロードで構文エラー

[kotani]

SQL: SELECT customer_id, name01, name02, kana01, kana02, zip01, zip02, (SELECT name FROM mtb_pref WHERE CAST(mtb_pref.id AS smallint) = dtb_customer.pref) as pref, addr01, addr02, email, tel01, tel02, tel03, fax01, fax02, fax03, (SELECT name FROM mtb_sex WHERE CAST(mtb_sex.id AS smallint) = dtb_customer.sex) as sex, (SELECT name FROM mtb_job WHERE CAST(mtb_job.id AS smallint) = dtb_customer.job) as job, birth, first_buy_date, last_buy_date, buy_times, point, note, create_date, update_date FROM dtb_customer WHERE del_flg = 0

MDB2 Error: syntax error

_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_4c5ee077e9e303e6e60c6d4c5c62eadbca88ad17a FROM 'SELECT customer_id, name01, name02, kana01, kana02, zip01, zip02, (SELECT name FROM mtb_pref WHERE CAST(mtb_pref.id AS smallint) = dtb_customer.pref) as pref, addr01, addr02, email, tel01, tel02, tel03, fax01, fax02, fax03, (SELECT name FROM mtb_sex WHERE CAST(mtb_sex.id AS smallint) = dtb_customer.sex) as sex, (SELECT name FROM mtb_job WHERE CAST(mtb_job.id AS smallint) = dtb_customer.job) as job, birth, first_buy_date, last_buy_date, buy_times, point, note, create_date, update_date FROM dtb_customer WHERE del_flg = 0 ']
[Native code: 1064]
[Native message: 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 'smallint) = dtb_customer.pref) as pref, addr01, addr02, email, tel01, tel02, tel' at line 1]