SELECT sg.* FROM tbweb1.shop_goods sg INNER JOIN newsp.shop_goods_category sgc ON sg.index_no = sgc.goods_no WHERE sgc.category_id LIKE '543516%' AND sgc.isopen = '1' AND sgc.shop_state = '0' ORDER BY sgc.m_count desc, sgc.`rank` DESC, sgc.goods_no DESC limit 0, 40
1054 : Unknown column 'sgc.m_count' in 'order clause'
error file : /shop/list.php