
SET NAMES utf8mb4;

INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1040','EF_OSO','OnlineShopOrder','ord_5d650c98c2b40','committed','1566903448',',1041,1042,',NULL,NULL,NULL,NULL,'2813.5897','3291.9000','2818.6324','3297.8000','15% VAT|15%|422.7949\n2% Pimcore Tax|2%|56.3727','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_16','1020','object','Betty','Rubble',NULL,'Rudolstädter Straße 21','63741','Aschaffenburg','DE','betty.rubble@modern.age','Betty','Rubble',NULL,'Rudolstaedter Strasse 21','63741','Aschaffenburg','DE',NULL,NULL,NULL,'2022989143');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1043','EF_OSO','OnlineShopOrder','ord_5d650d2ff14fb','committed','1566903600',',1044,',NULL,NULL,NULL,NULL,'37603.3761','43995.9500','36480.3175','42681.9715','15% VAT|15%|5472.0476\n2% Pimcore Tax|2%|729.6064','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_17','1020','object','Betty','Rubble',NULL,'Rudolstaedter Strasse 21','63741','Aschaffenburg','DE','betty.rubble@modern.age','Betty','Rubble',NULL,'Rudolstaedter Strasse 21','63741','Aschaffenburg','DE',NULL,NULL,NULL,'3841357902');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1051','EF_OSO','OnlineShopOrder','ord_5d651f669cde7','committed','1566908262',',1052,1053,1054,',NULL,NULL,NULL,NULL,'74434.0598','87087.8500','72206.0807','84481.1145','15% VAT|15%|10830.9121\n2% Pimcore Tax|2%|1444.1217','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_18','1021','object','Bamm-Bamm','Rubble',NULL,'Rudolstädter Straße 21','63741','Aschaffenburg','DE','bamm@modern.age','Bamm-Bamm','Rubble',NULL,'Rudolstädter Straße 21','63741','Aschaffenburg','DE',NULL,NULL,NULL,'3589884274');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1055','EF_OSO','OnlineShopOrder','ord_5d6521e8206d5','committed','1566908904',',1056,1057,1058,1059,1060,1061,1062,1063,',NULL,NULL,NULL,NULL,'54593.2968','63874.1575','52960.5406','61963.8328','15% VAT|15%|7944.0812\n2% Pimcore Tax|2%|1059.2110','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_19','1022','object','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT','joe.rockhead@middle.age','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT',NULL,NULL,NULL,'534227246');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1065','EF_OSO','OnlineShopOrder','ord_5d652278a41a5','committed','1566909048',',1066,',NULL,NULL,NULL,NULL,'680.2991','795.9500','685.3418','801.8500','15% VAT|15%|102.8013\n2% Pimcore Tax|2%|13.7069','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_20','1022','object','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT','joe.rockhead@middle.age','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT',NULL,NULL,NULL,'527939789');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1067','EF_OSO','OnlineShopOrder','ord_5d6522ee11854','committed','1566909166',',1068,1069,',NULL,NULL,NULL,NULL,'6061.4529','7091.9000','6066.4956','7097.8000','15% VAT|15%|909.9744\n2% Pimcore Tax|2%|121.3300','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_21','1022','object','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT','joe.rockhead@middle.age','Joe','Rockhead',NULL,'1502  Pratt Avenue','98109','Seattle','AT',NULL,NULL,NULL,'603906025');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1070','EF_OSO','OnlineShopOrder','ord_5d652e4a3c6a0','committed','1566912074',',1071,',NULL,NULL,NULL,NULL,'4270.0427','4995.9500','4440.9829','5195.9500','15% VAT|15%|666.1474\n2% Pimcore Tax|2%|88.8197','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_22','1020','object','Betty','Rubble',NULL,'Rudolstädter Straße 21','63741','Aschaffenburg','DE','betty.rubble@modern.age','Betty','Rubble',NULL,'Rudolstädter Straße 21','63741','Aschaffenburg','DE',NULL,NULL,NULL,'4285317549');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1084','EF_OSO','OnlineShopOrder','ord_5d6669a20f76c','committed','1566992802',',1085,',NULL,NULL,NULL,NULL,'11364.0598','13295.9500','11535.0000','13495.9500','15% VAT|15%|1730.2500\n2% Pimcore Tax|2%|230.7000','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_24','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'3477634120');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1089','EF_OSO','OnlineShopOrder','ord_5d6673898d7b0','committed','1566995337',',1090,1091,',NULL,NULL,',1092,',NULL,'77770.8547','90991.9000','75779.6094','88662.1430','15% VAT|15%|11366.9415\n2% Pimcore Tax|2%|1515.5921','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_25','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'3841826486');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1103','EF_OSO','OnlineShopOrder','ord_5d67d202490ea','committed','1567085058',',1104,',NULL,NULL,NULL,NULL,'4611.9231','5395.9500','4782.8633','5595.9500','15% VAT|15%|717.4295\n2% Pimcore Tax|2%|95.6573','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_26','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'1337307695');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1107','EF_OSO','OnlineShopOrder','ord_5d68e54f7945f','committed','1567155535',',1108,',NULL,NULL,',1092,',NULL,'7688.8462','8995.9500','7688.8462','8995.9500','15% VAT|15%|1153.3269\n2% Pimcore Tax|2%|153.7769','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_27','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'3132511100');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1109','EF_OSO','OnlineShopOrder','ord_5d68ed2127f75','committed','1567157537',',1110,',NULL,NULL,',1111,',NULL,'18970.8974','22195.9500','18952.1286','22173.9905','15% VAT|15%|2842.8193\n2% Pimcore Tax|2%|379.0425','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_28','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'4052156262');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1112','EF_OSO','OnlineShopOrder','ord_5d690dccf28a3','committed','1567165901',',1113,',NULL,NULL,NULL,NULL,'1159.4509','1356.5575','1167.9979','1366.5575','15% VAT|15%|175.1997\n2% Pimcore Tax|2%|23.3599','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\SessionCart_sesscart_5d690d9c874a0',NULL,NULL,'Wilma','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','wilma.flintstone@stone.age','Wilma','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'786326029');
INSERT INTO object_query_EF_OSO (`oo_id`,`oo_classId`,`oo_className`,`ordernumber`,`orderState`,`orderdate`,`items`,`comment`,`customerOrderData`,`voucherTokens`,`giftItems`,`subTotalNetPrice`,`subTotalPrice`,`totalNetPrice`,`totalPrice`,`taxInfo`,`currency`,`cartId`,`customer__id`,`customer__type`,`customerFirstname`,`customerLastname`,`customerCompany`,`customerStreet`,`customerZip`,`customerCity`,`customerCountry`,`customerEmail`,`deliveryFirstname`,`deliveryLastname`,`deliveryCompany`,`deliveryStreet`,`deliveryZip`,`deliveryCity`,`deliveryCountry`,`paymentReference`,`successorOrder__id`,`successorOrder__type`,`cartHash`) VALUES ('1117','EF_OSO','OnlineShopOrder','ord_5d691be60e116','committed','1567169510',',1118,',NULL,NULL,NULL,NULL,'27945.2564','32695.9500','27277.8389','31915.0715','15% VAT|15%|4091.6758\n2% Pimcore Tax|2%|545.5567','EUR','Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\Cart_29','1017','object','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT','pebbles.flintstone@stone.age','Pebbles','Flintstone',NULL,'Floridusgasse 18','1020','Vienna','AT',NULL,NULL,NULL,'1233282869');
