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 (305365,637288,568801,569907,504568,347039,346320,571202,342576,311699,310933,303321,295232,543315,343884,288197,565846,281460,258877,260189,249318,247355,205410,204046,201856,69864,36601,14604,11168,305365) ORDER BY FIELD(a.id,305365,637288,568801,569907,504568,347039,346320,571202,342576,311699,310933,303321,295232,543315,343884,288197,565846,281460,258877,260189,249318,247355,205410,204046,201856,69864,36601,14604,11168,305365)Table 'mb.b' doesn't exist