Suche Links - Quarry

This query is marked as a draft This query has been published by Habitator terrae.
SQL

USE dewiki_p;

SELECT "[[Spezial:Diff/"+revision_userindex.rev_id+"]]" AS diff
FROM externallinks, revision_userindex, page
WHERE page.page_namespace=0
AND revision_userindex.rev_timestamp BETWEEN TIMESTAMP("2020-07-20", "00:00:00") AND TIMESTAMP("2020-07-23", "00:00:00")
AND revision_userindex.rev_page=page.page_id
AND externallinks.el_from = page.page_id
AND ABS(IF(revision_userindex.rev_id<169614672,1.02321*(revision_userindex.rev_id-169115166)+60082762,IF(revision_userindex.rev_id<169806755,.5913*(revision_userindex.rev_id-169614672)+60593863,IF(revision_userindex.rev_id<170849600,.43565*(revision_userindex.rev_id-169806755)+60707441,IF(revision_userindex.rev_id<171050900,.56422*(revision_userindex.rev_id-170849600)+61161753,IF(revision_userindex.rev_id<171432627,.59507*(revision_userindex.rev_id-171050900)+61275331,IF(revision_userindex.rev_id<171888256,.37392*(revision_userindex.rev_id-171432627)+61502487,IF(revision_userindex.rev_id<172131433,.46706*(revision_userindex.rev_id-171888256)+61672854,IF(revision_userindex.rev_id<172511282,.74752*(revision_userindex.rev_id-172131433)+61786432,IF(revision_userindex.rev_id<173768888,.67735*(revision_userindex.rev_id-172511282)+62070377,IF(revision_userindex.rev_id<174193657,.66847*(revision_userindex.rev_id-173768888)+62922212,IF(revision_userindex.rev_id<174737854,.41742*(revision_userindex.rev_id-174193657)+63206157,IF(revision_userindex.rev_id<174820318,.68865*(revision_userindex.rev_id-174737854)+63433313,IF(revision_userindex.rev_id<175009596,.90009*(revision_userindex.rev_id-174820318)+63490102,IF(revision_userindex.rev_id<175463957,1.56549*(revision_userindex.rev_id-175009596)+63660469,IF(revision_userindex.rev_id<175520965,.69296*(revision_userindex.rev_id-175463957)+64371768,IF(revision_userindex.rev_id<175579480,7.08864*(revision_userindex.rev_id-175520965)+64411272,IF(revision_userindex.rev_id<175644983,.30154*(revision_userindex.rev_id-175579480)+64826064,IF(revision_userindex.rev_id<175688104,.68709*(revision_userindex.rev_id-175644983)+64845816,IF(revision_userindex.rev_id<176213010,9.47794*(revision_userindex.rev_id-175688104)+64875444,IF(revision_userindex.rev_id<176284844,25.29788*(revision_userindex.rev_id-176213010)+69850470,IF(revision_userindex.rev_id<176920035,.71524*(revision_userindex.rev_id-176284844)+71667718,IF(revision_userindex.rev_id<177265116,.4937*(revision_userindex.rev_id-176920035)+72122030,IF(revision_userindex.rev_id<177690960,.40007*(revision_userindex.rev_id-177265116)+72292397,IF(revision_userindex.rev_id<178373911,1.03744*(revision_userindex.rev_id-177690960)+72462764,IF(revision_userindex.rev_id<179362072,.65963*(revision_userindex.rev_id-178373911)+73171284,IF(revision_userindex.rev_id<180093639,.44549*(revision_userindex.rev_id-179362072)+73823100,IF(revision_userindex.rev_id<180678984,.48929*(revision_userindex.rev_id-180093639)+74149008,IF(revision_userindex.rev_id<181614727,.83378*(revision_userindex.rev_id-180678984)+74435412,IF(revision_userindex.rev_id<182116475,.51214*(revision_userindex.rev_id-181614727)+75215616,IF(revision_userindex.rev_id<183304840,2.15228*(revision_userindex.rev_id-182116475)+75472581,IF(revision_userindex.rev_id<183379546,1.32198*(revision_userindex.rev_id-183304840)+78030276,IF(revision_userindex.rev_id<183395705,.78148*(revision_userindex.rev_id-183379546)+78129036,IF(revision_userindex.rev_id<183705304,.661*(revision_userindex.rev_id-183395705)+78141664,IF(revision_userindex.rev_id<184481750,.55966*(revision_userindex.rev_id-183705304)+78346308,IF(revision_userindex.rev_id<185021610,.60428*(revision_userindex.rev_id-184481750)+78780852,IF(revision_userindex.rev_id<185886744,.7877*(revision_userindex.rev_id-185021610)+79107077,IF(revision_userindex.rev_id<186379310,.57646*(revision_userindex.rev_id-185886744)+79788545,IF(revision_userindex.rev_id<187285396,.62675*(revision_userindex.rev_id-186379310)+80072490,IF(revision_userindex.rev_id<187745924,1.23313*(revision_userindex.rev_id-187285396)+80640380,IF(revision_userindex.rev_id<187906886,1.05843*(revision_userindex.rev_id-187745924)+81208270,IF(revision_userindex.rev_id<188089339,.93376*(revision_userindex.rev_id-187906886)+81378637,IF(revision_userindex.rev_id<188681410,1.34282*(revision_userindex.rev_id-188089339)+81549004,IF(revision_userindex.rev_id<188829590,1.53297*(revision_userindex.rev_id-188681410)+82344050,IF(revision_userindex.rev_id<190201290,.70381*(revision_userindex.rev_id-188829590)+82571206,IF(revision_userindex.rev_id<191406497,.51832*(revision_userindex.rev_id-190201290)+83536619,IF(revision_userindex.rev_id<192772239,.6653*(revision_userindex.rev_id-191406497)+84161298,IF(revision_userindex.rev_id<193634803,1.31675*(revision_userindex.rev_id-192772239)+85069922,IF(revision_userindex.rev_id<195341586,.63218*(revision_userindex.rev_id-193634803)+86205702,IF(revision_userindex.rev_id<196912416,.57844*(revision_userindex.rev_id-195341586)+87284693,IF(revision_userindex.rev_id<197625410,1.27438*(revision_userindex.rev_id-196912416)+88193317,IF(revision_userindex.rev_id<198563089,.60563*(revision_userindex.rev_id-197625410)+89101941,IF(revision_userindex.rev_id<198714368,.39399*(revision_userindex.rev_id-198563089)+89669831,IF(revision_userindex.rev_id<199053912,.83612*(revision_userindex.rev_id-198714368)+89729434,IF(revision_userindex.rev_id<200130117,1.83603*(revision_userindex.rev_id-199053912)+90013334,IF(revision_userindex.rev_id<200707774,2.3099*(revision_userindex.rev_id-200130117)+91989278,IF(revision_userindex.rev_id<200950716,3.38892*(revision_userindex.rev_id-200707774)+93323608,IF(revision_userindex.rev_id<201045051,.66209*(revision_userindex.rev_id-200950716)+94146918,IF(revision_userindex.rev_id<201497974,.63935*(revision_userindex.rev_id-201045051)+94209376,IF(revision_userindex.rev_id<201711615,2.91433*(revision_userindex.rev_id-201497974)+94498954,IF(revision_userindex.rev_id<201921798,.63066*(revision_userindex.rev_id-201711615)+95121575,.63211*(revision_userindex.rev_id-201921798)+95254128))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))-externallinks.el_id)<1600000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
