Advertisement
Guest User

Untitled

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