SELECT articles.* , visits.* , COUNT( visits.visit ) AS numero_visite FROM articles LEFT JOIN visits ON articles.article = visits.visit_article GRUOP BY visits.visit LIMIT 1, 10

cosi? com'è?