where di.di_flg=1 and di.di_disp_status=1 and di.di_area!='ura' and di.di_mc_code like '%561f4d1c4e56ce%' and di.di_mcs_code like '%161f4d30fed3f0%' and di.di_color_sys_code like '%10613ddbc4cbb55%' 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'