select menu_title,

totalDays,

totalCooked

from (select menu_title,

count(*) as cookedTimes,

1 as idx

from cookrecord

WHERE uid = 22

GROUP BY menu_title

order by cookedTimes DESC limit 1) a

left join

(select

count(*)as totalDays,

sum(num) as totalCooked,

1 as idx

from

(select id,

count(*) as num

from cookrecord

where uid = 22

GROUP BY day(gmtCreate)

order by num) t1)t2

on a.idx = t2.idx