F
Floris
Guest
wetalknation.net
Code:
mysql> use xxx;
Database changed
mysql> SELECT COUNT(search_id)
-> FROM xf_search;
+------------------+
| COUNT(search_id) |
+------------------+
| 78 |
+------------------+
1 row in set (0.06 sec)
mysql> SELECT search_order, COUNT(search_id) AS total
-> FROM xf_search
-> GROUP BY search_order;
+--------------+-------+
| search_order | total |
+--------------+-------+
| date | 78 |
+--------------+-------+
1 row in set (0.00 sec)
mysql> SELECT COUNT(search_id) FROM xf_search
-> WHERE search_constraints LIKE '%reply_count%';
+------------------+
| COUNT(search_id) |
+------------------+
| 0 |
+------------------+
1 row in set (0.00 sec)
mysql>