nos acercamos
Código sql:
Ver originalSELECT (@REG := @REG + 1) Linea, consulta.id_promotor, consulta.totalVisitas, url_promotor FROM
(SELECT @REG :=0,ep.id_promotor, COUNT(*) AS totalVisitas, url_promotor
FROM ew_p_visitas epv INNER JOIN ew_promotores ep ON epv.id_promotor=ep.id_promotor
WHERE candidato_id=18 GROUP BY epv.id_promotor ORDER BY totalVisitas DESC) consulta;
sin probar es dificil
