SELECT mid,pos,visi,isParent,hasParent,descr,keyw,pagetitle, gp_menu2lang.label as menulabel FROM gp_menu JOIN gp_menu2lang using (mid) WHERE visi=1 and lid= order by `pos` -