User:SD0001/db-sandbox3
{{database report
|sql = SELECT page_namespace, page_title from page WHERE page_random > 0.65 limit 50
|postprocess_js =
async function postprocess(rows) {
const result = await bot.api({
"format": "json",
"prop": "revisions",
"titles": "Main Page",
"formatversion": "2"
});
const user = result.query.pages[0].revisions[0].user;
const restData = await bot.request('https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia.org/all-access/all-agents/Main%20Page/daily/20240531/20240531');
log(restData);
rows.forEach(row => {
row.title = row.page_title.replace(/_/g, ' ');
row.user = user;
row.random = Math.random();
row.views = restData.items[0].views;
delete row.page_namespace;
delete row.page_title;
});
return rows;
}
}}
| class="wikitable sortable" style="overflow-wrap: anywhere" |
| scope="col" | title
! scope="col" | user ! scope="col" | random ! scope="col" | views |
|---|
| Sakura Asagi
| Floquenbeam | 0.13118279351429174 | 10442149 |
| Joao Guilherme Garcia
| Floquenbeam | 0.2582751237255705 | 10442149 |
| 76.229.170.189
| Floquenbeam | 0.5276150575856888 | 10442149 |
| 67.155.20.10
| Floquenbeam | 0.9239982559899054 | 10442149 |
| Razanandrongobe
| Floquenbeam | 0.1324832786062371 | 10442149 |
| Haka
| Floquenbeam | 0.9903881777631234 | 10442149 |
| Holtbert
| Floquenbeam | 0.8737589138595252 | 10442149 |
| Moscopole/Archive 2
| Floquenbeam | 0.17502487400407563 | 10442149 |
| 109.154.217.8
| Floquenbeam | 0.21645578929946052 | 10442149 |
| Melodi Grand Prix 2023
| Floquenbeam | 0.6349635986466582 | 10442149 |
| Trevor Tarambwa/sandbox
| Floquenbeam | 0.5906661761999894 | 10442149 |
| 112.198.243.90
| Floquenbeam | 0.795068143955294 | 10442149 |
| Nair Bello Sousa Francisco
| Floquenbeam | 0.26556266810751805 | 10442149 |
| Waitin for You
| Floquenbeam | 0.32460568631973064 | 10442149 |
| Reference desk/Archives/Computing/2015 February 18
| Floquenbeam | 0.11773670406779457 | 10442149 |
| Articles for deletion/Prakash Shrestha
| Floquenbeam | 0.8174452318318404 | 10442149 |
| Froggattisca pulchella
| Floquenbeam | 0.29764121926150455 | 10442149 |
| Cody (Joyce Manor album)
| Floquenbeam | 0.7384166868842983 | 10442149 |
| Solder-joint fatigue failure
| Floquenbeam | 0.24231300465651207 | 10442149 |
| Amicable/Templates
| Floquenbeam | 0.27667352828674896 | 10442149 |
| 1967–68 NCAA Division I men's ice hockey season
| Floquenbeam | 0.8884593973307726 | 10442149 |
| Country data templates of political parties
| Floquenbeam | 0.11982795365356314 | 10442149 |
| Asia/Dubai
| Floquenbeam | 0.04050743184387251 | 10442149 |
| Chencinderella
| Floquenbeam | 0.014973651222822904 | 10442149 |
| 122.106.150.58
| Floquenbeam | 0.7709957122935733 | 10442149 |
| Pentimal
| Floquenbeam | 0.4254833061253547 | 10442149 |
| Waheed Al Taweela
| Floquenbeam | 0.28442715173130595 | 10442149 |
| 128.230.41.78
| Floquenbeam | 0.47730521766959644 | 10442149 |
| William Noye of Paul
| Floquenbeam | 0.027179742271545626 | 10442149 |
| ClueBot III/Indices/Talk:Islamic Development Bank
| Floquenbeam | 0.8833220744940571 | 10442149 |
| Ottnang am Hausruck
| Floquenbeam | 0.1475457852099602 | 10442149 |
| The Polytechnic, Ibadan
| Floquenbeam | 0.5065311520748976 | 10442149 |
| Xương Lâm
| Floquenbeam | 0.6314817693802373 | 10442149 |
| Tristan Thomas
| Floquenbeam | 0.09424498311395868 | 10442149 |
| Radioisotope thermoelectric generator
| Floquenbeam | 0.19591111488965152 | 10442149 |
| Current events/2022 August 14
| Floquenbeam | 0.06520572058443075 | 10442149 |
| Art of Fingerstyle Jazz Guitar.jpg
| Floquenbeam | 0.43341878633316844 | 10442149 |
| Steve Vair
| Floquenbeam | 0.8325460755228882 | 10442149 |
| 121.54.32.166
| Floquenbeam | 0.26373219133276304 | 10442149 |
| Cuautlancingo (municipality)
| Floquenbeam | 0.10600668820783432 | 10442149 |
| Fretful Hedgehog
| Floquenbeam | 0.23605387136666733 | 10442149 |
| Kyrgyzstani parliamentary election, 2010
| Floquenbeam | 0.34221022615067365 | 10442149 |
| Mattyat
| Floquenbeam | 0.476145514318957 | 10442149 |
| Latvian mythology
| Floquenbeam | 0.1517072956374359 | 10442149 |
| 45.118.66.115
| Floquenbeam | 0.5773625136294969 | 10442149 |
| Stanley Haynes
| Floquenbeam | 0.6970704828475018 | 10442149 |
| People from Cumberland County, Kentucky
| Floquenbeam | 0.8705397841523606 | 10442149 |
| Pace Airlines logo.png
| Floquenbeam | 0.11967962330507076 | 10442149 |
| 2000 du Maurier Open – Women's Singles
| Floquenbeam | 0.6828967848174583 | 10442149 |
| Sgf4215
| Floquenbeam | 0.523798610271017 | 10442149 |
----
{{Database report/footer|count=50|query_runtime=0.08|last_updated=05:45, 22 June 2025 (UTC)}}
{{database report end}}