mysql> select * from logging_ts_alternative where log_namespace = 2 and log_title = '46.118.124.27'; +----------+----------+------------+----------------+----------+---------------+---------------+---------------+----------+----------------------------+-------------------------------------------------+-------------+ | log_id | log_type | log_action | log_timestamp | log_user | log_user_text | log_namespace | log_title | log_page | log_comment | log_params | log_deleted | +----------+----------+------------+----------------+----------+---------------+---------------+---------------+----------+----------------------------+-------------------------------------------------+-------------+ | 27988876 | block | block | 20130420233450 | 3724 | Jasper Deng | 2 | 46.118.124.27 | 0 | spambot | 3 months nocreate | 0 | | 27989023 | block | block | 20130420233504 | 3724 | Jasper Deng | 2 | 46.118.124.27 | 0 | spambot | Sat, 20 Jul 2013 23:34:50 GMT anononly,nocreate | 0 | | 27989395 | block | unblock | 20130420233544 | 3724 | Jasper Deng | 2 | 46.118.124.27 | 0 | resolving double-block bug | | 0 | | 27989469 | block | unblock | 20130420233552 | 3724 | Jasper Deng | 2 | 46.118.124.27 | 0 | resolving double-block bug | | 0 | | 27990113 | block | block | 20130420233655 | 3724 | Jasper Deng | 2 | 46.118.124.27 | 0 | spambot | 3 months anononly,nocreate | 0 | +----------+----------+------------+----------------+----------+---------------+---------------+---------------+----------+----------------------------+-------------------------------------------------+-------------+ 5 rows in set (0.00 sec)