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      = 'page_3'       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

                               <BR><B>Error accessing database:</B>Got error 28 from storage engine<BR>