select bkb_frontoldalimenu.did as menu_did,bkb_frontoldalimenu.fomenu_did as menu_fomenuje,bkb_frontoldalimenu.megnevezes as menu_megnevezes,bkb_frontoldalimenu.weburl as menu_url,(select count(did) from bkb_frontoldalimenu where fomenu_did=menu_did) as almenuszam from bkb_frontoldalimenu where allapot='1' order by sorrend asc