ERROR :
select mc.id, mcxi.nombre, mc.id_padre from mc_categoria mc join mc_categoriaxidioma mcxi on (mcxi.id_categoria = mc.id) where mcxi.idioma='es' and mc.id in ( 38,39,44,45,113,114,117,96,97,98,99,81,82,86,88,67,68,73,75,29,30,34,35,,55,63,66) and id_padre='96' order by mcxi.nombre asc