View difference between Paste ID: khpYvTXK and XERwzCW0
SHOW: | | - or go back to the newest paste.
1
    select 01 mo_id, "March 2012" month, (select count(*) created from tickets where created_at > '2012-03-01 00:00:00' and created_at < '2012-04-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-03-01 00:00:00' and closed_at < '2012-04-01 00:00:00') closed  UNION
2
    select 02 mo_id, "April 2012" month, (select count(*) created from tickets where created_at > '2012-04-01 00:00:00' and created_at < '2012-05-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-04-01 00:00:00' and closed_at < '2012-05-01 00:00:00') closed UNION
3
    select 03 mo_id, "May 2012" month, (select count(*) created from tickets where created_at > '2012-05-01 00:00:00' and created_at < '2012-06-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-05-01 00:00:00' and closed_at < '2012-06-01 00:00:00') closed UNION
4
    select 04 mo_id, "June 2012" month, (select count(*) created from tickets where created_at > '2012-06-01 00:00:00' and created_at < '2012-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-06-01 00:00:00' and closed_at < '2012-07-01 00:00:00') closed UNION
5
    select 05 mo_id, "July 2012" month, (select count(*) created from tickets where created_at > '2012-07-01 00:00:00' and created_at < '2012-08-01 00:00:00') created,  (select count(*) created from tickets where closed_at > '2012-07-01 00:00:00' and closed_at < '2012-08-01 00:00:00') closed UNION
6
    select 06 mo_id, "August 2012" month, (select count(*) created from tickets where created_at > '2012-08-01 00:00:00' and created_at < '2012-09-01 00:00:00') created,  (select count(*) created from tickets where closed_at > '2012-08-01 00:00:00' and closed_at < '2012-09-01 00:00:00') closed UNION
7
    select 07 mo_id, "September 2012" month, (select count(*) created from tickets where created_at > '2012-09-01 00:00:00' and created_at < '2012-10-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-09-01 00:00:00' and closed_at < '2012-10-01 00:00:00') closed UNION
8
    select 08 mo_id, "October 2012" month, (select count(*) created from tickets where created_at > '2012-10-01 00:00:00' and created_at < '2012-11-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-10-01 00:00:00' and closed_at < '2012-11-01 00:00:00') closed UNION
9
    select 09 mo_id, "November 2012" month, (select count(*) created from tickets where created_at > '2012-11-01 00:00:00' and created_at < '2012-12-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-11-01 00:00:00' and closed_at < '2012-12-01 00:00:00') closed UNION
10
    select 10 mo_id, "December 2012" month, (select count(*) created from tickets where created_at > '2012-12-01 00:00:00' and created_at < '2013-01-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2012-12-01 00:00:00' and closed_at < '2013-01-01 00:00:00') closed UNION
11
    select 11 mo_id, "January 2013" month, (select count(*) created from tickets where created_at > '2013-01-01 00:00:00' and created_at < '2013-02-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-01-01 00:00:00' and closed_at < '2013-02-01 00:00:00') closed UNION
12
    select 12 mo_id, "February 2013" month, (select count(*) created from tickets where created_at > '2013-02-01 00:00:00' and created_at < '2013-03-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-02-01 00:00:00' and closed_at < '2013-03-01 00:00:00') closed UNION
13
    select 13 mo_id, "March 2013" month, (select count(*) created from tickets where created_at > '2013-03-01 00:00:00' and created_at < '2013-04-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-03-01 00:00:00' and closed_at < '2013-04-01 00:00:00') closed UNION
14
    select 14 mo_id, "April 2013" month, (select count(*) created from tickets where created_at > '2013-04-01 00:00:00' and created_at < '2013-05-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-04-01 00:00:00' and closed_at < '2013-05-01 00:00:00') closed UNION
15
    select 15 mo_id, "May 2013" month, (select count(*) created from tickets where created_at > '2013-05-01 00:00:00' and created_at < '2013-06-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-05-01 00:00:00' and closed_at < '2013-06-01 00:00:00') closed UNION
16-
    select 16 mo_id, "June 2013" month, (select count(*) created from tickets where created_at > '2013-06-01 00:00:00' and created_at < '2013-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-06-01 00:00:00' and closed_at < '2013-07-01 00:00:00') closed UNION
16+
    select 16 mo_id, "June 2013" month, (select count(*) created from tickets where created_at > '2013-06-01 00:00:00' and created_at < '2013-07-01 00:00:00') created, (select count(*) created from tickets where closed_at > '2013-06-01 00:00:00' and closed_at < '2013-07-01 00:00:00')