Wikipedia:Database reports/Fully salted titles with unusually long expiries
{{Database report
|sql =
SELECT
ROW_NUMBER() OVER(ORDER BY (SELECT 1)) AS "No.",
pt_title AS "Page",
user_name AS "Protecting admin",
DATE_FORMAT(pt_timestamp, '%Y-%m-%d') AS "Date of protection",
DATE_FORMAT(pt_expiry, '%Y-%m-%d') AS "Date of expiry",
comment_text AS "Reason",
pt_namespace
FROM protected_titles
JOIN comment_protected_titles ON comment_id = pt_reason_id
JOIN user on user_id = pt_user
WHERE pt_expiry >= DATE_FORMAT(NOW() + INTERVAL 1 YEAR, '%Y%m%d%H%i%S') AND pt_expiry != 'infinity'
AND pt_create_perm = 'sysop'
|wikilinks = 2:c7:show, 3:2
|hide = 7
|comments = 6
|interval = 14
}}
| class="wikitable sortable" style="overflow-wrap: anywhere" |
| scope="col" | No.
! scope="col" | Page ! scope="col" | Protecting admin ! scope="col" | Date of protection ! scope="col" | Date of expiry ! scope="col" | Reason |
|---|
| 1
| 2027 Formula One World Championship | Explicit | 2024-12-24 | 2026-12-24 |
| 2
| 2029 Women's Cricket World Cup | Pppery | 2025-02-26 | 2028-01-01 | Salt until closer to the event |
| 3
| 2011-06-29 | 2026-06-29 |
| 4
| 2011-06-30 | 2031-06-30 |
| 5
| 2011-06-29 | 2031-06-29 |
| 6
| Tavix | 2018-05-21 | 2035-05-21 |
| 7
| Adrenaline Rush (professional wrestling) | 2023-08-15 | 2028-08-15 | |
| 8
| 2023-06-20 | 2028-06-20 |
| 9
| 2023-02-18 | 2028-02-18 | |
| 10
| 2024-05-22 | 2027-05-09 | Repeatedly recreated - increase protection |
| 11
| Daniel Larze (Fil-Puerto Rican Singer) | 2024-11-18 | 2029-11-18 |
| 12
| 2023-02-18 | 2028-02-18 | |
| 13
| Gwenesis | 2024-10-26 | 2026-10-26 |
| 14
| 2017-10-09 | 2027-10-09 | Repeatedly recreated: Per Wikipedia:Articles for deletion/Infinite Computer Solutions (3rd nomination) |
| 15
| 2017-07-19 | 2027-07-19 | Per Wikipedia:Articles for deletion/Marcel Saucet (2nd nomination) |
| 16
| 2023-03-24 | 2028-03-24 |
| 17
| 2024-08-19 | 2029-08-19 |
| 18
| 2024-08-19 | 2029-08-19 |
| 19
| Muhammad Ryan Pamuji Setyawan | 2023-02-23 | 2028-02-23 | Repeatedly recreated: Wikipedia:Articles for deletion/Ryan Oris (2nd nomination) |
| 20
| 2022-08-21 | 2027-08-21 |
| 21
| 2023-08-15 | 2028-08-15 |
| 22
| 2024-08-19 | 2029-08-19 |
| 23
| Talk:2027 Formula One World Championship | Explicit | 2024-12-24 | 2026-12-24 |
| 24
| MBisanz | 2008-05-28 | 2028-05-28 | per past arbcom rulings |
| 25
| MBisanz | 2008-07-07 | 2028-07-07 | |
| 26
| MBisanz | 2008-05-12 | 2028-05-12 | |
| 27
| MBisanz | 2008-05-12 | 2028-05-12 | |
| 28
| User talk:Bsscq1w2e3r4t5y6u7i8o9p0 | MBisanz | 2008-05-02 | 2028-05-02 | grawp |
| 29
| User talk:Gdghdgncfnfgfgfffhfhfhfhfhfh | MBisanz | 2008-05-02 | 2028-05-02 | grawp |
| 30
| MBisanz | 2008-07-07 | 2028-07-07 | |
| 31
| MBisanz | 2008-05-12 | 2028-05-12 | |
| 32
| User talk:Point\of No Return 818 | MBisanz | 2008-07-07 | 2028-07-07 | |
| 33
| User talk:Sophisticated encryption | MBisanz | 2008-08-29 | 2028-08-29 | |
| 34
| MBisanz | 2008-05-02 | 2028-05-02 | grawp |
| 35
| MBisanz | 2008-05-02 | 2028-05-02 | grawp |
| 36
| Wikipedia:Usama Fareed Dairvi | 2023-04-03 | 2028-01-01 | random ego page, see user's deleted contributions and their talk page |
| 37
| Explicit | 2025-05-29 | 2030-05-29 |
----
{{Database report/footer|count=37|query_runtime=0.13|last_updated=05:25, 22 June 2025 (UTC)}}
{{Database report end}}