select
ui.channel,
count(ui.channel) as cnt
from
user_info as ui
left join (
select distinct
uid
from
order_log
)a
on
ui.uid = a.uid
where
a.uid is null
group by
ui.channel
order by
cnt desc,
ui.channel
limit 1


京公网安备 11010502036488号