temp

wine_ids:2,4,5,6,7,8,14,22,23,24

menu_ids:17,18,19

SELECT wine_set.wine_id, wine_set.wine_num*menu_set.set_num from wine_set join menu_set on menu_set.set_id = wine_set.set_id  where menu_set.menu_id in (select menu_id from menu where bar_id = ? and menu_status = ? ) group by wine_id

http://pan.baidu.com/s/1qYCvZic