U menya top reyting statistika po stranam povtaraetsya kak mozhna popravit?
Primer: xhtml html
kod takoy
$result = mysql_query("
SELECT `top_operators`.`country`, `top_operators_stat`.`count`
FROM `top_operators_stat`
LEFT JOIN `top_operators`
ON `top_operators`.`id` = `top_operators_stat`.`id_operator`
WHERE `date` = '$today' AND `day_week` = $week_day AND `uid` = $uid
ORDER BY `top_operators_stat`.`count` DESC
");

в какой таблице хранятся страны?

GROUP BY `top_operators`.`country`

Gemorroj написал:

GROUP BY `top_operators`.`country`

Kuda dobavit?

перед ORDER BY

paluchilas nu sechas xit ne pravilna pokazivaet
Primer: New| Staroe

Gemorroj, esho est takoy kadirovka
$result = mysql_query("SELECT DISTINCT `top_operators_stat`.`id_operator`, SUM(`top_operators_stat`.`count`) AS `count`, `top_operators`.`country` as `country` FROM `top_operators_stat`, `top_operators` WHERE `top_operators_stat`.`uid` = ".$uid." AND `date` = $date AND `top_operators_stat`.`id_operator` = `top_operators`.`id` GROUP BY `top_operators`.`country` ORDER BY 2 DESC;");
zdes vsego normalnya pakazivaet kromi (Другие) strana ne pokazivaet kak mozhna zdelat chtobi (Другие) strani tozhe pokazall?
Primer: xhtml

верни таблицы плз. в запросах куча хлама, и мне не совсем понятна структура хранения данных.

Struktura: Struktura

chlavek geni prosta super spasibo balshoe Gemaroj ya znal krome tebya ne kto ne smog eta zdelat