select distinct(c.id) from azira_content_menu as cm, azira_content as c where cm.idmenu = and cm.lang = 'en' and cm.lang = c.lang and cm.idcontent = c.id and cm.stato = 1 order by c.id asc Loden Tal - Sari Spazio
   

TONELLO

Lodental - Fw17 Man Collection[4]-53 - Sari Spazio