Changeset: 88de31cd8491 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/88de31cd8491
Modified Files:
sql/server/rel_optimizer.c
Branch: default
Log Message:
merged with oct2020
diffs (truncated from 465 to 300 lines):
diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -4198,10 +4198,6 @@ rel_push_aggr_down(visitor *v, sql_rel *
}
}
- u = rel_setop(v->sql->sa, ul, ur, op_union);
- rel_setop_set_exps(v->sql, u, rel_projections(v->sql, ul, NULL,
1, 1));
- set_processed(u);
-
if (rel->r) {
list *ogbe = rel->r;
@@ -4209,15 +4205,27 @@ rel_push_aggr_down(visitor *v, sql_rel *
for (n = ogbe->h; n; n = n->next) {
sql_exp *e = n->data, *ne;
+ /* group by in aggreation list */
ne = exps_uses_exp( rel->exps, e);
- if (!ne)
- continue;
- ne = list_find_exp( u->exps, ne);
+ if (ne)
+ ne = list_find_exp( ul->exps, ne);
+ if (!ne) {
+ /* e only in the ul/ur->r (group by
list) */
+ ne = exp_ref(v->sql, e);
+ list_append(ul->exps, ne);
+ ne = exp_ref(v->sql, e);
+ list_append(ur->exps, ne);
+ }
assert(ne);
ne = exp_ref(v->sql, ne);
append(gbe, ne);
}
}
+
+ u = rel_setop(v->sql->sa, ul, ur, op_union);
+ rel_setop_set_exps(v->sql, u, rel_projections(v->sql, ul, NULL,
1, 1));
+ set_processed(u);
+
exps = new_exp_list(v->sql->sa);
for (n = u->exps->h, m = rel->exps->h; n && m; n = n->next, m =
m->next) {
sql_exp *ne, *e = n->data, *oa = m->data;
diff --git a/sql/test/BugTracker-2021/Tests/All
b/sql/test/BugTracker-2021/Tests/All
--- a/sql/test/BugTracker-2021/Tests/All
+++ b/sql/test/BugTracker-2021/Tests/All
@@ -2,5 +2,6 @@ update-from-count.Bug-7079
HAVE_PYMONETDB?remote-table-ranges.Bug-7089
KNOWNFAIL?query-too-complex.Bug-7092
ntile-wrong-result.Bug-7104
+union-groupby.Bug-7108
merge-stmt.wrong-error.Bug-7109
remote-table-groupby.Bug-7110
diff --git a/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
b/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
@@ -0,0 +1,330 @@
+START TRANSACTION;
+CREATE TABLE "sys"."lineitem_denormalized_first1k_sanitised" (
+ "Customer_Gender" VARCHAR(255),
+ "Customer_Region" VARCHAR(255),
+ "Customer_Country" VARCHAR(255),
+ "Customer_State" VARCHAR(255),
+ "Customer_City" VARCHAR(255),
+ "Customer_Date_Of_Birth" TIMESTAMP,
+ "Customer_Id" BIGINT,
+ "Product_Family" VARCHAR(255),
+ "Product_Category" VARCHAR(255),
+ "Product_Subcategory" VARCHAR(255),
+ "Product_Name" VARCHAR(255),
+ "Product_Id" BIGINT,
+ "Store_Id" BIGINT,
+ "Store_Longitude" DOUBLE,
+ "Store_Latitude" DOUBLE,
+ "Store_Name" VARCHAR(255),
+ "Store_Manager" VARCHAR(255),
+ "Store_Phone_Number" VARCHAR(255),
+ "Store_Region" VARCHAR(255),
+ "Store_Country" VARCHAR(255),
+ "Store_State" VARCHAR(255),
+ "Store_City" VARCHAR(255),
+ "Order_Date" TIMESTAMP,
+ "Year_Begin_Date" TIMESTAMP,
+ "Quarter_Begin_Date" TIMESTAMP,
+ "Month_Begin_Date" TIMESTAMP,
+ "Yyyymm" BIGINT,
+ "Yyyymmdd" BIGINT,
+ "Ddmonyyyy" VARCHAR(255),
+ "Line_Price" DOUBLE,
+ "Line_Cost" DOUBLE,
+ "Line_Margin" DOUBLE,
+ "Line_Margin_Percent" DOUBLE
+);
+COPY 200 RECORDS INTO "sys"."lineitem_denormalized_first1k_sanitised" FROM
stdin USING DELIMITERS E'\t',E'\n','"';
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Clothing"
"Clothing" "Croft & Barrow Velour Separates" 1757 30 -3.2
55.95 "Edinburgh, United Kingdom" "Melody J. Hambard"
"+44-875-777-1712" "EUROPE" "United Kingdom" "Scotland"
"Edinburgh" "2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101103 "03NOV2010" 482.7 354.87 127.83 26.482
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Clothing"
"Clothing" "Men's Beanies" 2951 30 -3.2 55.95 "Edinburgh,
United Kingdom" "Melody J. Hambard" "+44-875-777-1712" "EUROPE"
"United Kingdom" "Scotland" "Edinburgh" "2010-11-03
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101103
"03NOV2010" 260.2 72.76 187.44 72.036
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Clothing"
"Clothing" "Smartwool Ski Socks" 3502 30 -3.2 55.95
"Edinburgh, United Kingdom" "Melody J. Hambard" "+44-875-777-1712"
"EUROPE" "United Kingdom" "Scotland" "Edinburgh"
"2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101103
"03NOV2010" 384.87 287.16 97.71 25.387
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Electronics"
"Digital media" "HP 8GB USB Flash Drive" 4154 30 -3.2 55.95
"Edinburgh, United Kingdom" "Melody J. Hambard" "+44-875-777-1712"
"EUROPE" "United Kingdom" "Scotland" "Edinburgh"
"2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101103
"03NOV2010" 27.04 21.24 5.8 21.449
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Electronic
entertainment" "DVD" "Smallville Complete 2nd Season (DVD)" 9352 30
-3.2 55.95 "Edinburgh, United Kingdom" "Melody J. Hambard"
"+44-875-777-1712" "EUROPE" "United Kingdom" "Scotland"
"Edinburgh" "2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101103 "03NOV2010" 47.2 34.36 12.84 27.203
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Clothing"
"Shoes" "Jean Paul Gaultier" 10103 30 -3.2 55.95 "Edinburgh,
United Kingdom" "Melody J. Hambard" "+44-875-777-1712" "EUROPE"
"United Kingdom" "Scotland" "Edinburgh" "2010-11-03
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101103
"03NOV2010" 206.76 80.54 126.22 61.046
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Health and
beauty" "Beauty" "MAC" 10682 30 -3.2 55.95 "Edinburgh,
United Kingdom" "Melody J. Hambard" "+44-875-777-1712" "EUROPE"
"United Kingdom" "Scotland" "Edinburgh" "2010-11-03
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101103
"03NOV2010" 65.44 50.28 15.16 23.166
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Automotive"
"Automotive tools" "BLAIR TORNADO ELECTRIC SHAKER" 11460 30 -3.2
55.95 "Edinburgh, United Kingdom" "Melody J. Hambard"
"+44-875-777-1712" "EUROPE" "United Kingdom" "Scotland"
"Edinburgh" "2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101103 "03NOV2010" 678.86 454.2 224.66 33.093
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Home and
garden" "Pets" "JW Pet Company Inc. JW iSqueak Bone - m (blue)"
11814 30 -3.2 55.95 "Edinburgh, United Kingdom" "Melody J.
Hambard" "+44-875-777-1712" "EUROPE" "United Kingdom"
"Scotland" "Edinburgh" "2010-11-03 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-11-01
00:00:00.000000" 201011 20101103 "03NOV2010" 14.56 8.54
6.02 41.346
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Non-consumables" "Electronic
entertainment" "Video games" "Pro Wrestling" 12762 30 -3.2
55.95 "Edinburgh, United Kingdom" "Melody J. Hambard"
"+44-875-777-1712" "EUROPE" "United Kingdom" "Scotland"
"Edinburgh" "2010-11-03 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101103 "03NOV2010" 58.35 16.95 41.4 70.951
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Snacks and candy" "Candy"
"Dark milk chocolate bar with hazelnuts and almonds" 26 110
-117.424872 41.487947 "Reno (89426) Nevada" "Keith M. Polsted"
"+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno" "2010-10-09
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 2.55 0.7 1.85 72.549
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Canned foods" "Canned
vegetables" "Whole asparagus" 66 110 -117.424872
41.487947 "Reno (89426) Nevada" "Keith M. Polsted"
"+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno" "2010-10-09
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 7.65 0.4 7.25 94.771
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Canned foods" "Canned
vegetables" "Mushrooms" 68 110 -117.424872 41.487947
"Reno (89426) Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER"
"USA" "Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 3.24 0.52
2.72 83.95
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Dairy" "Butter and milk"
"Concentrated milk (whole non-sweetened)" 106 110 -117.424872
41.487947 "Reno (89426) Nevada" "Keith M. Polsted"
"+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno" "2010-10-09
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 11.15 5.8 5.35 47.982
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Organic foods"
"Chocolates, candy and desserts" 223 110 -117.424872
41.487947 "Reno (89426) Nevada" "Keith M. Polsted"
"+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno" "2010-10-09
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 25.26 5.61 19.65 77.79
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Meat" "Chicken" "Smoked
chicken, prepared and cooked" 255 110 -117.424872 41.487947
"Reno (89426) Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER"
"USA" "Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 13.48 -0.46
13.94 103.412
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Dairy" "Butter and milk"
"Pasteurized butter" 256 110 -117.424872 41.487947 "Reno
(89426) Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA"
"Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 11.88 4.32
7.56 63.636
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Dairy" "Butter and milk"
"Croissants and pastry dough" 258 110 -117.424872 41.487947
"Reno (89426) Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER"
"USA" "Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 4.94 2.42
2.52 51.012
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Deli" "Pizza" "Pizza pies"
289 110 -117.424872 41.487947 "Reno (89426) Nevada" "Keith
M. Polsted" "+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno"
"2010-10-09 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 22.2 4.95 17.25 77.702
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Fruits"
"Currant" 10400 110 -117.424872 41.487947 "Reno (89426)
Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA"
"Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 12.78 4.74
8.04 62.91
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Fruits"
"Grapefruit" 10404 110 -117.424872 41.487947 "Reno (89426)
Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA"
"Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 4.65 0.05 4.6
98.924
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Fruits"
"Sweet Lime" 10421 110 -117.424872 41.487947 "Reno (89426)
Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA"
"Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 8.76 4
4.76 54.337
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Fruits"
"Okra" 10440 110 -117.424872 41.487947 "Reno (89426) Nevada"
"Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA" "Nevada"
"Reno" "2010-10-09 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-10-01 00:00:00.000000" 201010
20101009 "09OCT2010" 18.72 1.12 17.6 94.017
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Health foods" "Vegetables"
"Watercress" 10489 110 -117.424872 41.487947 "Reno (89426)
Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER" "USA"
"Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 8.36 0.5
7.86 94.019
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Meat" "Beef" "Veal (calves)"
10599 110 -117.424872 41.487947 "Reno (89426) Nevada" "Keith
M. Polsted" "+1-880-730-5536" "NAMER" "USA" "Nevada" "Reno"
"2010-10-09 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101009
"09OCT2010" 66.4 19.36 47.04 70.843
+"f" "APAC" "People's Republic of China" "Sichuan" "Yibin"
"1957-09-19 00:00:00.000000" 99425 "Food" "Snacks and candy"
"Cookies" "Snickerdoodle" 11438 110 -117.424872 41.487947
"Reno (89426) Nevada" "Keith M. Polsted" "+1-880-730-5536" "NAMER"
"USA" "Nevada" "Reno" "2010-10-09 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101009 "09OCT2010" 3.29 0.28
3.01 91.489
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Adult diapers" 331 57 100.51666667
13.75 "Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356"
"APAC" "Thailand" "Bangkok" "Bangkok" "2010-12-25
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 168.18 58.41 109.77 65.269
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 57 100.51666667
13.75 "Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356"
"APAC" "Thailand" "Bangkok" "Bangkok" "2010-12-25
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 95.13 51.33 43.8 46.042
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 57 100.51666667
13.75 "Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356"
"APAC" "Thailand" "Bangkok" "Bangkok" "2010-12-25
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 126.84 52.08 74.76 58.94
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 57 100.51666667
13.75 "Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356"
"APAC" "Thailand" "Bangkok" "Bangkok" "2010-12-25
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 126.84 95.52 31.32 24.692
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Photo" "Sony W310 12.1 MP 4x Optical Zoom Digital Camera" 4118 57
100.51666667 13.75 "Bangkok, Thailand" "Branson T. Grove"
"+66-350-528-2356" "APAC" "Thailand" "Bangkok" "Bangkok"
"2010-12-25 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 1172.9 295.07 877.83 74.842
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Digital media" "Auvio 20-FT HDMI Cable" 4144 57 100.51666667
13.75 "Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356"
"APAC" "Thailand" "Bangkok" "Bangkok" "2010-12-25
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 31.57 19.35 12.22 38.707
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Tablets" "GPX Boombox" 4719 57 100.51666667 13.75
"Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356" "APAC"
"Thailand" "Bangkok" "Bangkok" "2010-12-25 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101225 "25DEC2010" 3466.5 1211.16
2255.34 65.061
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Fitness" "Buy One, Get One 50% Off All Items" 8363 57
100.51666667 13.75 "Bangkok, Thailand" "Branson T. Grove"
"+66-350-528-2356" "APAC" "Thailand" "Bangkok" "Bangkok"
"2010-12-25 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 1806.68 343.6 1463.08 80.981
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronic
entertainment" "Video games" "Tomb Raider" 10068 57
100.51666667 13.75 "Bangkok, Thailand" "Branson T. Grove"
"+66-350-528-2356" "APAC" "Thailand" "Bangkok" "Bangkok"
"2010-12-25 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101225
"25DEC2010" 36.4 8.7 27.7 76.098
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Home and
garden" "Appliances" "LG - 3.7 Cu. Ft. 9-Cycle Large Capacity Washer"
10979 57 100.51666667 13.75 "Bangkok, Thailand" "Branson
T. Grove" "+66-350-528-2356" "APAC" "Thailand" "Bangkok"
"Bangkok" "2010-12-25 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101225 "25DEC2010" 6188.6 2448.44 3740.16 60.436
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Ball sports" "Basketball" 11629 57 100.51666667 13.75
"Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356" "APAC"
"Thailand" "Bangkok" "Bangkok" "2010-12-25 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101225 "25DEC2010" 14.34 8.08
6.26 43.654
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Mobile phones" "Samsung Galaxy Pro" 11717 57 100.51666667 13.75
"Bangkok, Thailand" "Branson T. Grove" "+66-350-528-2356" "APAC"
"Thailand" "Bangkok" "Bangkok" "2010-12-25 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101225 "25DEC2010" 1336.16 478.4
857.76 64.195
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Adult diapers" 331 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 168.18 91.53
76.65 45.576
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 126.84 44.4
82.44 64.995
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 95.13 54.21
40.92 43.014
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Home and
garden" "Kitchen" "Air fresheners" 1296 51
15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101217
"17DEC2010" 230.25 75.78 154.47 67.087
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Photo" "Sylvania SY-4000 Portable Digital Camera" 4119 51
15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101217
"17DEC2010" 1303.57 786.25 517.32 39.684
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Digital media" "Auvio 3-FT HDMI Cable" 4145 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 30.08 12.65
17.43 57.945
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Tablets" "DXG DXG-5B6VS High-Definition 720p HD 16 Megapixel" 4686
51 15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101217
"17DEC2010" 1588.59 1202.94 385.65 24.276
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Fitness" "Bushmaster w/ TRS-25 Red Dot" 8351 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 5748.28 3653.08
2095.2 36.449
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronic
entertainment" "Video games" "Gran Turismo" 10062 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101217
"17DEC2010" 34.6 16.38 18.22 52.658
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Home and
garden" "Appliances" "LG - 3.7 Cu. Ft. 9-Cycle Large Capacity Washer"
10979 51 15.43333333 47.06666667 "Graz, Austria" "Marjory
I. Radley" "+43-555-922-8237" "EUROPE" "Austria" "Graz"
"Graz" "2010-12-17 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101217 "17DEC2010" 6188.6 1375.2 4813.4 77.778
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Ball sports" "Basketball" 11629 51 15.43333333 47.06666667
"Graz, Austria" "Marjory I. Radley" "+43-555-922-8237" "EUROPE"
"Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 14.34 4.52
9.82 68.479
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Mobile phones" "Galaxy Pro" 11718 51 15.43333333 47.06666667
"Graz, Austria" "Marjory I. Radley" "+43-555-922-8237" "EUROPE"
"Austria" "Graz" "Graz" "2010-12-17 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101217 "17DEC2010" 619.84 486.34
133.5 21.537
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Baby diapers" 330 3 -63.56666667
44.65 "Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411"
"NAMER" "Canada" "Nova Scotia" "Halifax" "2010-12-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 52.91 41.44 11.47 21.678
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Adult diapers" 331 3 -63.56666667
44.65 "Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411"
"NAMER" "Canada" "Nova Scotia" "Halifax" "2010-12-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 168.18 66.66 101.52 60.363
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 3 -63.56666667
44.65 "Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411"
"NAMER" "Canada" "Nova Scotia" "Halifax" "2010-12-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 95.13 72.09 23.04 24.219
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Clothing"
"Clothing" "Entire Stock Of Men's Hanes Underwear" 1813 3
-63.56666667 44.65 "Halifax, Canada" "Kacie D. Denton"
"+1-867-931-7411" "NAMER" "Canada" "Nova Scotia" "Halifax"
"2010-12-15 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 145.11 99.9 45.21 31.155
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Clothing"
"Clothing" "Men's Bugaboots" 2971 3 -63.56666667 44.65
"Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411" "NAMER"
"Canada" "Nova Scotia" "Halifax" "2010-12-15 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101215 "15DEC2010" 531.96 144.48
387.48 72.84
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Clothing"
"Clothing" "Route 66 Men's Bomber Jacket" 3441 3 -63.56666667
44.65 "Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411"
"NAMER" "Canada" "Nova Scotia" "Halifax" "2010-12-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 250.36 184.58 65.78 26.274
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Digital media" "Lexar 64GB TwistTurn USB Flash Drive" 4159 3
-63.56666667 44.65 "Halifax, Canada" "Kacie D. Denton"
"+1-867-931-7411" "NAMER" "Canada" "Nova Scotia" "Halifax"
"2010-12-15 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 14.31 11.31 3 20.964
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronic
entertainment" "DVD" "Smallville Complete 5th Season (DVD)" 9355 3
-63.56666667 44.65 "Halifax, Canada" "Kacie D. Denton"
"+1-867-931-7411" "NAMER" "Canada" "Nova Scotia" "Halifax"
"2010-12-15 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 12.96 9.49 3.47 26.774
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Beauty" "Secret" 10675 3 -63.56666667
44.65 "Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411"
"NAMER" "Canada" "Nova Scotia" "Halifax" "2010-12-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 136.04 102.64 33.4 24.551
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Clothing"
"Shoes" "To Boot New York" 11357 3 -63.56666667 44.65
"Halifax, Canada" "Kacie D. Denton" "+1-867-931-7411" "NAMER"
"Canada" "Nova Scotia" "Halifax" "2010-12-15 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101215 "15DEC2010" 308.68 121.66
187.02 60.587
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronic
entertainment" "Video games" "Super Mario Sunshine" 12787 3
-63.56666667 44.65 "Halifax, Canada" "Kacie D. Denton"
"+1-867-931-7411" "NAMER" "Canada" "Nova Scotia" "Halifax"
"2010-12-15 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101215
"15DEC2010" 59.64 14.55 45.09 75.603
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 95.13 74.07
21.06 22.138
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 126.84 74.12
52.72 41.564
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Health and
beauty" "Diapers" "Wet tissues" 332 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 95.13 72.93
22.2 23.336
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Home and
garden" "Kitchen" "Toilets disinfectants" 1295 51
15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-10 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101210
"10DEC2010" 86.46 58.86 27.6 31.922
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Photo" "Sony Cyber-Shot DSC-W310 12.1 Megapixel w/ Auto Sm" 4108 51
15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-10 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101210
"10DEC2010" 929.87 417.17 512.7 55.136
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Digital media" "Auvio 6-FT HDMI Cable" 4146 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 24.47 6.05
18.42 75.275
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Tablets" "Elgato EyeTV 250 Plus" 4691 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 3711.42 2166.75
1544.67 41.619
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Fitness" "Browning A-Bolt Hunters" 8338 51 15.43333333
47.06666667 "Graz, Austria" "Marjory I. Radley" "+43-555-922-8237"
"EUROPE" "Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 5337.16 2065.96
3271.2 61.291
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronic
entertainment" "Video games" "Gran Turismo 2" 10064 51
15.43333333 47.06666667 "Graz, Austria" "Marjory I. Radley"
"+43-555-922-8237" "EUROPE" "Austria" "Graz" "Graz"
"2010-12-10 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101210
"10DEC2010" 34.3 23 11.3 32.944
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Home and
garden" "Appliances" "LG - 3.7 Cu. Ft. 9-Cycle Large Capacity Washer"
10979 51 15.43333333 47.06666667 "Graz, Austria" "Marjory
I. Radley" "+43-555-922-8237" "EUROPE" "Austria" "Graz"
"Graz" "2010-12-10 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101210 "10DEC2010" 6188.6 3898.66 2289.94 37.002
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Sports"
"Ball sports" "Football" 11630 51 15.43333333 47.06666667
"Graz, Austria" "Marjory I. Radley" "+43-555-922-8237" "EUROPE"
"Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 9.52 6.88
2.64 27.731
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Non-consumables" "Electronics"
"Mobile phones" "Galaxy Pro" 11718 51 15.43333333 47.06666667
"Graz, Austria" "Marjory I. Radley" "+43-555-922-8237" "EUROPE"
"Austria" "Graz" "Graz" "2010-12-10 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101210 "10DEC2010" 619.84 367.24
252.6 40.752
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Snacks and candy" "Candy"
"Dark milk chocolate bar with hazelnuts and almonds" 26 8
29.13333333 40.33333333 "Bursa, Turkey" "Cam Y. Dryland"
"+90-729-837-9835" "MIDDLE EAST" "Turkey" "Bursa" "Bursa"
"2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101202
"02DEC2010" 2.55 1.3 1.25 49.019
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Canned foods" "Canned
vegetables" "Whole asparagus" 66 8 29.13333333
40.33333333 "Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835"
"MIDDLE EAST" "Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 7.65 2.15 5.5
71.895
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Canned foods" "Canned
vegetables" "Other varied vegetables" 67 8 29.13333333
40.33333333 "Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835"
"MIDDLE EAST" "Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 3.9 1.56
2.34 60
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Concentrated milk (whole non-sweetened)" 106 8 29.13333333
40.33333333 "Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835"
"MIDDLE EAST" "Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 11.15 0.9
10.25 91.928
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Meat" "Chicken" "Smoked
chicken, prepared and cooked" 255 8 29.13333333 40.33333333
"Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST"
"Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 13.48 2.18
11.3 83.827
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Pasteurized butter" 256 8 29.13333333 40.33333333 "Bursa,
Turkey" "Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST"
"Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 15.84 8.88
6.96 43.939
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Croissants and pastry dough" 258 8 29.13333333 40.33333333
"Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST"
"Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 4.94 0.43
4.51 91.295
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Bakery" "Bread"
"Ordinary breads" 287 8 29.13333333 40.33333333 "Bursa,
Turkey" "Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST"
"Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 18.75 9.95 8.8
46.933
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Deli" "Pizza" "Pizza pies"
289 8 29.13333333 40.33333333 "Bursa, Turkey" "Cam Y.
Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey" "Bursa"
"Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 22.2 8.5 13.7 61.711
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Fruits"
"Pear" 10387 8 29.13333333 40.33333333 "Bursa, Turkey" "Cam Y.
Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey" "Bursa"
"Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 13.64 5.68 7.96 58.357
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Fruits"
"Key Lime" 10418 8 29.13333333 40.33333333 "Bursa, Turkey"
"Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey"
"Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 18 0.96 17.04 94.666
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Artichoke" 10444 8 29.13333333 40.33333333 "Bursa, Turkey"
"Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey"
"Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 2.02 0.96 1.06 52.475
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Shallots" 10481 8 29.13333333 40.33333333 "Bursa, Turkey"
"Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey"
"Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 17.55 1.23 16.32 92.991
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Watercress" 10489 8 29.13333333 40.33333333 "Bursa, Turkey"
"Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey"
"Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 8.36 0.54 7.82 93.54
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Meat" "Beef" "Veal (calves)"
10599 8 29.13333333 40.33333333 "Bursa, Turkey" "Cam Y.
Dryland" "+90-729-837-9835" "MIDDLE EAST" "Turkey" "Bursa"
"Bursa" "2010-12-02 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101202 "02DEC2010" 66.4 29.96 36.44 54.879
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Snacks and candy"
"Cookies" "Snickerdoodle" 11438 8 29.13333333 40.33333333
"Bursa, Turkey" "Cam Y. Dryland" "+90-729-837-9835" "MIDDLE EAST"
"Turkey" "Bursa" "Bursa" "2010-12-02 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101202 "02DEC2010" 3.29 1.05
2.24 68.085
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Snacks and candy" "Candy"
"Dark milk chocolate bar with hazelnuts and almonds" 26 27
-4.38333333 57.78333333 "Inverness, United Kingdom" "Daley N.
Morecott" "+44-702-946-9955" "EUROPE" "United Kingdom"
"Scotland" "Inverness" "2010-10-17 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101017 "17OCT2010" 2.55 0.25 2.3
90.196
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Canned foods" "Canned
vegetables" "Mushrooms" 68 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 8.1 3.9 4.2 51.851
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Concentrated milk (whole sweetened)" 107 27 -4.38333333
57.78333333 "Inverness, United Kingdom" "Daley N. Morecott"
"+44-702-946-9955" "EUROPE" "United Kingdom" "Scotland"
"Inverness" "2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-10-01 00:00:00.000000" 201010
20101017 "17OCT2010" 10.45 2.9 7.55 72.248
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Organic foods"
"Chocolates, candy and desserts" 223 27 -4.38333333
57.78333333 "Inverness, United Kingdom" "Daley N. Morecott"
"+44-702-946-9955" "EUROPE" "United Kingdom" "Scotland"
"Inverness" "2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-10-01 00:00:00.000000" 201010
20101017 "17OCT2010" 25.26 5.31 19.95 78.978
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Pasteurized butter" 256 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 15.84 1.88 13.96 88.131
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Dairy" "Butter and milk"
"Croissants and pastry dough" 258 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 4.94 1.59 3.35 67.813
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Drink" "Cold drinks" "Milk"
"Parmalat milk" 284 27 -4.38333333 57.78333333 "Inverness,
United Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 46.71 1.35 45.36 97.109
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Bakery" "Bread"
"Ordinary breads" 287 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 18.75 6.75 12 64
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Drink" "Cold drinks" "Soft drinks"
"Cola light pet 1,5l" 393 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 12.84 4.36 8.48 66.043
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Drink" "Cold drinks" "Soft drinks"
"Sach.33cl.Fruite multi" 521 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 9.76 4 5.76 59.016
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Fruits"
"Hawthorn" 10386 27 -4.38333333 57.78333333 "Inverness,
United Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 2.68 0.68 2 74.626
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Fruits"
"Mandarin" 10419 27 -4.38333333 57.78333333 "Inverness,
United Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 5 1.44 3.56 71.2
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Broccoli" 10449 27 -4.38333333 57.78333333 "Inverness,
United Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 8.72 0.6 8.12 93.119
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Squash" 10483 27 -4.38333333 57.78333333 "Inverness,
United Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 15.09 3.45 11.64 77.137
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Health foods" "Vegetables"
"Yams" 10491 27 -4.38333333 57.78333333 "Inverness, United
Kingdom" "Daley N. Morecott" "+44-702-946-9955" "EUROPE"
"United Kingdom" "Scotland" "Inverness" "2010-10-17
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 4.32 1.82 2.5 57.87
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Meat" "Beef" "Veal (calves)"
10599 27 -4.38333333 57.78333333 "Inverness, United Kingdom"
"Daley N. Morecott" "+44-702-946-9955" "EUROPE" "United
Kingdom" "Scotland" "Inverness" "2010-10-17 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101017 "17OCT2010" 66.4 3.2
63.2 95.18
+"f" "ANZ" "Australia" "Tasmania" "Greater Hobart"
"1993-03-27 00:00:00.000000" 99426 "Food" "Snacks and candy"
"Cookies" "Speculaas" 11439 27 -4.38333333 57.78333333
"Inverness, United Kingdom" "Daley N. Morecott" "+44-702-946-9955"
"EUROPE" "United Kingdom" "Scotland" "Inverness"
"2010-10-17 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-10-01 00:00:00.000000" 201010 20101017
"17OCT2010" 2.26 1.17 1.09 48.23
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Health and beauty"
"Diapers" "Baby diapers" 330 40 6.13333333 49.61666667
"Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962" "EUROPE"
"Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101201 "01DEC2010" 52.91 19.62
33.29 62.918
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Home and garden"
"Kitchen" "Water softener for irons" 534 40 6.13333333
49.61666667 "Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962"
"EUROPE" "Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101201
"01DEC2010" 100.35 45.3 55.05 54.857
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Handbags (orig $59-69)" 1951 40 6.13333333 49.61666667
"Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962" "EUROPE"
"Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101201
"01DEC2010" 62.37 28.92 33.45 53.631
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Men's Guy Harvey Short Sleeve Vintage Screen Tees" 3118 40
6.13333333 49.61666667 "Luxembourg, Luxembourg" "Lucy T. Swan"
"+352-334-2962" "EUROPE" "Luxembourg" "Luxembourg" "Luxembourg"
"2010-12-01 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101201
"01DEC2010" 288.84 186.87 101.97 35.303
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Timberland Puffer Jacket" 3586 40 6.13333333 49.61666667
"Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962" "EUROPE"
"Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101201
"01DEC2010" 269.28 88.66 180.62 67.075
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Electronic entertainment"
"DVD" "The Blind Side (DVD)" 9391 40 6.13333333 49.61666667
"Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962" "EUROPE"
"Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101201
"01DEC2010" 13.37 4.28 9.09 67.988
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Health and beauty"
"Beauty" "Secret" 10675 40 6.13333333 49.61666667
"Luxembourg, Luxembourg" "Lucy T. Swan" "+352-334-2962" "EUROPE"
"Luxembourg" "Luxembourg" "Luxembourg" "2010-12-01 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101201 "01DEC2010" 136.04 46.52
89.52 65.804
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Health and beauty"
"Personal care" "Nail care and remover" 314 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 35.92 21.88 14.04 39.086
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Health and beauty"
"Diapers" "Baby diapers" 330 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 52.91 26.61 26.3 49.707
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Home and garden"
"Kitchen" "Rubber gloves" 541 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 239.07 182.67 56.4 23.591
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Home and garden"
"Kitchen" "Salt for dishwashers" 550 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 73.68 21.09 52.59 71.376
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Home and garden"
"Kitchen" "Dish towel sponge , paper towels" 1304 37
4.63333333 52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 14.76 6.48 8.28 56.097
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Automotive" "Parts"
"Stanley 500W Inverter" 1322 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 288.84 62.28 226.56 78.437
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Caribou Creek Women's Denim Jeans" 1708 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 149.5 54.2 95.3 63.745
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Joe Boxer Table Panties" 1996 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 211.06 141.48 69.58 32.966
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Misses B.L.E.U. Apparel" 2866 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 594.24 438.76 155.48 26.164
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Electronics" "Photo"
"Kodak EasyShare C143 12 Megapixel 3x Optical Zoom" 4005 37
4.63333333 52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 3556.5 1682.76 1873.74 52.684
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Electronics" "Digital
media" "PNY 8GB USB Flash Drive" 4182 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 91.8 34.68 57.12 62.222
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Clothing"
"Women's Vanity Fair Bras" 4253 37 4.63333333 52.36666667
"Haarlem, Netherlands" "Darcy A. Boddenham" "+31-720-144-8621"
"EUROPE" "Netherlands" "Haarlem" "Haarlem" "2010-11-15
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101115
"15NOV2010" 232.16 108.68 123.48 53.187
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Jewelry"
"Men's Band Rings Stainless Steel" 7550 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 14815.98 6573.14 8242.84 55.634
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Clothing" "Shoes"
"Noir Jewelry" 10752 37 4.63333333 52.36666667 "Haarlem,
Netherlands" "Darcy A. Boddenham" "+31-720-144-8621" "EUROPE"
"Netherlands" "Haarlem" "Haarlem" "2010-11-15 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-11-01
00:00:00.000000" 201011 20101115 "15NOV2010" 934.12 543.2
390.92 41.849
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Electronics" "TV"
"Vizio 42"" Widescreen 1080p LCD HDTV" 15175 37 4.63333333
52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 1752.75 767.52 985.23 56.21
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Non-consumables" "Home and garden"
"Tools" "Stanley 12' and 25' Tape Rule Set (70-109)" 16325 37
4.63333333 52.36666667 "Haarlem, Netherlands" "Darcy A. Boddenham"
"+31-720-144-8621" "EUROPE" "Netherlands" "Haarlem"
"Haarlem" "2010-11-15 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101115 "15NOV2010" 412.35 116.7 295.65 71.698
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Oils and spices" "Sauces"
"Dehydrated sauces" 45 41 44.51666667 48.7 "Volgograd,
Russia" "Bobbi Q. Boothe" "+7-119-973-2875" "EUROPE"
"Russia" "Volgograd" "Volgograd" "2010-10-24 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 30.65 4.2
26.45 86.296
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Canned foods" "Canned vegetables"
"Peas and carrots" 76 41 44.51666667 48.7 "Volgograd,
Russia" "Bobbi Q. Boothe" "+7-119-973-2875" "EUROPE"
"Russia" "Volgograd" "Volgograd" "2010-10-24 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 1.63 0.25
1.38 84.662
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Dairy" "Desserts" "Flavoured" 87
41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q. Boothe"
"+7-119-973-2875" "EUROPE" "Russia" "Volgograd"
"Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-10-01 00:00:00.000000" 201010
20101024 "24OCT2010" 20.45 6.25 14.2 69.437
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Bakery" "Bread" "Ordinary breads"
287 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q.
Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 3.75 1.17
2.58 68.8
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Deli" "Salad bar" "Cold appetizers"
290 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q.
Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 31.12 10.28
20.84 66.966
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Health foods" "Vegetables" "Collards"
10458 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q.
Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 10.02 4.74
5.28 52.694
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Health foods" "Vegetables"
"Watercress" 10489 41 44.51666667 48.7 "Volgograd, Russia"
"Bobbi Q. Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 20.9 5
15.9 76.076
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Health foods" "Nuts" "Almond"
10492 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q.
Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 14.61 0.66
13.95 95.482
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Health foods" "Nuts" "Candlenut"
10496 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi Q.
Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 27.72 0.24
27.48 99.134
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Frozen foods" "Meat" "Frozen Domestic
Sheep (mutton)" 10594 41 44.51666667 48.7 "Volgograd,
Russia" "Bobbi Q. Boothe" "+7-119-973-2875" "EUROPE"
"Russia" "Volgograd" "Volgograd" "2010-10-24 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 57.85 17.7
40.15 69.403
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Meat" "Beef" "American Bison (buffalo
meat)" 10596 41 44.51666667 48.7 "Volgograd, Russia" "Bobbi
Q. Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 14.83 5.95
8.88 59.878
+"f" "NAMER" "USA" "California" "Cazadero" "1982-01-15
00:00:00.000000" 99427 "Food" "Frozen foods" "Frozen pizza" "Palermo's
Pizza" 11431 41 44.51666667 48.7 "Volgograd, Russia"
"Bobbi Q. Boothe" "+7-119-973-2875" "EUROPE" "Russia"
"Volgograd" "Volgograd" "2010-10-24 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-10-01
00:00:00.000000" 201010 20101024 "24OCT2010" 70.5 29.82
40.68 57.702
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Bakery" "Pastries"
"Filled snacks" 9 106 28.18333333 -25.73333333 "Pretoria,
South Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 27.21 1.44 25.77 94.707
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Snacks and candy" "Candy"
"High quality milk chocolate" 25 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 14.1 0.72 13.38 94.893
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Dairy" "Butter and milk"
"Concentrated milk (whole sweetened)" 107 106 28.18333333
-25.73333333 "Pretoria, South Africa" "Sienna O. Yaxley"
"+27-945-415-6396" "AFRICA" "South Africa" "Gauteng"
"Pretoria" "2010-12-31 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101231 "31DEC2010" 10.45 2.8 7.65 73.205
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Dairy" "Butter and milk"
"Dry milk powder" 108 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 14.56 2.16 12.4 85.164
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Organic foods"
"Cookies" 222 106 28.18333333 -25.73333333 "Pretoria,
South Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 26.67 4.35 22.32 83.689
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Oils and spices" "Mild
spices" "Granulated sugar" 241 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 7.35 0.43 6.92 94.149
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Milk"
"Parmalat milk" 284 106 28.18333333 -25.73333333 "Pretoria,
South Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 46.71 21.51 25.2 53.949
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Bakery" "Bread"
"Ordinary breads" 287 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 7.5 2.3 5.2 69.333
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Soft drinks"
"Coca cola light bt 6x33cl" 385 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 12.1 2.1 10 82.644
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Juices"
"Bk.6x20cl peneapple juice" 436 106 28.18333333 -25.73333333
"Pretoria, South Africa" "Sienna O. Yaxley" "+27-945-415-6396"
"AFRICA" "South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 12.39 5.95 6.44 51.977
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Soft drinks"
"B.1l morning orange/soybean Fruite" 529 106 28.18333333
-25.73333333 "Pretoria, South Africa" "Sienna O. Yaxley"
"+27-945-415-6396" "AFRICA" "South Africa" "Gauteng"
"Pretoria" "2010-12-31 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101231 "31DEC2010" 10.44 1.68 8.76 83.908
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Fruits"
"Plum" 10391 106 28.18333333 -25.73333333 "Pretoria, South
Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 8.44 0
8.44 100
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Fruits"
"Olive" 10413 106 28.18333333 -25.73333333 "Pretoria, South
Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 4.43 -0.14
4.57 103.16
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Fruits"
"Custard Apple" 10436 106 28.18333333 -25.73333333 "Pretoria,
South Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101231
"31DEC2010" 12.2 2.92 9.28 76.065
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Vegetables"
"Beans" 10447 106 28.18333333 -25.73333333 "Pretoria, South
Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 12.5 0.75
11.75 94
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Vegetables"
"Swede" 10484 106 28.18333333 -25.73333333 "Pretoria, South
Africa" "Sienna O. Yaxley" "+27-945-415-6396" "AFRICA"
"South Africa" "Gauteng" "Pretoria" "2010-12-31 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 8.82 3.72 5.1
57.823
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Meat" "Beef" "Veal (calves)"
10599 106 28.18333333 -25.73333333 "Pretoria, South Africa"
"Sienna O. Yaxley" "+27-945-415-6396" "AFRICA" "South Africa"
"Gauteng" "Pretoria" "2010-12-31 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 66.4 2.56
63.84 96.144
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Meat" "Duck" "Duck" 10601
106 28.18333333 -25.73333333 "Pretoria, South Africa" "Sienna
O. Yaxley" "+27-945-415-6396" "AFRICA" "South Africa"
"Gauteng" "Pretoria" "2010-12-31 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101231 "31DEC2010" 35.36 13.12
22.24 62.895
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Health and
beauty" "Personal care" "Nail care and remover" 314 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 35.92 7.4
28.52 79.398
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Kitchen" "Liquid soap" 549 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 108.42 69.63
38.79 35.777
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Kitchen" "Bristle pad" 1303 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 159.96 101.07
58.89 36.815
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Automotive"
"Parts" "Stanley Jumpstarter" 1324 19 -16.25 28.46666667 "Santa
Cruz de Tenerife, Spain" "Henderson A. Tedcastle" "+34-583-874-4753"
"EUROPE" "Spain" "Canary Islands" "Santa Cruz de Tenerife"
"2010-12-13 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101213
"13DEC2010" 279.24 115.08 164.16 58.788
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Entire Stock Of Nike For Her" 1817 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 159.82 89.38
70.44 44.074
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Girls' Arizona & Total Girl Fleece Hoodies" 1886 19
-16.25 28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A.
Tedcastle" "+34-583-874-4753" "EUROPE" "Spain" "Canary
Islands" "Santa Cruz de Tenerife" "2010-12-13 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 321.54 137.12
184.42 57.355
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Misses' Laura Scott Velour Pant" 2902 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 526.44 260.4
266.04 50.535
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Men's C.E. Schmidt Long-Sleeve Plaid Woven Shirts" 2986
19 -16.25 28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A.
Tedcastle" "+34-583-874-4753" "EUROPE" "Spain" "Canary
Islands" "Santa Cruz de Tenerife" "2010-12-13 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 228.96 117.09
111.87 48.86
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Electronics"
"Photo" "Kodak EasyShare C143 12MP Digital Camera and 8"" Di" 4008 19
-16.25 28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A.
Tedcastle" "+34-583-874-4753" "EUROPE" "Spain" "Canary
Islands" "Santa Cruz de Tenerife" "2010-12-13 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 2092.71 1401.93
690.78 33.008
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Electronics"
"Digital media" "PNY 8GB USB Flash Drive" 4181 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 100.88 54.16
46.72 46.312
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Young Men's Blue Sol Graphic Fleece" 4291 19 -16.25
28.46666667 "Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 65.38 19.58
45.8 70.052
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Jewelry" "Mens Fashion Watch" 7557 19 -16.25 28.46666667
"Santa Cruz de Tenerife, Spain" "Henderson A. Tedcastle"
"+34-583-874-4753" "EUROPE" "Spain" "Canary Islands" "Santa
Cruz de Tenerife" "2010-12-13 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101213 "13DEC2010" 7237.18 4363.92
2873.26 39.701
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Shoes" "OGIO" 10769 19 -16.25 28.46666667 "Santa Cruz de
Tenerife, Spain" "Henderson A. Tedcastle" "+34-583-874-4753"
"EUROPE" "Spain" "Canary Islands" "Santa Cruz de Tenerife"
"2010-12-13 00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101213
"13DEC2010" 1063.2 229.47 833.73 78.417
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Tools" "Stanley Heavy Duty Utility Blade Dispenser (11-921"
16332 19 -16.25 28.46666667 "Santa Cruz de Tenerife, Spain"
"Henderson A. Tedcastle" "+34-583-874-4753" "EUROPE" "Spain"
"Canary Islands" "Santa Cruz de Tenerife" "2010-12-13
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101213
"13DEC2010" 102.64 53.12 49.52 48.246
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Kitchen" "Powder detergent for delicates" 544 6
12.48333333 41.9 "Rome, Italy" "Kimberlee L. Collard"
"+39-301-686-6770" "EUROPE" "Italy" "Rome" "Rome" "2010-12-05
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101205
"05DEC2010" 26.94 20.34 6.6 24.498
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Magic Stretch Gloves" 561 6 12.48333333 41.9
"Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 132.06 84.94
47.12 35.68
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Kitchen" "Garbage bags" 1292 6 12.48333333
41.9 "Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770"
"EUROPE" "Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 66.21 42.84
23.37 35.296
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Home and
garden" "Kitchen" "Oven cleaners" 1297 6 12.48333333
41.9 "Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770"
"EUROPE" "Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 50.97 9.75
41.22 80.871
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Automotive"
"Parts" "Tailgate 150W Cup Inverter" 1325 6 12.48333333 41.9
"Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 209.44 119.72
89.72 42.838
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Dresses Misses' sizes" 1782 6 12.48333333 41.9
"Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 58.46 18.46 40
68.422
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Girls' Tops & Tees" 1922 6 12.48333333 41.9
"Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 131.38 33.9
97.48 74.196
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Men's Basic Edition Comfort Slippers" 2945 6
12.48333333 41.9 "Rome, Italy" "Kimberlee L. Collard"
"+39-301-686-6770" "EUROPE" "Italy" "Rome" "Rome" "2010-12-05
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101205
"05DEC2010" 580.28 188.84 391.44 67.457
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Clothing" "Men's Beanies" 2951 6 12.48333333 41.9 "Rome,
Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 390.3 104.4
285.9 73.251
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Electronics"
"Photo" "Kodak PlaySport HD Video Camera" 4026 6 12.48333333
41.9 "Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770"
"EUROPE" "Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 207.27 47.55
159.72 77.058
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Electronics"
"Digital media" "PNY Attache 8GB USB Flash Drive (Silver)" 4185 6
12.48333333 41.9 "Rome, Italy" "Kimberlee L. Collard"
"+39-301-686-6770" "EUROPE" "Italy" "Rome" "Rome" "2010-12-05
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101205
"05DEC2010" 138.32 101.36 36.96 26.72
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Clothing"
"Shoes" "Mountrek" 10373 6 12.48333333 41.9 "Rome, Italy"
"Kimberlee L. Collard" "+39-301-686-6770" "EUROPE" "Italy" "Rome"
"Rome" "2010-12-05 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-12-01 00:00:00.000000" 201012
20101205 "05DEC2010" 1080 445.68 634.32 58.733
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Health and
beauty" "Health care" "Royalty Free Relaxation Piano Music" 10686 6
12.48333333 41.9 "Rome, Italy" "Kimberlee L. Collard"
"+39-301-686-6770" "EUROPE" "Italy" "Rome" "Rome" "2010-12-05
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-12-01 00:00:00.000000" 201012 20101205
"05DEC2010" 55.5 31.92 23.58 42.486
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Non-consumables" "Toys" "Indoor
toys" "Huffy Uproar 16"" Bike" 15292 6 12.48333333 41.9
"Rome, Italy" "Kimberlee L. Collard" "+39-301-686-6770" "EUROPE"
"Italy" "Rome" "Rome" "2010-12-05 00:00:00.000000" "2010-01-01
00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-12-01
00:00:00.000000" 201012 20101205 "05DEC2010" 87.42 48.82
38.6 44.154
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Bakery" "Pastries"
"Filled snacks" 9 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 27.21 1.32 25.89 95.148
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Grains" "Rice"
"Pre-cooked rice" 102 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 11.52 2.34 9.18 79.687
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Dairy" "Butter and milk"
"Concentrated milk (whole sweetened)" 107 69 -43.93333333
-19.91666667 "Belo Horizonte, Brazil" "Lallie E. Chudderley"
"+55-168-133-9169" "SAMER" "Brazil" "Minas Gerais" "Belo
Horizonte" "2010-11-18 00:00:00.000000" "2010-01-01 00:00:00.000000"
"2010-10-01 00:00:00.000000" "2010-11-01 00:00:00.000000" 201011
20101118 "18NOV2010" 4.18 1.26 2.92 69.856
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Dairy" "Butter and milk"
"Dry milk powder" 108 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 14.56 2.08 12.48 85.714
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Organic foods"
"Cookies" 222 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 26.67 4.23 22.44 84.139
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Milk"
"Parmalat milk" 284 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 46.71 2.7 44.01 94.219
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Bakery" "Bread"
"Ordinary breads" 287 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 11.25 3.78 7.47 66.4
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Deli" "Salad bar" "Cold
appetizers" 290 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 15.56 1.48 14.08 90.488
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Juices"
"Bk.6x20cl peneapple juice" 436 69 -43.93333333 -19.91666667
"Belo Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 14.16 0.56 13.6 96.045
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Cold drinks" "Soft drinks"
"Boc 1l grapefruit Tropicana" 491 69 -43.93333333 -19.91666667
"Belo Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 24.22 9.52 14.7 60.693
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Drink" "Alcoholic beverages" "Beers"
"Blle 65cl Trad. Fischer" 1158 69 -43.93333333 -19.91666667
"Belo Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 44.01 8.52 35.49 80.64
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Fruits"
"Nectarines" 10390 69 -43.93333333 -19.91666667 "Belo
Horizonte, Brazil" "Lallie E. Chudderley" "+55-168-133-9169"
"SAMER" "Brazil" "Minas Gerais" "Belo Horizonte" "2010-11-18
00:00:00.000000" "2010-01-01 00:00:00.000000" "2010-10-01
00:00:00.000000" "2010-11-01 00:00:00.000000" 201011 20101118
"18NOV2010" 21.75 0.7 21.05 96.781
+"m" "MIDDLE EAST" "Turkey" "Mardin" "Yesilli"
"1951-07-12 00:00:00.000000" 99428 "Food" "Health foods" "Fruits"
"Figs" 10411 69 -43.93333333 -19.91666667 "Belo Horizonte,
Brazil" "Lallie E. Chudderley" "+55-168-133-9169" "SAMER" "Brazil"
"Minas Gerais" "Belo Horizonte" "2010-11-18 00:00:00.000000"
"2010-01-01 00:00:00.000000" "2010-10-01 00:00:00.000000" "2010-11-01
00:00:00.000000" 201011 20101118 "18NOV2010" 2.19 0
2.19 100
+
+with "t3ick" as (select "t1jc"."Customer_Gender", "t1jc"."Customer_Region",
"t1jc"."Customer_Country", "t1jc"."Customer_State", "t1jc"."Customer_City",
"t1jc"."Customer_Date_Of_Birth", "t1jc"."Customer_Id", "t1jc"."Product_Family",
"t1jc"."Product_Category", "t1jc"."Product_Subcategory",
+"t1jc"."Product_Name", "t1jc"."Product_Id", "t1jc"."Store_Id",
"t1jc"."Store_Longitude", "t1jc"."Store_Latitude", "t1jc"."Store_Name",
"t1jc"."Store_Manager", "t1jc"."Store_Phone_Number", "t1jc"."Store_Region",
"t1jc"."Store_Country", "t1jc"."Store_State", "t1jc"."Store_City",
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
