where di.di_flg=1 and di.di_disp_status=1 and di.di_area!='ura' and (di.di_mc_code like '%36200ed2ac81e6%' or di.di_item_status like '%76213c0b1a23f9%') and di.di_mcs_code like '%86200ee4e688a1%' and di.di_color_sys_code like '%10613de54a142aa%' order by di.di_open_date descデータ取得エラー:ERR_GDD_02You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and dii.dii_size_class='main'' at line 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and dii.dii_size_class='main'' at line 1
SELECT * FROM d_item_main as di inner join d_item_images as dii on di.di_code=dii.dii_di_code where di.di_code IN () and dii.dii_size_class='main'