Sorry, database error detected.
Please try again.
select DISTINCT T.item_id, T.parent_item_id, T.item_name item_name, T.item_pos, T.item_show, T.item_act, T.item_notes ,T.fullview_url item_url, count( DISTINCT A.good_id) counter from ssp_GoodsTree T inner join ssp_GoodsTreeCache TCount on TCount.parent_item_id= T.item_id inner join ssp_GoodsTree THiddens on THiddens.item_id= TCount.item_id or THiddens.item_id= T.item_id inner join ssp_Goods A on A.item_id= THiddens.item_id and THiddens.item_show and A.g_public where T.item_id= 167 or ( T.item_show and T.item_act) group by T.item_id, T.parent_item_id, T.item_name, T.item_pos, T.item_show, T.item_act, T.item_notes ,T.fullview_url

Got error 28 from storage engine