18/05/2023 09:08:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/05/2023 09:08:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21106' , '1' , '' , 'nuovo-prodotto' ) 18/05/2023 09:08:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21106' , '1' , '1' , '2' , NOW() , NOW() ) 18/05/2023 09:08:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21106' , '0' , '1' , '0' , '0' ) 18/05/2023 09:10:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 09:10:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1715' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.90' , '8.93' , NOW() , NOW() ) 18/05/2023 09:10:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84395' 18/05/2023 09:10:34 am >> DELETE FROM ps_document_detail WHERE id_document = '84395' 18/05/2023 09:10:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84395' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 18/05/2023 09:10:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84395' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 18/05/2023 09:11:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752628' AND id_product != '21106' AND ean13 != '' 18/05/2023 09:11:25 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791259752628', date_upd = NOW() WHERE id_product = '21106' 18/05/2023 09:11:25 am >> UPDATE ps_product_lang SET name = 'una comunita\' dal rito - g. costa', description = '' WHERE id_product = '21106' 18/05/2023 09:11:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '21106' 18/05/2023 09:11:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21106' 18/05/2023 09:11:25 am >> DELETE FROM ps_specific_price WHERE id_product = '21106' 18/05/2023 09:11:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21106' 18/05/2023 09:11:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21107' , '1' , '' , 'nuovo-prodotto' ) 18/05/2023 09:11:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21107' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21106' 18/05/2023 09:11:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21107' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21106' 18/05/2023 09:11:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752628' AND id_product != '21106' AND ean13 != '' 18/05/2023 09:11:49 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791259752628', date_upd = NOW() WHERE id_product = '21106' 18/05/2023 09:11:49 am >> UPDATE ps_product_lang SET name = 'UNA COMUNITA\' DAL RITO - G. COSTA', description = '' WHERE id_product = '21106' 18/05/2023 09:11:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25.0000' WHERE id_product = '21106' 18/05/2023 09:11:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25.0000', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21106' 18/05/2023 09:11:49 am >> DELETE FROM ps_specific_price WHERE id_product = '21106' 18/05/2023 09:13:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253582' AND id_product != '21107' AND ean13 != '' 18/05/2023 09:13:06 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9791281253582', date_upd = NOW() WHERE id_product = '21107' 18/05/2023 09:13:06 am >> UPDATE ps_product_lang SET name = 'ECCOMI DI MARIA - A. MARIANI', description = '' WHERE id_product = '21107' 18/05/2023 09:13:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6' WHERE id_product = '21107' 18/05/2023 09:13:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21107' 18/05/2023 09:13:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21107' 18/05/2023 09:13:07 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21107' 18/05/2023 09:13:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21108' , '1' , '' , 'nuovo-prodotto' ) 18/05/2023 09:13:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21108' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21107' 18/05/2023 09:13:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21108' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21107' 18/05/2023 09:15:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118034380' AND id_product != '21108' AND ean13 != '' 18/05/2023 09:15:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8019118034380', date_upd = NOW() WHERE id_product = '21108' 18/05/2023 09:15:24 am >> UPDATE ps_product_lang SET name = 'MAGARI MI METTO A DIETA - SPARTITO', description = '' WHERE id_product = '21108' 18/05/2023 09:15:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.25' WHERE id_product = '21108' 18/05/2023 09:15:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.25', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21108' 18/05/2023 09:15:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21108' 18/05/2023 09:15:25 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21108' 18/05/2023 09:15:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21109' , '1' , '' , 'nuovo-prodotto' ) 18/05/2023 09:15:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21109' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21108' 18/05/2023 09:15:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21109' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21108' 18/05/2023 09:16:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118021670' AND id_product != '21109' AND ean13 != '' 18/05/2023 09:16:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8019118021670', date_upd = NOW() WHERE id_product = '21109' 18/05/2023 09:16:20 am >> UPDATE ps_product_lang SET name = 'MAGARI MI METTO A DIETA - CD', description = '' WHERE id_product = '21109' 18/05/2023 09:16:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '21109' 18/05/2023 09:16:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21109' 18/05/2023 09:16:20 am >> DELETE FROM ps_specific_price WHERE id_product = '21109' 18/05/2023 09:16:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21109' 18/05/2023 09:16:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21110' , '1' , '' , 'nuovo-prodotto' ) 18/05/2023 09:16:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21110' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21109' 18/05/2023 09:16:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21110' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21109' 18/05/2023 09:16:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '631948' , '2023-05-16' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.26' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.60' , '112.78' , NOW() , NOW() ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84396' 18/05/2023 09:16:52 am >> DELETE FROM ps_document_detail WHERE id_document = '84396' 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '6263' , 'MARIA, DONNA DEI GIORNI NOSTRI - T.BELLO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '33' , '6.7000' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '6263' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6263' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '21106' , 'UNA COMUNITA DAL RITO - G. COSTA' , '1' , '1' , '4' , '25' , '25' , '0' , '30' , '17.5000' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21106' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21106' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '21107' , 'ECCOMI DI MARIA - A. MARIANI' , '2' , '2' , '4' , '6.00' , '6' , '0' , '30' , '8.4000' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21107' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21107' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '20949' , 'MARIA OMELIE E DISCORSI SCELTI - BENEDETTO XVI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20949' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20949' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '2' , '4' , '18.00' , '18' , '0' , '33' , '24.1200' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20655' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20655' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '1116' , 'BIBBIA DEI BAMBINI' , '1' , '1' , '4' , '12.90' , '12.9' , '0' , '30' , '9.0300' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '1116' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1116' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '20928' , 'CHI E MARIA? - C. MAGGIONI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '20928' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20928' , '7' , '1' ) 18/05/2023 09:16:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '21108' , 'MAGARI MI METTO A DIETA - SPARTITO' , '1' , '1' , '3' , '6.25' , '6.0096153846154' , '4' , '30' , '4.5500' ) 18/05/2023 09:16:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '21108' AND id_supplier = '7' 18/05/2023 09:16:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21108' , '7' , '1' ) 18/05/2023 09:16:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84396' , '21109' , 'MAGARI MI METTO A DIETA - CD' , '1' , '1' , '1' , '10.65' , '8.7295081967213' , '22' , '30' , '9.0951' ) 18/05/2023 09:16:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21109' AND id_supplier = '7' 18/05/2023 09:16:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21109' , '7' , '1' ) 18/05/2023 09:34:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 09:34:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1716' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '13.93' , NOW() , NOW() ) 18/05/2023 09:34:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84397' 18/05/2023 09:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '84397' 18/05/2023 09:34:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84397' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 18/05/2023 09:34:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84397' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/05/2023 09:57:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 09:57:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1717' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '234.00' , '196.58' , NOW() , NOW() ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84398' 18/05/2023 09:57:50 am >> DELETE FROM ps_document_detail WHERE id_document = '84398' 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '18223' , 'CORONA MISSIONARIA - R102' , '80' , '-80' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '80.00' ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '79.20' ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.1' , '9.0983606557377' , '22' , '0' , '11.10' ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 18/05/2023 09:57:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84398' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 18/05/2023 10:02:17 am >> SELECT document_num FROM ps_document WHERE document_num = '1353' AND id_document != '82937' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-22') 18/05/2023 10:02:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1353', document_date = '2023-04-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '51.28', price_tax_excluded = '46.23', date_upd = NOW() WHERE id_document = '82937' 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82937' 18/05/2023 10:02:17 am >> DELETE FROM ps_document_detail WHERE id_document = '82937' 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82937' , '9462' , 'SAN GIUSEPPE - T. STRAMARE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82937' , '9444' , 'SAN GIACOMO AP.- A.GOVERNALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82937' , '20817' , 'FACCIA A FACCIA CON GESU - D. RUOTOLO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82937' , '20072' , 'BRACCIALE - BC1759N' , '8' , '-8' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '16.00' ) 18/05/2023 10:02:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82937' , '18223' , 'CORONA MISSIONARIA - R102' , '12' , '-12' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '12.00' ) 18/05/2023 10:11:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 10:11:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1718' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.40' , '110.16' , NOW() , NOW() ) 18/05/2023 10:11:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84399' 18/05/2023 10:11:26 am >> DELETE FROM ps_document_detail WHERE id_document = '84399' 18/05/2023 10:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84399' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 18/05/2023 10:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84399' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 18/05/2023 10:11:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84399' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 18/05/2023 10:16:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 10:16:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1719' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '52.00' , NOW() , NOW() ) 18/05/2023 10:16:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84400' 18/05/2023 10:16:15 am >> DELETE FROM ps_document_detail WHERE id_document = '84400' 18/05/2023 10:16:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84400' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '52' , '52' , '0' , '0' , '52.00' ) 18/05/2023 10:19:13 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'AiFbbvUb8n4VA3Ne' , NOW() , NOW() ) 18/05/2023 10:19:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7050' , '1' ) 18/05/2023 10:19:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7050' , '2' ) 18/05/2023 10:19:13 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7050' , '3' ) 18/05/2023 10:20:57 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7050' 18/05/2023 10:20:57 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7050' , '10' , '210' , 'PARR. SANT\\\'ANDREA E GIOVANNI ' , ' DI ARIENZO ' , 'DON ANTONIO' , 'VIA VICENZA 45' , '' , '84099' , 'FILETTA DI SAN CIPRIANO PICENTINO' , '' , '' , '3336478158' , '' , '95021750658' , NOW() , NOW() ) 18/05/2023 10:20:57 am >> UPDATE ps_customer SET email = 'antoniodiarienzo@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7050' 18/05/2023 10:21:25 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 10:21:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '21' , '2023-05-18' , '' , '7050' , '0' , '135353944' , 'VIA VICENZA 45 84099 FILETTA DI SAN CIPRIANO PICENTINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '33.15' , '33.15' , NOW() , NOW() ) 18/05/2023 10:21:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11330' 18/05/2023 10:21:25 am >> DELETE FROM ps_document_detail WHERE id_document = '11330' 18/05/2023 10:21:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11330' , '125' , 'MIE PREGHIERINE - N. E.' , '26' , '-26' , '4' , '1.50' , '1.5' , '0' , '15' , '33.15' ) 18/05/2023 10:54:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 10:54:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1720' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.70' , NOW() , NOW() ) 18/05/2023 10:54:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84401' 18/05/2023 10:54:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84401' 18/05/2023 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84401' , '11272' , 'VETRO ROSSO RUBINO - VKINGS' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 18/05/2023 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84401' , '20119' , 'FATIMA CM 35 - 1023' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 18/05/2023 10:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84401' , '21070' , 'A GESU CON FRANCESCO E C. ACUTIS - FERREIRA/CALVARESE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 18/05/2023 10:55:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 10:55:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1721' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 18/05/2023 10:55:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84402' 18/05/2023 10:55:58 am >> DELETE FROM ps_document_detail WHERE id_document = '84402' 18/05/2023 10:55:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84402' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 18/05/2023 11:09:10 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '234/A' , '2023-05-18' , 'A' , '0' , '0' , '0' , '' , '' , '18/05/2023- CONSEGNATI 2800 X TITOLO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84000.00' , '84000.00' , NOW() , NOW() ) 18/05/2023 11:09:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84403' 18/05/2023 11:09:10 am >> DELETE FROM ps_document_detail WHERE id_document = '84403' 18/05/2023 11:09:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15000' , '15000' , '4' , '2.80' , '2.8' , '0' , '0' , '42000.0000' ) 18/05/2023 11:09:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15000' , '15000' , '4' , '2.80' , '2.8' , '0' , '0' , '42000.0000' ) 18/05/2023 11:09:34 am >> UPDATE ps_document SET id_document_type = '33', document_num = '234/A', document_date = '2023-05-18', document_letter = 'A', id_customer = '0', id_supplier = '53', id_address = '2648', address1 = '', address2 = '', note = '18/05/2023- CONSEGNATI 2800 X TITOLO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84000.00', price_tax_excluded = '84000.00', date_upd = NOW() WHERE id_document = '84403' 18/05/2023 11:09:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84403' 18/05/2023 11:09:34 am >> DELETE FROM ps_document_detail WHERE id_document = '84403' 18/05/2023 11:09:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15000' , '15000' , '4' , '2.8000' , '2.8' , '0' , '0' , '42000.00' ) 18/05/2023 11:09:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20952' AND id_supplier = '53' 18/05/2023 11:09:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20952' , '53' , '1' ) 18/05/2023 11:09:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84403' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15000' , '15000' , '4' , '2.8000' , '2.8' , '0' , '0' , '42000.00' ) 18/05/2023 11:09:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20953' AND id_supplier = '53' 18/05/2023 11:09:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20953' , '53' , '1' ) 18/05/2023 11:21:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 11:21:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1722' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 18/05/2023 11:21:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84404' 18/05/2023 11:21:55 am >> DELETE FROM ps_document_detail WHERE id_document = '84404' 18/05/2023 11:21:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84404' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '11' , '-11' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '13.20' ) 18/05/2023 11:43:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 11:43:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1723' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 18/05/2023 11:43:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84405' 18/05/2023 11:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '84405' 18/05/2023 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 18/05/2023 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7907' , 'PERGAMENE' , '15' , '-15' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '7.50' ) 18/05/2023 11:43:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '22' , '-22' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '11.00' ) 18/05/2023 11:45:39 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 11:45:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '92' , '2023-05-18' , '' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.23' , '92.23' , NOW() , NOW() ) 18/05/2023 11:45:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84406' 18/05/2023 11:45:39 am >> DELETE FROM ps_document_detail WHERE id_document = '84406' 18/05/2023 11:45:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84406' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '31' , '-31' , '4' , '3.50' , '3.5' , '0' , '15' , '92.23' ) 18/05/2023 11:47:45 am >> SELECT document_num FROM ps_document WHERE document_num = '92' AND id_document != '84406' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 11:47:45 am >> UPDATE ps_document SET id_document_type = '21', document_num = '92', document_date = '2023-05-18', document_letter = '', id_customer = '3356', id_supplier = '', id_address = '4671990', address1 = 'VIA SALVATORE DE RENZI, 26 84125 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '92.23', price_tax_excluded = '92.23', date_upd = NOW() WHERE id_document = '84406' 18/05/2023 11:47:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84406' 18/05/2023 11:47:45 am >> DELETE FROM ps_document_detail WHERE id_document = '84406' 18/05/2023 11:47:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84406' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 18/05/2023 11:49:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1185' AND id_document != '82722' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-07') 18/05/2023 11:49:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1185', document_date = '2023-04-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '12.50', price_tax_excluded = '11.33', date_upd = NOW() WHERE id_document = '82722' 18/05/2023 11:49:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82722' 18/05/2023 11:49:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82722' 18/05/2023 11:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82722' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 18/05/2023 11:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82722' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '-2' , '4' , '3' , '3' , '0' , '0' , '6.00' ) 18/05/2023 12:16:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1724' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 12:16:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1724' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 18/05/2023 12:16:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84407' 18/05/2023 12:16:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '84407' 18/05/2023 12:16:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84407' , '19560' , 'PERGAMENA 17X25' , '70' , '-70' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '49.00' ) 18/05/2023 12:28:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 12:28:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '22/E' , '2023-05-18' , 'E' , '31' , '0' , '4670717' , 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '282.24' , '282.24' , NOW() , NOW() ) 18/05/2023 12:28:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84408' 18/05/2023 12:28:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '84408' 18/05/2023 12:28:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84408' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '168' , '-168' , '4' , '2.80' , '2.8' , '0' , '40' , '282.24' ) 18/05/2023 03:02:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1723' AND id_document != '84405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 03:03:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1723', document_date = '2023-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '26.00', price_tax_excluded = '21.31', date_upd = NOW() WHERE id_document = '84405' 18/05/2023 03:03:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84405' 18/05/2023 03:03:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '84405' 18/05/2023 03:03:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '7.50' ) 18/05/2023 03:03:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 18/05/2023 03:03:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84405' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '22' , '-22' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '11.00' ) 18/05/2023 03:05:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/E' AND id_document != '84408' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 03:05:54 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '22/E', document_date = '2023-05-18', document_letter = 'E', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '282.24', price_tax_excluded = '282.24', date_upd = NOW() WHERE id_document = '84408' 18/05/2023 03:05:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84408' 18/05/2023 03:05:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '84408' 18/05/2023 03:05:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84408' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '168' , '-168' , '4' , '2.8000' , '2.8' , '0' , '40' , '282.24' ) 18/05/2023 03:26:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1725' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 03:26:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1725' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.72' , '20.72' , NOW() , NOW() ) 18/05/2023 03:26:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84409' 18/05/2023 03:26:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '84409' 18/05/2023 03:26:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84409' , '20326' , 'SEGRETO DI MIO FIGLIO - A. ACUTIS' , '2' , '-2' , '4' , '10.90' , '10.9' , '0' , '5' , '20.72' ) 18/05/2023 03:32:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1726' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 03:32:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1726' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 18/05/2023 03:32:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84410' 18/05/2023 03:32:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '84410' 18/05/2023 03:32:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84410' , '20115' , 'FATIMA CM 95 BRIL - 1039/PBL' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 18/05/2023 03:32:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84410' , '19723' , 'ROSARIO COPPIGLIATO MM8 - RE1715-SM' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/05/2023 04:33:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1727' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 04:33:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1727' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 18/05/2023 04:33:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84411' 18/05/2023 04:33:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '84411' 18/05/2023 04:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84411' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 18/05/2023 04:33:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84411' , '12044' , 'CONFEZIONE CARTONCINO CON CROCE - 2342/K126' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/05/2023 04:37:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1728' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 04:37:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1728' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '11.89' , NOW() , NOW() ) 18/05/2023 04:37:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84412' 18/05/2023 04:37:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '84412' 18/05/2023 04:37:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84412' , '17287' , 'CAPOCULLA 7X9' , '1' , '-1' , '1' , '14.50' , '11.885245901639' , '22' , '0' , '14.50' ) 18/05/2023 06:11:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1729' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 06:11:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1729' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.40' , '45.02' , NOW() , NOW() ) 18/05/2023 06:11:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84413' 18/05/2023 06:11:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '84413' 18/05/2023 06:11:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84413' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 18/05/2023 06:11:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84413' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 18/05/2023 06:11:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84413' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '2' , '-2' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '12.40' ) 18/05/2023 06:16:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '1730' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 06:16:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1730' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.70' , '4.42' , NOW() , NOW() ) 18/05/2023 06:16:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84414' 18/05/2023 06:16:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '84414' 18/05/2023 06:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84414' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 18/05/2023 06:16:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84414' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 18/05/2023 06:39:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1731' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 06:39:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1731' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 18/05/2023 06:39:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84415' 18/05/2023 06:39:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '84415' 18/05/2023 06:39:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84415' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/05/2023 07:31:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '213' , '2023-05-08' , '' , '0' , '53' , '2648' , 'VIA TERRE RISAIE 13 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1403.00' , '1150.00' , NOW() , NOW() ) 18/05/2023 07:31:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84416' 18/05/2023 07:31:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '84416' 18/05/2023 07:31:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84416' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '200' , '200' , '1' , '3.25' , '2.6639344262295' , '22' , '0' , '793.0000' ) 18/05/2023 07:31:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20885' AND id_supplier = '53' 18/05/2023 07:31:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20885' , '53' , '1' ) 18/05/2023 07:31:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84416' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '5000' , '5000' , '1' , '0.10' , '0.081967213114754' , '22' , '0' , '610.0000' ) 18/05/2023 07:31:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13504' AND id_supplier = '53' 18/05/2023 07:31:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13504' , '53' , '1' ) 18/05/2023 08:02:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1732' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-18') 18/05/2023 08:02:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1732' , '2023-05-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.70' , '43.63' , NOW() , NOW() ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84417' 18/05/2023 08:02:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '84417' 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '20755' , 'SANTITA MATRIMONIO FAMIGLIA ' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/05/2023 08:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84417' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' )