User:Ktin/sandbox/adhoc queries

Scenario 1: Institute a holding pattern
''Note: An extremely conservative approach has been used here for this simulation. For the purposes of this simulation, specifically to calculate the revised 'in time', I have taken the time that the next timestamp when an RD post was made by an Admin after 24 hours (even if is 48 hours after). In reality, the scenario will smoothen out closer to 24 hours, since at least one admin will login in on a given day. Unlikely that you will have a day when not a single Admin will log in / post to main page.''

Scenario 2: Spill over to maximize row 2 / row 3
Work in progress

Request
, tweaked your query -- but, is that what you are looking for? Ktin (talk) 02:56, 30 January 2021 (UTC)
 * I forgot to include type in the result set, nice catch. Yes that's it exactly. Over 50% of the total views for that article come from external sources, just over 10% from the main page. Cheers --LaserLegs (talk) 11:42, 30 January 2021 (UTC)