Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.os.linux.advocacy > #467407
| From | "F. Russell" <fr@random.info> |
|---|---|
| Newsgroups | comp.os.linux.advocacy |
| Subject | Re: a little bit closer |
| Date | 2018-09-16 20:39 +0000 |
| Organization | NewsGuy.com |
| Message-ID | <pnmf2d01om5@news4.newsguy.com> (permalink) |
| References | <px900ab.3agah383@rooftop.invalid> <TkfnD.41344$sO2.30293@fx41.iad> <XtfnD.101540$Ac3.34316@fx45.iad> <9a0b03a.go3@rooftop.invalid> <V0wnD.58326$LK2.45842@fx36.iad> |
On Sun, 16 Sep 2018 13:00:47 -0400, DFS wrote: > > the file USENET.sqlite is now 14GB, containing 2.62M posts in > 4 newsgroups, going back to Jul 2003. > In the sacred name of Jesus Fucking Christ, why in fucking hell are you doing this? Even collecting bottle caps would be far more fascinating as a hobby. Are you planning on opening an on-line freak show or selling to the highest bidder examples of psychotic jibber jabber? And why July 2003? Is everything that was posted before that date lost forever? > I'm definitely going to port the entire db permanently to something > other than SQLite (probably Postgres), but the SQLite query performance > is fine. But it's way slow to make changes to the tables or update > large rowcounts. > > >> Anyway, I suck at SQL, so give me some sample queries to use against >> your usenet db for testing some widgets. > > I sent recent 3000 total posts from cola and comp.lang.c. Unfortunately > I didn't think to remove 'frelwizzen' posts so there are a bunch of them > in there. > > First thing to do is create a 'master view' to see all the data - if you > open table POST most of the data is just system-assigned ID numbers. > > CREATE VIEW V_USENET AS > SELECT > P.POSTID, > NS.SERVERID, > NS.SERVERNAME, > NG.GROUPID, > NG.GROUPNAME, > P.ARTICLEID, > P2A.POSTERID, > P2A.POSTER, > P.UTCDATE, > P.UTCTIME, > M.MSGID, > M.MESSAGEID, > U.USERAGENTID, > U.USERAGENT, > U.USERAGENTMAJOR, > U.OS, > S.SUBJECTID, > S.SUBJECT, > P2B.POSTERID AS REPLY_TO_POSTERID, > P2B.POSTER AS REPLY_TO_POSTER, > P.NEWTHREAD_YN, > P.UNREAD_YN, > P.DTADDED > FROM > POST P, NNTP_SERVER NS, NNTP_GROUP NG, > POSTER P2A, POSTER P2B, MESSAGEID M, > USERAGENT U, SUBJECT S > WHERE > P.SERVERID = NS.SERVERID > AND P.GROUPID = NG.GROUPID > AND P.POSTERID = P2A.POSTERID > AND P.REPLY_TO_POSTERID = P2B.POSTERID > AND P.MSGID = M.MSGID > AND P.USERAGENTID = U.USERAGENTID > AND P.SUBJECTID = S.SUBJECTID > > > explained > P.POSTID, #unique system-assigned ID for the post > NS.SERVERID, #NNTP server ID - system assigned > NS.SERVERNAME, #NNTP server (ie usnews.blocknews.net) > NG.GROUPID, #NNTP newsgroup - system assigned ID > NG.GROUPNAME, #NNTP newsgroup from which article was sourced > P.ARTICLEID, #NNTP article number assigned by news server > P2A.POSTERID, #sent the post - system assigned ID > P2A.POSTER, #value in the From header > P.UTCDATE, #UTC date - converted from Date header > P.UTCTIME, #UTC time - converted from Date header > M.MSGID, #system assigned ID for the message ID > M.MESSAGEID, #messageID from headers > U.USERAGENTID, #system assigned ID for the user agent > U.USERAGENT, #user agent string from headers > U.USERAGENTMAJOR, #parsed out manually or with code > U.OS, #parsed out manually or with code > S.SUBJECTID, #system assigned ID > S.SUBJECT, #header value > P2B.POSTERID AS REPLY_TO_POSTERID, #system assigned ID > P2B.POSTER AS REPLY_TO_POSTER, #poster being replied to > P.NEWTHREAD_YN, #is this a new top-level thread (default N) > P.UNREAD_YN, #has this post been read (default N) > P.DTADDED #date-time stamp row added to table > > > A GUI tool for querying would be helpful. On Windows I use SQLiteStudio > https://imgur.com/a/Ik6T0BL > > > The table POSTER is in the master view twice: once to see the name of > the person who sent the post, and again to see the name of the person > being replied to. > > Once you have that VIEW in place, it's easy to query against. You can > actually use it to populate most of the front-end and the search > results, but it'll be very slow for some things so you want to write > individual queries instead. > > That view of 3000 posts doesn't contain the table POSTERNAMEGROUP, which > will restrict the results to posts made by nyms I considered regs, > either currently or in the past. > > The search option widgets (top to bottom, left to right) are standard: > lists (prefix 'list'), dropdowns (dd), text boxes (txt), option groups > (opt), check boxes (check), and buttons (btn). > > On your form, I'll label them top to bottom left to right: > > Name Source of data > --------------- ---------------------------------- > listPosterName from db - SQL below > ddPosterFrom from db - SQL below > listPeriod hard coded list > listYear hard coded or simple function > ddMonth hard coded 1;Jan;2;Feb;3;Mar;... > ddNewsgroup from db - SQL below > txtDateStart manual entry, or based on choices > txtDateEnd manual entry, or based on choices > ddInReplyTo from db - SQL below > txtMessageID manual entry > ddSearchTerms manual entry > optSearchTerms choose one with mouse > optSubjectBody choose one with mouse > checkNewThreads true/false, choose with mouse > checkUnread true/false, choose with mouse > checkTwoWay true/false, choose with mouse > checkFilterImmed true/false, choose with mouse > listSort hard coded > btnSearch kicks off search code - dynamically build up a > SQL statement based on choices in widgets > btnReset resets search options to default > btnExport kicks off code to export search results > to csv or txt file, etc > --------------- ---------------------------------- > > SQL: > > listPosterName (every poster) > SELECT POSTERID, POSTER > FROM POSTER > ORDER BY LOWER(POSTER); > > listPosterName (regs only) > SELECT P1.POSTERNAMEID, P1.POSTERNAME > FROM POSTERNAME P1, POSTERNAMEGROUP P2 > WHERE P1.POSTERNAMEID = P2.POSTERNAMEID > AND P2.GROUPID = <chosen newsgroup> > ORDER BY LOWER(P1.POSTERNAME); > > ddPosterFrom > SELECT POSTERID, POSTER > FROM POSTER > WHERE POSTERNAMEID = <value chosen in listPosterName - regs only> > ORDER BY POSTER; > > ddNewsgroup > SELECT GROUPID, GROUPNAME, GROUPABBR > FROM NNTP_GROUP > ORDER BY GROUPID; > > ddInReplyTo > same SQL as listPosterName > > > Access lists and dropdowns have ColumnCount, ColumnWidths and > BoundColumn properties, so you never have to see the ID numbers, but you > can easily use them in code. If you can't hide those ID numbers in the > tk front-end it will look funky, but not the end of the world.
Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
a little bit closer owl <owl@rooftop.invalid> - 2018-09-15 16:12 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 12:04 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 18:02 -0400
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 18:11 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 19:22 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-16 11:24 +0000
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-16 13:00 -0400
Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-16 20:39 +0000
Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-16 21:04 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-16 14:33 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 08:55 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-17 09:09 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 10:03 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:01 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 10:20 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:55 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 11:02 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 11:48 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:29 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 13:49 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 14:15 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 17:14 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 14:28 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 19:26 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 16:46 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 21:43 -0400
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 22:03 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 19:11 -0700
(Sub)Threads drift, big time. Jeff-Relf.Me @. - 2018-09-17 20:23 -0700
(Sub)Threads are ReConstructed using _ parents (!GrandParents). Jeff-Relf.Me @. - 2018-09-17 19:29 -0700
Re: (Sub)Threads are ReConstructed using _ parents (!GrandParents). DFS <nospam@nospam.com> - 2018-09-17 23:12 -0400
Re: (Sub)Threads are ReConstructed using _ parents (!GrandParents). Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 20:29 -0700
20 years hard labor, sans food. Jeff-Relf.Me @. - 2018-09-17 21:58 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 14:46 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 19:45 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 19:46 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-17 11:48 -0700
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-17 21:47 +0000
Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-17 22:53 +0000
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 15:57 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:47 -0400
Re: a little bit closer Peter Köhlmann <peter-koehlmann@t-online.de> - 2018-09-16 23:19 +0200
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-16 14:48 -0700
Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-17 11:42 -0500
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:37 -0400
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-17 23:37 +0000
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 21:24 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 18:55 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 13:19 -0400
Re: a little bit closer fr314159@gmail.com - 2018-09-17 10:35 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:31 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 13:59 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 10:52 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-17 12:03 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-17 12:26 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 16:20 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-17 13:42 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-17 22:10 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 19:26 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-17 06:58 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-17 07:28 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-18 22:11 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 19:33 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-19 05:53 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:33 -0400
Re: a little bit closer fr314159@gmail.com - 2018-09-19 06:52 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 11:19 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 08:36 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 12:29 -0700
Re: a little bit closer fr314159@gmail.com - 2018-09-19 08:39 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 09:08 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 13:32 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 09:27 -0400
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 15:01 +0000
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 20:47 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:01 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:18 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 11:41 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-22 11:47 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 12:12 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 00:21 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:02 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:59 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 11:21 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 14:43 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 12:28 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 12:56 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 16:04 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 17:07 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 09:20 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:43 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 14:18 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 19:30 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 16:51 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 20:15 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 17:04 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 09:26 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:58 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 08:56 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 12:33 -0400
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-24 12:44 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 10:54 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 11:39 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 13:13 -0400
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 14:26 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-26 09:00 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-26 19:40 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-28 16:40 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 11:13 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 13:11 -0400
Re: a little bit closer fr314159@gmail.com - 2018-09-24 07:53 -0700
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-24 09:03 -0700
Re: a little bit closer "F. Russell" <fr@random.info> - 2018-09-24 22:32 +0000
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-25 12:04 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 11:25 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 21:05 -0400
Re: a little bit closer Steve Carroll <fretwizzer@gmail.com> - 2018-09-23 10:00 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 10:34 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 22:04 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 15:22 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-20 23:55 -0400
Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-21 04:02 +0000
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-21 06:54 -0400
Re: a little bit closer Mel <mel@zzzzz.com> - 2018-09-21 13:31 +0200
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 04:52 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 16:07 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 10:53 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 04:37 -0700
Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-21 07:24 -0500
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:45 +0000
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:47 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:51 -0700
Re: a little bit closer RonB <ronb02NOSPAM@gmail.com> - 2018-09-22 16:47 +0000
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 20:13 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 13:30 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 16:06 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 17:02 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 17:01 -0700
Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-24 07:33 -0500
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 06:11 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-24 07:54 -0700
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:41 +0000
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:48 -0700
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-22 07:08 -0400
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 14:36 +0000
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:35 -0400
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-23 13:58 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 07:41 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-23 07:47 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-23 10:34 -0400
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-23 07:44 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-23 08:13 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 14:51 +0000
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:39 -0400
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-22 13:43 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 14:01 -0700
Re: a little bit closer RonB <ronb02NOSPAM@gmail.com> - 2018-09-22 16:51 +0000
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-22 20:13 +0000
Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-24 07:45 -0500
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-24 20:51 +0000
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-24 13:55 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-24 14:16 -0700
Re: a little bit closer SilverSlimer <silver@slim.er> - 2018-09-21 12:31 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 06:41 -0700
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:50 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 16:01 +0000
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 10:45 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 11:09 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 22:56 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 08:55 -0400
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 14:51 +0000
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-23 08:42 -0400
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-21 14:03 +0000
Re: a little bit closer Snit <usenet@gallopinginsanity.com> - 2018-09-21 07:38 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 07:44 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-22 03:04 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-21 20:20 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-22 01:01 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-22 09:54 -0400
Re: a little bit closer Chris Ahlstrom <OFeem1987@teleworm.us> - 2018-09-20 14:58 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 12:41 -0700
Re: a little bit closer chrisv <chrisv@nospam.invalid> - 2018-09-19 07:09 -0500
Re: a little bit closer fr314159@gmail.com - 2018-09-19 05:58 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 06:14 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-18 05:31 +0000
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-18 17:12 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 10:44 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 14:06 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-18 23:05 -0400
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 04:17 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 21:54 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-19 09:02 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 06:30 -0700
Re: a little bit closer owl <owl@rooftop.invalid> - 2018-09-19 22:08 +0000
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-19 15:37 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-20 23:59 -0400
Re: a little bit closer Melzzzzz <Melzzzzz@zzzzz.com> - 2018-09-21 04:03 +0000
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-21 00:50 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 22:03 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-20 22:19 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 22:42 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-18 12:34 -0700
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 15:28 -0700
Re: a little bit closer DFS <nospam@nospam.com> - 2018-09-15 19:24 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 16:32 -0700
Re: a little bit closer Special Edd <shortbus1963me@mail.com> - 2018-09-15 19:48 -0400
Re: a little bit closer Steve Carroll <frelwizzen@gmail.com> - 2018-09-15 18:36 -0700
csiph-web