Select a.nombre, Count(iddetalle) As total From articulos a Inner Join pedidos d ON a.idarticulo=d.idarticulo Group By a.idarticulo Order By Total DESC;