https://bugzilla.wikimedia.org/show_bug.cgi?id=37591
--- Comment #6 from Liangent <liang...@gmail.com> 2012-06-14 14:21:53 UTC ---
This is just some note.
mysql> select * from page where page_title='特色条目评选' and page_namespace=4;
+---------+----------------+--------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title | page_restrictions |
page_counter | page_is_redirect | page_is_new | page_random | page_touched
| page_latest | page_len |
+---------+----------------+--------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| 291154 | 4 | 特色条目评选 | | 0 |
1 | 0 | 0.429395508603 | 20120531141052 | 2353742 |
42 |
+---------+----------------+--------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
1 row in set (0.02 sec)
mysql> select * from revision where rev_page=291154 limit 10;
+---------+----------+-------------+------------------------------------------------------------------------------+----------+-----------------+----------------+----------------+-------------+---------+---------------+---------------------------------+
| rev_id | rev_page | rev_text_id | rev_comment
| rev_user | rev_user_text | rev_timestamp
| rev_minor_edit | rev_deleted | rev_len | rev_parent_id | rev_sha1
|
+---------+----------+-------------+------------------------------------------------------------------------------+----------+-----------------+----------------+----------------+-------------+---------+---------------+---------------------------------+
| 1977486 | 291154 | 1955773 |
[[Wikipedia:特色条目评选]]已移动到[[Wikipedia:特色条目候选]] | 23701 | 百家姓之四 |
20060523035902 | 0 | 0 | 42 | 0 |
ek74pn6yc6sdzdk4q0kmxmbhnoa8g02 |
| 2353701 | 291154 | 2317697 | 重定向到[[Wikipedia:特色條目候選]]
| 23701 | 百家姓之四 | 20060802021731 | 1 |
0 | 42 | 1977486 | sk2aazj3a537cmwxq54jox860brntz7 |
| 2353742 | 291154 | 2317736 | 重定向到[[Wikipedia:特色条目候选]]
| 23701 | 百家姓之四 | 20060802022403 | 1 |
0 | 42 | 2353701 | ek74pn6yc6sdzdk4q0kmxmbhnoa8g02 |
+---------+----------+-------------+------------------------------------------------------------------------------+----------+-----------------+----------------+----------------+-------------+---------+---------------+---------------------------------+
3 rows in set (0.04 sec)
mysql>
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
