經典sql語句查詢

$sql="SELECT CONCAT('r_',rb.r_cid,'_',rb.r_uid) as cc, sum(rb.r_pages) as pages,sum(rb.r_pagenone) as pagenone,sum(rb.r_copies) as copies FROM `reports_bak` as rb WHERE rb.r_del='0' AND rb.r_date >= '2013-03-21' AND rb.r_date <= '2013-03-22' AND rb.r_cid in ('1414','1429','1453','1474','1481','1484','1500','1523','1524','1531','1541','1542','1589','1595','1645','1656','1664','1678','1679','1682','1688','1697','1698','1699','1700','1701','1702','1703') group by cc"
主要用於查詢數量較大的用戶