SELECT n.id as node_id, n.Caption as node_Caption, n.Note as node_Note, n.Url as node_Url, n.EKey as node_EKey, o.id as obj_id, o.Note as obj_Note, o.date as obj_DATE_YmdHis, DATE_FORMAT(o.date,'%Y') as obj_DATE_Y, DATE_FORMAT(o.date,'%m') as obj_DATE_m, DATE_FORMAT(o.date,'%M') as obj_DATE_F, DATE_FORMAT(o.date,'%d') as obj_DATE_d, DATE_FORMAT(o.date,'%w') as obj_DATE_w, DATE_FORMAT(o.date,'%W') as obj_DATE_l, DATE_FORMAT(o.date,'%j') as obj_DATE_j, DATE_FORMAT(o.date,'%H') as obj_DATE_H, DATE_FORMAT(o.date,'%i') as obj_DATE_i, DATE_FORMAT(o.date,'%S') as obj_DATE_s, UNIX_TIMESTAMP(o.date) as obj_DATE_utime, if(pm.Par1!='#NOUSE#',o.Par1,'#NOUSE#') as obj_PAR_Par1, pm.Par1 as obj_PAR_Par1Name, if(pm.Par2!='#NOUSE#',o.Par2,'#NOUSE#') as obj_PAR_Par2, pm.Par2 as obj_PAR_Par2Name, if(pm.Par3!='#NOUSE#',o.Par3,'#NOUSE#') as obj_PAR_Par3, pm.Par3 as obj_PAR_Par3Name, if(pm.Par4!='#NOUSE#',o.Par4,'#NOUSE#') as obj_PAR_Par4, pm.Par4 as obj_PAR_Par4Name, if(pm.Par5!='#NOUSE#',o.Par5,'#NOUSE#') as obj_PAR_Par5, pm.Par5 as obj_PAR_Par5Name, if(pm.Par6!='#NOUSE#',o.Par6,'#NOUSE#') as obj_PAR_Par6, pm.Par6 as obj_PAR_Par6Name, if(pm.Par7!='#NOUSE#',o.Par7,'#NOUSE#') as obj_PAR_Par7, pm.Par7 as obj_PAR_Par7Name, e.id as evn_id, e.Note as evn_Note, e.Code as evn_Code FROM avs_sm_clnt_nodes as n, avs_sm_clnt_grp_node_obj as gno, avs_sm_clnt_objects as o, avs_sm_clnt_paramaps as pm, avs_sm_clnt_grp_obj_evn as goe, avs_sm_clnt_events as e WHERE n.EKey = 'sm-master-avs' AND gno.id_node = n.id AND o.id = gno.id_obj AND o.EKey = 'main' AND o.enabled = 1 AND pm.id = o.id_parmap AND goe.id_obj = o.id AND e.id = goe.id_evn AND e.EKey = 'Default' GROUP BY o.id
Error accessing database:Got error 28 from storage engine