Well I've just hit a weird behaviour that I've never seen before, or haven't noticed.

I'm using this query:

```
  SELECT *, 
         COUNT(*) AS pages 
    FROM notis 
   WHERE cid = 20 
ORDER BY nid DESC 
   LIMIT 0, 3

```

...to read 3 items but while doing that I want to get the total rows.

Problem is...
-------------

...when I use count the query only returns one row, but if I remove
`COUNT(*) AS pages` -- I get the 3 rows as I'm suppose to. Obviously, i'm missing something here.