Skip to content

Instantly share code, notes, and snippets.

@holybit

holybit/gist:31436bbb8043e252b4e9

Last active August 29, 2015 14:10
Show Gist options
  • Save holybit/31436bbb8043e252b4e9 to your computer and use it in GitHub Desktop.
Save holybit/31436bbb8043e252b4e9 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle SQL odd date format results GROUP BY week (i.e., IW)
Raw
gistfile1.sql
--------------------------------------------------------
-- DDL for Table ABUSE_CUSTID_INST_ROLLUP
--------------------------------------------------------
CREATE TABLE "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP"
( "ROLLUP_DT" DATE,
"COMPANY_ID" NUMBER,
"INST_COUNT" NUMBER DEFAULT 0
);
--------------------------------------------------------
-- DDL for Index ABUSE_CUSTID_INST_ROLLUP_PK
--------------------------------------------------------
CREATE UNIQUE INDEX "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP_PK" ON "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP" ("ROLLUP_DT", "COMPANY_ID");
--------------------------------------------------------
-- Constraints for Table ABUSE_CUSTID_INST_ROLLUP
--------------------------------------------------------
ALTER TABLE "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP" ADD CONSTRAINT "ABUSE_CUSTID_INST_ROLLUP_PK" PRIMARY KEY ("ROLLUP_DT", "COMPANY_ID");
ALTER TABLE "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP" MODIFY ("INST_COUNT" NOT NULL ENABLE);
ALTER TABLE "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP" MODIFY ("COMPANY_ID" NOT NULL ENABLE);
ALTER TABLE "FBL_OWNER"."ABUSE_CUSTID_INST_ROLLUP" MODIFY ("ROLLUP_DT" NOT NULL ENABLE);
/*
SQL
*/
SELECT TO_CHAR(rollup_dt, 'IW') AS week_of_year,
TO_CHAR(rollup_dt, 'D') AS day_of_week,
TO_CHAR(rollup_dt, 'YYYY-MM-DD') AS dt,
SUM(inst_count)
OVER (
PARTITION BY TO_CHAR(rollup_dt, 'IW')) AS total,
inst_count
FROM fbl_owner.abuse_custid_inst_rollup
WHERE company_id = :company_id
ORDER BY dt DESC,
day_of_week ASC;
"WEEK_OF_YEAR" "DAY_OF_WEEK" "DT" "TOTAL" "INST_COUNT"
"49" "5" "2014-12-04" "20" "1"
"49" "5" "2014-12-04" "20" "2"
"49" "5" "2014-12-04" "20" "1"
"49" "5" "2014-12-04" "20" "1"
"49" "5" "2014-12-04" "20" "1"
"49" "5" "2014-12-04" "20" "1"
"49" "4" "2014-12-03" "20" "1"
"49" "4" "2014-12-03" "20" "3"
"49" "4" "2014-12-03" "20" "1"
"49" "4" "2014-12-03" "20" "1"
"49" "4" "2014-12-03" "20" "1"
"49" "4" "2014-12-03" "20" "1"
"49" "2" "2014-12-01" "20" "2"
"49" "2" "2014-12-01" "20" "1"
"49" "2" "2014-12-01" "20" "1"
"49" "2" "2014-12-01" "20" "1"
---- November 30, 2014 is not the first day of week 48. It's the last day of week 48. December 1 above should be the first day of week 49.
"48" "1" "2014-11-30" "71" "1"
"48" "1" "2014-11-30" "71" "1"
"48" "1" "2014-11-30" "71" "4"
"48" "1" "2014-11-30" "71" "1"
----
"48" "7" "2014-11-29" "71" "1"
"48" "7" "2014-11-29" "71" "1"
"48" "7" "2014-11-29" "71" "1"
"48" "7" "2014-11-29" "71" "1"
"48" "7" "2014-11-29" "71" "1"
"48" "6" "2014-11-28" "71" "1"
"48" "6" "2014-11-28" "71" "1"
"48" "6" "2014-11-28" "71" "1"
"48" "6" "2014-11-28" "71" "1"
"48" "6" "2014-11-28" "71" "1"
"48" "5" "2014-11-27" "71" "1"
"48" "5" "2014-11-27" "71" "2"
"48" "5" "2014-11-27" "71" "2"
"48" "5" "2014-11-27" "71" "1"
"48" "5" "2014-11-27" "71" "4"
"48" "5" "2014-11-27" "71" "1"
"48" "4" "2014-11-26" "71" "1"
"48" "4" "2014-11-26" "71" "3"
"48" "4" "2014-11-26" "71" "2"
"48" "4" "2014-11-26" "71" "2"
"48" "4" "2014-11-26" "71" "2"
"48" "4" "2014-11-26" "71" "1"
"48" "4" "2014-11-26" "71" "1"
"48" "4" "2014-11-26" "71" "1"
"48" "4" "2014-11-26" "71" "1"
"48" "3" "2014-11-25" "71" "3"
"48" "3" "2014-11-25" "71" "3"
"48" "3" "2014-11-25" "71" "1"
"48" "3" "2014-11-25" "71" "1"
"48" "3" "2014-11-25" "71" "2"
"48" "3" "2014-11-25" "71" "1"
"48" "3" "2014-11-25" "71" "1"
"48" "3" "2014-11-25" "71" "4"
"48" "3" "2014-11-25" "71" "1"
"48" "3" "2014-11-25" "71" "2"
"48" "3" "2014-11-25" "71" "1"
"48" "2" "2014-11-24" "71" "1"
"48" "2" "2014-11-24" "71" "1"
"48" "2" "2014-11-24" "71" "1"
"48" "2" "2014-11-24" "71" "1"
"48" "2" "2014-11-24" "71" "2"
"48" "2" "2014-11-24" "71" "1"
"48" "2" "2014-11-24" "71" "2"
"47" "1" "2014-11-23" "142" "1"
"47" "1" "2014-11-23" "142" "2"
"47" "1" "2014-11-23" "142" "21"
"47" "1" "2014-11-23" "142" "2"
"47" "1" "2014-11-23" "142" "15"
"47" "7" "2014-11-22" "142" "1"
"47" "7" "2014-11-22" "142" "1"
"47" "6" "2014-11-21" "142" "1"
"47" "6" "2014-11-21" "142" "3"
"47" "6" "2014-11-21" "142" "1"
"47" "6" "2014-11-21" "142" "21"
"47" "6" "2014-11-21" "142" "17"
"47" "6" "2014-11-21" "142" "3"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "2"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "1"
"47" "5" "2014-11-20" "142" "1"
"47" "4" "2014-11-19" "142" "1"
"47" "4" "2014-11-19" "142" "3"
"47" "4" "2014-11-19" "142" "2"
"47" "4" "2014-11-19" "142" "1"
"47" "4" "2014-11-19" "142" "2"
"47" "4" "2014-11-19" "142" "1"
"47" "4" "2014-11-19" "142" "2"
"47" "4" "2014-11-19" "142" "1"
"47" "3" "2014-11-18" "142" "3"
"47" "3" "2014-11-18" "142" "3"
"47" "3" "2014-11-18" "142" "1"
"47" "3" "2014-11-18" "142" "1"
"47" "3" "2014-11-18" "142" "1"
"47" "2" "2014-11-17" "142" "3"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "4"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "2"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "2"
"47" "2" "2014-11-17" "142" "2"
"47" "2" "2014-11-17" "142" "1"
"47" "2" "2014-11-17" "142" "1"
"46" "1" "2014-11-16" "393" "9"
"46" "1" "2014-11-16" "393" "1"
"46" "1" "2014-11-16" "393" "1"
"46" "1" "2014-11-16" "393" "5"
"46" "1" "2014-11-16" "393" "1"
"46" "1" "2014-11-16" "393" "43"
"46" "1" "2014-11-16" "393" "2"
"46" "1" "2014-11-16" "393" "2"
"46" "1" "2014-11-16" "393" "3"
"46" "1" "2014-11-16" "393" "1"
"46" "1" "2014-11-16" "393" "8"
"46" "7" "2014-11-15" "393" "2"
"46" "7" "2014-11-15" "393" "1"
"46" "7" "2014-11-15" "393" "1"
"46" "7" "2014-11-15" "393" "1"
"46" "7" "2014-11-15" "393" "3"
"46" "7" "2014-11-15" "393" "1"
"46" "7" "2014-11-15" "393" "2"
"46" "7" "2014-11-15" "393" "2"
"46" "7" "2014-11-15" "393" "1"
"46" "7" "2014-11-15" "393" "5"
"46" "7" "2014-11-15" "393" "2"
"46" "7" "2014-11-15" "393" "4"
"46" "7" "2014-11-15" "393" "3"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "2"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "2"
"46" "6" "2014-11-14" "393" "3"
"46" "6" "2014-11-14" "393" "2"
"46" "6" "2014-11-14" "393" "2"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "3"
"46" "6" "2014-11-14" "393" "2"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "3"
"46" "6" "2014-11-14" "393" "1"
"46" "6" "2014-11-14" "393" "3"
"46" "6" "2014-11-14" "393" "3"
"46" "5" "2014-11-13" "393" "7"
"46" "5" "2014-11-13" "393" "7"
"46" "5" "2014-11-13" "393" "8"
"46" "5" "2014-11-13" "393" "5"
"46" "5" "2014-11-13" "393" "33"
"46" "5" "2014-11-13" "393" "4"
"46" "5" "2014-11-13" "393" "7"
"46" "5" "2014-11-13" "393" "1"
"46" "5" "2014-11-13" "393" "4"
"46" "5" "2014-11-13" "393" "4"
"46" "5" "2014-11-13" "393" "2"
"46" "5" "2014-11-13" "393" "2"
"46" "5" "2014-11-13" "393" "11"
"46" "5" "2014-11-13" "393" "7"
"46" "5" "2014-11-13" "393" "3"
"46" "5" "2014-11-13" "393" "1"
"46" "5" "2014-11-13" "393" "1"
"46" "5" "2014-11-13" "393" "1"
"46" "5" "2014-11-13" "393" "6"
"46" "4" "2014-11-12" "393" "1"
"46" "4" "2014-11-12" "393" "4"
"46" "4" "2014-11-12" "393" "8"
"46" "4" "2014-11-12" "393" "4"
"46" "4" "2014-11-12" "393" "4"
"46" "4" "2014-11-12" "393" "9"
"46" "4" "2014-11-12" "393" "4"
"46" "4" "2014-11-12" "393" "4"
"46" "4" "2014-11-12" "393" "9"
"46" "4" "2014-11-12" "393" "3"
"46" "4" "2014-11-12" "393" "9"
"46" "4" "2014-11-12" "393" "5"
"46" "4" "2014-11-12" "393" "1"
"46" "4" "2014-11-12" "393" "2"
"46" "4" "2014-11-12" "393" "1"
"46" "4" "2014-11-12" "393" "3"
"46" "3" "2014-11-11" "393" "3"
"46" "3" "2014-11-11" "393" "5"
"46" "3" "2014-11-11" "393" "5"
"46" "3" "2014-11-11" "393" "1"
"46" "3" "2014-11-11" "393" "4"
"46" "3" "2014-11-11" "393" "1"
"46" "3" "2014-11-11" "393" "1"
"46" "3" "2014-11-11" "393" "3"
"46" "3" "2014-11-11" "393" "2"
"46" "3" "2014-11-11" "393" "1"
"46" "3" "2014-11-11" "393" "1"
"46" "3" "2014-11-11" "393" "2"
"46" "3" "2014-11-11" "393" "1"
"46" "2" "2014-11-10" "393" "2"
"46" "2" "2014-11-10" "393" "4"
"46" "2" "2014-11-10" "393" "1"
"46" "2" "2014-11-10" "393" "4"
"46" "2" "2014-11-10" "393" "2"
"46" "2" "2014-11-10" "393" "2"
"46" "2" "2014-11-10" "393" "7"
"46" "2" "2014-11-10" "393" "2"
"46" "2" "2014-11-10" "393" "4"
"46" "2" "2014-11-10" "393" "2"
"46" "2" "2014-11-10" "393" "6"
"46" "2" "2014-11-10" "393" "1"
"46" "2" "2014-11-10" "393" "1"
"46" "2" "2014-11-10" "393" "1"
"46" "2" "2014-11-10" "393" "1"
"46" "2" "2014-11-10" "393" "1"
"45" "1" "2014-11-09" "283" "2"
"45" "1" "2014-11-09" "283" "3"
"45" "1" "2014-11-09" "283" "7"
"45" "1" "2014-11-09" "283" "1"
"45" "1" "2014-11-09" "283" "1"
"45" "1" "2014-11-09" "283" "2"
"45" "1" "2014-11-09" "283" "3"
"45" "1" "2014-11-09" "283" "1"
"45" "1" "2014-11-09" "283" "1"
"45" "1" "2014-11-09" "283" "3"
"45" "1" "2014-11-09" "283" "2"
"45" "1" "2014-11-09" "283" "1"
"45" "7" "2014-11-08" "283" "5"
"45" "7" "2014-11-08" "283" "4"
"45" "7" "2014-11-08" "283" "2"
"45" "7" "2014-11-08" "283" "1"
"45" "7" "2014-11-08" "283" "1"
"45" "7" "2014-11-08" "283" "2"
"45" "7" "2014-11-08" "283" "2"
"45" "7" "2014-11-08" "283" "2"
"45" "6" "2014-11-07" "283" "1"
"45" "6" "2014-11-07" "283" "3"
"45" "6" "2014-11-07" "283" "2"
"45" "6" "2014-11-07" "283" "2"
"45" "6" "2014-11-07" "283" "11"
"45" "6" "2014-11-07" "283" "1"
"45" "6" "2014-11-07" "283" "2"
"45" "6" "2014-11-07" "283" "2"
"45" "6" "2014-11-07" "283" "4"
"45" "6" "2014-11-07" "283" "6"
"45" "6" "2014-11-07" "283" "2"
"45" "5" "2014-11-06" "283" "9"
"45" "5" "2014-11-06" "283" "2"
"45" "5" "2014-11-06" "283" "4"
"45" "5" "2014-11-06" "283" "1"
"45" "5" "2014-11-06" "283" "1"
"45" "5" "2014-11-06" "283" "33"
"45" "5" "2014-11-06" "283" "4"
"45" "5" "2014-11-06" "283" "59"
"45" "5" "2014-11-06" "283" "1"
"45" "5" "2014-11-06" "283" "2"
"45" "5" "2014-11-06" "283" "1"
"45" "5" "2014-11-06" "283" "3"
"45" "5" "2014-11-06" "283" "2"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "12"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "3"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "4"
"45" "4" "2014-11-05" "283" "1"
"45" "4" "2014-11-05" "283" "1"
"45" "3" "2014-11-04" "283" "4"
"45" "3" "2014-11-04" "283" "2"
"45" "3" "2014-11-04" "283" "3"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "4"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "2"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "1"
"45" "3" "2014-11-04" "283" "6"
"45" "2" "2014-11-03" "283" "2"
"45" "2" "2014-11-03" "283" "1"
"45" "2" "2014-11-03" "283" "6"
"45" "2" "2014-11-03" "283" "1"
"45" "2" "2014-11-03" "283" "2"
"45" "2" "2014-11-03" "283" "2"
"45" "2" "2014-11-03" "283" "2"
"45" "2" "2014-11-03" "283" "3"
"45" "2" "2014-11-03" "283" "1"
"45" "2" "2014-11-03" "283" "2"
"45" "2" "2014-11-03" "283" "1"
"45" "2" "2014-11-03" "283" "1"
"45" "2" "2014-11-03" "283" "1"
"44" "1" "2014-11-02" "195" "1"
"44" "1" "2014-11-02" "195" "1"
"44" "1" "2014-11-02" "195" "3"
"44" "1" "2014-11-02" "195" "2"
"44" "1" "2014-11-02" "195" "2"
"44" "1" "2014-11-02" "195" "1"
"44" "1" "2014-11-02" "195" "1"
"44" "1" "2014-11-02" "195" "2"
"44" "1" "2014-11-02" "195" "1"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "8"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "2"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "2"
"44" "7" "2014-11-01" "195" "1"
"44" "7" "2014-11-01" "195" "2"
"44" "7" "2014-11-01" "195" "2"
"44" "6" "2014-10-31" "195" "3"
"44" "6" "2014-10-31" "195" "1"
"44" "6" "2014-10-31" "195" "1"
"44" "6" "2014-10-31" "195" "2"
"44" "6" "2014-10-31" "195" "5"
"44" "6" "2014-10-31" "195" "1"
"44" "6" "2014-10-31" "195" "2"
"44" "6" "2014-10-31" "195" "1"
"44" "6" "2014-10-31" "195" "2"
"44" "6" "2014-10-31" "195" "1"
"44" "5" "2014-10-30" "195" "6"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "3"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "2"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "3"
"44" "5" "2014-10-30" "195" "3"
"44" "5" "2014-10-30" "195" "1"
"44" "5" "2014-10-30" "195" "3"
"44" "5" "2014-10-30" "195" "2"
"44" "5" "2014-10-30" "195" "2"
"44" "5" "2014-10-30" "195" "5"
"44" "4" "2014-10-29" "195" "1"
"44" "4" "2014-10-29" "195" "1"
"44" "4" "2014-10-29" "195" "8"
"44" "4" "2014-10-29" "195" "1"
"44" "4" "2014-10-29" "195" "1"
"44" "4" "2014-10-29" "195" "2"
"44" "4" "2014-10-29" "195" "2"
"44" "4" "2014-10-29" "195" "2"
"44" "4" "2014-10-29" "195" "3"
"44" "4" "2014-10-29" "195" "1"
"44" "4" "2014-10-29" "195" "13"
"44" "4" "2014-10-29" "195" "1"
"44" "3" "2014-10-28" "195" "2"
"44" "3" "2014-10-28" "195" "1"
"44" "3" "2014-10-28" "195" "6"
"44" "3" "2014-10-28" "195" "6"
"44" "3" "2014-10-28" "195" "1"
"44" "3" "2014-10-28" "195" "3"
"44" "3" "2014-10-28" "195" "2"
"44" "3" "2014-10-28" "195" "2"
"44" "3" "2014-10-28" "195" "1"
"44" "3" "2014-10-28" "195" "1"
"44" "3" "2014-10-28" "195" "2"
"44" "3" "2014-10-28" "195" "2"
"44" "3" "2014-10-28" "195" "1"
"44" "2" "2014-10-27" "195" "1"
"44" "2" "2014-10-27" "195" "1"
"44" "2" "2014-10-27" "195" "1"
"44" "2" "2014-10-27" "195" "4"
"44" "2" "2014-10-27" "195" "4"
"44" "2" "2014-10-27" "195" "1"
"44" "2" "2014-10-27" "195" "8"
"44" "2" "2014-10-27" "195" "3"
"44" "2" "2014-10-27" "195" "2"
"44" "2" "2014-10-27" "195" "2"
"44" "2" "2014-10-27" "195" "3"
"44" "2" "2014-10-27" "195" "2"
"44" "2" "2014-10-27" "195" "3"
"44" "2" "2014-10-27" "195" "2"
"44" "2" "2014-10-27" "195" "1"
"43" "1" "2014-10-26" "331" "4"
"43" "1" "2014-10-26" "331" "1"
"43" "1" "2014-10-26" "331" "3"
"43" "1" "2014-10-26" "331" "1"
"43" "1" "2014-10-26" "331" "1"
"43" "1" "2014-10-26" "331" "1"
"43" "1" "2014-10-26" "331" "5"
"43" "1" "2014-10-26" "331" "3"
"43" "1" "2014-10-26" "331" "4"
"43" "1" "2014-10-26" "331" "1"
"43" "1" "2014-10-26" "331" "1"
"43" "7" "2014-10-25" "331" "2"
"43" "7" "2014-10-25" "331" "5"
"43" "7" "2014-10-25" "331" "4"
"43" "7" "2014-10-25" "331" "1"
"43" "7" "2014-10-25" "331" "1"
"43" "7" "2014-10-25" "331" "5"
"43" "7" "2014-10-25" "331" "4"
"43" "7" "2014-10-25" "331" "1"
"43" "7" "2014-10-25" "331" "1"
"43" "6" "2014-10-24" "331" "1"
"43" "6" "2014-10-24" "331" "3"
"43" "6" "2014-10-24" "331" "2"
"43" "6" "2014-10-24" "331" "7"
"43" "6" "2014-10-24" "331" "1"
"43" "6" "2014-10-24" "331" "2"
"43" "6" "2014-10-24" "331" "1"
"43" "6" "2014-10-24" "331" "1"
"43" "6" "2014-10-24" "331" "8"
"43" "6" "2014-10-24" "331" "2"
"43" "6" "2014-10-24" "331" "1"
"43" "6" "2014-10-24" "331" "8"
"43" "6" "2014-10-24" "331" "2"
"43" "6" "2014-10-24" "331" "2"
"43" "5" "2014-10-23" "331" "2"
"43" "5" "2014-10-23" "331" "1"
"43" "5" "2014-10-23" "331" "3"
"43" "5" "2014-10-23" "331" "6"
"43" "5" "2014-10-23" "331" "12"
"43" "5" "2014-10-23" "331" "1"
"43" "5" "2014-10-23" "331" "4"
"43" "5" "2014-10-23" "331" "1"
"43" "5" "2014-10-23" "331" "2"
"43" "5" "2014-10-23" "331" "2"
"43" "5" "2014-10-23" "331" "5"
"43" "5" "2014-10-23" "331" "6"
"43" "5" "2014-10-23" "331" "9"
"43" "5" "2014-10-23" "331" "1"
"43" "5" "2014-10-23" "331" "4"
"43" "5" "2014-10-23" "331" "5"
"43" "4" "2014-10-22" "331" "1"
"43" "4" "2014-10-22" "331" "3"
"43" "4" "2014-10-22" "331" "5"
"43" "4" "2014-10-22" "331" "1"
"43" "4" "2014-10-22" "331" "1"
"43" "4" "2014-10-22" "331" "1"
"43" "4" "2014-10-22" "331" "3"
"43" "4" "2014-10-22" "331" "3"
"43" "4" "2014-10-22" "331" "2"
"43" "4" "2014-10-22" "331" "2"
"43" "4" "2014-10-22" "331" "3"
"43" "4" "2014-10-22" "331" "10"
"43" "4" "2014-10-22" "331" "5"
"43" "4" "2014-10-22" "331" "2"
"43" "4" "2014-10-22" "331" "7"
"43" "4" "2014-10-22" "331" "3"
"43" "4" "2014-10-22" "331" "1"
"43" "4" "2014-10-22" "331" "4"
"43" "4" "2014-10-22" "331" "3"
"43" "3" "2014-10-21" "331" "2"
"43" "3" "2014-10-21" "331" "3"
"43" "3" "2014-10-21" "331" "6"
"43" "3" "2014-10-21" "331" "8"
"43" "3" "2014-10-21" "331" "6"
"43" "3" "2014-10-21" "331" "4"
"43" "3" "2014-10-21" "331" "2"
"43" "3" "2014-10-21" "331" "48"
"43" "3" "2014-10-21" "331" "3"
"43" "3" "2014-10-21" "331" "1"
"43" "3" "2014-10-21" "331" "2"
"43" "3" "2014-10-21" "331" "3"
"43" "3" "2014-10-21" "331" "1"
"43" "3" "2014-10-21" "331" "1"
"43" "3" "2014-10-21" "331" "3"
"43" "3" "2014-10-21" "331" "5"
"43" "3" "2014-10-21" "331" "1"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "4"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "2"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "2"
"43" "2" "2014-10-20" "331" "2"
"43" "2" "2014-10-20" "331" "1"
"43" "2" "2014-10-20" "331" "1"
"42" "1" "2014-10-19" "256" "1"
"42" "1" "2014-10-19" "256" "2"
"42" "1" "2014-10-19" "256" "5"
"42" "1" "2014-10-19" "256" "1"
"42" "1" "2014-10-19" "256" "4"
"42" "1" "2014-10-19" "256" "2"
"42" "1" "2014-10-19" "256" "2"
"42" "1" "2014-10-19" "256" "1"
"42" "1" "2014-10-19" "256" "4"
"42" "1" "2014-10-19" "256" "2"
"42" "1" "2014-10-19" "256" "1"
"42" "1" "2014-10-19" "256" "3"
"42" "1" "2014-10-19" "256" "1"
"42" "7" "2014-10-18" "256" "2"
"42" "7" "2014-10-18" "256" "2"
"42" "7" "2014-10-18" "256" "4"
"42" "7" "2014-10-18" "256" "2"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "2"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "1"
"42" "7" "2014-10-18" "256" "2"
"42" "7" "2014-10-18" "256" "4"
"42" "7" "2014-10-18" "256" "5"
"42" "7" "2014-10-18" "256" "2"
"42" "6" "2014-10-17" "256" "1"
"42" "6" "2014-10-17" "256" "2"
"42" "6" "2014-10-17" "256" "4"
"42" "6" "2014-10-17" "256" "1"
"42" "6" "2014-10-17" "256" "4"
"42" "6" "2014-10-17" "256" "3"
"42" "6" "2014-10-17" "256" "2"
"42" "6" "2014-10-17" "256" "3"
"42" "6" "2014-10-17" "256" "1"
"42" "6" "2014-10-17" "256" "3"
"42" "6" "2014-10-17" "256" "2"
"42" "6" "2014-10-17" "256" "3"
"42" "6" "2014-10-17" "256" "1"
"42" "6" "2014-10-17" "256" "4"
"42" "5" "2014-10-16" "256" "1"
"42" "5" "2014-10-16" "256" "2"
"42" "5" "2014-10-16" "256" "1"
"42" "5" "2014-10-16" "256" "7"
"42" "5" "2014-10-16" "256" "6"
"42" "5" "2014-10-16" "256" "13"
"42" "5" "2014-10-16" "256" "4"
"42" "5" "2014-10-16" "256" "1"
"42" "5" "2014-10-16" "256" "10"
"42" "5" "2014-10-16" "256" "4"
"42" "5" "2014-10-16" "256" "2"
"42" "4" "2014-10-15" "256" "8"
"42" "4" "2014-10-15" "256" "3"
"42" "4" "2014-10-15" "256" "4"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "3"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "5"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "1"
"42" "4" "2014-10-15" "256" "2"
"42" "4" "2014-10-15" "256" "2"
"42" "3" "2014-10-14" "256" "4"
"42" "3" "2014-10-14" "256" "1"
"42" "3" "2014-10-14" "256" "9"
"42" "3" "2014-10-14" "256" "3"
"42" "3" "2014-10-14" "256" "2"
"42" "3" "2014-10-14" "256" "2"
"42" "3" "2014-10-14" "256" "2"
"42" "3" "2014-10-14" "256" "1"
"42" "3" "2014-10-14" "256" "2"
"42" "3" "2014-10-14" "256" "1"
"42" "3" "2014-10-14" "256" "4"
"42" "3" "2014-10-14" "256" "3"
"42" "3" "2014-10-14" "256" "1"
"42" "3" "2014-10-14" "256" "3"
"42" "3" "2014-10-14" "256" "7"
"42" "3" "2014-10-14" "256" "2"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "3"
"42" "2" "2014-10-13" "256" "4"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "3"
"42" "2" "2014-10-13" "256" "1"
"42" "2" "2014-10-13" "256" "3"
"42" "2" "2014-10-13" "256" "2"
"42" "2" "2014-10-13" "256" "3"
"42" "2" "2014-10-13" "256" "5"
"42" "2" "2014-10-13" "256" "1"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "3"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "2"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "6"
"41" "1" "2014-10-12" "163" "1"
"41" "1" "2014-10-12" "163" "5"
"41" "7" "2014-10-11" "163" "2"
"41" "7" "2014-10-11" "163" "2"
"41" "7" "2014-10-11" "163" "1"
"41" "7" "2014-10-11" "163" "1"
"41" "7" "2014-10-11" "163" "9"
"41" "7" "2014-10-11" "163" "1"
"41" "7" "2014-10-11" "163" "4"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "2"
"41" "6" "2014-10-10" "163" "3"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "5"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "3"
"41" "6" "2014-10-10" "163" "2"
"41" "6" "2014-10-10" "163" "1"
"41" "6" "2014-10-10" "163" "2"
"41" "6" "2014-10-10" "163" "2"
"41" "5" "2014-10-09" "163" "1"
"41" "4" "2014-10-08" "163" "1"
"41" "4" "2014-10-08" "163" "6"
"41" "4" "2014-10-08" "163" "4"
"41" "4" "2014-10-08" "163" "1"
"41" "4" "2014-10-08" "163" "1"
"41" "4" "2014-10-08" "163" "2"
"41" "4" "2014-10-08" "163" "8"
"41" "4" "2014-10-08" "163" "3"
"41" "3" "2014-10-07" "163" "1"
"41" "3" "2014-10-07" "163" "6"
"41" "3" "2014-10-07" "163" "2"
"41" "3" "2014-10-07" "163" "1"
"41" "3" "2014-10-07" "163" "2"
"41" "3" "2014-10-07" "163" "1"
"41" "3" "2014-10-07" "163" "6"
"41" "3" "2014-10-07" "163" "3"
"41" "3" "2014-10-07" "163" "3"
"41" "3" "2014-10-07" "163" "2"
"41" "3" "2014-10-07" "163" "1"
"41" "3" "2014-10-07" "163" "2"
"41" "3" "2014-10-07" "163" "3"
"41" "3" "2014-10-07" "163" "1"
"41" "3" "2014-10-07" "163" "4"
"41" "3" "2014-10-07" "163" "1"
"41" "2" "2014-10-06" "163" "3"
"41" "2" "2014-10-06" "163" "3"
"41" "2" "2014-10-06" "163" "3"
"41" "2" "2014-10-06" "163" "4"
"41" "2" "2014-10-06" "163" "1"
"41" "2" "2014-10-06" "163" "2"
"41" "2" "2014-10-06" "163" "3"
"41" "2" "2014-10-06" "163" "6"
"41" "2" "2014-10-06" "163" "1"
"41" "2" "2014-10-06" "163" "1"
"41" "2" "2014-10-06" "163" "1"
"41" "2" "2014-10-06" "163" "1"
"40" "1" "2014-10-05" "150" "2"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "3"
"40" "1" "2014-10-05" "150" "3"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "4"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "2"
"40" "1" "2014-10-05" "150" "2"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "2"
"40" "1" "2014-10-05" "150" "3"
"40" "1" "2014-10-05" "150" "1"
"40" "1" "2014-10-05" "150" "1"
"40" "7" "2014-10-04" "150" "1"
"40" "7" "2014-10-04" "150" "2"
"40" "7" "2014-10-04" "150" "5"
"40" "7" "2014-10-04" "150" "1"
"40" "7" "2014-10-04" "150" "2"
"40" "7" "2014-10-04" "150" "2"
"40" "7" "2014-10-04" "150" "5"
"40" "7" "2014-10-04" "150" "1"
"40" "7" "2014-10-04" "150" "2"
"40" "7" "2014-10-04" "150" "1"
"40" "7" "2014-10-04" "150" "5"
"40" "7" "2014-10-04" "150" "1"
"40" "7" "2014-10-04" "150" "1"
"40" "6" "2014-10-03" "150" "2"
"40" "6" "2014-10-03" "150" "1"
"40" "6" "2014-10-03" "150" "4"
"40" "6" "2014-10-03" "150" "8"
"40" "6" "2014-10-03" "150" "1"
"40" "6" "2014-10-03" "150" "1"
"40" "6" "2014-10-03" "150" "2"
"40" "6" "2014-10-03" "150" "2"
"40" "6" "2014-10-03" "150" "1"
"40" "6" "2014-10-03" "150" "2"
"40" "6" "2014-10-03" "150" "1"
"40" "6" "2014-10-03" "150" "2"
"40" "6" "2014-10-03" "150" "1"
"40" "5" "2014-10-02" "150" "2"
"40" "5" "2014-10-02" "150" "3"
"40" "5" "2014-10-02" "150" "10"
"40" "5" "2014-10-02" "150" "3"
"40" "5" "2014-10-02" "150" "3"
"40" "5" "2014-10-02" "150" "4"
"40" "5" "2014-10-02" "150" "2"
"40" "5" "2014-10-02" "150" "4"
"40" "5" "2014-10-02" "150" "1"
"40" "5" "2014-10-02" "150" "2"
"40" "5" "2014-10-02" "150" "4"
"40" "5" "2014-10-02" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "3"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
"40" "4" "2014-10-01" "150" "2"
"40" "4" "2014-10-01" "150" "1"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment