Check goods. Id, goods goods_name, goods. Short_name, goods. Labels
Requires every goods_id corresponding to the corresponding goods, goods_name, goods. Short_name, goods. Labels



The following was written by yourself, I don't know sure right hope the great god directions

 
Select ` groupbuy_goods `. ` id ` ` groupbuy_goods `. ` goods_name `, ` groupbuy_goods `. ` short_name `, ` groupbuy_goods `. ` labels ` from ` groupbuy_group_buy_goods ` left join ` groupbuy_goods ` on ` groupbuy_goods `. ` ` id=` groupbuy_group_buy_goods `. ` goods_id ` where (` groupbuy_goods `. ` tenant_id `=? And ` groupbuy_goods `. ` type `=?) And ` groupbuy_group_buy_goods `. ` group_buy_id `=?