优化这段sql语句 select tlllabel_namecounttcqymc from t_label_company_match t left JOIN t_company_info tc on tcid=tcompany_id left JOIN t_label_library tll on tllid=tlabel_id where tlllabel_index_id like -2
SELECT tll.label_name, COUNT(tc.qymc) FROM t_label_company_match t LEFT JOIN t_company_info tc ON tc.id = t.company_id LEFT JOIN t_label_library tll ON tll.id = t.label_id WHERE tll.label_index_id LIKE '-2%' GROUP BY tll.label_name ORDER BY COUNT(tc.qymc) DESC LIMIT 4
原文地址: https://www.cveoy.top/t/topic/egW5 著作权归作者所有。请勿转载和采集!