SELECT `deal_id`, group_concat(cast( user_id as char)) as uid,count(1) as c FROM `favorite` where user_id in (1308987221,1668338340,1760612041) group by `deal_id` order by c desc limit 0,5