SELECT categorielang.*, catMere.categorie as categoriemere FROM categories INNER JOIN categorielang on categories.IDcategorie=categorielang.IDcategorie INNER JOIN categorielang as catMere on categories.IDparent=catMere.IDcategorie WHERE categorielang.url='t���ches' and catMere.url='peau'