mysql> SELECT SQL_CALC_FOUND_ROWS `id_x`, COUNT(*) FROM `x` GROUP BY `id_x`LIMIT 0,5


+-----------+----------+
|   id_x    | COUNT(*) |
+-----------+----------+
|         1 |        1 |
|         3 |        1 |
|         5 |        1 |
+-----------+----------+

3 rows in set (0.00 sec)

# NOT WORKING..... :/
# I neeed (3 rows in set (0.00 sec)) in variable, and rowset... :/

mysql> Select FOUND_ROWS();
+--------------+
| FOUND_ROWS() |
+--------------+
|            8 |
+--------------+
1 row in set (0.00 sec)