비품,사무용품
비품,사무용품

TotalRecordQuery :
SELECT SUM(cnt) AS cnt, GROUP_CONCAT(DISTINCT CONCAT(A.UID,'|',A.P_brand,'|',A.c_cnt) ORDER BY c_cnt desc ) AS brand_name FROM ( SELECT SUM(1) AS cnt, B.UID ,B.P_brand, COUNT(*) c_cnt FROM Plaza_product AS P INNER JOIN Company C ON ( P.P_comp_uid = C.C_uid ) INNER JOIN Plaza_brand B ON ( P.P_brand = B.UID ) WHERE 0=0 AND P.P_show = 'show' AND P.P_approval = 'ok' AND C.C_approval = 'Y' AND C.C_state = '' AND P.P_item = 'M' AND P.P_dir IN ( ) GROUP BY B.UID, B.P_brand ORDER BY c_cnt DESC) A;
-->