mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-21 19:45:56 +03:00
528 lines
52 KiB
Plaintext
528 lines
52 KiB
Plaintext
# -------------------------------------------------------------- #
|
|
# Test case migrated from regression test suite: bug3038c.sql
|
|
#
|
|
# Author: Daniel Lee, daniel.lee@mariadb.com
|
|
# -------------------------------------------------------------- #
|
|
#
|
|
--source ../include/have_columnstore.inc
|
|
#
|
|
USE tpch1;
|
|
#
|
|
#/* Test case from Radek at CognitiveMatch - customer who bought based on us adding the multi-value in clause feature. */
|
|
|
|
#/* Second test using myisam tables. */
|
|
--disable_warnings
|
|
drop table if exists agg_fact_pageview;
|
|
drop table if exists dim_date;
|
|
--enable_warnings
|
|
create table AGG_FACT_PAGEVIEW
|
|
(
|
|
server_day_date date ,
|
|
server_hour_24_qty smallint,
|
|
client_day_date date ,
|
|
client_hour_24_qty smallint,
|
|
organisation_name varchar(255),
|
|
domain_name varchar(255),
|
|
views int,
|
|
events int
|
|
)engine=myisam;
|
|
|
|
create table DIM_DATE
|
|
(
|
|
date_sk int ,
|
|
day_date date ,
|
|
day_name varchar(60) ,
|
|
month_sk int ,
|
|
month_number int ,
|
|
month_name varchar(60) ,
|
|
quarter_sk int ,
|
|
quarter_number int ,
|
|
quarter_name varchar(60) ,
|
|
day_of_week_number smallint ,
|
|
day_of_month_number smallint ,
|
|
days_in_month_qty smallint ,
|
|
day_of_year_number smallint ,
|
|
week_of_month_number smallint ,
|
|
week_of_year_number smallint ,
|
|
weekend_ind char(1) ,
|
|
week_of_month_name varchar(60) ,
|
|
year_quarter_name varchar(60) ,
|
|
day_of_week_sort_name varchar(60) ,
|
|
week_sk int ,
|
|
week_name varchar(60) ,
|
|
year_sk int ,
|
|
year_sort_number varchar(4) ,
|
|
year_number int
|
|
)engine=myisam;
|
|
|
|
insert into agg_fact_pageview values
|
|
('2010-08-01', 0, '2008-08-01', 0, 'net-a-porter.co.uk', 14, 0, 0),
|
|
('2010-08-01', 0, '2008-08-01', 0, 'net-a-porter.com', 17110, 70, 0),
|
|
('2010-08-01', 0, '2008-08-01', 0, 'netaporter.co.uk', 6, 0, 0),
|
|
('2010-08-01', 0, '2008-08-01', 0, 'rankings.ft.com', 104, 0, 0),
|
|
('2010-08-01', 0, '2008-08-01', 0, 'translate.googleusercontent.com', 2, 0, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'net-a-porter.co.uk', 4, 0, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'net-a-porter.com', 12904, 63, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'net-a-porter.de', 1, 0, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'netaporter.co.uk', 6, 0, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'rankings.ft.com', 108, 0, 0),
|
|
('2010-08-01', 1, '2008-08-01', 0, 'thefastfindengine.com', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'dotsearchengine.org', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'net-a-porter.co.uk', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'net-a-porter.com', 11578, 102, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'netaporter.co.uk', 2, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'polyvore.com', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'purseblog.com', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'rankings.ft.com', 49, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'translate.google.com.hk', 1, 0, 0),
|
|
('2010-08-01', 2, '2008-08-01', 0, 'translate.googleusercontent.com', 5, 0, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'net-a-porter.co.uk', 2, 0, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'net-a-porter.com', 11870, 119, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'rankings.ft.com', 23, 0, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'translate.googleusercontent.com', 25, 0, 0),
|
|
('2010-08-01', 3, '2008-08-01', 0, 'www1.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'net-a-porter.co.uk', 1, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'net-a-porter.com', 11743, 83, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'net-a-porter.ru', 6, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'netaporter.co.uk', 6, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'rankings.ft.com', 24, 0, 0),
|
|
('2010-08-01', 4, '2008-08-01', 0, 'WWW.NET-A-PORTER.COM', 1, 0, 0),
|
|
('2010-08-01', 5, '2008-08-01', 0, 'brownsfashion.com', 1, 0, 0),
|
|
('2010-08-01', 5, '2008-08-01', 0, 'net-a-porter.com', 14262, 59, 0),
|
|
('2010-08-01', 5, '2008-08-01', 0, 'netaporter.co.uk', 8, 0, 0),
|
|
('2010-08-01', 5, '2008-08-01', 0, 'rankings.ft.com', 84, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'baygaw.com', 1, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'bqgkue.com', 1, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'fanyi.youdao.com', 1, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'net-a-porter.co.uk', 4, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'net-a-porter.com', 21614, 125, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'net-a-porter.de', 2, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'netaporter.co.uk', 5, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'rankings.ft.com', 151, 0, 0),
|
|
('2010-08-01', 6, '2008-08-01', 0, 'translate.googleusercontent.com', 1, 0, 0),
|
|
('2010-08-01', 7, '2008-08-01', 0, 'fanyi.youdao.com', 1, 0, 0),
|
|
('2010-08-01', 7, '2008-08-01', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'net-a-porter.co.uk', 2, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'net-a-porter.com', 15388, 87, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'netaporter.co.uk', 12, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'rankings.ft.com', 163, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'translate.googleusercontent.com', 4, 0, 0),
|
|
('2010-08-02', 0, '2008-08-02', 0, 'www1.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'net-a-porter.co.uk', 4, 0, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'net-a-porter.com', 13303, 68, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'rankings.ft.com', 130, 0, 0),
|
|
('2010-08-02', 1, '2008-08-02', 0, 'translate.googleusercontent.com', 33, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'fanyi.youdao.com', 1, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'fullsearchengine.org', 1, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'net-a-porter.com', 12752, 74, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'netaporter.co.uk', 5, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'rankings.ft.com', 60, 0, 0),
|
|
('2010-08-02', 2, '2008-08-02', 0, 'translate.googleusercontent.com', 9, 0, 0),
|
|
('2010-08-02', 3, '2008-08-02', 0, 'net-a-porter.co.uk', 3, 0, 0),
|
|
('2010-08-02', 3, '2008-08-02', 0, 'net-a-porter.com', 13141, 68, 0),
|
|
('2010-08-02', 3, '2008-08-02', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-02', 3, '2008-08-02', 0, 'rankings.ft.com', 47, 0, 0),
|
|
('2010-08-02', 3, '2008-08-02', 0, 'translate.googleusercontent.com', 19, 0, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'net-a-porter.co.uk', 7, 0, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'net-a-porter.com', 14023, 87, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'netaporter.co.uk', 5, 0, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'rankings.ft.com', 72, 0, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'translate.googleusercontent.com', 3, 0, 0),
|
|
('2010-08-02', 4, '2008-08-02', 0, 'translate.googleusercontent.com', 3, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'altoolbar.co.kr', 2, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'fanyi.youdao.com', 1, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'net-a-porter.co.uk', 4, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'net-a-porter.com', 17468, 95, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'net-a-porter.de', 1, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'netaporter.co.uk', 9, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'rankings.ft.com', 128, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'theoutnet.com', 1, 0, 0),
|
|
('2010-08-02', 5, '2008-08-02', 0, 'translate.googleusercontent.com', 10, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'net-a-porter.co.uk', 6, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'net-a-porter.com', 27189, 153, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'net-a-porter.de', 2, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'netaporter.co.uk', 10, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'rankings.ft.com', 239, 0, 0),
|
|
('2010-08-02', 6, '2008-08-02', 0, 'translate.googleusercontent.com', 45, 0, 0),
|
|
('2010-08-02', 7, '2008-08-02', 0, 'net-a-porter.co.uk', 8, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'fanyi.youdao.com', 2, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'flash.net-a-porter.com', 2, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'net-a-porter.co.uk', 8, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'net-a-porter.com', 19853, 155, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'net-a-porter.de', 1, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'netaporter.co.uk', 9, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'rankings.ft.com', 200, 0, 0),
|
|
('2010-08-03', 0, '2008-08-03', 0, 'Www.netaporter.co.uk', 1, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'net-a-porter.co.uk', 9, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'net-a-porter.com', 15233, 105, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'net-a-porter.com.', 2, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'netaporter.co.uk', 5, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'rankings.ft.com', 121, 0, 0),
|
|
('2010-08-03', 1, '2008-08-03', 0, 'www1.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'eresearchengine.com', 1, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'net-a-porter.co.uk', 3, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'net-a-porter.com', 16662, 139, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'net-a-porter.ru', 2, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'rankings.ft.com', 41, 0, 0),
|
|
('2010-08-03', 2, '2008-08-03', 0, 'translate.googleusercontent.com', 22, 0, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'net-a-porter.co.uk', 3, 0, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'net-a-porter.com', 16678, 171, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'rankings.ft.com', 50, 0, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'translate.googleusercontent.com', 1, 0, 0),
|
|
('2010-08-03', 3, '2008-08-03', 0, 'translate.googleusercontent.com', 6, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'net-a-porter.co.uk', 6, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'net-a-porter.com', 17527, 114, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'net-a-porter.com.', 1, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'netaporter.co.uk', 2, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'rankings.ft.com', 66, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'share.hil.ntt.co.jp:18080', 9, 0, 0),
|
|
('2010-08-03', 4, '2008-08-03', 0, 'translate.googleusercontent.com', 9, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'engine.uk.cognitivematch.com', 2, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'net-a-porter.co.uk', 12, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'net-a-porter.com', 20946, 158, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'net-a-porter.com.', 2, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'net-a-porter.de', 1, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'net-a-porter.ru', 1, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'netaporter.co.uk', 14, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'rankings.ft.com', 143, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'translate.google.com.hk', 1, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'translate.googleusercontent.com', 1, 0, 0),
|
|
('2010-08-03', 5, '2008-08-03', 0, 'translate.googleusercontent.com', 4, 0, 0),
|
|
('2010-08-03', 6, '2008-08-03', 0, 'altoolbar.co.kr', 1, 0, 0),
|
|
('2010-08-03', 6, '2008-08-03', 0, 'fullsearchengine.com', 1, 0, 0),
|
|
('2010-08-03', 6, '2008-08-03', 0, 'net-a-porter.co.uk', 16, 0, 0),
|
|
('2010-08-04', 0, '2008-08-04', 0, 'net-a-porter.co.uk', 6, 0, 0),
|
|
('2010-08-04', 0, '2008-08-04', 0, 'net-a-porter.com', 17252, 166, 0),
|
|
('2010-08-04', 0, '2008-08-04', 0, 'netaporter.co.uk', 8, 0, 0),
|
|
('2010-08-04', 0, '2008-08-04', 0, 'rankings.ft.com', 138, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'flash.net-a-porter.com', 2, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'net-a-porter.co.uk', 7, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'net-a-porter.com', 14474, 66, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'net-a-porter.de', 2, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'netaporter.co.uk', 3, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'rankings.ft.com', 57, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'tbagslosangeles.com', 1, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'translate.googleusercontent.com', 2, 0, 0),
|
|
('2010-08-04', 1, '2008-08-04', 0, 'www1.net-a-porter.com', 2, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'fanyi.youdao.com', 1, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'flash.net-a-porter.com', 1, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'net-a-porter.com', 13528, 58, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'netaporter.co.uk', 7, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'phs.net.nz', 1, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'rankings.ft.com', 62, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'royalsearchengine.com', 1, 0, 0),
|
|
('2010-08-04', 2, '2008-08-04', 0, 'translate.googleusercontent.com', 2, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'flash.net-a-porter.com', 2, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'net-a-porter.co.uk', 2, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'net-a-porter.com', 14326, 75, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'net-a-porter.ru', 2, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'netaporter.co.uk', 4, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'rankings.ft.com', 52, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'toolbar.google.com', 1, 0, 0),
|
|
('2010-08-04', 3, '2008-08-04', 0, 'translate.googleusercontent.com', 6, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'altoolbar.co.kr', 1, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'net-a-porter.co.uk', 7, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'net-a-porter.com', 15697, 85, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'net-a-porter.de', 1, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'netaporter.co.uk', 3, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'rankings.ft.com', 108, 0, 0),
|
|
('2010-08-04', 4, '2008-08-04', 0, 'translate.googleusercontent.com', 19, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'flash.net-a-porter.com', 2, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'net-a-porter.co.uk', 2, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'net-a-porter.com', 21895, 142, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'net-a-porter.com.', 1, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'netaporter.co.uk', 8, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'perevod.yandex.net', 1, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'rankings.ft.com', 93, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'translate.googleusercontent.com', 1, 0, 0),
|
|
('2010-08-04', 5, '2008-08-04', 0, 'translate.googleusercontent.com', 46, 0, 0),
|
|
('2010-08-04', 6, '2008-08-04', 0, 'engine.uk.cognitivematch.com', 1, 0, 0),
|
|
('2010-08-04', 6, '2008-08-04', 0, 'flash.net-a-porter.com', 4, 0, 0),
|
|
('2010-08-04', 6, '2008-08-04', 0, 'net-a-porter.co.uk', 18, 0, 0),
|
|
('2010-08-04', 6, '2008-08-04', 0, 'net-a-porter.com', 31440, 290, 0),
|
|
('2010-08-04', 6, '2008-08-04', 0, 'net-a-porter.de', 7, 0, 0);
|
|
|
|
|
|
insert into dim_date values
|
|
(1, '2010-01-02', 'Saturday', 1, 1, 'January', 1, 1, 'Q1', 6, 2, 31, 2, 1, 1, 'Y', 'W1', 'Q12010', 'Day 6', 201001, 'W201001', 2010, '2010', 2010),
|
|
(2, '2010-01-03', 'Sunday', 1, 1, 'January', 1, 1, 'Q1', 7, 3, 31, 3, 1, 1, 'Y', 'W1', 'Q12010', 'Day 7', 201001, 'W201001', 2010, '2010', 2010),
|
|
(3, '2010-01-04', 'Monday', 1, 1, 'January', 1, 1, 'Q1', 1, 4, 31, 4, 2, 2, 'N', 'W2', 'Q12010', 'Day 1', 201002, 'W201002', 2010, '2010', 2010),
|
|
(4, '2010-01-05', 'Tuesday', 1, 1, 'January', 1, 1, 'Q1', 2, 5, 31, 5, 2, 2, 'N', 'W2', 'Q12010', 'Day 2', 201002, 'W201002', 2010, '2010', 2010),
|
|
(5, '2010-01-06', 'Wednesday', 1, 1, 'January', 1, 1, 'Q1', 3, 6, 31, 6, 2, 2, 'N', 'W2', 'Q12010', 'Day 3', 201002, 'W201002', 2010, '2010', 2010),
|
|
(6, '2010-01-07', 'Thursday', 1, 1, 'January', 1, 1, 'Q1', 4, 7, 31, 7, 2, 2, 'N', 'W2', 'Q12010', 'Day 4', 201002, 'W201002', 2010, '2010', 2010),
|
|
(7, '2010-01-08', 'Friday', 1, 1, 'January', 1, 1, 'Q1', 5, 8, 31, 8, 2, 2, 'N', 'W2', 'Q12010', 'Day 5', 201002, 'W201002', 2010, '2010', 2010),
|
|
(8, '2010-01-09', 'Saturday', 1, 1, 'January', 1, 1, 'Q1', 6, 9, 31, 9, 2, 2, 'Y', 'W2', 'Q12010', 'Day 6', 201002, 'W201002', 2010, '2010', 2010),
|
|
(9, '2010-01-10', 'Sunday', 1, 1, 'January', 1, 1, 'Q1', 7, 10, 31, 10, 2, 2, 'Y', 'W2', 'Q12010', 'Day 7', 201002, 'W201002', 2010, '2010', 2010),
|
|
(10, '2010-01-11', 'Monday', 1, 1, 'January', 1, 1, 'Q1', 1, 11, 31, 11, 3, 3, 'N', 'W3', 'Q12010', 'Day 1', 201003, 'W201003', 2010, '2010', 2010),
|
|
(11, '2010-01-12', 'Tuesday', 1, 1, 'January', 1, 1, 'Q1', 2, 12, 31, 12, 3, 3, 'N', 'W3', 'Q12010', 'Day 2', 201003, 'W201003', 2010, '2010', 2010),
|
|
(12, '2010-01-13', 'Wednesday', 1, 1, 'January', 1, 1, 'Q1', 3, 13, 31, 13, 3, 3, 'N', 'W3', 'Q12010', 'Day 3', 201003, 'W201003', 2010, '2010', 2010),
|
|
(13, '2010-01-14', 'Thursday', 1, 1, 'January', 1, 1, 'Q1', 4, 14, 31, 14, 3, 3, 'N', 'W3', 'Q12010', 'Day 4', 201003, 'W201003', 2010, '2010', 2010),
|
|
(14, '2010-01-15', 'Friday', 1, 1, 'January', 1, 1, 'Q1', 5, 15, 31, 15, 3, 3, 'N', 'W3', 'Q12010', 'Day 5', 201003, 'W201003', 2010, '2010', 2010),
|
|
(15, '2010-01-16', 'Saturday', 1, 1, 'January', 1, 1, 'Q1', 6, 16, 31, 16, 3, 3, 'Y', 'W3', 'Q12010', 'Day 6', 201003, 'W201003', 2010, '2010', 2010),
|
|
(16, '2010-01-17', 'Sunday', 1, 1, 'January', 1, 1, 'Q1', 7, 17, 31, 17, 3, 3, 'Y', 'W3', 'Q12010', 'Day 7', 201003, 'W201003', 2010, '2010', 2010),
|
|
(17, '2010-01-18', 'Monday', 1, 1, 'January', 1, 1, 'Q1', 1, 18, 31, 18, 4, 4, 'N', 'W4', 'Q12010', 'Day 1', 201004, 'W201004', 2010, '2010', 2010),
|
|
(18, '2010-01-19', 'Tuesday', 1, 1, 'January', 1, 1, 'Q1', 2, 19, 31, 19, 4, 4, 'N', 'W4', 'Q12010', 'Day 2', 201004, 'W201004', 2010, '2010', 2010),
|
|
(19, '2010-01-20', 'Wednesday', 1, 1, 'January', 1, 1, 'Q1', 3, 20, 31, 20, 4, 4, 'N', 'W4', 'Q12010', 'Day 3', 201004, 'W201004', 2010, '2010', 2010),
|
|
(20, '2010-01-21', 'Thursday', 1, 1, 'January', 1, 1, 'Q1', 4, 21, 31, 21, 4, 4, 'N', 'W4', 'Q12010', 'Day 4', 201004, 'W201004', 2010, '2010', 2010),
|
|
(21, '2010-01-22', 'Friday', 1, 1, 'January', 1, 1, 'Q1', 5, 22, 31, 22, 4, 4, 'N', 'W4', 'Q12010', 'Day 5', 201004, 'W201004', 2010, '2010', 2010),
|
|
(22, '2010-01-23', 'Saturday', 1, 1, 'January', 1, 1, 'Q1', 6, 23, 31, 23, 4, 4, 'Y', 'W4', 'Q12010', 'Day 6', 201004, 'W201004', 2010, '2010', 2010),
|
|
(23, '2010-01-24', 'Sunday', 1, 1, 'January', 1, 1, 'Q1', 7, 24, 31, 24, 4, 4, 'Y', 'W4', 'Q12010', 'Day 7', 201004, 'W201004', 2010, '2010', 2010),
|
|
(24, '2010-01-25', 'Monday', 1, 1, 'January', 1, 1, 'Q1', 1, 25, 31, 25, 5, 5, 'N', 'W5', 'Q12010', 'Day 1', 201005, 'W201005', 2010, '2010', 2010),
|
|
(25, '2010-01-26', 'Tuesday', 1, 1, 'January', 1, 1, 'Q1', 2, 26, 31, 26, 5, 5, 'N', 'W5', 'Q12010', 'Day 2', 201005, 'W201005', 2010, '2010', 2010),
|
|
(26, '2010-01-27', 'Wednesday', 1, 1, 'January', 1, 1, 'Q1', 3, 27, 31, 27, 5, 5, 'N', 'W5', 'Q12010', 'Day 3', 201005, 'W201005', 2010, '2010', 2010),
|
|
(27, '2010-01-28', 'Thursday', 1, 1, 'January', 1, 1, 'Q1', 4, 28, 31, 28, 5, 5, 'N', 'W5', 'Q12010', 'Day 4', 201005, 'W201005', 2010, '2010', 2010),
|
|
(28, '2010-01-29', 'Friday', 1, 1, 'January', 1, 1, 'Q1', 5, 29, 31, 29, 5, 5, 'N', 'W5', 'Q12010', 'Day 5', 201005, 'W201005', 2010, '2010', 2010),
|
|
(29, '2010-01-30', 'Saturday', 1, 1, 'January', 1, 1, 'Q1', 6, 30, 31, 30, 5, 5, 'Y', 'W5', 'Q12010', 'Day 6', 201005, 'W201005', 2010, '2010', 2010),
|
|
(30, '2010-01-31', 'Sunday', 1, 1, 'January', 1, 1, 'Q1', 7, 31, 31, 31, 5, 5, 'Y', 'W5', 'Q12010', 'Day 7', 201005, 'W201005', 2010, '2010', 2010),
|
|
(31, '2010-02-01', 'Monday', 2, 2, 'February', 1, 1, 'Q1', 1, 1, 28, 32, 2, 6, 'N', 'W2', 'Q12010', 'Day 1', 201006, 'W201006', 2010, '2010', 2010),
|
|
(32, '2010-02-02', 'Tuesday', 2, 2, 'February', 1, 1, 'Q1', 2, 2, 28, 33, 2, 6, 'N', 'W2', 'Q12010', 'Day 2', 201006, 'W201006', 2010, '2010', 2010),
|
|
(33, '2010-02-03', 'Wednesday', 2, 2, 'February', 1, 1, 'Q1', 3, 3, 28, 34, 2, 6, 'N', 'W2', 'Q12010', 'Day 3', 201006, 'W201006', 2010, '2010', 2010),
|
|
(34, '2010-02-04', 'Thursday', 2, 2, 'February', 1, 1, 'Q1', 4, 4, 28, 35, 2, 6, 'N', 'W2', 'Q12010', 'Day 4', 201006, 'W201006', 2010, '2010', 2010),
|
|
(35, '2010-02-05', 'Friday', 2, 2, 'February', 1, 1, 'Q1', 5, 5, 28, 36, 2, 6, 'N', 'W2', 'Q12010', 'Day 5', 201006, 'W201006', 2010, '2010', 2010),
|
|
(36, '2010-02-06', 'Saturday', 2, 2, 'February', 1, 1, 'Q1', 6, 6, 28, 37, 2, 6, 'Y', 'W2', 'Q12010', 'Day 6', 201006, 'W201006', 2010, '2010', 2010),
|
|
(37, '2010-02-07', 'Sunday', 2, 2, 'February', 1, 1, 'Q1', 7, 7, 28, 38, 2, 6, 'Y', 'W2', 'Q12010', 'Day 7', 201006, 'W201006', 2010, '2010', 2010),
|
|
(38, '2010-02-08', 'Monday', 2, 2, 'February', 1, 1, 'Q1', 1, 8, 28, 39, 3, 7, 'N', 'W3', 'Q12010', 'Day 1', 201007, 'W201007', 2010, '2010', 2010),
|
|
(39, '2010-02-09', 'Tuesday', 2, 2, 'February', 1, 1, 'Q1', 2, 9, 28, 40, 3, 7, 'N', 'W3', 'Q12010', 'Day 2', 201007, 'W201007', 2010, '2010', 2010),
|
|
(40, '2010-02-10', 'Wednesday', 2, 2, 'February', 1, 1, 'Q1', 3, 10, 28, 41, 3, 7, 'N', 'W3', 'Q12010', 'Day 3', 201007, 'W201007', 2010, '2010', 2010),
|
|
(41, '2010-02-11', 'Thursday', 2, 2, 'February', 1, 1, 'Q1', 4, 11, 28, 42, 3, 7, 'N', 'W3', 'Q12010', 'Day 4', 201007, 'W201007', 2010, '2010', 2010),
|
|
(42, '2010-02-12', 'Friday', 2, 2, 'February', 1, 1, 'Q1', 5, 12, 28, 43, 3, 7, 'N', 'W3', 'Q12010', 'Day 5', 201007, 'W201007', 2010, '2010', 2010),
|
|
(43, '2010-02-13', 'Saturday', 2, 2, 'February', 1, 1, 'Q1', 6, 13, 28, 44, 3, 7, 'Y', 'W3', 'Q12010', 'Day 6', 201007, 'W201007', 2010, '2010', 2010),
|
|
(44, '2010-02-14', 'Sunday', 2, 2, 'February', 1, 1, 'Q1', 7, 14, 28, 45, 3, 7, 'Y', 'W3', 'Q12010', 'Day 7', 201007, 'W201007', 2010, '2010', 2010),
|
|
(45, '2010-02-15', 'Monday', 2, 2, 'February', 1, 1, 'Q1', 1, 15, 28, 46, 4, 8, 'N', 'W4', 'Q12010', 'Day 1', 201008, 'W201008', 2010, '2010', 2010),
|
|
(46, '2010-02-16', 'Tuesday', 2, 2, 'February', 1, 1, 'Q1', 2, 16, 28, 47, 4, 8, 'N', 'W4', 'Q12010', 'Day 2', 201008, 'W201008', 2010, '2010', 2010),
|
|
(47, '2010-02-17', 'Wednesday', 2, 2, 'February', 1, 1, 'Q1', 3, 17, 28, 48, 4, 8, 'N', 'W4', 'Q12010', 'Day 3', 201008, 'W201008', 2010, '2010', 2010),
|
|
(48, '2010-02-18', 'Thursday', 2, 2, 'February', 1, 1, 'Q1', 4, 18, 28, 49, 4, 8, 'N', 'W4', 'Q12010', 'Day 4', 201008, 'W201008', 2010, '2010', 2010),
|
|
(49, '2010-02-19', 'Friday', 2, 2, 'February', 1, 1, 'Q1', 5, 19, 28, 50, 4, 8, 'N', 'W4', 'Q12010', 'Day 5', 201008, 'W201008', 2010, '2010', 2010),
|
|
(50, '2010-02-20', 'Saturday', 2, 2, 'February', 1, 1, 'Q1', 6, 20, 28, 51, 4, 8, 'Y', 'W4', 'Q12010', 'Day 6', 201008, 'W201008', 2010, '2010', 2010),
|
|
(51, '2010-02-21', 'Sunday', 2, 2, 'February', 1, 1, 'Q1', 7, 21, 28, 52, 4, 8, 'Y', 'W4', 'Q12010', 'Day 7', 201008, 'W201008', 2010, '2010', 2010),
|
|
(52, '2010-02-22', 'Monday', 2, 2, 'February', 1, 1, 'Q1', 1, 22, 28, 53, 5, 9, 'N', 'W5', 'Q12010', 'Day 1', 201009, 'W201009', 2010, '2010', 2010),
|
|
(53, '2010-02-23', 'Tuesday', 2, 2, 'February', 1, 1, 'Q1', 2, 23, 28, 54, 5, 9, 'N', 'W5', 'Q12010', 'Day 2', 201009, 'W201009', 2010, '2010', 2010),
|
|
(54, '2010-02-24', 'Wednesday', 2, 2, 'February', 1, 1, 'Q1', 3, 24, 28, 55, 5, 9, 'N', 'W5', 'Q12010', 'Day 3', 201009, 'W201009', 2010, '2010', 2010),
|
|
(55, '2010-02-25', 'Thursday', 2, 2, 'February', 1, 1, 'Q1', 4, 25, 28, 56, 5, 9, 'N', 'W5', 'Q12010', 'Day 4', 201009, 'W201009', 2010, '2010', 2010),
|
|
(56, '2010-02-26', 'Friday', 2, 2, 'February', 1, 1, 'Q1', 5, 26, 28, 57, 5, 9, 'N', 'W5', 'Q12010', 'Day 5', 201009, 'W201009', 2010, '2010', 2010),
|
|
(57, '2010-02-27', 'Saturday', 2, 2, 'February', 1, 1, 'Q1', 6, 27, 28, 58, 5, 9, 'Y', 'W5', 'Q12010', 'Day 6', 201009, 'W201009', 2010, '2010', 2010),
|
|
(58, '2010-02-28', 'Sunday', 2, 2, 'February', 1, 1, 'Q1', 7, 28, 28, 59, 5, 9, 'Y', 'W5', 'Q12010', 'Day 7', 201009, 'W201009', 2010, '2010', 2010),
|
|
(59, '2010-03-01', 'Monday', 3, 3, 'March', 1, 1, 'Q1', 1, 1, 31, 60, 2, 10, 'N', 'W2', 'Q12010', 'Day 1', 201010, 'W201010', 2010, '2010', 2010),
|
|
(60, '2010-03-02', 'Tuesday', 3, 3, 'March', 1, 1, 'Q1', 2, 2, 31, 61, 2, 10, 'N', 'W2', 'Q12010', 'Day 2', 201010, 'W201010', 2010, '2010', 2010),
|
|
(61, '2010-03-03', 'Wednesday', 3, 3, 'March', 1, 1, 'Q1', 3, 3, 31, 62, 2, 10, 'N', 'W2', 'Q12010', 'Day 3', 201010, 'W201010', 2010, '2010', 2010),
|
|
(62, '2010-03-04', 'Thursday', 3, 3, 'March', 1, 1, 'Q1', 4, 4, 31, 63, 2, 10, 'N', 'W2', 'Q12010', 'Day 4', 201010, 'W201010', 2010, '2010', 2010),
|
|
(63, '2010-03-05', 'Friday', 3, 3, 'March', 1, 1, 'Q1', 5, 5, 31, 64, 2, 10, 'N', 'W2', 'Q12010', 'Day 5', 201010, 'W201010', 2010, '2010', 2010),
|
|
(64, '2010-03-06', 'Saturday', 3, 3, 'March', 1, 1, 'Q1', 6, 6, 31, 65, 2, 10, 'Y', 'W2', 'Q12010', 'Day 6', 201010, 'W201010', 2010, '2010', 2010),
|
|
(65, '2010-03-07', 'Sunday', 3, 3, 'March', 1, 1, 'Q1', 7, 7, 31, 66, 2, 10, 'Y', 'W2', 'Q12010', 'Day 7', 201010, 'W201010', 2010, '2010', 2010),
|
|
(66, '2010-03-08', 'Monday', 3, 3, 'March', 1, 1, 'Q1', 1, 8, 31, 67, 3, 11, 'N', 'W3', 'Q12010', 'Day 1', 201011, 'W201011', 2010, '2010', 2010),
|
|
(67, '2010-03-09', 'Tuesday', 3, 3, 'March', 1, 1, 'Q1', 2, 9, 31, 68, 3, 11, 'N', 'W3', 'Q12010', 'Day 2', 201011, 'W201011', 2010, '2010', 2010),
|
|
(68, '2010-03-10', 'Wednesday', 3, 3, 'March', 1, 1, 'Q1', 3, 10, 31, 69, 3, 11, 'N', 'W3', 'Q12010', 'Day 3', 201011, 'W201011', 2010, '2010', 2010),
|
|
(69, '2010-03-11', 'Thursday', 3, 3, 'March', 1, 1, 'Q1', 4, 11, 31, 70, 3, 11, 'N', 'W3', 'Q12010', 'Day 4', 201011, 'W201011', 2010, '2010', 2010),
|
|
(70, '2010-03-12', 'Friday', 3, 3, 'March', 1, 1, 'Q1', 5, 12, 31, 71, 3, 11, 'N', 'W3', 'Q12010', 'Day 5', 201011, 'W201011', 2010, '2010', 2010),
|
|
(71, '2010-03-13', 'Saturday', 3, 3, 'March', 1, 1, 'Q1', 6, 13, 31, 72, 3, 11, 'Y', 'W3', 'Q12010', 'Day 6', 201011, 'W201011', 2010, '2010', 2010),
|
|
(72, '2010-03-14', 'Sunday', 3, 3, 'March', 1, 1, 'Q1', 7, 14, 31, 73, 3, 11, 'Y', 'W3', 'Q12010', 'Day 7', 201011, 'W201011', 2010, '2010', 2010),
|
|
(73, '2010-03-15', 'Monday', 3, 3, 'March', 1, 1, 'Q1', 1, 15, 31, 74, 4, 12, 'N', 'W4', 'Q12010', 'Day 1', 201012, 'W201012', 2010, '2010', 2010),
|
|
(74, '2010-03-16', 'Tuesday', 3, 3, 'March', 1, 1, 'Q1', 2, 16, 31, 75, 4, 12, 'N', 'W4', 'Q12010', 'Day 2', 201012, 'W201012', 2010, '2010', 2010),
|
|
(75, '2010-03-17', 'Wednesday', 3, 3, 'March', 1, 1, 'Q1', 3, 17, 31, 76, 4, 12, 'N', 'W4', 'Q12010', 'Day 3', 201012, 'W201012', 2010, '2010', 2010),
|
|
(76, '2010-03-18', 'Thursday', 3, 3, 'March', 1, 1, 'Q1', 4, 18, 31, 77, 4, 12, 'N', 'W4', 'Q12010', 'Day 4', 201012, 'W201012', 2010, '2010', 2010),
|
|
(77, '2010-03-19', 'Friday', 3, 3, 'March', 1, 1, 'Q1', 5, 19, 31, 78, 4, 12, 'N', 'W4', 'Q12010', 'Day 5', 201012, 'W201012', 2010, '2010', 2010),
|
|
(78, '2010-03-20', 'Saturday', 3, 3, 'March', 1, 1, 'Q1', 6, 20, 31, 79, 4, 12, 'Y', 'W4', 'Q12010', 'Day 6', 201012, 'W201012', 2010, '2010', 2010),
|
|
(79, '2010-03-21', 'Sunday', 3, 3, 'March', 1, 1, 'Q1', 7, 21, 31, 80, 4, 12, 'Y', 'W4', 'Q12010', 'Day 7', 201012, 'W201012', 2010, '2010', 2010),
|
|
(80, '2010-03-22', 'Monday', 3, 3, 'March', 1, 1, 'Q1', 1, 22, 31, 81, 5, 13, 'N', 'W5', 'Q12010', 'Day 1', 201013, 'W201013', 2010, '2010', 2010),
|
|
(81, '2010-03-23', 'Tuesday', 3, 3, 'March', 1, 1, 'Q1', 2, 23, 31, 82, 5, 13, 'N', 'W5', 'Q12010', 'Day 2', 201013, 'W201013', 2010, '2010', 2010),
|
|
(82, '2010-03-24', 'Wednesday', 3, 3, 'March', 1, 1, 'Q1', 3, 24, 31, 83, 5, 13, 'N', 'W5', 'Q12010', 'Day 3', 201013, 'W201013', 2010, '2010', 2010),
|
|
(83, '2010-03-25', 'Thursday', 3, 3, 'March', 1, 1, 'Q1', 4, 25, 31, 84, 5, 13, 'N', 'W5', 'Q12010', 'Day 4', 201013, 'W201013', 2010, '2010', 2010),
|
|
(84, '2010-03-26', 'Friday', 3, 3, 'March', 1, 1, 'Q1', 5, 26, 31, 85, 5, 13, 'N', 'W5', 'Q12010', 'Day 5', 201013, 'W201013', 2010, '2010', 2010),
|
|
(85, '2010-03-27', 'Saturday', 3, 3, 'March', 1, 1, 'Q1', 6, 27, 31, 86, 5, 13, 'Y', 'W5', 'Q12010', 'Day 6', 201013, 'W201013', 2010, '2010', 2010),
|
|
(86, '2010-03-28', 'Sunday', 3, 3, 'March', 1, 1, 'Q1', 7, 28, 31, 87, 5, 13, 'Y', 'W5', 'Q12010', 'Day 7', 201013, 'W201013', 2010, '2010', 2010),
|
|
(87, '2010-03-29', 'Monday', 3, 3, 'March', 1, 1, 'Q1', 1, 29, 31, 88, 6, 14, 'N', 'W6', 'Q12010', 'Day 1', 201014, 'W201014', 2010, '2010', 2010),
|
|
(88, '2010-03-30', 'Tuesday', 3, 3, 'March', 1, 1, 'Q1', 2, 30, 31, 89, 6, 14, 'N', 'W6', 'Q12010', 'Day 2', 201014, 'W201014', 2010, '2010', 2010),
|
|
(89, '2010-03-31', 'Wednesday', 3, 3, 'March', 1, 1, 'Q1', 3, 31, 31, 90, 6, 14, 'N', 'W6', 'Q12010', 'Day 3', 201014, 'W201014', 2010, '2010', 2010),
|
|
(90, '2010-04-01', 'Thursday', 4, 4, 'April', 2, 2, 'Q2', 4, 1, 30, 91, 1, 14, 'N', 'W1', 'Q22010', 'Day 4', 201014, 'W201014', 2010, '2010', 2010),
|
|
(91, '2010-04-02', 'Friday', 4, 4, 'April', 2, 2, 'Q2', 5, 2, 30, 92, 1, 14, 'N', 'W1', 'Q22010', 'Day 5', 201014, 'W201014', 2010, '2010', 2010),
|
|
(92, '2010-04-03', 'Saturday', 4, 4, 'April', 2, 2, 'Q2', 6, 3, 30, 93, 1, 14, 'Y', 'W1', 'Q22010', 'Day 6', 201014, 'W201014', 2010, '2010', 2010),
|
|
(93, '2010-04-04', 'Sunday', 4, 4, 'April', 2, 2, 'Q2', 7, 4, 30, 94, 1, 14, 'Y', 'W1', 'Q22010', 'Day 7', 201014, 'W201014', 2010, '2010', 2010),
|
|
(94, '2010-04-05', 'Monday', 4, 4, 'April', 2, 2, 'Q2', 1, 5, 30, 95, 2, 15, 'N', 'W2', 'Q22010', 'Day 1', 201015, 'W201015', 2010, '2010', 2010),
|
|
(95, '2010-04-06', 'Tuesday', 4, 4, 'April', 2, 2, 'Q2', 2, 6, 30, 96, 2, 15, 'N', 'W2', 'Q22010', 'Day 2', 201015, 'W201015', 2010, '2010', 2010),
|
|
(96, '2010-04-07', 'Wednesday', 4, 4, 'April', 2, 2, 'Q2', 3, 7, 30, 97, 2, 15, 'N', 'W2', 'Q22010', 'Day 3', 201015, 'W201015', 2010, '2010', 2010),
|
|
(97, '2010-04-08', 'Thursday', 4, 4, 'April', 2, 2, 'Q2', 4, 8, 30, 98, 2, 15, 'N', 'W2', 'Q22010', 'Day 4', 201015, 'W201015', 2010, '2010', 2010),
|
|
(98, '2010-04-09', 'Friday', 4, 4, 'April', 2, 2, 'Q2', 5, 9, 30, 99, 2, 15, 'N', 'W2', 'Q22010', 'Day 5', 201015, 'W201015', 2010, '2010', 2010),
|
|
(99, '2010-04-10', 'Saturday', 4, 4, 'April', 2, 2, 'Q2', 6, 10, 30, 100, 2, 15, 'Y', 'W2', 'Q22010', 'Day 6', 201015, 'W201015', 2010, '2010', 2010),
|
|
(100, '2010-04-11', 'Sunday', 4, 4, 'April', 2, 2, 'Q2', 7, 11, 30, 101, 2, 15, 'Y', 'W2', 'Q22010', 'Day 7', 201015, 'W201015', 2010, '2010', 2010),
|
|
(101, '2010-04-12', 'Monday', 4, 4, 'April', 2, 2, 'Q2', 1, 12, 30, 102, 3, 16, 'N', 'W3', 'Q22010', 'Day 1', 201016, 'W201016', 2010, '2010', 2010),
|
|
(102, '2010-04-13', 'Tuesday', 4, 4, 'April', 2, 2, 'Q2', 2, 13, 30, 103, 3, 16, 'N', 'W3', 'Q22010', 'Day 2', 201016, 'W201016', 2010, '2010', 2010),
|
|
(103, '2010-04-14', 'Wednesday', 4, 4, 'April', 2, 2, 'Q2', 3, 14, 30, 104, 3, 16, 'N', 'W3', 'Q22010', 'Day 3', 201016, 'W201016', 2010, '2010', 2010),
|
|
(104, '2010-04-15', 'Thursday', 4, 4, 'April', 2, 2, 'Q2', 4, 15, 30, 105, 3, 16, 'N', 'W3', 'Q22010', 'Day 4', 201016, 'W201016', 2010, '2010', 2010),
|
|
(105, '2010-04-16', 'Friday', 4, 4, 'April', 2, 2, 'Q2', 5, 16, 30, 106, 3, 16, 'N', 'W3', 'Q22010', 'Day 5', 201016, 'W201016', 2010, '2010', 2010),
|
|
(106, '2010-04-17', 'Saturday', 4, 4, 'April', 2, 2, 'Q2', 6, 17, 30, 107, 3, 16, 'Y', 'W3', 'Q22010', 'Day 6', 201016, 'W201016', 2010, '2010', 2010),
|
|
(107, '2010-04-18', 'Sunday', 4, 4, 'April', 2, 2, 'Q2', 7, 18, 30, 108, 3, 16, 'Y', 'W3', 'Q22010', 'Day 7', 201016, 'W201016', 2010, '2010', 2010),
|
|
(108, '2010-04-19', 'Monday', 4, 4, 'April', 2, 2, 'Q2', 1, 19, 30, 109, 4, 17, 'N', 'W4', 'Q22010', 'Day 1', 201017, 'W201017', 2010, '2010', 2010),
|
|
(109, '2010-04-20', 'Tuesday', 4, 4, 'April', 2, 2, 'Q2', 2, 20, 30, 110, 4, 17, 'N', 'W4', 'Q22010', 'Day 2', 201017, 'W201017', 2010, '2010', 2010),
|
|
(110, '2010-04-21', 'Wednesday', 4, 4, 'April', 2, 2, 'Q2', 3, 21, 30, 111, 4, 17, 'N', 'W4', 'Q22010', 'Day 3', 201017, 'W201017', 2010, '2010', 2010),
|
|
(111, '2010-04-22', 'Thursday', 4, 4, 'April', 2, 2, 'Q2', 4, 22, 30, 112, 4, 17, 'N', 'W4', 'Q22010', 'Day 4', 201017, 'W201017', 2010, '2010', 2010),
|
|
(112, '2010-04-23', 'Friday', 4, 4, 'April', 2, 2, 'Q2', 5, 23, 30, 113, 4, 17, 'N', 'W4', 'Q22010', 'Day 5', 201017, 'W201017', 2010, '2010', 2010),
|
|
(113, '2010-04-24', 'Saturday', 4, 4, 'April', 2, 2, 'Q2', 6, 24, 30, 114, 4, 17, 'Y', 'W4', 'Q22010', 'Day 6', 201017, 'W201017', 2010, '2010', 2010),
|
|
(114, '2010-04-25', 'Sunday', 4, 4, 'April', 2, 2, 'Q2', 7, 25, 30, 115, 4, 17, 'Y', 'W4', 'Q22010', 'Day 7', 201017, 'W201017', 2010, '2010', 2010),
|
|
(115, '2010-04-26', 'Monday', 4, 4, 'April', 2, 2, 'Q2', 1, 26, 30, 116, 5, 18, 'N', 'W5', 'Q22010', 'Day 1', 201018, 'W201018', 2010, '2010', 2010),
|
|
(116, '2010-04-27', 'Tuesday', 4, 4, 'April', 2, 2, 'Q2', 2, 27, 30, 117, 5, 18, 'N', 'W5', 'Q22010', 'Day 2', 201018, 'W201018', 2010, '2010', 2010),
|
|
(117, '2010-04-28', 'Wednesday', 4, 4, 'April', 2, 2, 'Q2', 3, 28, 30, 118, 5, 18, 'N', 'W5', 'Q22010', 'Day 3', 201018, 'W201018', 2010, '2010', 2010),
|
|
(118, '2010-04-29', 'Thursday', 4, 4, 'April', 2, 2, 'Q2', 4, 29, 30, 119, 5, 18, 'N', 'W5', 'Q22010', 'Day 4', 201018, 'W201018', 2010, '2010', 2010),
|
|
(119, '2010-04-30', 'Friday', 4, 4, 'April', 2, 2, 'Q2', 5, 30, 30, 120, 5, 18, 'N', 'W5', 'Q22010', 'Day 5', 201018, 'W201018', 2010, '2010', 2010),
|
|
(120, '2010-05-01', 'Saturday', 5, 5, 'May', 2, 2, 'Q2', 6, 1, 31, 121, 1, 18, 'Y', 'W1', 'Q22010', 'Day 6', 201018, 'W201018', 2010, '2010', 2010),
|
|
(121, '2010-05-02', 'Sunday', 5, 5, 'May', 2, 2, 'Q2', 7, 2, 31, 122, 1, 18, 'Y', 'W1', 'Q22010', 'Day 7', 201018, 'W201018', 2010, '2010', 2010),
|
|
(122, '2010-05-03', 'Monday', 5, 5, 'May', 2, 2, 'Q2', 1, 3, 31, 123, 2, 19, 'N', 'W2', 'Q22010', 'Day 1', 201019, 'W201019', 2010, '2010', 2010),
|
|
(123, '2010-05-04', 'Tuesday', 5, 5, 'May', 2, 2, 'Q2', 2, 4, 31, 124, 2, 19, 'N', 'W2', 'Q22010', 'Day 2', 201019, 'W201019', 2010, '2010', 2010),
|
|
(124, '2010-05-05', 'Wednesday', 5, 5, 'May', 2, 2, 'Q2', 3, 5, 31, 125, 2, 19, 'N', 'W2', 'Q22010', 'Day 3', 201019, 'W201019', 2010, '2010', 2010),
|
|
(125, '2010-05-06', 'Thursday', 5, 5, 'May', 2, 2, 'Q2', 4, 6, 31, 126, 2, 19, 'N', 'W2', 'Q22010', 'Day 4', 201019, 'W201019', 2010, '2010', 2010),
|
|
(126, '2010-05-07', 'Friday', 5, 5, 'May', 2, 2, 'Q2', 5, 7, 31, 127, 2, 19, 'N', 'W2', 'Q22010', 'Day 5', 201019, 'W201019', 2010, '2010', 2010),
|
|
(127, '2010-05-08', 'Saturday', 5, 5, 'May', 2, 2, 'Q2', 6, 8, 31, 128, 2, 19, 'Y', 'W2', 'Q22010', 'Day 6', 201019, 'W201019', 2010, '2010', 2010),
|
|
(128, '2010-05-09', 'Sunday', 5, 5, 'May', 2, 2, 'Q2', 7, 9, 31, 129, 2, 19, 'Y', 'W2', 'Q22010', 'Day 7', 201019, 'W201019', 2010, '2010', 2010),
|
|
(129, '2010-05-10', 'Monday', 5, 5, 'May', 2, 2, 'Q2', 1, 10, 31, 130, 3, 20, 'N', 'W3', 'Q22010', 'Day 1', 201020, 'W201020', 2010, '2010', 2010),
|
|
(130, '2010-05-11', 'Tuesday', 5, 5, 'May', 2, 2, 'Q2', 2, 11, 31, 131, 3, 20, 'N', 'W3', 'Q22010', 'Day 2', 201020, 'W201020', 2010, '2010', 2010),
|
|
(131, '2010-05-12', 'Wednesday', 5, 5, 'May', 2, 2, 'Q2', 3, 12, 31, 132, 3, 20, 'N', 'W3', 'Q22010', 'Day 3', 201020, 'W201020', 2010, '2010', 2010),
|
|
(132, '2010-05-13', 'Thursday', 5, 5, 'May', 2, 2, 'Q2', 4, 13, 31, 133, 3, 20, 'N', 'W3', 'Q22010', 'Day 4', 201020, 'W201020', 2010, '2010', 2010),
|
|
(133, '2010-05-14', 'Friday', 5, 5, 'May', 2, 2, 'Q2', 5, 14, 31, 134, 3, 20, 'N', 'W3', 'Q22010', 'Day 5', 201020, 'W201020', 2010, '2010', 2010),
|
|
(134, '2010-05-15', 'Saturday', 5, 5, 'May', 2, 2, 'Q2', 6, 15, 31, 135, 3, 20, 'Y', 'W3', 'Q22010', 'Day 6', 201020, 'W201020', 2010, '2010', 2010),
|
|
(135, '2010-05-16', 'Sunday', 5, 5, 'May', 2, 2, 'Q2', 7, 16, 31, 136, 3, 20, 'Y', 'W3', 'Q22010', 'Day 7', 201020, 'W201020', 2010, '2010', 2010),
|
|
(136, '2010-05-17', 'Monday', 5, 5, 'May', 2, 2, 'Q2', 1, 17, 31, 137, 4, 21, 'N', 'W4', 'Q22010', 'Day 1', 201021, 'W201021', 2010, '2010', 2010),
|
|
(137, '2010-05-18', 'Tuesday', 5, 5, 'May', 2, 2, 'Q2', 2, 18, 31, 138, 4, 21, 'N', 'W4', 'Q22010', 'Day 2', 201021, 'W201021', 2010, '2010', 2010),
|
|
(138, '2010-05-19', 'Wednesday', 5, 5, 'May', 2, 2, 'Q2', 3, 19, 31, 139, 4, 21, 'N', 'W4', 'Q22010', 'Day 3', 201021, 'W201021', 2010, '2010', 2010),
|
|
(139, '2010-05-20', 'Thursday', 5, 5, 'May', 2, 2, 'Q2', 4, 20, 31, 140, 4, 21, 'N', 'W4', 'Q22010', 'Day 4', 201021, 'W201021', 2010, '2010', 2010),
|
|
(140, '2010-05-21', 'Friday', 5, 5, 'May', 2, 2, 'Q2', 5, 21, 31, 141, 4, 21, 'N', 'W4', 'Q22010', 'Day 5', 201021, 'W201021', 2010, '2010', 2010),
|
|
(141, '2010-05-22', 'Saturday', 5, 5, 'May', 2, 2, 'Q2', 6, 22, 31, 142, 4, 21, 'Y', 'W4', 'Q22010', 'Day 6', 201021, 'W201021', 2010, '2010', 2010),
|
|
(142, '2010-05-23', 'Sunday', 5, 5, 'May', 2, 2, 'Q2', 7, 23, 31, 143, 4, 21, 'Y', 'W4', 'Q22010', 'Day 7', 201021, 'W201021', 2010, '2010', 2010),
|
|
(143, '2010-05-24', 'Monday', 5, 5, 'May', 2, 2, 'Q2', 1, 24, 31, 144, 5, 22, 'N', 'W5', 'Q22010', 'Day 1', 201022, 'W201022', 2010, '2010', 2010),
|
|
(144, '2010-05-25', 'Tuesday', 5, 5, 'May', 2, 2, 'Q2', 2, 25, 31, 145, 5, 22, 'N', 'W5', 'Q22010', 'Day 2', 201022, 'W201022', 2010, '2010', 2010),
|
|
(145, '2010-05-26', 'Wednesday', 5, 5, 'May', 2, 2, 'Q2', 3, 26, 31, 146, 5, 22, 'N', 'W5', 'Q22010', 'Day 3', 201022, 'W201022', 2010, '2010', 2010),
|
|
(146, '2010-05-27', 'Thursday', 5, 5, 'May', 2, 2, 'Q2', 4, 27, 31, 147, 5, 22, 'N', 'W5', 'Q22010', 'Day 4', 201022, 'W201022', 2010, '2010', 2010),
|
|
(147, '2010-05-28', 'Friday', 5, 5, 'May', 2, 2, 'Q2', 5, 28, 31, 148, 5, 22, 'N', 'W5', 'Q22010', 'Day 5', 201022, 'W201022', 2010, '2010', 2010),
|
|
(148, '2010-05-29', 'Saturday', 5, 5, 'May', 2, 2, 'Q2', 6, 29, 31, 149, 5, 22, 'Y', 'W5', 'Q22010', 'Day 6', 201022, 'W201022', 2010, '2010', 2010),
|
|
(149, '2010-05-30', 'Sunday', 5, 5, 'May', 2, 2, 'Q2', 7, 30, 31, 150, 5, 22, 'Y', 'W5', 'Q22010', 'Day 7', 201022, 'W201022', 2010, '2010', 2010),
|
|
(150, '2010-05-31', 'Monday', 5, 5, 'May', 2, 2, 'Q2', 1, 31, 31, 151, 6, 23, 'N', 'W6', 'Q22010', 'Day 1', 201023, 'W201023', 2010, '2010', 2010),
|
|
(151, '2010-06-01', 'Tuesday', 6, 6, 'June', 2, 2, 'Q2', 2, 1, 30, 152, 1, 23, 'N', 'W1', 'Q22010', 'Day 2', 201023, 'W201023', 2010, '2010', 2010),
|
|
(152, '2010-06-02', 'Wednesday', 6, 6, 'June', 2, 2, 'Q2', 3, 2, 30, 153, 1, 23, 'N', 'W1', 'Q22010', 'Day 3', 201023, 'W201023', 2010, '2010', 2010),
|
|
(153, '2010-06-03', 'Thursday', 6, 6, 'June', 2, 2, 'Q2', 4, 3, 30, 154, 1, 23, 'N', 'W1', 'Q22010', 'Day 4', 201023, 'W201023', 2010, '2010', 2010),
|
|
(154, '2010-06-04', 'Friday', 6, 6, 'June', 2, 2, 'Q2', 5, 4, 30, 155, 1, 23, 'N', 'W1', 'Q22010', 'Day 5', 201023, 'W201023', 2010, '2010', 2010),
|
|
(155, '2010-06-05', 'Saturday', 6, 6, 'June', 2, 2, 'Q2', 6, 5, 30, 156, 1, 23, 'Y', 'W1', 'Q22010', 'Day 6', 201023, 'W201023', 2010, '2010', 2010),
|
|
(156, '2010-06-06', 'Sunday', 6, 6, 'June', 2, 2, 'Q2', 7, 6, 30, 157, 1, 23, 'Y', 'W1', 'Q22010', 'Day 7', 201023, 'W201023', 2010, '2010', 2010),
|
|
(157, '2010-06-07', 'Monday', 6, 6, 'June', 2, 2, 'Q2', 1, 7, 30, 158, 2, 24, 'N', 'W2', 'Q22010', 'Day 1', 201024, 'W201024', 2010, '2010', 2010),
|
|
(158, '2010-06-08', 'Tuesday', 6, 6, 'June', 2, 2, 'Q2', 2, 8, 30, 159, 2, 24, 'N', 'W2', 'Q22010', 'Day 2', 201024, 'W201024', 2010, '2010', 2010),
|
|
(159, '2010-06-09', 'Wednesday', 6, 6, 'June', 2, 2, 'Q2', 3, 9, 30, 160, 2, 24, 'N', 'W2', 'Q22010', 'Day 3', 201024, 'W201024', 2010, '2010', 2010),
|
|
(160, '2010-06-10', 'Thursday', 6, 6, 'June', 2, 2, 'Q2', 4, 10, 30, 161, 2, 24, 'N', 'W2', 'Q22010', 'Day 4', 201024, 'W201024', 2010, '2010', 2010),
|
|
(161, '2010-06-11', 'Friday', 6, 6, 'June', 2, 2, 'Q2', 5, 11, 30, 162, 2, 24, 'N', 'W2', 'Q22010', 'Day 5', 201024, 'W201024', 2010, '2010', 2010),
|
|
(162, '2010-06-12', 'Saturday', 6, 6, 'June', 2, 2, 'Q2', 6, 12, 30, 163, 2, 24, 'Y', 'W2', 'Q22010', 'Day 6', 201024, 'W201024', 2010, '2010', 2010),
|
|
(163, '2010-06-13', 'Sunday', 6, 6, 'June', 2, 2, 'Q2', 7, 13, 30, 164, 2, 24, 'Y', 'W2', 'Q22010', 'Day 7', 201024, 'W201024', 2010, '2010', 2010),
|
|
(164, '2010-06-14', 'Monday', 6, 6, 'June', 2, 2, 'Q2', 1, 14, 30, 165, 3, 25, 'N', 'W3', 'Q22010', 'Day 1', 201025, 'W201025', 2010, '2010', 2010),
|
|
(165, '2010-06-15', 'Tuesday', 6, 6, 'June', 2, 2, 'Q2', 2, 15, 30, 166, 3, 25, 'N', 'W3', 'Q22010', 'Day 2', 201025, 'W201025', 2010, '2010', 2010),
|
|
(166, '2010-06-16', 'Wednesday', 6, 6, 'June', 2, 2, 'Q2', 3, 16, 30, 167, 3, 25, 'N', 'W3', 'Q22010', 'Day 3', 201025, 'W201025', 2010, '2010', 2010),
|
|
(167, '2010-06-17', 'Thursday', 6, 6, 'June', 2, 2, 'Q2', 4, 17, 30, 168, 3, 25, 'N', 'W3', 'Q22010', 'Day 4', 201025, 'W201025', 2010, '2010', 2010),
|
|
(168, '2010-06-18', 'Friday', 6, 6, 'June', 2, 2, 'Q2', 5, 18, 30, 169, 3, 25, 'N', 'W3', 'Q22010', 'Day 5', 201025, 'W201025', 2010, '2010', 2010),
|
|
(169, '2010-06-19', 'Saturday', 6, 6, 'June', 2, 2, 'Q2', 6, 19, 30, 170, 3, 25, 'Y', 'W3', 'Q22010', 'Day 6', 201025, 'W201025', 2010, '2010', 2010),
|
|
(170, '2010-06-20', 'Sunday', 6, 6, 'June', 2, 2, 'Q2', 7, 20, 30, 171, 3, 25, 'Y', 'W3', 'Q22010', 'Day 7', 201025, 'W201025', 2010, '2010', 2010),
|
|
(171, '2010-06-21', 'Monday', 6, 6, 'June', 2, 2, 'Q2', 1, 21, 30, 172, 4, 26, 'N', 'W4', 'Q22010', 'Day 1', 201026, 'W201026', 2010, '2010', 2010),
|
|
(172, '2010-06-22', 'Tuesday', 6, 6, 'June', 2, 2, 'Q2', 2, 22, 30, 173, 4, 26, 'N', 'W4', 'Q22010', 'Day 2', 201026, 'W201026', 2010, '2010', 2010),
|
|
(173, '2010-06-23', 'Wednesday', 6, 6, 'June', 2, 2, 'Q2', 3, 23, 30, 174, 4, 26, 'N', 'W4', 'Q22010', 'Day 3', 201026, 'W201026', 2010, '2010', 2010),
|
|
(174, '2010-06-24', 'Thursday', 6, 6, 'June', 2, 2, 'Q2', 4, 24, 30, 175, 4, 26, 'N', 'W4', 'Q22010', 'Day 4', 201026, 'W201026', 2010, '2010', 2010),
|
|
(175, '2010-06-25', 'Friday', 6, 6, 'June', 2, 2, 'Q2', 5, 25, 30, 176, 4, 26, 'N', 'W4', 'Q22010', 'Day 5', 201026, 'W201026', 2010, '2010', 2010),
|
|
(176, '2010-06-26', 'Saturday', 6, 6, 'June', 2, 2, 'Q2', 6, 26, 30, 177, 4, 26, 'Y', 'W4', 'Q22010', 'Day 6', 201026, 'W201026', 2010, '2010', 2010),
|
|
(177, '2010-06-27', 'Sunday', 6, 6, 'June', 2, 2, 'Q2', 7, 27, 30, 178, 4, 26, 'Y', 'W4', 'Q22010', 'Day 7', 201026, 'W201026', 2010, '2010', 2010),
|
|
(178, '2010-06-28', 'Monday', 6, 6, 'June', 2, 2, 'Q2', 1, 28, 30, 179, 5, 27, 'N', 'W5', 'Q22010', 'Day 1', 201027, 'W201027', 2010, '2010', 2010),
|
|
(179, '2010-06-29', 'Tuesday', 6, 6, 'June', 2, 2, 'Q2', 2, 29, 30, 180, 5, 27, 'N', 'W5', 'Q22010', 'Day 2', 201027, 'W201027', 2010, '2010', 2010),
|
|
(180, '2010-06-30', 'Wednesday', 6, 6, 'June', 2, 2, 'Q2', 3, 30, 30, 181, 5, 27, 'N', 'W5', 'Q22010', 'Day 3', 201027, 'W201027', 2010, '2010', 2010),
|
|
(181, '2010-07-01', 'Thursday', 7, 7, 'July', 2, 2, 'Q2', 4, 1, 31, 182, 1, 27, 'N', 'W1', 'Q22010', 'Day 4', 201027, 'W201027', 2010, '2010', 2010),
|
|
(182, '2010-07-02', 'Friday', 7, 7, 'July', 2, 2, 'Q2', 5, 2, 31, 183, 1, 27, 'N', 'W1', 'Q22010', 'Day 5', 201027, 'W201027', 2010, '2010', 2010),
|
|
(183, '2010-07-03', 'Saturday', 7, 7, 'July', 2, 2, 'Q2', 6, 3, 31, 184, 1, 27, 'Y', 'W1', 'Q22010', 'Day 6', 201027, 'W201027', 2010, '2010', 2010),
|
|
(184, '2010-07-04', 'Sunday', 7, 7, 'July', 2, 2, 'Q2', 7, 4, 31, 185, 1, 27, 'Y', 'W1', 'Q22010', 'Day 7', 201027, 'W201027', 2010, '2010', 2010),
|
|
(185, '2010-07-05', 'Monday', 7, 7, 'July', 2, 2, 'Q2', 1, 5, 31, 186, 2, 28, 'N', 'W2', 'Q22010', 'Day 1', 201028, 'W201028', 2010, '2010', 2010),
|
|
(186, '2010-07-06', 'Tuesday', 7, 7, 'July', 2, 2, 'Q2', 2, 6, 31, 187, 2, 28, 'N', 'W2', 'Q22010', 'Day 2', 201028, 'W201028', 2010, '2010', 2010),
|
|
(187, '2010-07-07', 'Wednesday', 7, 7, 'July', 2, 2, 'Q2', 3, 7, 31, 188, 2, 28, 'N', 'W2', 'Q22010', 'Day 3', 201028, 'W201028', 2010, '2010', 2010),
|
|
(188, '2010-07-08', 'Thursday', 7, 7, 'July', 2, 2, 'Q2', 4, 8, 31, 189, 2, 28, 'N', 'W2', 'Q22010', 'Day 4', 201028, 'W201028', 2010, '2010', 2010),
|
|
(189, '2010-07-09', 'Friday', 7, 7, 'July', 2, 2, 'Q2', 5, 9, 31, 190, 2, 28, 'N', 'W2', 'Q22010', 'Day 5', 201028, 'W201028', 2010, '2010', 2010),
|
|
(190, '2010-07-10', 'Saturday', 7, 7, 'July', 2, 2, 'Q2', 6, 10, 31, 191, 2, 28, 'Y', 'W2', 'Q22010', 'Day 6', 201028, 'W201028', 2010, '2010', 2010),
|
|
(191, '2010-07-11', 'Sunday', 7, 7, 'July', 2, 2, 'Q2', 7, 11, 31, 192, 2, 28, 'Y', 'W2', 'Q22010', 'Day 7', 201028, 'W201028', 2010, '2010', 2010),
|
|
(192, '2010-07-12', 'Monday', 7, 7, 'July', 2, 2, 'Q2', 1, 12, 31, 193, 3, 29, 'N', 'W3', 'Q22010', 'Day 1', 201029, 'W201029', 2010, '2010', 2010),
|
|
(193, '2010-07-13', 'Tuesday', 7, 7, 'July', 2, 2, 'Q2', 2, 13, 31, 194, 3, 29, 'N', 'W3', 'Q22010', 'Day 2', 201029, 'W201029', 2010, '2010', 2010),
|
|
(194, '2010-07-14', 'Wednesday', 7, 7, 'July', 2, 2, 'Q2', 3, 14, 31, 195, 3, 29, 'N', 'W3', 'Q22010', 'Day 3', 201029, 'W201029', 2010, '2010', 2010),
|
|
(195, '2010-07-15', 'Thursday', 7, 7, 'July', 2, 2, 'Q2', 4, 15, 31, 196, 3, 29, 'N', 'W3', 'Q22010', 'Day 4', 201029, 'W201029', 2010, '2010', 2010),
|
|
(196, '2010-07-16', 'Friday', 7, 7, 'July', 2, 2, 'Q2', 5, 16, 31, 197, 3, 29, 'N', 'W3', 'Q22010', 'Day 5', 201029, 'W201029', 2010, '2010', 2010),
|
|
(197, '2010-07-17', 'Saturday', 7, 7, 'July', 2, 2, 'Q2', 6, 17, 31, 198, 3, 29, 'Y', 'W3', 'Q22010', 'Day 6', 201029, 'W201029', 2010, '2010', 2010),
|
|
(198, '2010-07-18', 'Sunday', 7, 7, 'July', 2, 2, 'Q2', 7, 18, 31, 199, 3, 29, 'Y', 'W3', 'Q22010', 'Day 7', 201029, 'W201029', 2010, '2010', 2010),
|
|
(199, '2010-07-19', 'Monday', 7, 7, 'July', 2, 2, 'Q2', 1, 19, 31, 200, 4, 30, 'N', 'W4', 'Q22010', 'Day 1', 201030, 'W201030', 2010, '2010', 2010),
|
|
(200, '2010-07-20', 'Tuesday', 7, 7, 'July', 2, 2, 'Q2', 2, 20, 31, 201, 4, 30, 'N', 'W4', 'Q22010', 'Day 2', 201030, 'W201030', 2010, '2010', 2010),
|
|
(201, '2010-07-21', 'Wednesday', 7, 7, 'July', 2, 2, 'Q2', 3, 21, 31, 202, 4, 30, 'N', 'W4', 'Q22010', 'Day 3', 201030, 'W201030', 2010, '2010', 2010),
|
|
(202, '2010-07-22', 'Thursday', 7, 7, 'July', 2, 2, 'Q2', 4, 22, 31, 203, 4, 30, 'N', 'W4', 'Q22010', 'Day 4', 201030, 'W201030', 2010, '2010', 2010),
|
|
(203, '2010-07-23', 'Friday', 7, 7, 'July', 2, 2, 'Q2', 5, 23, 31, 204, 4, 30, 'N', 'W4', 'Q22010', 'Day 5', 201030, 'W201030', 2010, '2010', 2010),
|
|
(204, '2010-07-24', 'Saturday', 7, 7, 'July', 2, 2, 'Q2', 6, 24, 31, 205, 4, 30, 'Y', 'W4', 'Q22010', 'Day 6', 201030, 'W201030', 2010, '2010', 2010),
|
|
(205, '2010-07-28', 'Wednesday', 7, 7, 'July', 2, 2, 'Q2', 3, 28, 31, 209, 5, 31, 'N', 'W5', 'Q22010', 'Day 3', 201031, 'W201031', 2010, '2010', 2010),
|
|
(206, '2010-07-29', 'Thursday', 7, 7, 'July', 2, 2, 'Q2', 4, 29, 31, 210, 5, 31, 'N', 'W5', 'Q22010', 'Day 4', 201031, 'W201031', 2010, '2010', 2010),
|
|
(207, '2010-07-30', 'Friday', 7, 7, 'July', 2, 2, 'Q2', 5, 30, 31, 211, 5, 31, 'N', 'W5', 'Q22010', 'Day 5', 201031, 'W201031', 2010, '2010', 2010),
|
|
(208, '2010-07-31', 'Saturday', 7, 7, 'July', 2, 2, 'Q2', 6, 31, 31, 212, 5, 31, 'Y', 'W5', 'Q22010', 'Day 6', 201031, 'W201031', 2010, '2010', 2010),
|
|
(209, '2010-07-25', 'Sunday', 7, 7, 'July', 2, 2, 'Q2', 7, 25, 31, 206, 4, 30, 'Y', 'W4', 'Q22010', 'Day 7', 201030, 'W201030', 2010, '2010', 2010),
|
|
(210, '2010-07-26', 'Monday', 7, 7, 'July', 2, 2, 'Q2', 1, 26, 31, 207, 5, 31, 'N', 'W5', 'Q22010', 'Day 1', 201031, 'W201031', 2010, '2010', 2010),
|
|
(211, '2010-07-27', 'Tuesday', 7, 7, 'July', 2, 2, 'Q2', 2, 27, 31, 208, 5, 31, 'N', 'W5', 'Q22010', 'Day 2', 201031, 'W201031', 2010, '2010', 2010),
|
|
(212, '2010-08-01', 'Sunday', 8, 8, 'August', 3, 3, 'Q3', 7, 1, 31, 213, 1, 31, 'Y', 'W1', 'Q32010', 'Day 7', 201031, 'W201031', 2010, '2010', 2010),
|
|
(213, '2010-08-02', 'Monday', 8, 8, 'August', 3, 3, 'Q3', 1, 2, 31, 214, 2, 32, 'N', 'W2', 'Q32010', 'Day 1', 201032, 'W201032', 2010, '2010', 2010),
|
|
(214, '2010-08-03', 'Tuesday', 8, 8, 'August', 3, 3, 'Q3', 2, 3, 31, 215, 2, 32, 'N', 'W2', 'Q32010', 'Day 2', 201032, 'W201032', 2010, '2010', 2010),
|
|
(215, '2010-08-04', 'Wednesday', 8, 8, 'August', 3, 3, 'Q3', 3, 4, 31, 216, 2, 32, 'N', 'W2', 'Q32010', 'Day 3', 201032, 'W201032', 2010, '2010', 2010),
|
|
(216, '2010-08-05', 'Thursday', 8, 8, 'August', 3, 3, 'Q3', 4, 5, 31, 217, 2, 32, 'N', 'W2', 'Q32010', 'Day 4', 201032, 'W201032', 2010, '2010', 2010),
|
|
(217, '2010-08-06', 'Friday', 8, 8, 'August', 3, 3, 'Q3', 5, 6, 31, 218, 2, 32, 'N', 'W2', 'Q32010', 'Day 5', 201032, 'W201032', 2010, '2010', 2010),
|
|
(218, '2010-08-07', 'Saturday', 8, 8, 'August', 3, 3, 'Q3', 6, 7, 31, 219, 2, 32, 'Y', 'W2', 'Q32010', 'Day 6', 201032, 'W201032', 2010, '2010', 2010),
|
|
(219, '2010-08-08', 'Sunday', 8, 8, 'August', 3, 3, 'Q3', 7, 8, 31, 220, 2, 32, 'Y', 'W2', 'Q32010', 'Day 7', 201032, 'W201032', 2010, '2010', 2010),
|
|
(220, '2010-08-09', 'Monday', 8, 8, 'August', 3, 3, 'Q3', 1, 9, 31, 221, 3, 33, 'N', 'W3', 'Q32010', 'Day 1', 201033, 'W201033', 2010, '2010', 2010),
|
|
(221, '2010-08-10', 'Tuesday', 8, 8, 'August', 3, 3, 'Q3', 2, 10, 31, 222, 3, 33, 'N', 'W3', 'Q32010', 'Day 2', 201033, 'W201033', 2010, '2010', 2010),
|
|
(222, '2010-08-11', 'Wednesday', 8, 8, 'August', 3, 3, 'Q3', 3, 11, 31, 223, 3, 33, 'N', 'W3', 'Q32010', 'Day 3', 201033, 'W201033', 2010, '2010', 2010),
|
|
(223, '2010-08-12', 'Thursday', 8, 8, 'August', 3, 3, 'Q3', 4, 12, 31, 224, 3, 33, 'N', 'W3', 'Q32010', 'Day 4', 201033, 'W201033', 2010, '2010', 2010),
|
|
(224, '2010-08-13', 'Friday', 8, 8, 'August', 3, 3, 'Q3', 5, 13, 31, 225, 3, 33, 'N', 'W3', 'Q32010', 'Day 5', 201033, 'W201033', 2010, '2010', 2010),
|
|
(225, '2010-08-14', 'Saturday', 8, 8, 'August', 3, 3, 'Q3', 6, 14, 31, 226, 3, 33, 'Y', 'W3', 'Q32010', 'Day 6', 201033, 'W201033', 2010, '2010', 2010),
|
|
(226, '2010-08-15', 'Sunday', 8, 8, 'August', 3, 3, 'Q3', 7, 15, 31, 227, 3, 33, 'Y', 'W3', 'Q32010', 'Day 7', 201033, 'W201033', 2010, '2010', 2010),
|
|
(227, '2010-08-16', 'Monday', 8, 8, 'August', 3, 3, 'Q3', 1, 16, 31, 228, 4, 34, 'N', 'W4', 'Q32010', 'Day 1', 201034, 'W201034', 2010, '2010', 2010),
|
|
(228, '2010-08-17', 'Tuesday', 8, 8, 'August', 3, 3, 'Q3', 2, 17, 31, 229, 4, 34, 'N', 'W4', 'Q32010', 'Day 2', 201034, 'W201034', 2010, '2010', 2010),
|
|
(229, '2010-08-18', 'Wednesday', 8, 8, 'August', 3, 3, 'Q3', 3, 18, 31, 230, 4, 34, 'N', 'W4', 'Q32010', 'Day 3', 201034, 'W201034', 2010, '2010', 2010),
|
|
(230, '2010-08-19', 'Thursday', 8, 8, 'August', 3, 3, 'Q3', 4, 19, 31, 231, 4, 34, 'N', 'W4', 'Q32010', 'Day 4', 201034, 'W201034', 2010, '2010', 2010),
|
|
(231, '2010-08-20', 'Friday', 8, 8, 'August', 3, 3, 'Q3', 5, 20, 31, 232, 4, 34, 'N', 'W4', 'Q32010', 'Day 5', 201034, 'W201034', 2010, '2010', 2010),
|
|
(232, '2010-08-21', 'Saturday', 8, 8, 'August', 3, 3, 'Q3', 6, 21, 31, 233, 4, 34, 'Y', 'W4', 'Q32010', 'Day 6', 201034, 'W201034', 2010, '2010', 2010),
|
|
(233, '2010-08-22', 'Sunday', 8, 8, 'August', 3, 3, 'Q3', 7, 22, 31, 234, 4, 34, 'Y', 'W4', 'Q32010', 'Day 7', 201034, 'W201034', 2010, '2010', 2010),
|
|
(234, '2010-08-23', 'Monday', 8, 8, 'August', 3, 3, 'Q3', 1, 23, 31, 235, 5, 35, 'N', 'W5', 'Q32010', 'Day 1', 201035, 'W201035', 2010, '2010', 2010),
|
|
(235, '2010-08-24', 'Tuesday', 8, 8, 'August', 3, 3, 'Q3', 2, 24, 31, 236, 5, 35, 'N', 'W5', 'Q32010', 'Day 2', 201035, 'W201035', 2010, '2010', 2010),
|
|
(236, '2010-08-25', 'Wednesday', 8, 8, 'August', 3, 3, 'Q3', 3, 25, 31, 237, 5, 35, 'N', 'W5', 'Q32010', 'Day 3', 201035, 'W201035', 2010, '2010', 2010);
|
|
|
|
select
|
|
`DIM_DATE`.`year_number` as `c0`, `DIM_DATE`.`quarter_number` as `c1`, `DIM_DATE`.`quarter_name` as `c2`,
|
|
`DIM_DATE`.`month_number` as `c3`, `DIM_DATE`.`month_name` as `c4`, `DIM_DATE`.`week_of_year_number` as `c5`,
|
|
`DIM_DATE`.`day_of_month_number` as `c6`, `AGG_FACT_PAGEVIEW`.`organisation_name` as `c7`
|
|
from
|
|
`DIM_DATE` as `DIM_DATE`,
|
|
`AGG_FACT_PAGEVIEW` as `AGG_FACT_PAGEVIEW`
|
|
where
|
|
`AGG_FACT_PAGEVIEW`.`server_day_date` = `DIM_DATE`.`day_date`
|
|
and (`DIM_DATE`.`month_number` = 8 and `DIM_DATE`.`quarter_number` = 3 and `DIM_DATE`.`year_number` = 2010)
|
|
and ((`DIM_DATE`.`day_of_month_number`,`DIM_DATE`.`week_of_year_number`,`DIM_DATE`.`month_number`,`DIM_DATE`.`quarter_number`,`DIM_DATE`.`year_number`)
|
|
in ((1,31,8,'3',2010),(2,32,8,'3',2010),(3,32,8,'3',2010),(4,32,8,'3',2010)))
|
|
group by
|
|
`DIM_DATE`.`year_number`, `DIM_DATE`.`quarter_number`, `DIM_DATE`.`quarter_name`, `DIM_DATE`.`month_number`,
|
|
`DIM_DATE`.`month_name`, `DIM_DATE`.`week_of_year_number`,
|
|
`DIM_DATE`.`day_of_month_number`, `AGG_FACT_PAGEVIEW`.`organisation_name`
|
|
order by
|
|
ISNULL(`DIM_DATE`.`year_number`), `DIM_DATE`.`year_number` ASC, ISNULL(`DIM_DATE`.`quarter_number`),
|
|
`DIM_DATE`.`quarter_number` ASC, ISNULL(`DIM_DATE`.`month_number`), `DIM_DATE`.`month_number` ASC,
|
|
ISNULL(`DIM_DATE`.`week_of_year_number`), `DIM_DATE`.`week_of_year_number` ASC, ISNULL(`DIM_DATE`.`day_of_month_number`),
|
|
`DIM_DATE`.`day_of_month_number` ASC, ISNULL(`AGG_FACT_PAGEVIEW`.`organisation_name`), `AGG_FACT_PAGEVIEW`.`organisation_name` ASC;
|
|
|
|
|
|
--disable_warnings
|
|
drop table if exists agg_fact_pageview;
|
|
drop table if exists dim_date;
|
|
--enable_warnings
|
|
#
|
|
|