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