08/02/2024 08:13:39 am >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '90071' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-24') 08/02/2024 08:13:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2024-01-24', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1424.40', price_tax_excluded = '1243.28', date_upd = NOW() WHERE id_document = '90071' 08/02/2024 08:13: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 = '90071' 08/02/2024 08:13:39 am >> DELETE FROM ps_document_detail WHERE id_document = '90071' 08/02/2024 08:13: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 ( '90071' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 08/02/2024 08:13: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 ( '90071' , '0' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/02/2024 08:13: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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 08/02/2024 08:13: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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/02/2024 08:13: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 ( '90071' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/02/2024 08:13: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/02/2024 08:13: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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 08/02/2024 08:13: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 ( '90071' , '0' , 'spedito il 05/04/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/02/2024 08:13: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 ( '90071' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '200' , '-200' , '4' , '3.5000' , '3.5' , '0' , '40' , '420.00' ) 08/02/2024 08:13: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 ( '90071' , '0' , 'spedito 1/6/23' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/02/2024 08:13: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/02/2024 08:13: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 ( '90071' , '0' , 'spedito 2/11/23' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/02/2024 08:13: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/02/2024 08:13: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 ( '90071' , '12817' , 'LIBRO DEI MATRIMONI' , '3' , '-3' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '72.00' ) 08/02/2024 08:13:40 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 ( '90071' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '40' , '14.40' ) 08/02/2024 08:13:40 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 ( '90071' , '0' , 'spediti 24/01/2024' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/02/2024 08:13:40 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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/02/2024 08:13:40 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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/02/2024 08:13:40 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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/02/2024 08:13:40 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 ( '90071' , '' , '08/02/2024' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 08/02/2024 08:13:40 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '72.00' ) 08/02/2024 09:24:41 am >> SELECT document_num FROM ps_document WHERE document_num = '396' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 09:24:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '396' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.48' , NOW() , NOW() ) 08/02/2024 09:24:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90288' 08/02/2024 09:24:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90288' 08/02/2024 09:24:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90288' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 08/02/2024 09:24:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90288' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 08/02/2024 09:29:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'CUNC01' AND id_product != '21916' AND ean13 != '' 08/02/2024 09:29:22 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'CUNC01', date_upd = NOW() WHERE id_product = '21916' 08/02/2024 09:29:22 am >> UPDATE ps_product_lang SET name = 'TOVAGLIA D\'ALTARE SU MISURA', description = '' WHERE id_product = '21916' 08/02/2024 09:29:22 am >> UPDATE ps_product SET wholesale_price = '55.00', on_sale = '0', price = '114.7541' WHERE id_product = '21916' 08/02/2024 09:29:22 am >> UPDATE ps_product_shop SET wholesale_price = '55.00', price = '114.7541', id_tax_rules_group = '1', id_category_default = '440', 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 = '21916' 08/02/2024 09:29:22 am >> DELETE FROM ps_specific_price WHERE id_product = '21916' 08/02/2024 09:29:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '82' , '2024-02-05' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '67.10' , '55.00' , NOW() , NOW() ) 08/02/2024 09:29:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90289' 08/02/2024 09:29:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90289' 08/02/2024 09:29:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90289' , '21916' , 'TOVAGLIA DALTARE SU MISURA' , '1' , '1' , '1' , '55' , '45.081967213115' , '22' , '0' , '67.1000' ) 08/02/2024 09:29:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21916' AND id_supplier = '122' 08/02/2024 09:29:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21916' , '122' , '1' ) 08/02/2024 09:30:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'CUNC01' AND id_product != '21916' AND ean13 != '' 08/02/2024 09:30:11 am >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = 'CUNC01', date_upd = NOW() WHERE id_product = '21916' 08/02/2024 09:30:11 am >> UPDATE ps_product_lang SET name = 'TOVAGLIA D\'ALTARE SU MISURA', description = '' WHERE id_product = '21916' 08/02/2024 09:30:11 am >> UPDATE ps_product SET wholesale_price = '55.00', on_sale = '0', price = '122.95081967213115' WHERE id_product = '21916' 08/02/2024 09:30:11 am >> UPDATE ps_product_shop SET wholesale_price = '55.00', price = '122.95081967213115', id_tax_rules_group = '1', id_category_default = '440', 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 = '21916' 08/02/2024 09:30:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21916' 08/02/2024 09:32:27 am >> UPDATE ps_document SET id_document_type = '31', document_num = '82', document_date = '2024-02-05', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669556', address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO', address2 = '', note = 'CAMBIARE NUMERO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '67.10', price_tax_excluded = '55.00', date_upd = NOW() WHERE id_document = '90289' 08/02/2024 09:32:27 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 = '90289' 08/02/2024 09:32:27 am >> DELETE FROM ps_document_detail WHERE id_document = '90289' 08/02/2024 09:32:27 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 ( '90289' , '21916' , 'TOVAGLIA DALTARE SU MISURA' , '1' , '1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '67.10' ) 08/02/2024 10:01:21 am >> SELECT document_num FROM ps_document WHERE document_num = '389' AND id_document != '90280' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-07') 08/02/2024 10:01:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '389', document_date = '2024-02-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.50', price_tax_excluded = '16.80', date_upd = NOW() WHERE id_document = '90280' 08/02/2024 10:01:21 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 = '90280' 08/02/2024 10:01:21 am >> DELETE FROM ps_document_detail WHERE id_document = '90280' 08/02/2024 10:01:21 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 ( '90280' , '21594' , 'CARTONCINO 16X23' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/02/2024 10:01:21 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 ( '90280' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '0.50' ) 08/02/2024 10:01:21 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 ( '90280' , '22011' , 'CROCE SAN DAMIANO MOGANO 26X19 - PG552' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 08/02/2024 10:02:38 am >> SELECT document_num FROM ps_document WHERE document_num = '397' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 10:02:38 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' , '397' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.25' , '42.25' , NOW() , NOW() ) 08/02/2024 10:02:38 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 = '90290' 08/02/2024 10:02:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90290' 08/02/2024 10:02:38 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 ( '90290' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '42.25' , '42.25' , '0' , '' , '42.25' ) 08/02/2024 11:46:11 am >> SELECT document_num FROM ps_document WHERE document_num = '398' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 11:46:11 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' , '398' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 08/02/2024 11:46:11 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 = '90291' 08/02/2024 11:46:11 am >> DELETE FROM ps_document_detail WHERE id_document = '90291' 08/02/2024 11:46:11 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 ( '90291' , '22089' , 'QUARESIMA 2024 GIORNO PER GIORNO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 08/02/2024 12:34:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '399' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 12:34:08 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' , '399' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '67.62' , NOW() , NOW() ) 08/02/2024 12:34:08 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 = '90292' 08/02/2024 12:34:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '90292' 08/02/2024 12:34:08 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 ( '90292' , '16834' , 'LITURGICO CARTA 8GG' , '25' , '-25' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '82.50' ) 08/02/2024 03:06:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '400' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 03:06: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' , '400' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 08/02/2024 03:06: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 = '90293' 08/02/2024 03:06:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90293' 08/02/2024 03:06: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 ( '90293' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/02/2024 03:07:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '401' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 03:07:06 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' , '401' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 08/02/2024 03:07:06 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 = '90294' 08/02/2024 03:07:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90294' 08/02/2024 03:07:06 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 ( '90294' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 08/02/2024 03:25:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3' AND id_document != '90215' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-02') 08/02/2024 03:25:52 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '3', document_date = '2024-02-02', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '4410.00', price_tax_excluded = '4410.00', date_upd = NOW() WHERE id_document = '90215' 08/02/2024 03:25: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 = '90215' 08/02/2024 03:25:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90215' 08/02/2024 03:25: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 ( '90215' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '50' , '-50' , '4' , '2.1000' , '2.1' , '0' , '0' , '105.00' ) 08/02/2024 03:25: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 ( '90215' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '110' , '-110' , '4' , '6.0000' , '6' , '0' , '0' , '660.00' ) 08/02/2024 03:25: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 ( '90215' , '16667' , 'VIA CRUCIS' , '300' , '-300' , '4' , '3.0000' , '3' , '0' , '0' , '900.00' ) 08/02/2024 03:25: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 ( '90215' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '20' , '-20' , '4' , '10.0000' , '10' , '0' , '0' , '200.00' ) 08/02/2024 03:25: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 ( '90215' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '90' , '-90' , '4' , '2.5000' , '2.5' , '0' , '0' , '225.00' ) 08/02/2024 03:25: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 ( '90215' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '480' , '-480' , '4' , '2.5000' , '2.5' , '0' , '0' , '1200.00' ) 08/02/2024 03:25: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 ( '90215' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1120' , '-1120' , '4' , '1.0000' , '1' , '0' , '0' , '1120.00' ) 08/02/2024 05:23:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '402' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 05:23: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' , '402' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.60' , '11.60' , NOW() , NOW() ) 08/02/2024 05:23: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 = '90295' 08/02/2024 05:23:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90295' 08/02/2024 05:23: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 ( '90295' , '21920' , 'AMEN - MAR 24' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 08/02/2024 05:23: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 ( '90295' , '21919' , 'AMEN - APR 24' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '0' , '5.80' ) 08/02/2024 05:24:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 05:24:14 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' , '403' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.80' , '189.83' , NOW() , NOW() ) 08/02/2024 05:24:14 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 = '90296' 08/02/2024 05:24:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '90296' 08/02/2024 05:24:14 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 ( '90296' , '21920' , 'AMEN - MAR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/02/2024 05:24:14 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 ( '90296' , '21919' , 'AMEN - APR 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 08/02/2024 05:24:14 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 ( '90296' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/02/2024 05:24:14 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 ( '90296' , '21916' , 'TOVAGLIA D\'ALTARE SU MISURA' , '1' , '-1' , '1' , '150.00' , '122.95081967213' , '22' , '0' , '150.00' ) 08/02/2024 05:24:14 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 ( '90296' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 08/02/2024 05:24:14 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 ( '90296' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 08/02/2024 05:58:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 05:58: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' , '404' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 08/02/2024 05:58: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 = '90297' 08/02/2024 05:58:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90297' 08/02/2024 05:58: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 ( '90297' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/02/2024 06:00:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '405' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 06:00:46 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' , '405' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.99' , NOW() , NOW() ) 08/02/2024 06:00:46 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 = '90298' 08/02/2024 06:00:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '90298' 08/02/2024 06:00:46 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 ( '90298' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.7' , '2.2131147540984' , '22' , '0' , '2.70' ) 08/02/2024 06:00:46 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 ( '90298' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 08/02/2024 06:00:46 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 ( '90298' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 08/02/2024 06:00:46 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 ( '90298' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 08/02/2024 06:00:46 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 ( '90298' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 08/02/2024 07:16:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '406' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 07:16: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' , '406' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '30.00' , NOW() , NOW() ) 08/02/2024 07:16: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 = '90299' 08/02/2024 07:16:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '90299' 08/02/2024 07:16: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 ( '90299' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 08/02/2024 07:50:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 07:50:16 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' , '407' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.50' , '64.34' , NOW() , NOW() ) 08/02/2024 07:50:16 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 = '90300' 08/02/2024 07:50:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90300' 08/02/2024 07:50:16 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 ( '90300' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 08/02/2024 07:50:16 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 ( '90300' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 08/02/2024 07:50:16 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 ( '90300' , '17257' , 'IO TI BATTEZZO ' , '10' , '-10' , '4' , '1.80' , '1.8' , '0' , '5' , '17.10' ) 08/02/2024 07:50:16 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 ( '90300' , '15492' , 'CROCE SAN BENEDETTO CON BASE E LEGNO - CZ6BSNIK' , '1' , '-1' , '1' , '29.50' , '24.180327868852' , '22' , '0' , '29.50' ) 08/02/2024 07:50:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-08') 08/02/2024 07:50: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' , '408' , '2024-02-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 08/02/2024 07:50: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 = '90301' 08/02/2024 07:50:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90301' 08/02/2024 07:50: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 ( '90301' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' )