22/12/2023 09:05:42 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' , '3999/2023' , '2023-12-18' , '2023' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '11' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '293.89' , '240.89' , NOW() , NOW() ) 22/12/2023 09:05:42 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 = '89637' 22/12/2023 09:05:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89637' 22/12/2023 09:05:42 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 ( '89637' , '15537' , 'AMITTO PURO LINO RICAMO A MANO' , '1' , '1' , '1' , '28.5' , '23.360655737705' , '22' , '3' , '33.7269' ) 22/12/2023 09:05:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '15537' AND id_supplier = '129' 22/12/2023 09:05:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15537' , '129' , '1' ) 22/12/2023 09:05:42 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 ( '89637' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO' , '3' , '3' , '1' , '69.5' , '56.967213114754' , '22' , '3' , '246.7389' ) 22/12/2023 09:05:43 am >> DELETE FROM ps_product_supplier WHERE id_product = '15541' AND id_supplier = '129' 22/12/2023 09:05:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15541' , '129' , '1' ) 22/12/2023 09:18:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 09:18:20 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' , '4113' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.30' , '29.32' , NOW() , NOW() ) 22/12/2023 09:18:20 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 = '89638' 22/12/2023 09:18:20 am >> DELETE FROM ps_document_detail WHERE id_document = '89638' 22/12/2023 09:18:20 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 ( '89638' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 22/12/2023 09:18:20 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 ( '89638' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/12/2023 09:18:20 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 ( '89638' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/12/2023 09:18:20 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 ( '89638' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 22/12/2023 09:22:30 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001575' AND id_product != '18339' AND ean13 != '' 22/12/2023 09:22:30 am >> UPDATE ps_product SET id_supplier = '91', reference = '', ean13 = '001575', date_upd = NOW() WHERE id_product = '18339' 22/12/2023 09:22:30 am >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI', description = '' WHERE id_product = '18339' 22/12/2023 09:22:30 am >> UPDATE ps_product SET wholesale_price = '4.98', on_sale = '0', price = '9.0164' WHERE id_product = '18339' 22/12/2023 09:22:30 am >> UPDATE ps_product_shop SET wholesale_price = '4.98', price = '9.0164', id_tax_rules_group = '1', id_category_default = '401', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18339' 22/12/2023 09:22:30 am >> DELETE FROM ps_specific_price WHERE id_product = '18339' 22/12/2023 09:26:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 09:26: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' , '4114' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '15.98' , NOW() , NOW() ) 22/12/2023 09:26: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 = '89639' 22/12/2023 09:26:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89639' 22/12/2023 09:26: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 ( '89639' , '21150' , 'QUADRO 15X15' , '1' , '-1' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '19.50' ) 22/12/2023 09:58:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 09:58:35 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' , '4115' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.40' , '50.13' , NOW() , NOW() ) 22/12/2023 09:58:35 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 = '89640' 22/12/2023 09:58:35 am >> DELETE FROM ps_document_detail WHERE id_document = '89640' 22/12/2023 09:58:35 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 ( '89640' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '6' , '-6' , '1' , '5' , '4.0983606557377' , '22' , '0' , '30.00' ) 22/12/2023 09:58:35 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 ( '89640' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '1' , '-1' , '1' , '4.70' , '3.8524590163934' , '22' , '0' , '4.70' ) 22/12/2023 09:58:35 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 ( '89640' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/12/2023 09:58:35 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 ( '89640' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.6' , '4.5901639344262' , '22' , '0' , '5.60' ) 22/12/2023 10:01:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:01:12 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' , '4116' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.43' , NOW() , NOW() ) 22/12/2023 10:01:12 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 = '89641' 22/12/2023 10:01:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89641' 22/12/2023 10:01:12 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 ( '89641' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.4' , '4.4262295081967' , '22' , '0' , '5.40' ) 22/12/2023 10:18:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:18:46 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' , '4117' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '127.00' , '105.36' , NOW() , NOW() ) 22/12/2023 10:18: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 = '89642' 22/12/2023 10:18:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89642' 22/12/2023 10:18: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 ( '89642' , '13345' , 'PRESEPE LEGNO' , '10' , '-10' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '75.00' ) 22/12/2023 10:18: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 ( '89642' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '10' , '-10' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '45.00' ) 22/12/2023 10:18: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 ( '89642' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 22/12/2023 10:18: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 ( '89642' , '16518' , 'ADMIRABILE SIGNUM' , '1' , '-1' , '4' , '1.20' , '1.2' , '0' , '0' , '1.20' ) 22/12/2023 10:36:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:36: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' , '4118' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.00' , '45.19' , NOW() , NOW() ) 22/12/2023 10:36: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 = '89643' 22/12/2023 10:36:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89643' 22/12/2023 10:36: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 ( '89643' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/12/2023 10:36: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 ( '89643' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/12/2023 10:36: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 ( '89643' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/12/2023 10:39:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:39:06 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' , '4119' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '17.95' , NOW() , NOW() ) 22/12/2023 10:39:06 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 = '89644' 22/12/2023 10:39:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89644' 22/12/2023 10:39:06 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 ( '89644' , '18172' , 'CONFEZIONE SCATOLA PORTA CIUCCIO' , '1' , '-1' , '1' , '21.90' , '17.950819672131' , '22' , '0' , '21.90' ) 22/12/2023 10:41:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:41:48 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' , '4120' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.17' , NOW() , NOW() ) 22/12/2023 10:41:48 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 = '89645' 22/12/2023 10:41:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89645' 22/12/2023 10:41:48 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 ( '89645' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 22/12/2023 10:53:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:53:35 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' , '4121' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '89.92' , NOW() , NOW() ) 22/12/2023 10:53:35 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 = '89646' 22/12/2023 10:53:35 am >> DELETE FROM ps_document_detail WHERE id_document = '89646' 22/12/2023 10:53:35 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 ( '89646' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/12/2023 10:53:35 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 ( '89646' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 22/12/2023 10:53:35 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 ( '89646' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4' , '3.8461538461538' , '4' , '0' , '4.00' ) 22/12/2023 10:53:35 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 ( '89646' , '7202' , 'ARTICOLI RELIGIOSI' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 22/12/2023 10:53:35 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 ( '89646' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 22/12/2023 10:53:35 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 ( '89646' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 22/12/2023 10:54:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 10:54: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 ( '11' , '4122' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.20' , '25.57' , NOW() , NOW() ) 22/12/2023 10:54: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 = '89647' 22/12/2023 10:54:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89647' 22/12/2023 10:54: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 ( '89647' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 22/12/2023 10:54: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 ( '89647' , '19253' , 'bruciaincenso cm 9' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 22/12/2023 10:54: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 ( '89647' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 22/12/2023 11:00:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30-246' AND id_product != '19253' AND ean13 != '' 22/12/2023 11:00:31 am >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-246', date_upd = NOW() WHERE id_product = '19253' 22/12/2023 11:00:31 am >> UPDATE ps_product_lang SET name = 'BRUCIAINCENSO CM 9', description = '' WHERE id_product = '19253' 22/12/2023 11:00:31 am >> UPDATE ps_product SET wholesale_price = '6.82', on_sale = '0', price = '15.5738' WHERE id_product = '19253' 22/12/2023 11:00:31 am >> UPDATE ps_product_shop SET wholesale_price = '6.82', price = '15.5738', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19253' 22/12/2023 11:00:31 am >> DELETE FROM ps_specific_price WHERE id_product = '19253' 22/12/2023 11:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4025' AND id_document != '89535' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-16') 22/12/2023 11:20:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4025', document_date = '2023-12-16', 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 = '67.28', price_tax_excluded = '55.92', date_upd = NOW() WHERE id_document = '89535' 22/12/2023 11:20: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 = '89535' 22/12/2023 11:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89535' 22/12/2023 11:20: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 ( '89535' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '100' , '-100' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '50.00' ) 22/12/2023 11:20: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 ( '89535' , '20422' , 'PRESEPE' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 22/12/2023 11:20: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 ( '89535' , '14789' , 'NATIVITA STELLATA 18 CM' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 22/12/2023 11:26:49 am >> SELECT document_num FROM ps_document WHERE document_num = '4123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 11:26:49 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' , '4123' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.80' , '19.51' , NOW() , NOW() ) 22/12/2023 11:26:49 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 = '89648' 22/12/2023 11:26:49 am >> DELETE FROM ps_document_detail WHERE id_document = '89648' 22/12/2023 11:26:49 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 ( '89648' , '20177' , 'ANGELO SU CUORE CM 6,5 - AR112' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/12/2023 11:26:49 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 ( '89648' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/12/2023 11:26:49 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 ( '89648' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/12/2023 11:38:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '30-246' AND id_product != '19253' AND ean13 != '' 22/12/2023 11:38:51 am >> UPDATE ps_product SET id_supplier = '86', reference = '', ean13 = '30-246', date_upd = NOW() WHERE id_product = '19253' 22/12/2023 11:38:51 am >> UPDATE ps_product_lang SET name = 'BRUCIAINCENSO CM 9', description = '' WHERE id_product = '19253' 22/12/2023 11:38:51 am >> UPDATE ps_product SET wholesale_price = '6.82', on_sale = '0', price = '15.5738' WHERE id_product = '19253' 22/12/2023 11:38:51 am >> UPDATE ps_product_shop SET wholesale_price = '6.82', price = '15.5738', id_tax_rules_group = '1', id_category_default = '394', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19253' 22/12/2023 11:38:51 am >> DELETE FROM ps_specific_price WHERE id_product = '19253' 22/12/2023 11:56:58 am >> SELECT document_num FROM ps_document WHERE document_num = '4124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 11:56: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' , '4124' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.55' , '34.78' , NOW() , NOW() ) 22/12/2023 11:56: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 = '89649' 22/12/2023 11:56:58 am >> DELETE FROM ps_document_detail WHERE id_document = '89649' 22/12/2023 11:56: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 ( '89649' , '14167' , 'BORSETTA PORTA TECA ' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 22/12/2023 11:56: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 ( '89649' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 22/12/2023 11:56: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 ( '89649' , '21812' , 'PREGHIERA E CONOSCENZA DI SE - A. GRUN' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 22/12/2023 11:59:17 am >> SELECT document_num FROM ps_document WHERE document_num = '146/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 11:59:17 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 ( '24' , '146/A' , '2023-12-22' , 'A' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '18.84' , NOW() , NOW() ) 22/12/2023 11:59: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 = '89650' 22/12/2023 11:59:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89650' 22/12/2023 11:59: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 ( '89650' , '22015' , 'MEDJUGORJE VERA STORIA - 8593' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 22/12/2023 11:59: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 ( '89650' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/12/2023 12:00:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '4125' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:00:24 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' , '4125' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '340.00' , '278.69' , NOW() , NOW() ) 22/12/2023 12:00:24 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 = '89651' 22/12/2023 12:00:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89651' 22/12/2023 12:00:24 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 ( '89651' , '19449' , 'CAMICE F/LANA - 6995' , '1' , '-1' , '1' , '340' , '278.68852459016' , '22' , '0' , '340.00' ) 22/12/2023 12:02:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '4126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:02:27 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' , '4126' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 22/12/2023 12:02:27 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 = '89652' 22/12/2023 12:02:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89652' 22/12/2023 12:02:27 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 ( '89652' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '0' , '25.00' ) 22/12/2023 12:02:27 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 ( '89652' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 22/12/2023 12:02:41 pm >> DELETE FROM ps_document WHERE id_document = '89652' 22/12/2023 12:02:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89652' 22/12/2023 12:03:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:03:15 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' , '4126' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 22/12/2023 12:03:15 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 = '89653' 22/12/2023 12:03:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89653' 22/12/2023 12:03:15 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 ( '89653' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '0' , '85.00' ) 22/12/2023 12:03:31 pm >> DELETE FROM ps_document WHERE id_document = '89653' 22/12/2023 12:03:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89653' 22/12/2023 12:05:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '4126' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:05:44 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' , '4126' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.60' , '26.45' , NOW() , NOW() ) 22/12/2023 12:05:44 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 = '89654' 22/12/2023 12:05:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89654' 22/12/2023 12:05:44 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 ( '89654' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/12/2023 12:05:44 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 ( '89654' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 22/12/2023 12:16:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4127' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:16:45 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' , '4127' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 22/12/2023 12:16:45 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 = '89655' 22/12/2023 12:16:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89655' 22/12/2023 12:16:45 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 ( '89655' , '6342' , 'MEDAGLIA S. BENEDETTO ARGENTO - RA633' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 22/12/2023 12:16:45 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 ( '89655' , '6343' , 'MEDAGLIA S. BENEDETTO ARGENTO - MM18 - RA 634' , '1' , '-1' , '1' , '32.00' , '26.229508196721' , '22' , '0' , '32.00' ) 22/12/2023 12:34:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3823' AND id_document != '89263' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-01') 22/12/2023 12:34:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3823', document_date = '2023-12-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 = '141.10', price_tax_excluded = '117.37', date_upd = NOW() WHERE id_document = '89263' 22/12/2023 12:34:27 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 = '89263' 22/12/2023 12:34:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89263' 22/12/2023 12:34:27 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 ( '89263' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 22/12/2023 12:34:27 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 ( '89263' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '1.60' ) 22/12/2023 12:34:27 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 ( '89263' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '-10' , '4' , '1.0000' , '1' , '0' , '5' , '9.50' ) 22/12/2023 12:34:27 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 ( '89263' , '19076' , 'NATIVITA 5 PEZZI CM 30 - PB8026' , '1' , '-1' , '1' , '128.00' , '104.91803278689' , '22' , '0' , '128.00' ) 22/12/2023 12:35:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '4128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:35: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' , '4128' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.10' , '112.10' , NOW() , NOW() ) 22/12/2023 12:35: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 = '89656' 22/12/2023 12:35:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89656' 22/12/2023 12:35: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 ( '89656' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '22' , '-22' , '4' , '5.00' , '5' , '0' , '5' , '104.50' ) 22/12/2023 12:35: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 ( '89656' , '21868' , 'MESSA MEDITAZIONE - GEN/FEB 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/12/2023 12:54:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 12:54:52 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' , '4129' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/12/2023 12:54: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 = '89657' 22/12/2023 12:54:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '89657' 22/12/2023 12:54: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 ( '89657' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/12/2023 03:00:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 03:00:17 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' , '4130' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.10' , '36.10' , NOW() , NOW() ) 22/12/2023 03:00:17 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 = '89658' 22/12/2023 03:00:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89658' 22/12/2023 03:00:17 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 ( '89658' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 22/12/2023 03:02:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '4131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 03:02: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' , '4131' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 22/12/2023 03:02: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 = '89659' 22/12/2023 03:02:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89659' 22/12/2023 03:02: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 ( '89659' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 22/12/2023 03:37:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3751' AND id_document != '89168' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-27') 22/12/2023 03:37:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3751', document_date = '2023-11-27', 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 = '87.80', price_tax_excluded = '71.97', date_upd = NOW() WHERE id_document = '89168' 22/12/2023 03:37:12 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 = '89168' 22/12/2023 03:37:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89168' 22/12/2023 03:37:12 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 ( '89168' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 22/12/2023 03:37:12 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 ( '89168' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 22/12/2023 03:37:13 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 ( '89168' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 22/12/2023 03:44:29 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 ( '32' , '2754/2023' , '2023-12-22' , '2023' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '95.12' , '77.97' , NOW() , NOW() ) 22/12/2023 03:44:29 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 = '89660' 22/12/2023 03:44:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89660' 22/12/2023 03:44:29 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 ( '89660' , '21862' , 'BAMBINELLO CM 20 - PKS20-C' , '2' , '0' , '1' , '12.0000' , '9.8361' , '22' , '10' , '26.35' ) 22/12/2023 03:44:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21862' AND id_supplier = '43' 22/12/2023 03:44:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21862' , '43' , '1' ) 22/12/2023 03:44:29 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 ( '89660' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '1' , '0' , '1' , '13.5000' , '11.0656' , '22' , '10' , '14.82' ) 22/12/2023 03:44:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20970' AND id_supplier = '43' 22/12/2023 03:44:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20970' , '43' , '1' ) 22/12/2023 03:44:29 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 ( '89660' , '22010' , 'CROCE SAN DAMIANO 40X30 - PG553' , '1' , '0' , '1' , '13.5200' , '11.082' , '22' , '10' , '14.85' ) 22/12/2023 03:44:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22010' AND id_supplier = '43' 22/12/2023 03:44:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22010' , '43' , '1' ) 22/12/2023 03:44:29 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 ( '89660' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '1' , '0' , '1' , '7.6200' , '6.2459' , '22' , '10' , '8.37' ) 22/12/2023 03:44:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22011' AND id_supplier = '43' 22/12/2023 03:44:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22011' , '43' , '1' ) 22/12/2023 03:44:30 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 ( '89660' , '22012' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG092' , '1' , '0' , '1' , '11.5800' , '9.4918' , '22' , '10' , '12.71' ) 22/12/2023 03:44:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22012' AND id_supplier = '43' 22/12/2023 03:44:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22012' , '43' , '1' ) 22/12/2023 03:44:30 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 ( '89660' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '0' , '1' , '5.3000' , '4.3443' , '22' , '10' , '5.82' ) 22/12/2023 03:44:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20964' AND id_supplier = '43' 22/12/2023 03:44:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20964' , '43' , '1' ) 22/12/2023 04:43:48 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'eiFA6BymxYpZJqYJ' , NOW() , NOW() ) 22/12/2023 04:43:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7081' , '1' ) 22/12/2023 04:43:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7081' , '2' ) 22/12/2023 04:43:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7081' , '3' ) 22/12/2023 04:45:06 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7081' 22/12/2023 04:45:06 pm >> 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 ( '7081' , '10' , '123' , 'IST. SUORE DI SANTA CHIARA FRANCESCANA' , '' , '' , 'VIA ATRIO VAL VERDE 1' , '' , '92019' , 'SCIACCA' , '' , '' , '3290250808' , '' , '' , NOW() , NOW() ) 22/12/2023 04:45:06 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7081' 22/12/2023 05:00:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 05:00:53 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' , '4132' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/12/2023 05:00: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 = '89661' 22/12/2023 05:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89661' 22/12/2023 05:00:53 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 ( '89661' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/12/2023 05:04:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 05:04:10 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' , '4133' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '26.44' , NOW() , NOW() ) 22/12/2023 05:04:10 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 = '89662' 22/12/2023 05:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89662' 22/12/2023 05:04:10 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 ( '89662' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 22/12/2023 05:04:10 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 ( '89662' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/12/2023 05:38:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 05:38:22 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' , '4134' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.60' , '17.70' , NOW() , NOW() ) 22/12/2023 05:38:22 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 = '89663' 22/12/2023 05:38:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89663' 22/12/2023 05:38:22 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 ( '89663' , '13286' , 'NATIVITA IN PORCELLANA CON LED CM 9,5' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/12/2023 05:38:22 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 ( '89663' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 22/12/2023 05:38:22 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 ( '89663' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '1' , '-1' , '1' , '2.30' , '1.8852459016393' , '22' , '0' , '2.30' ) 22/12/2023 05:38:22 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 ( '89663' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 22/12/2023 05:41:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 05:41:58 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' , '4135' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 22/12/2023 05:41:58 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 = '89664' 22/12/2023 05:41:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '89664' 22/12/2023 05:41:58 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 ( '89664' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '10' , '-10' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '15.00' ) 22/12/2023 06:09:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 06:09:05 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' , '4136' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.50' , '58.61' , NOW() , NOW() ) 22/12/2023 06:09:05 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 = '89665' 22/12/2023 06:09:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89665' 22/12/2023 06:09:05 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 ( '89665' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '5' , '-5' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '32.50' ) 22/12/2023 06:09:05 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 ( '89665' , '16318' , 'NATIVITA 11X9' , '2' , '-2' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '32.00' ) 22/12/2023 06:09:05 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 ( '89665' , '16319' , 'NATIVITA CM 8X8' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 22/12/2023 06:27:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '4137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 06:27:25 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' , '4137' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 22/12/2023 06:27:25 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 = '89666' 22/12/2023 06:27:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '89666' 22/12/2023 06:27:25 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 ( '89666' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 22/12/2023 06:35:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '4138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 06:35:43 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' , '4138' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 22/12/2023 06:35:43 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 = '89667' 22/12/2023 06:35:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89667' 22/12/2023 06:35:43 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 ( '89667' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/12/2023 06:35:43 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 ( '89667' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/12/2023 06:43:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '4139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 06:43: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' , '4139' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '25.89' , NOW() , NOW() ) 22/12/2023 06:43: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 = '89668' 22/12/2023 06:43:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89668' 22/12/2023 06:43: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 ( '89668' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 22/12/2023 06:43: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 ( '89668' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/12/2023 06:59:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '4140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 06:59: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' , '4140' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.10' , '34.31' , NOW() , NOW() ) 22/12/2023 06:59: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 = '89669' 22/12/2023 06:59:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89669' 22/12/2023 06:59: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 ( '89669' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 22/12/2023 06:59: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 ( '89669' , '21688' , 'ANGELO PIEGHEVOLE CM 15' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 22/12/2023 06:59: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 ( '89669' , '21689' , 'ANGELO PIEGHEVOLE CM 12' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/12/2023 07:05:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:05:17 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' , '4141' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '22.00' , NOW() , NOW() ) 22/12/2023 07:05:17 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 = '89670' 22/12/2023 07:05:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89670' 22/12/2023 07:05:17 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 ( '89670' , '942' , 'BAMBINO CM 5 - FOSFORO - PX' , '2' , '-2' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '0.80' ) 22/12/2023 07:05:17 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 ( '89670' , '6402' , 'MENSA BIANCA 60X200 ' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 22/12/2023 07:05:17 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 ( '89670' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/12/2023 07:05:17 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 ( '89670' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 22/12/2023 07:05: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 ( '89670' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 22/12/2023 07:06:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:07: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 ( '11' , '4142' , '2023-12-22' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '46.25' , NOW() , NOW() ) 22/12/2023 07:07: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 = '89671' 22/12/2023 07:07:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89671' 22/12/2023 07:07: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 ( '89671' , '11151' , 'LIBRI' , '200' , '-200' , '4' , '0.1200' , '0.12' , '0' , '0' , '24.00' ) 22/12/2023 07:07: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 ( '89671' , '16518' , 'ADMIRABILE SIGNUM' , '10' , '-10' , '4' , '1.2000' , '1.2' , '0' , '0' , '12.00' ) 22/12/2023 07:07: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 ( '89671' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '5' , '-5' , '1' , '1.3000' , '1.0656' , '22' , '0' , '6.50' ) 22/12/2023 07:07: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 ( '89671' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '10' , '-10' , '1' , '0.6000' , '0.4918' , '22' , '0' , '6.00' ) 22/12/2023 07:07:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:07:41 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' , '4143' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 22/12/2023 07:07:41 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 = '89672' 22/12/2023 07:07:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89672' 22/12/2023 07:07: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 ( '89672' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 22/12/2023 07:08:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4142' AND id_document != '89671' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:08:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4142', document_date = '2023-12-22', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '48.50', price_tax_excluded = '46.25', date_upd = NOW() WHERE id_document = '89671' 22/12/2023 07:08:32 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 = '89671' 22/12/2023 07:08:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89671' 22/12/2023 07:08:32 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 ( '89671' , '11151' , 'LIBRI' , '200' , '-200' , '4' , '0.1200' , '0.12' , '0' , '0' , '24.00' ) 22/12/2023 07:08:32 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 ( '89671' , '16518' , 'ADMIRABILE SIGNUM' , '10' , '-10' , '4' , '1.2000' , '1.2' , '0' , '0' , '12.00' ) 22/12/2023 07:08:32 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 ( '89671' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '5' , '-5' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '6.50' ) 22/12/2023 07:08:32 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 ( '89671' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '10' , '-10' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '6.00' ) 22/12/2023 07:10:05 pm >> DELETE FROM ps_document WHERE id_document = '89397' 22/12/2023 07:10:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89397' 22/12/2023 07:11:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '4144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:11:32 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' , '4144' , '2023-12-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 22/12/2023 07:11:32 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 = '89673' 22/12/2023 07:11:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89673' 22/12/2023 07:11:32 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 ( '89673' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 22/12/2023 07:29:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '4137' AND id_document != '89666' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:29:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4137', document_date = '2023-12-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '89666' 22/12/2023 07:29:23 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 = '89666' 22/12/2023 07:29:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '89666' 22/12/2023 07:29:23 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 ( '89666' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 22/12/2023 07:29:23 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 ( '89666' , '17563' , 'PRESEPE TERRACOTTA - P288' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 22/12/2023 07:44:00 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16321' 22/12/2023 07:44:00 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '16321' 22/12/2023 07:45:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '89565' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 22/12/2023 07:45:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4048', document_date = '2023-12-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 = '29.90', price_tax_excluded = '24.51', date_upd = NOW() WHERE id_document = '89565' 22/12/2023 07:45:10 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 = '89565' 22/12/2023 07:45:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89565' 22/12/2023 07:45:10 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 ( '89565' , '17563' , 'PRESEPE TERRACOTTA - P288' , '1' , '-1' , '1' , '29.9' , '24.508196721311' , '22' , '0' , '29.90' ) 22/12/2023 07:45:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '4121' AND id_document != '89646' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-22') 22/12/2023 07:45:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4121', document_date = '2023-12-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 = '100.00', price_tax_excluded = '89.92', date_upd = NOW() WHERE id_document = '89646' 22/12/2023 07:45:49 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 = '89646' 22/12/2023 07:45:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89646' 22/12/2023 07:45:49 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 ( '89646' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/12/2023 07:45:49 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 ( '89646' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 22/12/2023 07:45:49 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 ( '89646' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '4.00' ) 22/12/2023 07:45:49 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 ( '89646' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/12/2023 07:45:49 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 ( '89646' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/12/2023 07:45:49 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 ( '89646' , '16318' , 'NATIVITA 11X9' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 22/12/2023 07:45:49 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 ( '89646' , '17562' , 'PRESEPE TERRACOTTA - P287' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' )