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 ...

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...

Ha, Lot! Are Idaho?

Ha , Lot ! Are Ida ho ? This was very difficult to get to you, in the land of no power and hurricane disaster recovery; so it's filled with extra errors, and I am sure some more thoughts that trailing and unfinished.  That's a decent "microcosm" or "metaphor" for you, you are in a freedom disaster; and the act of being is a giant leap towards ensuring victory.   Still, you look very cupid to me.     EVERY DAY IS A NEW DAY Literally I am sitting here talking to you until the end of time, you could call it a thousand and one Arabian nights, and realize that as we speak we are nearing that onc  speciad  night.  There's a fire growing in my heart, and believe me when I tell you this thing is about to start.  I'll try and keep this short and sweet, since you all seem to have so little time to hear from the Creator of all things, and I truly don't want to steal your spotlight. We are here, at the the end of t...