select c.MRL,c.OPERATION_ID,c.PRODUCT_ID,
sum(if(TYPE='ONSHOW',1,0) as 上架数,
sum(if(TYPE='WITHDRAW',1,0) as 下架数,
sum(if(TYPE='MOVE',1,0) as 迁移数
from chanage_apply c,chanage_cabinets d
where c. -- ??????? 看不出你这两个表如何联接。
group by c.MRL,c.OPERATION_ID,c.PRODUCT_ID
select count(*) as aa , HomeRealName ,AwayRealName from VirtualMatch group by HomeRealName ,AwayRealName