IMPORTANTgothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3052', 'Zollikofen', 40, '1983-12-05 00:00:00', '+41 79 578 00 00', 'oliver@amonn.ch', 96, '36', '80756009940017532381', '0011_000008_11.05.22.csv-import-2', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-15 11:30:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-2', '2022-04-15 11:30:00', 39, 36, '', '80756009940017532381', 0, '+41 79 578 00 00', 'oliver@amonn.ch', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 2, 8, '', '', '', '3052', 'Zollikofen', 40, '1985-09-10 00:00:00', '+41 79 534 62 84', 'christina@amonn.ch', 96, '7', '80756003120015422502', '0011_000008_11.05.22.csv-import-3', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-15 11:35:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-3', '2022-04-15 11:35:00', 39, 7, '', '80756003120015422502', 0, '+41 79 534 62 84', 'christina@amonn.ch', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3925', 'Grächen', 40, '1982-07-31 00:00:00', '+41 79 860 13 43', 'davide.rausa@icloud.com', 96, '40', '80756015090041361071', '0011_000008_11.05.22.csv-import-4', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-15 18:05:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-4', '2022-04-15 18:05:00', 39, 40, '', '80756015090041361071', 0, '+41 79 860 13 43', 'davide.rausa@icloud.com', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3014', 'Bern', 40, '1968-09-26 00:00:00', '+41 79 920 42 14', 'dg@feelitprod.ch', 96, '23', '80756015620047512554', '0011_000008_11.05.22.csv-import-5', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-16 17:35:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-5', '2022-04-16 17:35:00', 39, 23, '', '80756015620047512554', 0, '+41 79 920 42 14', 'dg@feelitprod.ch', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3303', 'Jegenstorf', 40, '1966-03-10 00:00:00', '+41 79 296 36 68', '', 96, '50', '80756005090019654679', '0011_000008_11.05.22.csv-import-6', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-16 14:15:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-6', '2022-04-16 14:15:00', 39, 50, '', '80756005090019654679', 0, '+41 79 296 36 68', '', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3097', 'Liebefeld', 40, '2000-09-21 00:00:00', '+41 79 680 49 47', 'yago@tanzkarussell.com', 96, '46', '80756013840040821228', '0011_000008_11.05.22.csv-import-7', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-14 11:45:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-7', '2022-04-14 11:45:00', 39, 46, '', '80756013840040821228', 0, '+41 79 680 49 47', 'yago@tanzkarussell.com', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '8004', 'Zürich', 40, '1988-10-21 00:00:00', '+41 79 768 80 43', 'd_kummer@msn.com', 96, '17', '80756008810013913412', '0011_000008_11.05.22.csv-import-8', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-14 17:55:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-8', '2022-04-14 17:55:00', 39, 17, '', '80756008810013913412', 0, '+41 79 768 80 43', 'd_kummer@msn.com', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3014', 'Bern', 40, '1994-04-13 00:00:00', '+41 78 683 60 63', 'remomichael@hotmail.de', 96, '40', '80756015090038771705', '0011_000008_11.05.22.csv-import-9', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2966, '', '', '', '', '', '2022-04-15 12:00:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-9', '2022-04-15 12:00:00', 39, 40, '', '80756015090038771705', 0, '+41 78 683 60 63', 'remomichael@hotmail.de', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
gothere112createnewcart112sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 1, 9, '', '', '', '3012', 'Bern', 40, '1983-07-20 00:00:00', '+41 78 770 06 79', 'thierry.beyeler@vicero.com', 96, '36', '80756009940011812646', '0011_000008_11.05.22.csv-import-10', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-14 12:05:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-10', '2022-04-14 12:05:00', 39, 36, '', '80756009940011812646', 0, '+41 78 770 06 79', 'thierry.beyeler@vicero.com', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'Antigen-Schnelltest SARS-CoV-2', '', '', 0, 1, 0, 180, 0, NULL, 'AgSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 47, 47, 47, 0);
fehlt kkgothere112createnewcart112 deckungsabfragbar112:11 sql error: :INSERT INTO `person` ( `agent_id`, `name-de`, `name-en`, `personal_key`, `salutation`, `sex`, `lastname`, `firstname`, `street`, `zip`, `city`, `country`, `date_of_birth`, `phone`, `email`, `billing_tgtp`, `health_insurance`, `health_insurance_card_number`, `last_reference`, `last_used_at` ) VALUES ( 8, '', '', '', 2, 8, '', '', '', '3924', 'St. Niklaus', 40, '1979-05-30 00:00:00', '+41 79 307 90 13', 'patricia_anthamatten@bluewin.ch', 96, '0', '80756015690012303643', '0011_000008_11.05.22.csv-import-11', '2025-03-15 12:37:43' );
sql error: :INSERT INTO cart ( `agent_id`, `remitter_type`, `remitter_source`, `remitter_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `person_id`, `date`, `order_type`, `cart_status`, `currency`, `total_excl_tax`, `total_tax`, `total_incl_tax`, `payment_type`, `payment_info`, `external_ordernumber`, `reference`, `sampling_date`, `sampling_type`, `health_insurance`, `health_insurance_number`, `health_insurance_card_number`, `accident`, `person_phone`, `person_email`, `copy_to_person_by`, `copy_to_alternate_by`, `comment`, `copy_to_alternate_hin`, `copy_to_alternate_name`, `invoice_to_remitter_id`, `invoice_code_to`, `corona_travel_report`, `corona_inv_pcr`, `corona_inv_sero`) VALUES ( 8, 36, 38, 2965, '', '', '', '', '', '2022-04-14 16:00:00', 33, 90, 'CHF', 0, 0, 0, 12, '', '', '0011_000008_11.05.22.csv-import-11', '2022-04-14 16:00:00', 39, 0, '', '80756015690012303643', 0, '+41 79 307 90 13', 'patricia_anthamatten@bluewin.ch', 144, 146, '', '', '', 0, 84, 0, '', '');
sql error: :INSERT INTO cart_item ( `agent_id`, `short_name-de`, `short_name-en`, `name-de`, `name-en`, `cart_id`, `position_order`, `number`, `analysis_block_id`, `analysis_id`, `orderentry_method_id`, `service_id`, `lis_code`, `specialization`, `material_text`, `material_code`, `material_shortname`, `labor_id`, `lis_transfer`, `price_excl`, `price`, `total`, `tax`) VALUES ( 8, '', '', 'PCR SARS-CoV-2', '', '', 0, 1, 0, 181, 0, NULL, 'PCRSARSCoV2testc', 'chem', 'Nasopharynxabstrich', '', '', 'intern', 1, 159, 159, 159, 0);
deckungsql error: :UPDATE cart SET veka_req_datetime ='2025-03-15 12:37:43' WHERE id =