内容摘要:select year(createdate) 年,month(createdate) 月,count(1) from public_cms_arcwhere (userid in (select id from cms_admin wh...
select year(createdate) 年, month(createdate) 月, count(1) from public_cms_arc where (userid in (select id from cms_admin where userid='392') or userid='392') group by year(createdate), month(createdate) order by year(createdate) desc,month(createdate) desc