Page MenuHomePhabricator
Paste P70617

(An Untitled Masterwork)
ActivePublic
Actions

Authored by Krinkle on Oct 29 2024, 2:42 PM.
Tags
None
Referenced Files
F57655971: raw-paste-data.txt
Oct 29 2024, 2:47 PM
F57655967: raw-paste-data.txt
Oct 29 2024, 2:45 PM
F57655956: raw-paste-data.txt
Oct 29 2024, 2:42 PM
Subscribers
None
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT rev_id, rev_page, IFNULL(rev_timestamp,"NULL") FROM revision WHERE rev_id IN (1601,1602,1604);
+--------+----------+------------------------------+
| rev_id | rev_page | IFNULL(rev_timestamp,"NULL") |
+--------+----------+------------------------------+
| 1601 | 1 | |
| 1602 | 2 | |
| 1604 | 4 | |
+--------+----------+------------------------------+
3 rows in set (0.004 sec)
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT rev_id, rev_page, LENGTH(rev_timestamp) FROM revision WHERE rev_id IN (1601,1602,1604);
+--------+----------+-----------------------+
| rev_id | rev_page | LENGTH(rev_timestamp) |
+--------+----------+-----------------------+
| 1601 | 1 | 14 |
| 1602 | 2 | 14 |
| 1604 | 4 | 14 |
+--------+----------+-----------------------+
3 rows in set (0.001 sec)
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT * FROM revision WHERE rev_id IN (1601,1602,1604);
+--------+----------+----------------+-----------+----------------+----------------+-------------+---------+---------------+---------------------------------+
| rev_id | rev_page | rev_comment_id | rev_actor | rev_timestamp | rev_minor_edit | rev_deleted | rev_len | rev_parent_id | rev_sha1 |
+--------+----------+----------------+-----------+----------------+----------------+-------------+---------+---------------+---------------------------------+
| 1601 | 1 | 1 | 5991 | | 0 | 0 | 99 | 0 | fxcniwluwrblgtxe0muu3t7lvnvchwo |
| 1602 | 2 | 1 | 5991 | | 0 | 0 | 95 | 0 | 7rxhihs6cnjzfs170c73g5b4dshvimd |
| 1604 | 4 | 1 | 5991 | | 0 | 0 | 210 | 0 | tpm52lb9y72zcb04wi92adguyw0dc40 |
+--------+----------+----------------+-----------+----------------+----------------+-------------+---------+---------------+---------------------------------+
3 rows in set (0.001 sec)
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT * FROM actor WHERE actor_id=5991 LIMIT 2;
+----------+------------+------------+
| actor_id | actor_user | actor_name |
+----------+------------+------------+
| 5991 | NULL | |
+----------+------------+------------+
1 row in set (0.000 sec)
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT rev_id,rev_page,rev_actor,rev_timestamp,rev_deleted,rev_len,rev_parent_id FROM revision WHERE rev_page IN (1,2,4);
+--------+----------+-----------+----------------+-------------+---------+---------------+
| rev_id | rev_page | rev_actor | rev_timestamp | rev_deleted | rev_len | rev_parent_id |
+--------+----------+-----------+----------------+-------------+---------+---------------+
| 1601 | 1 | 5991 | | 0 | 99 | 0 |
| 1602 | 2 | 5991 | | 0 | 95 | 0 |
| 1604 | 4 | 5991 | | 0 | 210 | 0 |
+--------+----------+-----------+----------------+-------------+---------+---------------+
3 rows in set (0.001 sec)
wikiadmin2023@10.64.48.160(chrwiktionary)> SELECT * FROM page where page_id in(1,2,4);
+---------+----------------+--------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| page_id | page_namespace | page_title | page_is_redirect | page_is_new | page_random | page_touched | page_links_updated | page_latest | page_len | page_content_model | page_lang |
+---------+----------------+--------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+
| 1 | 4 | Upload_log | 0 | 0 | 0.500487452839024 | 20240804133149 | 20240804133148 | 1601 | 99 | wikitext | NULL |
| 2 | 4 | Deletion_log | 0 | 0 | 0.727492747574572 | 20230516193637 | 20230516193637 | 1602 | 96 | wikitext | NULL |
| 4 | 4 | Block_log | 0 | 0 | 0.497528838457101 | 20240805163710 | 20240805163709 | 1604 | 210 | wikitext | NULL |
+---------+----------------+--------------+------------------+-------------+-------------------+----------------+--------------------+-------------+----------+--------------------+-----------+
3 rows in set (0.001 sec)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits