08/08/2023 09:06:45 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/08/2023 09:06:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21478' , '1' , '' , 'nuovo-prodotto' ) 08/08/2023 09:06:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21478' , '1' , '1' , '2' , NOW() , NOW() ) 08/08/2023 09:06:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21478' , '0' , '1' , '0' , '0' ) 08/08/2023 09:07:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048578' AND id_product != '21478' AND ean13 != '' 08/08/2023 09:07:38 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048578', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:07:38 am >> UPDATE ps_product_lang SET name = 'PILASTRI DELLA FEDE -8474', description = '' WHERE id_product = '21478' 08/08/2023 09:07:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21478' 08/08/2023 09:07:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '0', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:07:38 am >> DELETE FROM ps_specific_price WHERE id_product = '21478' 08/08/2023 09:07:39 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 = '21478' 08/08/2023 09:07:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21479' , '1' , '' , 'nuovo-prodotto' ) 08/08/2023 09:07:39 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 '21479' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21478' 08/08/2023 09:07:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21479' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21478' 08/08/2023 09:08:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048578' AND id_product != '21478' AND ean13 != '' 08/08/2023 09:08:06 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048578', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:08:06 am >> UPDATE ps_product_lang SET name = 'PILASTRI DELLA FEDE -8474', description = '' WHERE id_product = '21478' 08/08/2023 09:08:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '21478' 08/08/2023 09:08:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:08:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21478' 08/08/2023 09:08:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048578' AND id_product != '21478' AND ean13 != '' 08/08/2023 09:08:21 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048578', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:08:21 am >> UPDATE ps_product_lang SET name = 'PILASTRI DELLA FEDE -8474', description = '' WHERE id_product = '21478' 08/08/2023 09:08:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21478' 08/08/2023 09:08:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21478' 08/08/2023 09:08:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21478' 08/08/2023 09:09:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048721' AND id_product != '21479' AND ean13 != '' 08/08/2023 09:09:09 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048721', date_upd = NOW() WHERE id_product = '21479' 08/08/2023 09:09:09 am >> UPDATE ps_product_lang SET name = 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517', description = '' WHERE id_product = '21479' 08/08/2023 09:09:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '21479' 08/08/2023 09:09:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '0', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21479' 08/08/2023 09:09:09 am >> DELETE FROM ps_specific_price WHERE id_product = '21479' 08/08/2023 09:09:10 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 = '21479' 08/08/2023 09:09:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21480' , '1' , '' , 'nuovo-prodotto' ) 08/08/2023 09:09:10 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 '21480' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21479' 08/08/2023 09:09:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21480' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21479' 08/08/2023 09:09:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048721' AND id_product != '21479' AND ean13 != '' 08/08/2023 09:09:29 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048721', date_upd = NOW() WHERE id_product = '21479' 08/08/2023 09:09:29 am >> UPDATE ps_product_lang SET name = 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517', description = '' WHERE id_product = '21479' 08/08/2023 09:09:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '21479' 08/08/2023 09:09:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21479' 08/08/2023 09:09:29 am >> DELETE FROM ps_specific_price WHERE id_product = '21479' 08/08/2023 09:10:01 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 ( '31' , '12594/00/2023' , '2023-08-04' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '247.80' , '247.80' , NOW() , NOW() ) 08/08/2023 09:10:01 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 = '87000' 08/08/2023 09:10:01 am >> DELETE FROM ps_document_detail WHERE id_document = '87000' 08/08/2023 09:10:02 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 ( '87000' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '70' , '70' , '4' , '5.00' , '5' , '0' , '40' , '210.0000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21192' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21192' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '21478' , 'PILASTRI DELLA FEDE -8474' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21478' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21478' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '21479' , 'PENSIERI E PREGHIERE DI DON DOLINDO - 8517' , '3' , '3' , '4' , '2.00' , '2' , '0' , '40' , '3.6000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '21479' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21479' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '11281' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11281' , '38' , '1' ) 08/08/2023 09:10:02 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 ( '87000' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' , '1' , '4' , '11.00' , '11' , '0' , '40' , '6.6000' ) 08/08/2023 09:10:02 am >> DELETE FROM ps_product_supplier WHERE id_product = '13499' AND id_supplier = '38' 08/08/2023 09:10:02 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13499' , '38' , '1' ) 08/08/2023 09:29:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2581' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 09:29: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' , '2581' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '7.00' , NOW() , NOW() ) 08/08/2023 09:29: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 = '87001' 08/08/2023 09:29:08 am >> DELETE FROM ps_document_detail WHERE id_document = '87001' 08/08/2023 09:29: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 ( '87001' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 08/08/2023 09:34:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2582' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 09:34:02 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' , '2582' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.80' , '66.64' , NOW() , NOW() ) 08/08/2023 09:34:02 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 = '87002' 08/08/2023 09:34:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87002' 08/08/2023 09:34:02 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 ( '87002' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '10' , '10' , '0' , '0' , '40.00' ) 08/08/2023 09:34:02 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 ( '87002' , '21205' , 'MI AMI TU? - CD' , '1' , '-1' , '4' , '16.80' , '16.8' , '0' , '0' , '16.80' ) 08/08/2023 09:34:02 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 ( '87002' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 08/08/2023 09:39:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 09:39: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' , '2583' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '4.84' , NOW() , NOW() ) 08/08/2023 09:39: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 = '87003' 08/08/2023 09:39:50 am >> DELETE FROM ps_document_detail WHERE id_document = '87003' 08/08/2023 09:39: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 ( '87003' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 08/08/2023 09:42:50 am >> SELECT document_num FROM ps_document WHERE document_num = '2584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 09:42: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' , '2584' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 08/08/2023 09:42: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 = '87004' 08/08/2023 09:42:50 am >> DELETE FROM ps_document_detail WHERE id_document = '87004' 08/08/2023 09:42: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 ( '87004' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 08/08/2023 09:57:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1772' AND id_document != '84465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-22') 08/08/2023 09:57:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1772', document_date = '2023-05-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 = '105.00', price_tax_excluded = '86.07', date_upd = NOW() WHERE id_document = '84465' 08/08/2023 09:57:05 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 = '84465' 08/08/2023 09:57:05 am >> DELETE FROM ps_document_detail WHERE id_document = '84465' 08/08/2023 09:57:05 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 ( '84465' , '19598' , 'MEDAGLIA SPILLA SPIRITO SANTO - G24OX' , '38' , '-38' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '53.20' ) 08/08/2023 09:57:05 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 ( '84465' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '40' , '-40' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '20.00' ) 08/08/2023 09:57:05 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 ( '84465' , '4243' , 'FORMELLA 15X15 ANGELO - F1087MI' , '1' , '-1' , '1' , '30.8' , '25.245901639344' , '22' , '0' , '30.80' ) 08/08/2023 09:57:05 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 ( '84465' , '1231' , 'BIGLIETTO BATTESIMO - ROSA - 598-P.G.1' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/08/2023 10:26:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2577' AND id_document != '86996' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-07') 08/08/2023 10:26:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2577', document_date = '2023-08-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 = '96.00', price_tax_excluded = '82.45', date_upd = NOW() WHERE id_document = '86996' 08/08/2023 10:26:51 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 = '86996' 08/08/2023 10:26:51 am >> DELETE FROM ps_document_detail WHERE id_document = '86996' 08/08/2023 10:26:51 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 ( '86996' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 08/08/2023 10:26:51 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 ( '86996' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 08/08/2023 10:26:51 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 ( '86996' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 08/08/2023 10:26:51 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 ( '86996' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/08/2023 10:26:51 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 ( '86996' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 08/08/2023 10:26:51 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 ( '86996' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 08/08/2023 10:26:51 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 ( '86996' , '20154' , 'QUADRETTO CULLA ANGELO DI DIO ROSA - 5510SC' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 08/08/2023 10:26:51 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 ( '86996' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.5' , '2.4038461538462' , '4' , '0' , '2.50' ) 08/08/2023 10:26: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 ( '86996' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 08/08/2023 10:27:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2568' AND id_document != '86985' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-04') 08/08/2023 10:27:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2568', document_date = '2023-08-04', 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 = '60.00', price_tax_excluded = '57.69', date_upd = NOW() WHERE id_document = '86985' 08/08/2023 10:27:56 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 = '86985' 08/08/2023 10:27:56 am >> DELETE FROM ps_document_detail WHERE id_document = '86985' 08/08/2023 10:27:56 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 ( '86985' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '14.5' , '13.942307692308' , '4' , '0' , '14.50' ) 08/08/2023 10:27:56 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 ( '86985' , '16689' , 'OSTIA PAN DI CENA mm80' , '9' , '-9' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '18.00' ) 08/08/2023 10:27:57 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 ( '86985' , '7311' , 'OSTIA SOTTILE 74MM' , '12' , '-12' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '24.00' ) 08/08/2023 10:27:57 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 ( '86985' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/08/2023 10:28:23 am >> DELETE FROM ps_document WHERE id_document = '86987' 08/08/2023 10:28:23 am >> DELETE FROM ps_document_detail WHERE id_document = '86987' 08/08/2023 10:52:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 10:52:22 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' , '2585' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 08/08/2023 10:52:22 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 = '87005' 08/08/2023 10:52:22 am >> DELETE FROM ps_document_detail WHERE id_document = '87005' 08/08/2023 10:52:22 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 ( '87005' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 08/08/2023 11:45:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 11:45:37 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' , '2586' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 08/08/2023 11:45:37 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 = '87006' 08/08/2023 11:45:37 am >> DELETE FROM ps_document_detail WHERE id_document = '87006' 08/08/2023 11:45:37 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 ( '87006' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '3' , '-3' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '48.00' ) 08/08/2023 11:45:37 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 ( '87006' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 08/08/2023 11:49:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2587' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 11:49: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' , '2587' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '25.41' , NOW() , NOW() ) 08/08/2023 11:49: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 = '87007' 08/08/2023 11:49:41 am >> DELETE FROM ps_document_detail WHERE id_document = '87007' 08/08/2023 11:49: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 ( '87007' , '1595' , 'CAMPANELLO - CM 14 - 631' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 08/08/2023 11:49: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 ( '87007' , '1597' , 'CAMPANELLO CM 11 - 632' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 08/08/2023 11:50:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 11:50:05 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' , '2588' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.10' , '10.97' , NOW() , NOW() ) 08/08/2023 11:50:05 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 = '87008' 08/08/2023 11:50:05 am >> DELETE FROM ps_document_detail WHERE id_document = '87008' 08/08/2023 11:50:05 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 ( '87008' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 08/08/2023 11:50:05 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 ( '87008' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/08/2023 11:53:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2587' AND id_document != '87007' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 11:53:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2587', document_date = '2023-08-08', 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 = '31.00', price_tax_excluded = '25.41', date_upd = NOW() WHERE id_document = '87007' 08/08/2023 11:53:00 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 = '87007' 08/08/2023 11:53:00 am >> DELETE FROM ps_document_detail WHERE id_document = '87007' 08/08/2023 11:53:00 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 ( '87007' , '1595' , 'CAMPANELLO - CM 14 - 631' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 08/08/2023 11:53:00 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 ( '87007' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 08/08/2023 12:33:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '86936' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-01') 08/08/2023 12:33:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2533', document_date = '2023-08-01', 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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '86936' 08/08/2023 12:33:53 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 = '86936' 08/08/2023 12:33:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '86936' 08/08/2023 12:33: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 ( '86936' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.5' , '10.5' , '0' , '0' , '10.50' ) 08/08/2023 12:33: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 ( '86936' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 08/08/2023 12:34:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '86936' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-01') 08/08/2023 12:34:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2533', document_date = '2023-08-01', 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 = '20.00', price_tax_excluded = '20.00', date_upd = NOW() WHERE id_document = '86936' 08/08/2023 12:34:39 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 = '86936' 08/08/2023 12:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '86936' 08/08/2023 12:34:39 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 ( '86936' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5.75' , '5.75' , '0' , '0' , '5.75' ) 08/08/2023 12:34:39 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 ( '86936' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 08/08/2023 12:40:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 12:40:40 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' , '2589' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.48' , NOW() , NOW() ) 08/08/2023 12:40:40 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 = '87009' 08/08/2023 12:40:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '87009' 08/08/2023 12:40:40 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 ( '87009' , '18102' , 'CROCE ULIVO DELL\'AMICIZIA - PG748 ' , '1' , '-1' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '1.80' ) 08/08/2023 12:51:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 12:51:19 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' , '2590' , '2023-08-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 08/08/2023 12:51:19 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 = '87010' 08/08/2023 12:51:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '87010' 08/08/2023 12:51:19 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 ( '87010' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 08/08/2023 01:01:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '86/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-08-08') 08/08/2023 01:01:35 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 ( '24' , '86/A' , '2023-08-08' , 'A' , '3213' , '0' , '4669539' , 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.20' , '4.20' , NOW() , NOW() ) 08/08/2023 01:01:35 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 = '87011' 08/08/2023 01:01:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '87011' 08/08/2023 01:01:35 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 ( '87011' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 08/08/2023 01:12:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2568' AND id_document != '86985' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-04') 08/08/2023 01:12:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2568', document_date = '2023-08-04', 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 = '60.00', price_tax_excluded = '57.69', date_upd = NOW() WHERE id_document = '86985' 08/08/2023 01:12:04 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 = '86985' 08/08/2023 01:12:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86985' 08/08/2023 01:12:04 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 ( '86985' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '9' , '8.6538461538462' , '4' , '0' , '9.00' ) 08/08/2023 01:12:04 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 ( '86985' , '16689' , 'OSTIA PAN DI CENA mm80' , '9' , '-9' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '18.00' ) 08/08/2023 01:12:04 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 ( '86985' , '7311' , 'OSTIA SOTTILE 74MM' , '13' , '-13' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '26.00' ) 08/08/2023 01:12:04 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 ( '86985' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/08/2023 01:12:04 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 ( '86985' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/08/2023 01:12:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1771' AND id_document != '84464' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-22') 08/08/2023 01:12:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1771', document_date = '2023-05-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 = '75.60', price_tax_excluded = '65.66', date_upd = NOW() WHERE id_document = '84464' 08/08/2023 01:12:52 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 = '84464' 08/08/2023 01:12:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '84464' 08/08/2023 01:12:52 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 ( '84464' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 08/08/2023 01:12:52 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 ( '84464' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '19.60' ) 08/08/2023 01:12:52 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 ( '84464' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/08/2023 01:12:52 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 ( '84464' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 08/08/2023 01:12:52 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 ( '84464' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 08/08/2023 01:12:52 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 ( '84464' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' )