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,103,106,81,82,86,88,67,68,73,75,218,220,,55,63,66,29,30,34,35,211,213) and id_padre='96' order by mcxi.nombre asc