Re: Pending Move
08-06-2017, 10:04 AM (This post was last modified: 03-29-2019, 02:28 PM by Bob Schroeck.)
08-06-2017, 10:04 AM (This post was last modified: 03-29-2019, 02:28 PM by Bob Schroeck.)
I can find a way to sort by last post!
sqlite> select date(max(utime), 'unixepoch', 'localtime'), author FROM posts GROUP BY author ORDER BY max(utime, 0);
That's 88 users who have posted in this calendar year.-- ?×V
sqlite> select date(max(utime), 'unixepoch', 'localtime'), author FROM posts GROUP BY author ORDER BY max(utime, 0);
| 2003-03-03 | Oathsblood |
| 2003-06-15 | Trodamus |
| 2003-11-14 | the kwp |
| 2004-03-12 | ro |
| 2004-04-08 | The StarWolf |
| 2004-04-14 | Ed Becerra |
| 2004-04-14 | Skitz Warriors Alpha |
| 2005-07-28 | Sukael |
| 2005-07-31 | Harlequin |
| 2005-09-27 | SKJAM |
| 2005-09-30 | Druid |
| 2005-10-09 | Bakadring |
| 2005-10-22 | Tsubomi Koneko |
| 2006-01-17 | Morgan Champion |
| 2006-01-21 | NeoRavenK7 |
| 2006-02-15 | vitruvian |
| 2006-03-08 | Vialeh |
| 2006-03-08 | Crescend |
| 2006-03-20 | Cloakgrey |
| 2006-07-31 | Moonsword |
| 2006-08-15 | Loki Laufeyjarson |
| 2006-09-12 | Luca Nicolai |
| 2006-09-23 | Koryimran |
| 2006-09-29 | mrfix186 |
| 2006-10-10 | Gaean Conspiracy |
| 2006-11-11 | Custos Sophiae |
| 2006-11-14 | Aegis Sanctuary |
| 2006-12-04 | Sonic4997v3 |
| 2007-02-18 | Piccolo181 |
| 2007-05-12 | anonymous coward |
| 2007-06-26 | Alaeth |
| 2007-07-10 | blob |
| 2007-08-20 | Periwinkle Skyye |
| 2007-09-04 | Vangeek |
| 2007-09-07 | Kheram Coldstar |
| 2007-09-08 | Joe Littrell |
| 2007-10-21 | ejheckathorn |
| 2007-12-09 | cpt kangarooski |
| 2007-12-13 | Anpwhotep |
| 2007-12-14 | Cernig |
| 2007-12-25 | Chibi Konatsu |
| 2007-12-25 | Offsides |
| 2008-01-07 | Grahorn |
| 2008-03-13 | crimsonsun |
| 2008-03-18 | Dragonflight |
| 2008-03-19 | Elizabeth McCoy |
| 2008-04-07 | Texarcanum |
| 2008-04-08 | williath |
| 2008-05-03 | Jeap |
| 2008-05-12 | Aleh |
| 2008-05-15 | A117 |
| 2008-07-25 | ElectroEagle |
| 2008-08-06 | wxnut |
| 2008-09-02 | Kaze no Ryuu |
| 2008-09-07 | Ravynlocke |
| 2008-09-20 | AbyssalDaemon |
| 2008-11-12 | Wetter Hexe |
| 2009-03-29 | madmatt85 |
| 2009-04-03 | Feinan |
| 2009-04-25 | yjk |
| 2009-05-06 | Murmur the Fallen |
| 2009-05-23 | ariel silverstorm |
| 2009-05-25 | Dynamistress |
| 2009-06-06 | Elsa Bibat |
| 2009-06-19 | RMH |
| 2009-06-20 | Xenoproctologist |
| 2009-06-30 | Kyoumen |
| 2009-07-06 | HDTrio |
| 2009-07-10 | ladyday |
| 2009-07-13 | Hollow49 |
| 2009-07-28 | Hotpoint |
| 2009-09-24 | jmucchiello |
| 2009-10-15 | Sybylloura |
| 2009-10-18 | yumekochan |
| 2009-11-03 | Freddy Isnot |
| 2009-11-21 | Shinkaze |
| 2010-01-07 | Mekadave |
| 2010-01-09 | LantisEscudo |
| 2010-02-09 | Render |
| 2010-02-18 | Shirei |
| 2010-03-31 | Vyperpunk |
| 2010-05-10 | Balentius |
| 2010-06-07 | Lord Aries Greymon |
| 2010-07-07 | SpecialistsShawn |
| 2010-09-23 | Jonas |
| 2010-09-30 | ZeonicFreak |
| 2010-10-11 | Wolff |
| 2010-10-24 | DKnight54 |
| 2010-11-03 | Jeanne Hedge |
| 2010-11-10 | sam vere |
| 2010-11-30 | Fenian |
| 2011-04-06 | Reynold Hughes |
| 2011-04-11 | ScottMichaelHarris |
| 2011-05-05 | al103 |
| 2011-05-20 | NotDavies |
| 2011-07-10 | Ayiekie |
| 2011-07-21 | rmthorn |
| 2011-07-22 | Epsilon |
| 2011-08-05 | darkreader |
| 2011-08-06 | Fidoohki |
| 2011-08-15 | Kat Sinclaire |
| 2011-08-17 | New Hampshire Battleship Lover |
| 2011-09-17 | Lord Svengali |
| 2011-12-26 | Starbolt13 |
| 2012-02-25 | Weaver |
| 2012-02-28 | MechaDeuce |
| 2012-03-20 | Kokuten |
| 2012-05-18 | The Hunterminator |
| 2012-05-29 | SCM Writer of 2814 |
| 2012-06-17 | SilverSun17 |
| 2012-06-19 | Gantithoren |
| 2012-06-23 | Dragyn |
| 2012-07-10 | HendrikBoom |
| 2012-07-29 | Salvage |
| 2012-08-14 | AdmiralTigerclaw |
| 2012-08-14 | KaiserDrgn |
| 2012-08-18 | Warringer |
| 2012-08-31 | alaskanime |
| 2012-09-01 | Wiredgeek |
| 2012-09-01 | Neko Hibiki |
| 2012-09-02 | Ferfer |
| 2012-09-03 | Zilem Kain |
| 2012-09-04 | madmageknight |
| 2012-09-09 | Evil Midnight Lurker |
| 2012-10-06 | Vincent Ursus |
| 2012-10-07 | Ace Dreamer |
| 2012-10-19 | Tiroth |
| 2012-11-10 | HoagieOfDoom |
| 2012-11-24 | His Lovely Wife |
| 2012-11-28 | Rakhasa |
| 2012-12-03 | ArachnosX |
| 2012-12-13 | Lordpanther14 |
| 2013-01-25 | KJ |
| 2013-02-14 | sparkthatbled |
| 2013-02-19 | murmur |
| 2013-03-09 | RomanFanboy |
| 2013-03-10 | trboturtle |
| 2013-03-30 | Reyemile |
| 2013-05-06 | Pyeknu.e |
| 2013-05-17 | bmull |
| 2013-05-26 | Unicorna |
| 2013-07-20 | Kurisu |
| 2013-07-31 | GreggHL |
| 2013-08-24 | Griever |
| 2013-09-01 | Asta Kask |
| 2013-09-21 | Glidergun |
| 2013-09-21 | Irascor |
| 2013-10-10 | kentmagus |
| 2013-10-15 | richardson |
| 2013-10-22 | Gold And Appel Inc |
| 2013-11-21 | anowack |
| 2013-11-21 | Ranchoth |
| 2013-12-08 | Ransan |
| 2014-01-23 | Rusco Ducam |
| 2014-03-13 | nylor |
| 2014-04-19 | DaemeonX |
| 2014-04-26 | Talienas |
| 2014-04-28 | CrimsonKMR |
| 2014-05-21 | stormcloud |
| 2014-05-21 | nick012000 |
| 2014-06-09 | kashim27 |
| 2014-07-07 | Thesilentjackofalltrade |
| 2014-08-02 | kevncody |
| 2014-08-31 | The Dragonic Saint |
| 2014-09-14 | zero sum mgame |
| 2014-10-16 | KellLogo |
| 2014-10-24 | CattyNebulart |
| 2014-11-19 | Baseload |
| 2014-12-01 | Merior |
| 2014-12-24 | DreadnaughtVV |
| 2015-01-03 | Judah |
| 2015-02-03 | Angryoptimist |
| 2015-02-06 | The Wanderer |
| 2015-02-12 | skychan |
| 2015-02-18 | Mark Skarr |
| 2015-03-15 | aeroprime |
| 2015-03-16 | Baldo |
| 2015-04-29 | Necratoid |
| 2015-05-04 | Scrambler |
| 2015-05-23 | MarqFJA87 |
| 2015-06-09 | Silverex |
| 2015-06-11 | sweno |
| 2015-06-26 | RustedPantheress |
| 2015-07-10 | MicroHue |
| 2015-07-14 | Honorbridge |
| 2015-07-26 | shaderic |
| 2015-08-25 | HRogge |
| 2015-08-28 | trantos |
| 2015-08-29 | BYapes |
| 2015-09-13 | Guilherme Loureiro |
| 2015-10-09 | BLHarrison |
| 2015-10-12 | gamlain |
| 2015-11-03 | Terrenceknight |
| 2015-11-25 | OpMegs |
| 2015-11-25 | Vulpis |
| 2015-12-25 | Jenova Silverstar |
| 2015-12-29 | Caligostro |
| 2016-01-01 | Jervic |
| 2016-01-08 | dark seraph |
| 2016-01-08 | ckosacranoid |
| 2016-02-03 | cleverwings |
| 2016-02-10 | paladindythe |
| 2016-03-10 | Ross Van Loan |
| 2016-04-21 | gubaba |
| 2016-05-16 | DRAG0NFLIGHT |
| 2016-06-06 | Sofaspud |
| 2016-06-07 | Florin |
| 2016-06-07 | s3yang |
| 2016-06-20 | Shay Guy |
| 2016-07-01 | Bluemage |
| 2016-07-20 | ShinDangaioh |
| 2016-07-21 | DocMui |
| 2016-07-26 | PrinceCharon |
| 2016-08-21 | Davies |
| 2016-09-02 | Terrace |
| 2016-09-03 | CapBoulanger |
| 2016-09-07 | Another Troper |
| 2016-09-10 | WengFook |
| 2016-09-24 | Sirrocco |
| 2016-09-28 | Scarman |
| 2016-10-25 | Bloodfox64 |
| 2016-11-09 | InsaneTD |
| 2016-11-10 | yesilmavi |
| 2016-11-26 | Guest |
| 2016-12-03 | Seraviel |
| 2016-12-08 | TvT Rivals |
| 2016-12-18 | Valles |
| 2017-01-06 | Darwithe |
| 2017-01-10 | Dakota |
| 2017-01-12 | Threepony |
| 2017-01-23 | Lubaf |
| 2017-02-04 | travelerayga |
| 2017-02-04 | jpub |
| 2017-02-16 | Stephen Mann |
| 2017-02-19 | hmelton |
| 2017-02-22 | David Lewis |
| 2017-03-11 | Drenivian |
| 2017-03-14 | Proginoskes |
| 2017-04-06 | KindelR |
| 2017-04-14 | Last Free Human |
| 2017-04-15 | Acyl |
| 2017-04-19 | NDKilla |
| 2017-04-22 | jqavins |
| 2017-04-22 | Rod H |
| 2017-04-24 | NifT |
| 2017-04-27 | chibipoe |
| 2017-05-04 | happerry |
| 2017-05-10 | khagler |
| 2017-05-16 | Spoilsport |
| 2017-05-21 | nemonowan |
| 2017-05-22 | kestrel404 |
| 2017-06-01 | SkyeFire |
| 2017-06-02 | Berk |
| 2017-06-02 | tjalorak |
| 2017-06-06 | werehawk |
| 2017-06-10 | Rihtan |
| 2017-06-13 | JakeGrey |
| 2017-07-02 | Duane Peters |
| 2017-07-03 | Foxboy |
| 2017-07-03 | Jorlem |
| 2017-07-04 | Azunth |
| 2017-07-06 | Tennie |
| 2017-07-07 | drakensis |
| 2017-07-07 | LilFluff |
| 2017-07-08 | Zojojojo |
| 2017-07-08 | VladimirTherin |
| 2017-07-08 | BronzeSpider |
| 2017-07-12 | M Fnord |
| 2017-07-14 | Firvulag |
| 2017-07-14 | carpenter3 |
| 2017-07-16 | K sai |
| 2017-07-16 | azunth! |
| 2017-07-17 | RMH999 |
| 2017-07-22 | nocarename |
| 2017-07-22 | Rev Dark |
| 2017-07-24 | Soutern Cross |
| 2017-07-24 | hysteriumredux |
| 2017-07-25 | SilverFang01 |
| 2017-07-25 | Kilroy |
| 2017-07-26 | GethN7 |
| 2017-07-26 | TheTwisted1 |
| 2017-07-26 | ClassicDrogn |
| 2017-07-26 | Pyeknu |
| 2017-07-27 | Jinx999 |
| 2017-07-27 | Reception123 |
| 2017-07-28 | Ankhani |
| 2017-07-28 | DeputyJones |
| 2017-07-28 | JFerio |
| 2017-07-28 | Star Ranger4 |
| 2017-07-28 | ordnance11 |
| 2017-07-29 | Morganite |
| 2017-07-29 | Rajvik |
| 2017-07-29 | LulzKiller |
| 2017-07-29 | skyfire2020 |
| 2017-07-30 | ECSNorway |
| 2017-07-30 | Labster |
| 2017-07-30 | jonathanlennox |
| 2017-07-31 | Matrix Dragon |
| 2017-07-31 | Ebony |
| 2017-07-31 | Mamorien |
| 2017-07-31 | Cobalt Greywalker |
| 2017-08-01 | drogan niteflier |
| 2017-08-01 | Timote |
| 2017-08-01 | Herr Bad Moon |
| 2017-08-01 | Hazard |
| 2017-08-01 | Black Aeronaut |
| 2017-08-01 | Deadpan29 |
| 2017-08-01 | Manytales00 |
| 2017-08-01 | Dartz |
| 2017-08-01 | Shepherd |
| 2017-08-01 | DHBirr |
| 2017-08-01 | batzulger |
| 2017-08-01 | Inquisitive Raven |
| 2017-08-01 | Bob Schroeck |
| 2017-08-02 | robkelk |
That's 88 users who have posted in this calendar year.-- ?×V