SELECT a.id,a.name as pname,a.price,a.yprice,a.create_price_time,a.update_price_time,a.market_price,a.member_id as userid,a.pic,c.company, p.* FROM mb_product a left join mb_distribution_product p ON a.id=p.product_id left join  b on a.id=b.product_id left join mb_shop c on a.member_id=c.userid WHERE a.id in (2912381,2883883,2887985,2888010,2886712,2886725,2887943,2556428,2886738,2887969,73961,2886811,189586,73953,2912383,2888012,2886976,211126,2056997,544876,328912,2906392,342004,3119689,2903049,2903045,2903042,2888025,2886983,2883826) ORDER BY FIELD(a.id,2912381,2883883,2887985,2888010,2886712,2886725,2887943,2556428,2886738,2887969,73961,2886811,189586,73953,2912383,2888012,2886976,211126,2056997,544876,328912,2906392,342004,3119689,2903049,2903045,2903042,2888025,2886983,2883826)Table 'mb.b' doesn't exist