SELECT m.id,m.parent,m.type,m.auth,m.value,m.images,m.visible, if(ml.name!=NULL OR ml.name!='',ml.name,md.name) AS name, if(ms.title!=NULL OR ms.title!='',ms.title,if(msd.title!=NULL OR msd.title!='',msd.title,if(ml.name!=NULL OR ml.name!='',ml.name,md.name))) AS title, if(ms.discription!=NULL OR ms.discription!='',ms.discription,msd.discription) AS descript, if(ms.keywords!=NULL OR ms.keywords!='',ms.keywords,msd.keywords) AS keywords, if(ms.toptext!=NULL OR ms.toptext!='',ms.toptext,msd.toptext) AS top, if(ms.bottomtext!=NULL OR ms.bottomtext!='',ms.bottomtext,msd.bottomtext) AS bottom, if(mc.value!=NULL OR mc.value!='',mc.value,if(mcd.value!='' OR mcd.value!=NULL,mcd.value,NULL)) AS content FROM _menu AS m LEFT JOIN _lang AS l ON l.defaults=1 LEFT JOIN _menu_lang AS ml ON ml.id=m.id AND ml.lang='2' LEFT JOIN _menu_lang AS md ON md.id=m.id AND md.lang=l.id LEFT JOIN _menu_site AS ms ON ms.id=m.id AND ml.lang=ms.lang LEFT JOIN _menu_site AS msd ON msd.id=m.id AND msd.lang=l.id LEFT JOIN _menu_content AS mc ON mc.id=m.id AND mc.lang=ml.lang AND ((mc.auth='0' AND m.type='auth') OR mc.auth='0') LEFT JOIN _menu_content AS mcd ON mcd.id=m.id AND mcd.lang=l.id AND mcd.auth=mc.auth WHERE m.visible!=4 AND m.id='224' ORDER BY m.parent,m.sort ASC