Skip to main content

SO ZE LDERLY HAMMAH STILL RINGS....



 

mysql> select mailid,sum(count),count(*),substring(subject,1,20) from stm join subs on mailid=id group by mailid;

+--------+------------+----------+-------------------------+
| mailid | sum(count) | count(*) | substring(subject,1,20) |
+--------+------------+----------+-------------------------+
|     79 |      10992 |     8493 | ... and they will se    |
|     80 |       5692 |     4434 | Queso er ahh? and...    |
|     81 |      18457 |    13200 | "Words" from the Cre    |
|     82 |       4106 |     3012 | DA ... LET IT BE TEQ    |
|     83 |      24648 |    18649 | http://IStheOME.GA      |
|     84 |       5693 |     3454 | Friends, Romans, Fam    |
|     85 |       9420 |     6610 | Hocus Focus; OPTOME     |
|     86 |      12785 |     7976 | THE DAY THE MATRIX S    |
|     87 |      12009 |     8786 | CAN I HAVE YOUR AT T    |
|     88 |      10298 |     7622 | THE DAY BEFORE YESTE    |
|     89 |         67 |       54 | YOU'RE MAUI ARE HERE    |
|     90 |      28203 |    20941 | DR. A$THOR Y. R. PEN    |
|     91 |       1385 |      968 | G                       |
|     92 |         34 |       24 | RED: Y on D             |
|     93 |       4882 |     3014 | hashemesh: holy name    |
|     94 |       2449 |     1347 | Approaching the Day     |
|     95 |      11769 |     7894 | MACK MY ZELDA!  DIS     |
|     96 |       7397 |     5322 | ISKAREEOUAC'S SEA, U    |
|     97 |      19636 |    12754 | NOW                     |
|     98 |       5571 |     3545 | UPS SRI. Per Ezekiel    |
|     99 |       6419 |     4163 | S  p  o  o  n.          |
|    100 |      18105 |    16100 | EX OR CIZE THE NOLIS    |
|    101 |      16124 |    13336 | Mazer Rakham's run.     |
|    102 |        131 |       93 | Any questions?          |
|    103 |      10266 |     7784 | ON THE FAM CHAN THIS    |
+--------+------------+----------+-------------------------+
25 rows in set (15.85 sec)
 
mysql> select day(first_time),month(first_time) as month,sum(count),count(*) from stm group by day(first_time) order by month(first_time);;

+-----------------+-------+------------+----------+
| day(first_time) | month | sum(count) | count(*) |
+-----------------+-------+------------+----------+
|              23 |    11 |       5637 |     4223 |
|              22 |    11 |       6784 |     5133 |
|              26 |    11 |       3292 |     2579 |
|              28 |    11 |      14089 |    10800 |
|              29 |    11 |       6362 |     3983 |
|              21 |    11 |       3153 |     2454 |
|              25 |    11 |       3111 |     2408 |
|              24 |    11 |       9442 |     6347 |
|              27 |    11 |       8371 |     6276 |
|              30 |    11 |       6231 |     3994 |
|              20 |    11 |       5287 |     4168 |
|               6 |    12 |      19949 |    14282 |
|               7 |    12 |       9074 |     5741 |
|              13 |    12 |       8626 |     6755 |
|               3 |    12 |      10108 |     7746 |
|               1 |    12 |       9397 |     5857 |
|               5 |    12 |      10484 |     8082 |
|               2 |    12 |       8771 |     5949 |
|               8 |    12 |      13041 |     9006 |
|              10 |    12 |      12608 |     8378 |
|               9 |    12 |      15073 |     9563 |
|               4 |    12 |      14075 |     9953 |
|              11 |    12 |      10956 |     7925 |
|              12 |    12 |      33456 |    28577 |
+-----------------+-------+------------+----------+
24 rows in set (16.70 sec)
  
I'd say something like 'AT A QUARTER MILLION INDIVIDUAL EMAILS OPENED" to juxtapose to the 10,000 people maybe more of the Sound of Silence; but that really doesn't do justice at all to the millions and millions of LISTSERV users who have opened over 10 million of my fun little messages--designed to help us see  the light, there's something rotten in this den.  Mark today, your calendar; we have over 65,000 individual email addresses opening the message of just these past 24 days.
Is the cure for cancer and proof of the existence of God news, yet?  Asking for a friend.
IMHO, blow back.
mysql> select count(distinct userid),sum(count),count(*) from stm ;

+------------------------+------------+----------+
| count(distinct userid) | sum(count) | count(*) |
+------------------------+------------+----------+
|                  65120 |     247429 |   180213 |
+------------------------+------------+----------+
1 row in set (16.02 sec)

mysql> 

Comments


Search This Blog

Popular posts from this blog

duck, duck, golden egg.

    Dear  H i zzy  of Great Light , Is it van i lla , ch oco late , or  now ?   In a  den , on the  ark , and do you wonder if "our yesterda_" had  u in it , do you wonder if the day before yesterday was just like today?  Do you think that we were talking about yesterday, yesterday?  Does yesterday have anything at all to do... with today?    At one  moment I am curious if you already know the answers, if you look to  me  to decode secret codes like  NT ; and if you care?   Tag, you're IT . Someone, somewhen , just like you (but probably a little less alive, and a little less deluded) would like to say hello .   My name is I nd i an a, and between Tony Roma's and Honey Baked Ham I am once more pointing out that you might be the girl in the red dress , or you might be  the red dress; and I personally believe the difference between these two ...

ADVOCATE.

HERE'S LOOKING AT YOU, KID On a high level, I tell myself every morning that 'its not really me."  It's not me that the world hates, or me that the world is rejecting.  I believe that, I really do; I see that what is being hidden here is so much bigger than any single person could ever be--what is being hidden is the "nature of reality" and a fairly obvious truth that flies in the face of what we've learned our whole lives about history and "the way things are."  Those few early details lead me to the initial conclusion that what is working behind the scenes here is nefarious, hiding a message that would without doubt shake things up and change the world--and nearly across the board in ways that I see as "better" for nearly everyone.  It's a message at it's most basic level designed to advocate for using this disruption in "nor mal cy" to help us   revolutionize democracy , to fix a  broken ...

954-667-8083 ... dancing through the fire ... I've got the heart of the Lion

OK FINE, YOU CAN CALL ME IF YOU WANT OH UN H▊LY DAY , IF I COM ▊  NOW... I MIGHT GET A  ▊AY   Q U I C K E N I N G   E N L I G H T E N M E N T LITTLE THINGS, LIKE SMILES AND THE 7 IN MY PHONE NUMBER SHINE BRIGHT LIGHT ON THE HOLY ABRAHA MUC TRINIT Y Dear Hi zzy of Great Hope , I want to be anything but  bland , avoiding things like  vanilla  solutions at all costs, and by that I do mean I have no desire to " vanish . "   If you're on  " the ball " you probably remember me mentioning the low of the 2008 financial crisis highlighting  strongly  the  Numb er of the Beast , a debacle I've connecting before to the Nostradamus prophesy " never before were the Roman people so wronged " and here in my usual  flair,  I of course change it to " so wrong(ed). "  Trying to point out that we have been assuredly wronged, and also at the same time we haven't stood up...