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 things is acknowledging the meaning of the word " Ham. "  You see, if you lis

Be Alarmed.

TABLE ROW, I AM TIME . The stories and characters I am explaining to you have something to with this event, from the snake being fought off in the move (and the story) of Ra and Horus--in "Gods of Egypt" this snake is a monster taking over your minds.  I understand what it means because I see it, nearly every day now--and you can be sure it's a very scary thing to see.  I have tried, in my mind, to come up with plausible reasons why you would allow such a thing to happen and not "scream at the top of your lungs" as I do when I see it... not just in you but in me also.  It once told me it "was me" but clearly it's not--and frankly I don't believe that it  was ever me , as I once thought possible.  Neither here nor there, if it was me and is now much older coming from another place, perhaps from "a previous Heaven" it's no longer anything like me, as I would never, ever, ever, take over my own body to mak

This delusion we live in, this place called "Earth."

  there's a fire  growing in my heart reaching a fever pitch thing is about to start Huracan [1]  ( / ˈ h ʊ r ə k ə n ,  ˈ h ʊ r ə ˌ k ɑː n / ;  Spanish :  Huracán ;  Mayan :   Hunraqan , "one legged"), often referred to as  U K'ux Kaj , the " Heart of Sky ", [2]  is a  K'iche'   Maya  god of  wind ,  storm ,  fire  and one of the creator deities who participated in all three attempts at creating humanity. [3]  He also caused the  Great Flood  after the second generation of humans angered the gods. He supposedly lived in the windy mists above the floodwaters and repeatedly invoked "earth" until land came up from the seas. The lore of " Huracan " says that he repeatedly invoked the name of Earth, to me it sounds like crying in the dark for a better place; and to see that he is I, begging to do  this again , well, it might tell you something about the "other place."  I sit here invoking " the day " ov