Valid Data Matrix

Conversation Success Matrix

mysql> select t1.success, t2.success, count(*) from stc_tweets as t1 inner join stc_tweet_ids as ids on t1.item_id = ids.post_id inner join stc_tweets as t2 on ids.reply_id = t2.item_id group by t1.success, t2.success;
+---------+---------+----------+
| success | success | count(*) |
+---------+---------+----------+
|      -2 |      -2 |     1079 |
|      -2 |      -1 |      923 |
|      -2 |       1 |    11608 |
|      -1 |      -2 |      781 |
|      -1 |      -1 |     3210 |
|      -1 |       1 |    22477 |
|       1 |      -2 |    10483 |
|       1 |      -1 |    22132 |
|       1 |       1 |   427307 |
+---------+---------+----------+
9 rows in set (6.63 sec)

post success \ reply success	1	-1	-2
1	427307	22132	10483
-1	22477	3210	781
-2	11608	923	1079