SELECT d.id_pais, COUNT(*) AS cuantos FROM reviews r JOIN pedidos p USING (id_cliente) JOIN direcciones d ON (p.id_dir_envio=d.id_direccion) WHERE r.id_producto='sbplg' AND r.id_estado='publ' AND p.id_estado='clos' GROUP BY d.id_pais ORDER BY COUNT(*) DESC