Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement