Issvar
11-05-2003, 08:23 AM
I tried posting
SELECT
userid,
username,
COUNT(*) as weekpostcount
FROM
post
WHERE
dateline > (UNIX_TIMESTAMP() - 7*24*60*60)
GROUP BY
username,
userid
ORDER BY
weekpostcount DESC
LIMIT 5
As you see it writes [high#0000CC] and [endhigh] in my query in the outer parentheses.
SELECT
userid,
username,
COUNT(*) as weekpostcount
FROM
post
WHERE
dateline > (UNIX_TIMESTAMP() - 7*24*60*60)
GROUP BY
username,
userid
ORDER BY
weekpostcount DESC
LIMIT 5
As you see it writes [high#0000CC] and [endhigh] in my query in the outer parentheses.