Changeset: 17a18f096841 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/17a18f096841
Added Files:
sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.test
Removed Files:
sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.stable.err
sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.stable.out
Branch: default
Log Message:
Converted test
diffs (truncated from 756 to 300 lines):
diff --git a/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
b/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
deleted file mode 100644
--- a/sql/test/BugTracker-2021/Tests/union-groupby.Bug-7108.sql
+++ /dev/null
@@ -1,330 +0,0 @@
-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",
-"t1jc"."Order_Date", "t1jc"."Year_Begin_Date", "t1jc"."Quarter_Begin_Date",
"t1jc"."Month_Begin_Date", "t1jc"."Yyyymm", "t1jc"."Yyyymmdd",
"t1jc"."Ddmonyyyy", "t1jc"."Line_Price", "t1jc"."Line_Cost",
"t1jc"."Line_Margin", "t1jc"."Line_Margin_Percent"
-from "lineitem_denormalized_first1k_sanitised" as "t1jc" where
"Line_Margin_Percent" = '0x1.7775c28f5c28fp6'), "t3idm" 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", "t1jc"."Order_Date", "t1jc"."Year_Begin_Date",
"t1jc"."Quarter_Begin_Date", "t1jc"."Month_Begin_Date",
-"t1jc"."Yyyymm", "t1jc"."Yyyymmdd", "t1jc"."Ddmonyyyy", "t1jc"."Line_Price",
"t1jc"."Line_Cost", "t1jc"."Line_Margin", "t1jc"."Line_Margin_Percent" from
"lineitem_denormalized_first1k_sanitised" as "t1jc"
-where ("Line_Margin_Percent" is null or "Line_Margin_Percent" <>
'0x1.35b95810624ddp6')), "t3idx" 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",
"t1jc"."Order_Date",
-"t1jc"."Year_Begin_Date", "t1jc"."Quarter_Begin_Date",
"t1jc"."Month_Begin_Date", "t1jc"."Yyyymm", "t1jc"."Yyyymmdd",
"t1jc"."Ddmonyyyy", "t1jc"."Line_Price", "t1jc"."Line_Cost",
"t1jc"."Line_Margin", "t1jc"."Line_Margin_Percent"
-from "lineitem_denormalized_first1k_sanitised" as "t1jc" where
("Line_Margin_Percent" is null or "Line_Margin_Percent" <>
'0x1.35b95810624ddp6')), "t3idb" 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",
-"t1jc"."Order_Date", "t1jc"."Year_Begin_Date", "t1jc"."Quarter_Begin_Date",
"t1jc"."Month_Begin_Date", "t1jc"."Yyyymm", "t1jc"."Yyyymmdd",
"t1jc"."Ddmonyyyy", "t1jc"."Line_Price", "t1jc"."Line_Cost",
"t1jc"."Line_Margin", "t1jc"."Line_Margin_Percent"
-from "lineitem_denormalized_first1k_sanitised" as "t1jc" where
("Line_Margin_Percent" is null or "Line_Margin_Percent" <>
'0x1.35b95810624ddp6')), "t3id0" 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",
"t1jc"."Order_Date", "t1jc"."Year_Begin_Date", "t1jc"."Quarter_Begin_Date",
"t1jc"."Month_Begin_Date", "t1jc"."Yyyymm", "t1jc"."Yyyymmdd",
-"t1jc"."Ddmonyyyy", "t1jc"."Line_Price", "t1jc"."Line_Cost",
"t1jc"."Line_Margin", "t1jc"."Line_Margin_Percent" from
"lineitem_denormalized_first1k_sanitised" as "t1jc" where
("Line_Margin_Percent" is null or "Line_Margin_Percent" <>
'0x1.35b95810624ddp6'))
-select "t3ifg"."c3if7_source_6325213786828233216",
"t3ifh"."c3iff_mode_customer_gender" from (select
"t3if6"."c3iex_source_6325213786828233216" as
"c3if7_source_6325213786828233216" from (select 'Left, Right' as
"c3iex_source_6325213786828233216",
-"t3if4"."c3icl_customer_gender" as "c3iey_customer_gender",
"t3if4"."c3icx_mode_customer_state" as "c3if0_customer_state__mode_",
"t3if4"."c3icm_customer_region" as "c3iez_customer_region",
"t3if4"."c3icn_record_count" as "c3if3_record_count",
"t3if5"."c3iei_grouping_names"
-as "c3if1_grouping_names", "t3if5"."c3iej_measure_names" as
"c3if2_measure_names" from (select "t3icy"."c3icl_customer_gender",
"t3icy"."c3icm_customer_region", "t3icy"."c3icn_record_count",
"t3icz"."c3icx_mode_customer_state" from (select "t3ick"."Customer_Gender" as
-"c3icl_customer_gender", "t3ick"."Customer_Region" as "c3icm_customer_region",
count(*) as "c3icn_record_count" from "t3ick" group by
"t3ick"."Customer_Gender", "t3ick"."Customer_Region") as "t3icy" left outer
join (select "t3icw"."c3icu_modegrp_c3ico_modegrp_custome",
-"t3icw"."c3icv_modegrp_c3icp_modegrp_custome", case when count(*) = 1 then
max("t3icw"."c3icq_modeclmn_customer_state") else cast(null as VARCHAR(255))
end as "c3icx_mode_customer_state" from (select c3icq_modeclmn_customer_state,
c3ico_modegrp_customer_gender as
-"c3icu_modegrp_c3ico_modegrp_custome", c3icp_modegrp_customer_region as
"c3icv_modegrp_c3icp_modegrp_custome", rank() over (partition by
"c3ico_modegrp_customer_gender", "c3icp_modegrp_customer_region" order by
"c3icr_modecnt_customer_state" desc) as "c3ict_mode_rank"
-from (select "t3ick"."Customer_Gender" as "c3ico_modegrp_customer_gender",
"t3ick"."Customer_Region" as "c3icp_modegrp_customer_region",
max("t3ick"."Customer_State") as "c3icq_modeclmn_customer_state", count(*) as
"c3icr_modecnt_customer_state" from "t3ick" where
-"t3ick"."Customer_State" is not null group by "t3ick"."Customer_Gender",
"t3ick"."Customer_Region", "t3ick"."Customer_State") as "t3ics") as "t3icw"
where "t3icw"."c3ict_mode_rank" = 1 group by
"c3icu_modegrp_c3ico_modegrp_custome", "c3icv_modegrp_c3icp_modegrp_custome")
-as "t3icz" on (("t3icy"."c3icl_customer_gender" =
"t3icz"."c3icu_modegrp_c3ico_modegrp_custome" or
("t3icy"."c3icl_customer_gender" is null and
"t3icz"."c3icu_modegrp_c3ico_modegrp_custome" is null)) and
("t3icy"."c3icm_customer_region" = "t3icz"."c3icv_modegrp_c3icp_modegrp_custome"
-or ("t3icy"."c3icm_customer_region" is null and
"t3icz"."c3icv_modegrp_c3icp_modegrp_custome" is null)))) as "t3if4" join
(select "t3iew"."c3iei_grouping_names", "t3iew"."c3iej_measure_names",
"t3iew"."c3iek_customer_city__mode_", "t3iew"."c3iel_measure_values" from
-((select "t3ies"."c3iei_grouping_names" as "c3iei_grouping_names",
"t3ies"."c3iej_measure_names" as "c3iej_measure_names",
"t3ies"."c3iek_customer_city__mode_" as "c3iek_customer_city__mode_",
"t3ies"."c3iel_measure_values" as "c3iel_measure_values" from
-(select 'Customer_Gender' as "c3iei_grouping_names", 'Customer_State
(Singleton)' as "c3iej_measure_names", "c3ids_mode_customer_city" as
"c3iek_customer_city__mode_", "c3idu_customer_state__singleton__2" as
"c3iel_measure_values" from (select "t3idw"."c3ids_mode_customer_city",
-"t3idv"."c3idt_record_count", "t3idv"."c3idu_customer_state__singleton__2"
from (select count(*) as "c3idt_record_count", case when
(count("t3idm"."Customer_State") = count(*) and count(distinct
"t3idm"."Customer_State") = 1) then min("t3idm"."Customer_State") else null
-end as "c3idu_customer_state__singleton__2" from "t3idm") as "t3idv" left
outer join (select case when count(*) = 1 then
max("t3idr"."c3idn_modeclmn_customer_city") else cast(null as VARCHAR(255)) end
as "c3ids_mode_customer_city" from (select c3idn_modeclmn_customer_city,
-rank() over (order by "c3ido_modecnt_customer_city" desc) as "c3idq_mode_rank"
from (select "t3idm"."Customer_City" as "c3idn_modeclmn_customer_city",
count(*) as "c3ido_modecnt_customer_city" from "t3idm" where
"t3idm"."Customer_City" is not null group by "t3idm"."Customer_City")
-as "t3idp") as "t3idr" where "t3idr"."c3idq_mode_rank" = 1) as "t3idw" on 1 =
1) as "t3iem") as "t3ies") union all (select "t3iet"."c3ien_grouping_names" as
"c3iei_grouping_names", "t3iet"."c3ieo_measure_names" as "c3iej_measure_names",
"t3iet"."c3iep_customer_city__mode_"
-as "c3iek_customer_city__mode_", "t3iet"."c3ieq_measure_values" as
"c3iel_measure_values" from (select 'Customer_Region' as
"c3ien_grouping_names", 'Customer_State (Singleton)' as "c3ieo_measure_names",
"c3ie3_mode_customer_city" as "c3iep_customer_city__mode_",
-"c3ie5_customer_state__singleton__2" as "c3ieq_measure_values" from (select
"t3ie7"."c3ie3_mode_customer_city", "t3ie6"."c3ie4_record_count_2",
"t3ie6"."c3ie5_customer_state__singleton__2" from (select count(*) as
"c3ie4_record_count_2", case when
-(count("t3idx"."Customer_State") = count(*) and count(distinct
"t3idx"."Customer_State") = 1) then min("t3idx"."Customer_State") else null end
as "c3ie5_customer_state__singleton__2" from "t3idx") as "t3ie6" left outer
join (select case when count(*) = 1
-then max("t3ie2"."c3idy_modeclmn_customer_city") else cast(null as
VARCHAR(255)) end as "c3ie3_mode_customer_city" from (select
c3idy_modeclmn_customer_city, rank() over (order by
"c3idz_modecnt_customer_city" desc) as "c3ie1_mode_rank" from (select
"t3idx"."Customer_City"
-as "c3idy_modeclmn_customer_city", count(*) as "c3idz_modecnt_customer_city"
from "t3idx" where "t3idx"."Customer_City" is not null group by
"t3idx"."Customer_City") as "t3ie0") as "t3ie2" where "t3ie2"."c3ie1_mode_rank"
= 1) as "t3ie7" on 1 = 1) as "t3ier") as
-"t3iet") union all (select "t3ieu"."c3ied_grouping_names" as
"c3iei_grouping_names", "t3ieu"."c3iee_measure_names" as "c3iej_measure_names",
"t3ieu"."c3ief_customer_city__mode_" as "c3iek_customer_city__mode_",
"t3ieu"."c3ieg_measure_values" as "c3iel_measure_values"
-from (select 'Customer_Gender' as "c3ied_grouping_names", 'Customer_Country
(Singleton)' as "c3iee_measure_names", "c3idh_mode_customer_city" as
"c3ief_customer_city__mode_", "c3idj_customer_country__singleton__" as
"c3ieg_measure_values" from (select
-"t3idl"."c3idh_mode_customer_city", "t3idk"."c3idi_record_count",
"t3idk"."c3idj_customer_country__singleton__" from (select count(*) as
"c3idi_record_count", case when (count("t3idb"."Customer_Country") = count(*)
and count(distinct "t3idb"."Customer_Country") = 1)
-then min("t3idb"."Customer_Country") else null end as
"c3idj_customer_country__singleton__" from "t3idb") as "t3idk" left outer join
(select case when count(*) = 1 then max("t3idg"."c3idc_modeclmn_customer_city")
else cast(null as VARCHAR(255)) end as
-"c3idh_mode_customer_city" from (select c3idc_modeclmn_customer_city, rank()
over (order by "c3idd_modecnt_customer_city" desc) as "c3idf_mode_rank" from
(select "t3idb"."Customer_City" as "c3idc_modeclmn_customer_city", count(*) as
"c3idd_modecnt_customer_city"
-from "t3idb" where "t3idb"."Customer_City" is not null group by
"t3idb"."Customer_City") as "t3ide") as "t3idg" where "t3idg"."c3idf_mode_rank"
= 1) as "t3idl" on 1 = 1) as "t3ieh") as "t3ieu") union all (select
"t3iev"."c3ie8_grouping_names" as "c3iei_grouping_names",
-"t3iev"."c3ie9_measure_names" as "c3iej_measure_names",
"t3iev"."c3iea_customer_city__mode_" as "c3iek_customer_city__mode_",
"t3iev"."c3ieb_measure_values" as "c3iel_measure_values" from (select
'Customer_Region' as "c3ie8_grouping_names", 'Customer_Country (Singleton)' as
-"c3ie9_measure_names", "c3id6_mode_customer_city" as
"c3iea_customer_city__mode_", "c3id8_customer_country__singleton__" as
"c3ieb_measure_values" from (select "t3ida"."c3id6_mode_customer_city",
"t3id9"."c3id7_record_count_2", "t3id9"."c3id8_customer_country__singleton__"
-from (select count(*) as "c3id7_record_count_2", case when
(count("t3id0"."Customer_Country") = count(*) and count(distinct
"t3id0"."Customer_Country") = 1) then min("t3id0"."Customer_Country") else null
end as "c3id8_customer_country__singleton__" from "t3id0") as "t3id9"
-left outer join (select case when count(*) = 1 then
max("t3id5"."c3id1_modeclmn_customer_city") else cast(null as VARCHAR(255)) end
as "c3id6_mode_customer_city" from (select c3id1_modeclmn_customer_city, rank()
over (order by "c3id2_modecnt_customer_city" desc) as
-"c3id4_mode_rank" from (select "t3id0"."Customer_City" as
"c3id1_modeclmn_customer_city", count(*) as "c3id2_modecnt_customer_city" from
"t3id0" where "t3id0"."Customer_City" is not null group by
"t3id0"."Customer_City") as "t3id3") as "t3id5" where "t3id5"."c3id4_mode_rank"
= 1)
-as "t3ida" on 1 = 1) as "t3iec") as "t3iev")) as "t3iew") as "t3if5" on
(("t3if4"."c3icl_customer_gender" = "t3if5"."c3iek_customer_city__mode_" or
("t3if4"."c3icl_customer_gender" is null and
"t3if5"."c3iek_customer_city__mode_" is null)) and
("t3if4"."c3icx_mode_customer_state"
-= "t3if5"."c3iel_measure_values" or ("t3if4"."c3icx_mode_customer_state" is
null and "t3if5"."c3iel_measure_values" is null)))) as "t3if6" group by
"t3if6"."c3iex_source_6325213786828233216") as "t3ifg" left outer join (select
"t3ife"."c3ifd_modegrp_c3if8_modegrp_c3iex_s",
-case when count(*) = 1 then max("t3ife"."c3if9_modeclmn_customer_gender") else
cast(null as VARCHAR(255)) end as "c3iff_mode_customer_gender" from (select
c3if9_modeclmn_customer_gender, c3if8_modegrp_c3iex_source_63252137 as
"c3ifd_modegrp_c3if8_modegrp_c3iex_s",
-rank() over (partition by "c3if8_modegrp_c3iex_source_63252137" order by
"c3ifa_modecnt_customer_gender" desc) as "c3ifc_mode_rank" from (select
"t3if6"."c3iex_source_6325213786828233216" as
"c3if8_modegrp_c3iex_source_63252137", max("t3if6"."c3iey_customer_gender")
-as "c3if9_modeclmn_customer_gender", count(*) as
"c3ifa_modecnt_customer_gender" from (select 'Left, Right' as
"c3iex_source_6325213786828233216", "t3if4"."c3icl_customer_gender" as
"c3iey_customer_gender", "t3if4"."c3icx_mode_customer_state" as
"c3if0_customer_state__mode_",
-"t3if4"."c3icm_customer_region" as "c3iez_customer_region",
"t3if4"."c3icn_record_count" as "c3if3_record_count",
"t3if5"."c3iei_grouping_names" as "c3if1_grouping_names",
"t3if5"."c3iej_measure_names" as "c3if2_measure_names" from (select
"t3icy"."c3icl_customer_gender",
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
