SELECT gb , cnt , @rn := @rn + 1 AS rn FROM (SELECT gb , CASE gb WHEN 0 THEN u_cnt0 WHEN 1 THEN u_cnt1 WHEN 2 THEN u_cnt2 WHEN 3 THEN u_cnt3 WHEN 4 THEN u_cnt4 WHEN 5 THEN u_cnt5 WHEN 6 THEN u_cnt6 WHEN 7 THEN u_cnt7 WHEN 8 THEN u_cnt8 END cnt , @rn := 0 FROM (SELECT COUNT(CASE WHEN g.referer_site LIKE '%google%' THEN 1 END) u_cnt0 -- 유입경로(구글) , COUNT(CASE WHEN g.referer_site LIKE '%naver%' THEN 1 END) u_cnt1 -- 유입경로(네이버) FROM mms_new_referer g INNER JOIN mms_new_default_info n ON g.mms_unique_num = n.mms_unique_num WHERE (g.referer_site LIKE '%google%' OR g.referer_site LIKE '%naver%') AND g.referer_datetime BETWEEN '2019-06-16' AND '2019-06-22' ) a CROSS JOIN (SELECT COUNT(CASE mms_sales_t WHEN 'H' THEN 1 END) u_cnt2 -- 문의방식(전화문의) , COUNT(CASE mms_sales_t WHEN 'I' THEN 1 END) u_cnt3 -- 문의방식(인터넷문의) , COUNT(CASE mms_sales_t WHEN 'E' THEN 1 END) u_cnt4 -- 문의방식(이메일문의) , COUNT(CASE mms_sales_u WHEN 'A' THEN 1 END) u_cnt5 -- 영업처(광고) , COUNT(CASE mms_sales_u WHEN 'I' THEN 1 END) u_cnt6 -- 영업처(소개) , COUNT(CASE mms_sales_u WHEN 'C' THEN 1 END) u_cnt7 -- 영업처(기존고객) , COUNT(CASE mms_sales_u WHEN 'E' THEN 1 END) u_cnt8 -- 영업처(기타) FROM mms_new_default_info q INNER JOIN mms_project_info b ON q.mms_unique_num = b.mms_unique_num WHERE b.mms_sales_date BETWEEN '2019-06-16' AND '2019-06-22' ) b CROSS JOIN (SELECT 0 gb UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 ) c ORDER BY cnt DESC LIMIT 9 ) a ;