Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT * FROM cd_sql.cd_subscription_stats;
- +------------+----------------+-------+-----------------------------------+---------------------+
- | dt | field | total | product_handle | last_updated |
- +------------+----------------+-------+-----------------------------------+---------------------+
- | 2010-11-02 | active_subs | 53 | | 2010-11-02 23:42:06 |
- | 2010-11-02 | active_subs | 0 | wc2_for_1299_notrial | 2010-11-02 20:01:29 |
- | 2010-11-02 | active_subs | 2 | wc3_for_1599 | 2010-11-02 20:01:18 |
- | 2010-11-02 | active_subs | -1 | wc3_for_1599_notrial | 2010-11-02 23:31:43 |
- | 2010-11-02 | active_subs | 3 | wc4_for_1999 | 2010-11-02 22:56:12 |
- | 2010-11-02 | active_subs | 0 | wc4_for_1999_notrial | 2010-11-02 23:44:40 |
- | 2010-11-02 | active_subs | 0 | wc5_for_2499_notrial | 2010-11-02 22:51:19 |
- | 2010-11-02 | active_subs | 1 | wc6_for_2999 | 2010-11-02 22:41:44 |
- | 2010-11-02 | active_subs | 1 | wc6_for_2999_notrial | 2010-11-02 23:24:17 |
- | 2010-11-02 | cancelled_subs | 0 | | 2010-11-02 19:38:40 |
- | 2010-11-02 | cancelled_subs | 0 | wc3_for_1599 | 2010-11-02 20:00:56 |
- | 2010-11-02 | cancelled_subs | 1 | wc3_for_1599_notrial | 2010-11-02 20:01:19 |
- | 2010-11-02 | cancelled_subs | -1 | wc4_for_1999 | 2010-11-02 20:01:16 |
- | 2010-11-02 | cancelled_subs | 0 | wc4_for_1999_notrial | 2010-11-02 20:02:22 |
- | 2010-11-02 | cancelled_subs | -1 | wc6_for_2999_notrial | 2010-11-02 20:04:13 |
- | 2010-11-02 | redeemed | 113 | | 2010-11-02 23:49:39 |
- | 2010-11-02 | redeemed | 12 | wc3_for_1599_notrial | 2010-11-02 23:20:19 |
- | 2010-11-02 | redeemed | 5 | wc4_for_1999 | 2010-11-02 23:39:15 |
- | 2010-11-02 | redeemed | 10 | wc4_for_1999_notrial | 2010-11-02 23:55:10 |
- | 2010-11-02 | redeemed | 3 | wc6_for_2999_notrial | 2010-11-02 23:17:28 |
- | 2010-11-02 | redeemed | 4 | weekly-cinema-12_99_preauth | 2010-11-02 21:13:25 |
- | 2010-11-02 | total_subs | 61 | wc2_for_1299_notrial | NULL |
- | 2010-11-02 | total_subs | 18 | wc2_for_899_notrial | NULL |
- | 2010-11-02 | total_subs | 4 | wc3_for_1499 | NULL |
- | 2010-11-02 | total_subs | 52 | wc3_for_1499_notrial | NULL |
- | 2010-11-02 | total_subs | 161 | wc3_for_1599 | NULL |
- | 2010-11-02 | total_subs | 1002 | wc3_for_1599_notrial | NULL |
- | 2010-11-02 | total_subs | 1180 | wc4_for_1999 | NULL |
- | 2010-11-02 | total_subs | 2249 | wc4_for_1999_notrial | NULL |
- | 2010-11-02 | total_subs | 27 | wc5_for_2499 | NULL |
- | 2010-11-02 | total_subs | 68 | wc5_for_2499_notrial | NULL |
- | 2010-11-02 | total_subs | 131 | wc6_for_2999 | NULL |
- | 2010-11-02 | total_subs | 207 | wc6_for_2999_notrial | NULL |
- | 2010-11-03 | active_subs | 5 | | 2010-11-03 00:56:21 |
- | 2010-11-03 | active_subs | 0 | wc2_for_1299_notrial | 2010-11-03 02:01:17 |
- | 2010-11-03 | active_subs | 2 | wc3_for_1599 | 2010-11-03 02:01:12 |
- | 2010-11-03 | active_subs | 0 | wc3_for_1599_notrial | 2010-11-03 02:01:32 |
- | 2010-11-03 | active_subs | 5 | wc4_for_1999 | 2010-11-03 02:01:15 |
- | 2010-11-03 | active_subs | -1 | wc4_for_1999_notrial | 2010-11-03 02:01:34 |
- | 2010-11-03 | active_subs | 0 | wc5_for_2499_notrial | 2010-11-03 02:01:16 |
- | 2010-11-03 | active_subs | 0 | wc6_for_2999 | 2010-11-03 02:01:17 |
- | 2010-11-03 | active_subs | 0 | wc6_for_2999_notrial | 2010-11-03 02:01:21 |
- | 2010-11-03 | cancelled_subs | 0 | | 2010-11-03 02:08:04 |
- | 2010-11-03 | cancelled_subs | 0 | wc3_for_1599 | 2010-11-03 02:00:49 |
- | 2010-11-03 | cancelled_subs | 0 | wc3_for_1599_notrial | 2010-11-03 02:01:12 |
- | 2010-11-03 | cancelled_subs | 0 | wc4_for_1999 | 2010-11-03 02:00:54 |
- | 2010-11-03 | cancelled_subs | 1 | wc4_for_1999_notrial | 2010-11-03 02:01:18 |
- | 2010-11-03 | redeemed | 95 | | 2010-11-03 02:12:56 |
- | 2010-11-03 | redeemed | 1 | wc3_for_1499_notrial | 2010-11-03 01:46:09 |
- | 2010-11-03 | redeemed | 3 | wc3_for_1599_notrial | 2010-11-03 00:11:59 |
- | 2010-11-03 | redeemed | 14 | wc4_for_1999 | 2010-11-03 00:16:58 |
- | 2010-11-03 | redeemed | 61 | wc4_for_1999_notrial | 2010-11-03 00:59:28 |
- | 2010-11-03 | redeemed | 8 | wc6_for_2999_notrial | 2010-11-03 00:13:24 |
- | 2010-11-03 | redeemed | 3 | weekly-cinema-15_99-instantcharge | 2010-11-03 00:18:37 |
- | 2010-11-03 | redeemed | 1 | weekly-cinema-15_99_preauth | 2010-11-03 00:23:20 |
- +------------+----------------+-------+-----------------------------------+---------------------+
- 55 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement