The following query works perfectly in MySQL:
SELECT
`user`,
COUNT(`ip`) AS `ip`
FROM db_connects
WHERE `user` <> '' AND `user` <> 'Guest'
GROUP BY `user`
ORDER BY `ip` DESC
LIMIT 25
When using it in the PHPR it shows correst when pressing "Result" tab, but the limit statement is ignored when outputting for my chart.
If I click "Query Designer" and return to "SQL", the LIMIT statement have gone.
If I click "NEXT" from the "SQL" tav, I get a warning saying " ORDER BY fields must match SELECT fields. You may let Runner to fix SQL query automaticly or fix it by hand." And then O get 4 options with following results:
I hope my description is such, that you understand the problem.