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

I already know you aren't going to love the reason. I'm sure though, it will be OK.

GL AR i E L IGHT , GO GO G AD GET RE AL K MAD e DEN The  Grinch  is a bitter, grouchy, cave-dwelling creature with a heart "two sizes too small" who lives on snowy Mount Crumpit, a steep high mountain just north of the town of Who ville, home of the merry and warm-hearted Who s. His only companion is his unloved, but loyal dog, Max . From his cave, the Grinch can hear the noisy Christmas festivities that take place in Who ville. Annoyed, he decides to stop Christmas from coming by stealing their presents, trees, and food for their Christmas feast. He crudely disguises himself as Santa Claus, and forces Max, disguised as a reindeer, to drag a sleigh to Who ville. Once there, the Grinch slides down the chimney and steals all of the Who s' Christmas presents, the  Christmas tree , and the  log  for their fire. He is briefly interrupted in his burglary by Cindy Lou, a little Who girl, but concocts a crafty lie to effect his escape from her home.

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

Applegates and Covenants... do you rock, Mischa Barton?

this I  tell  you  sistaz ,  you can't have  Nun  without the other ...   C O  V E N   A N T              ... off course, of course ...     despite all my  rage, I am  still just  the rat   and   the cage     RO HO W COME HELP ME GET HIGH, WATER ᐧ     DON'T MISS    T H E  E N D ,  NEW MATERIAL HERE WRITE A PAPER YOU CAN PROVE THE LANGUAGE PROVES CREATION.   I THOUGHT TO MYSELF     LOOKING HIGH AND LO FOR HIS KEY, TO SAY "HI  ON THE  SKY"         I TRIED LETTUCE Si, AND DA "LET IT BE GIN"       ​ I CHANGED "ENDS" TO "HE ADDS" A FUNNERAD   I POINTED TO SUNRISE BLVD, AND EVEN FRIED SUNSET STRIP    BE CAUSE THERE'S NO SUBSTITUTE FOR...   The b ottom line is, we're about  a foot  away from Heaven, and all it takes to get there is one  small  acknowledgement.... of th