no puedo recuperar consulta Table 'admin_orione.rubro_categoria' doesn't exist
SELECT cat.id_categoria AS idcategoria, cat.nombre_categoria As categoria, rubro.CodigoRubro As idrubro, rubro.NombreRubro AS rubro, subrubro.IDSubRubro AS idsubrubro, subrubro.NombreSubRubro AS subrubro, COUNT(articulo.idart) AS total FROM articulo LEFT JOIN rubro ON rubro.CodigoRubro = articulo.CodigoRubro LEFT JOIN rubro_categoria AS cat ON cat.id_categoria = rubro.id_categoria LEFT JOIN subrubro ON subrubro.IDSubRubro=articulo.IDSubRubro WHERE articulo.Discontinuo='No' AND cat.ecommerce='Si' AND articulo.ecommerce='Si' AND articulo.tipo_art='Articulo' AND rubro.ecommerce='Si' AND subrubro.ecommerce='Si' GROUP BY cat.id_categoria,rubro.CodigoRubro,subrubro.IDSubRubro HAVING COUNT(articulo.IDArt) > 0 ORDER BY cat.nombre_categoria ASC,rubro.NombreRubro,subrubro.NombreSubRubro ASC