select 0+menus.titre AS num, menus.*,urls.url FROM apimolucciana_menus as menus INNER JOIN apimolucciana_urls as urls on type_objet='menu' and id_objet=id_menu and lang='' where id_parent=0 order by num asc