SELECT DISTINCT c.gcate, d.catename, d.upcate FROM shop_goods a, shop_goods_review b WHERE a.index_no = b.gs_id and a.shop_state = '0' and a.isopen < '3' and (FIND_IN_SET('admin', use_hide) = 0) ORDER BY d.upcate

1054 : Unknown column 'c.gcate' in 'field list'

error file : /shop/review.php