 <p>First of all you should use table to store the values you have in your <code>IN</code> list and then join against that. If this is transient data, you could use temporary table.</p> <pre><code>CREATE TEMPORARY TABLE t1 (yourid VARCHAR(9) PRIMARY KEY); INSERT IGNORE INTO t1 VALUES ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('44089839'),('44089839'),('44089839'), ('44089839'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('96611525'),('96611525'), ('96611525'),('96611525'),('142061451'),('142061451'), ('142061451'),('142061451'),('142061451'),('142061451'), ('142061451'),('142061451'),('142061451'),('142061451'), ('142061451'),('142061451'),('142061451'),('142061451'), ('142061451'),('142061451'),('142061451'),('142061451'), ('142061451'),('142801551'),('142801551'),('142801551'), ('142801551'),('142801551'),('142801551'),('142801551'), ('142801551'),('142801551'),('142801551'),('142801551'), ('142801551'),('142801551'),('142801551'),('142801551'), ('142801551'),('142801551'),('142801551'),('142801551'), ('142801551'),('142801551'),('142801551'),('143381529'), ('143381529'),('143381529'),('143381529'),('143381529'), ('143381529'),('147713054'),('147713054'),('147713054'), ('147713054'),('147713054'),('147713054'),('147713054'), ('148164398'),('148164398'),('148164398'),('148164398'), ('148164398'),('148164398'),('148164398'),('148164398'), ('148164398'),('148164398'),('148164398'),('148296160'), ('148296160'),('148296160'),('148296160'),('148296160'), ('148296160'),('151063722'),('151063722'),('151063722'), ('151063722'),('151063722'),('151063722'),('151063722'), ('151063722'),('151063722'),('151063722'),('151063722'), ('151063722'),('151063722'),('151063722'),('151063722'), ('151063722'),('151063722'),('151063722'),('151063722'), ('151063722'),('151063722'),('153933372'),('153933372'), ('153933372'),('153933372'),('153933372'),('153933372'), ('154447237'),('154447237'),('154447237'),('154447237'), ('154447237'),('154447237'),('154447237'),('158137781'), ('158137781'),('158137781'),('158137781'),('158137781'), ('158137781'),('158217358'),('158217358'),('158217358'), ('158217358'),('158217358'),('158217358'),('158217358'), ('158217358'),('158217358'),('158217358'),('158217358'), ('158217358'),('158217358'),('158246547'),('158246547'), ('158246547'),('158246547'),('158246547'),('158246547'), ('158246547'),('158246547'),('158246547'),('158246547'), ('158246547'),('158246547'),('158246547'),('158246547'), ('158246547'),('158246547'),('158246547'),('158246547'), ('158246547'),('158246547'),('158246547'),('160734561'), ('160734561'),('160734561'),('160734561'),('160734561'), ('160734561'),('162435844'),('162435844'),('162435844'), ('162435844'),('162435844'),('162435844'),('162435844'), ('162435844'),('162435844'),('162435844'),('162435844'), ('162435844'),('162435844'),('163784258'),('163784258'), ('163784258'),('163784258'),('163784258'),('163784258'), ('163784258'),('163784258'),('163784258'),('163784258'), ('163784258'),('163784258'),('163784258'),('163784258'), ('163784258'),('163784258'),('163784258'),('163784258'), ('163784258'),('163800813'),('163800813'),('163800813'), ('163800813'),('163800813'),('163800813'),('163800813'), ('163800813'),('163800813'),('163800813'),('163800813'), ('163803246'),('163803246'),('163803246'),('163803246'), ('163803246'),('163803246'),('164617535'),('164617535'), ('164617535'),('164617535'),('164617535'),('164617535'), ('164617535'),('164617535'),('164617535'),('164617535'), ('164617535'),('164617535'),('164617535'),('164617535'), ('164617535'),('164617535'),('164617535'),('164617535'), ('164617535'),('164617535'),('164617535'); </code></pre> <p>Above statement creates the temporary table, inserts data into it and also removes all the duplicates. </p> <p>Once that's done, then you just use your table in you query:</p> <pre><code>SELECT id,kdt_id,kdt_goods_id,fx_price,min_retail_price,max_retail_price,fx_count,stock_num,sold_num,recommend_level,is_display,is_delete,quit_time, review_status,fx_auth,level_discount_auth,is_fx_delete,sold_status FROM apple_goods JOIN t1 ON (yourid=kdt_goods_id); </code></pre> <p>I'd also suggest that you match types in your temporary table and columns you <code>JOIN</code> against, e.g. if <code>kdt_goods_id</code> is <code>INT</code> then <code>yourid</code> in your temporary table should be <code>INT</code>. </p>