17/11/2023 09:53:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3345' AND id_document != '88558' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 17/11/2023 09:53:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3345', document_date = '2023-10-26', 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 = '3', id_causal = '0', price_tax_included = '348.87', price_tax_excluded = '348.74', date_upd = NOW() WHERE id_document = '88558' 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88558' 17/11/2023 09:53:02 am >> DELETE FROM ps_document_detail WHERE id_document = '88558' 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '10' , '32.40' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '10' , '16.20' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '10' , '40.50' ) 17/11/2023 09:53:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88558' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '12' , '-12' , '4' , '3.0000' , '3' , '0' , '10' , '32.40' ) 17/11/2023 09:53:03 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 ( '88558' , '5444' , 'IO SONO CON VOI - CAT.' , '3' , '-3' , '4' , '5.5000' , '5.5' , '0' , '5' , '15.69' ) 17/11/2023 09:53:03 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 ( '88558' , '2679' , 'CONOSCERE GESU' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '10' , '15.75' ) 17/11/2023 09:53:03 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 ( '88558' , '2867' , 'CREDO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 17/11/2023 09:53:03 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 ( '88558' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.9000' , '7.9' , '0' , '5' , '7.51' ) 17/11/2023 09:53:03 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 ( '88558' , '3666' , 'DONI DELLO SPIRITO SANTO SPIEGATI AI RAGAZZI - V. BOCCI' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 17/11/2023 09:53:03 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 ( '88558' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 17/11/2023 09:53:03 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 ( '88558' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '1' , '-1' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '0.70' ) 17/11/2023 10:13:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3640' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:13:31 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' , '3640' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.22' , '40.22' , NOW() , NOW() ) 17/11/2023 10:13:31 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 = '89003' 17/11/2023 10:13:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89003' 17/11/2023 10:13:31 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 ( '89003' , '21829' , 'ANIMA DI OGNI APOSTOLATO - D. CHAUTARD' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 17/11/2023 10:13:31 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 ( '89003' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 17/11/2023 10:13:31 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 ( '89003' , '21515' , 'CINQUE PANI DORZO 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 17/11/2023 10:13:31 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 ( '89003' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 17/11/2023 10:28:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3641' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:28:51 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' , '3641' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.55' , '28.36' , NOW() , NOW() ) 17/11/2023 10:28:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89004' 17/11/2023 10:28:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89004' 17/11/2023 10:28:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89004' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/11/2023 10:28:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89004' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '19.00' ) 17/11/2023 10:28:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89004' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 17/11/2023 10:31:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3642' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:31:59 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' , '3642' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.80' , '60.80' , NOW() , NOW() ) 17/11/2023 10:31:59 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 = '89005' 17/11/2023 10:31:59 am >> DELETE FROM ps_document_detail WHERE id_document = '89005' 17/11/2023 10:31:59 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 ( '89005' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 17/11/2023 10:31:59 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 ( '89005' , '21742' , 'MARIA, LA DONNA PIU BELLA - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 17/11/2023 10:31:59 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 ( '89005' , '21713' , 'FEDE SPERANZA E CARITA - R. CANTALAMESSA' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 17/11/2023 10:32:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3643' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:32:16 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' , '3643' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.16' , '33.16' , NOW() , NOW() ) 17/11/2023 10:32:16 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 = '89006' 17/11/2023 10:32:16 am >> DELETE FROM ps_document_detail WHERE id_document = '89006' 17/11/2023 10:32:16 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 ( '89006' , '21774' , 'COME FRANCESCO INVENTO IL PRESEPE - A. FOLI' , '1' , '-1' , '4' , '19.90' , '19.9' , '0' , '5' , '18.91' ) 17/11/2023 10:32:16 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 ( '89006' , '21576' , 'LUNGO LA STRADA CON LUI - ANNO B - P.R. SCALABRINI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 17/11/2023 10:34:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3644' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:34:36 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' , '3644' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 17/11/2023 10:34:36 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 = '89007' 17/11/2023 10:34:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89007' 17/11/2023 10:34:36 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 ( '89007' , '21798' , 'ENCICLICA DEI BAMBINI - FORTUNATO / CAGNOLI' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 17/11/2023 10:35:46 am >> SELECT document_num FROM ps_document WHERE document_num = '273' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:35: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 ( '21' , '273' , '2023-11-17' , '' , '260' , '0' , '4670956' , 'PIAZZA UMBERTO I, 2 03032 ARCE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '197.20' , '197.20' , NOW() , NOW() ) 17/11/2023 10:35: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 = '89008' 17/11/2023 10:35:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89008' 17/11/2023 10:35: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 ( '89008' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '40' , '-40' , '4' , '3.40' , '3.4' , '0' , '15' , '115.60' ) 17/11/2023 10:35: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 ( '89008' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '40' , '-40' , '4' , '2.40' , '2.4' , '0' , '15' , '81.60' ) 17/11/2023 10:41:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3645' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:41:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3645' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.35' , '13.35' , NOW() , NOW() ) 17/11/2023 10:41:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89009' 17/11/2023 10:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '89009' 17/11/2023 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89009' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/11/2023 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89009' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 17/11/2023 10:41:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89009' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 17/11/2023 10:44:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3646' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 10:44:53 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' , '3646' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.60' , '27.60' , NOW() , NOW() ) 17/11/2023 10:44:53 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 = '89010' 17/11/2023 10:44:53 am >> DELETE FROM ps_document_detail WHERE id_document = '89010' 17/11/2023 10:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89010' , '18126' , 'ROSARIO LIVATINO - IL GIUDICE GIUSTO' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 17/11/2023 10:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89010' , '19135' , 'ESERCIZI SPIRITUALI S. IGNAZIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 17/11/2023 10:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89010' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 17/11/2023 11:02:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3647' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:02:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3647' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.40' , '54.43' , NOW() , NOW() ) 17/11/2023 11:02:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89011' 17/11/2023 11:02:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89011' 17/11/2023 11:02:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89011' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 17/11/2023 11:02:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89011' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 17/11/2023 11:06:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3648' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:06:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3648' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 17/11/2023 11:06:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89012' 17/11/2023 11:06:05 am >> DELETE FROM ps_document_detail WHERE id_document = '89012' 17/11/2023 11:06:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89012' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 17/11/2023 11:10:21 am >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:10:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '105' , '2023-11-17' , '' , '7076' , '0' , '158690079' , 'Via Fontana dei salici , 66 83030 Villanova del battista' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '32.55' , '32.55' , NOW() , NOW() ) 17/11/2023 11:10: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 = '13496' 17/11/2023 11:10:21 am >> DELETE FROM ps_document_detail WHERE id_document = '13496' 17/11/2023 11:10: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 ( '13496' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '18' , '-18' , '4' , '1.50' , '1.5' , '0' , '5' , '25.65' ) 17/11/2023 11:18:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '648653' , '2023-11-15' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.31' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.85' , '145.85' , NOW() , NOW() ) 17/11/2023 11:18:03 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 = '89013' 17/11/2023 11:18:03 am >> DELETE FROM ps_document_detail WHERE id_document = '89013' 17/11/2023 11:18:03 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 ( '89013' , '21663' , 'CORAGGIO DI UNA DONNA ' , '3' , '3' , '4' , '5.00' , '5' , '0' , '30' , '10.5000' ) 17/11/2023 11:18:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21663' AND id_supplier = '7' 17/11/2023 11:18:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21663' , '7' , '1' ) 17/11/2023 11:18:03 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 ( '89013' , '21834' , 'PAPIA ' , '2' , '2' , '4' , '7.80' , '7.8' , '0' , '30' , '10.9200' ) 17/11/2023 11:18:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '21834' AND id_supplier = '7' 17/11/2023 11:18:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21834' , '7' , '1' ) 17/11/2023 11:18:03 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 ( '89013' , '529' , 'AMORIS LAETITIA' , '84' , '84' , '4' , '2.20' , '2.2' , '0' , '35' , '120.1200' ) 17/11/2023 11:18:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '7' 17/11/2023 11:18:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '7' , '1' ) 17/11/2023 11:18:03 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 ( '89013' , '529' , 'AMORIS LAETITIA' , '7' , '7' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 17/11/2023 11:18:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '529' AND id_supplier = '7' 17/11/2023 11:18:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '529' , '7' , '1' ) 17/11/2023 11:23:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3649' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:23: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' , '3649' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.80' , '103.95' , NOW() , NOW() ) 17/11/2023 11:23: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 = '89014' 17/11/2023 11:23:35 am >> DELETE FROM ps_document_detail WHERE id_document = '89014' 17/11/2023 11:23: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 ( '89014' , '19231' , 'CARD CARLO ACUTIS - RN93' , '19' , '-19' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '19.00' ) 17/11/2023 11:23: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 ( '89014' , '18005' , 'MEDAGLIETTA CARLO ACUTIS' , '80' , '-80' , '1' , '1' , '0.81967213114754' , '22' , '0' , '80.00' ) 17/11/2023 11:23: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 ( '89014' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '4' , '-4' , '4' , '6.00' , '6' , '0' , '5' , '22.80' ) 17/11/2023 11:39:18 am >> SELECT document_num FROM ps_document WHERE document_num = '274' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:39:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '274' , '2023-11-17' , '' , '302' , '0' , '4672778' , 'VIA F. LLI ROSSELLI 84096 MONTECORVINO ROVELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '59.50' , '59.50' , NOW() , NOW() ) 17/11/2023 11:39:18 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 = '89015' 17/11/2023 11:39:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89015' 17/11/2023 11:39:18 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 ( '89015' , '2679' , 'CONOSCERE GESU' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 17/11/2023 11:46:17 am >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '13496' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 11:46:17 am >> UPDATE ps_document SET id_document_type = '21', document_num = '105', document_date = '2023-11-17', document_letter = '', id_customer = '7076', id_supplier = '', id_address = '158690079', address1 = 'Via Fontana dei salici , 66 83030 Villanova del battista', address2 = '', note = '', price_shipping = '6.99', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '32.64', price_tax_excluded = '32.64', date_upd = NOW() WHERE id_document = '13496' 17/11/2023 11:46: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 = '13496' 17/11/2023 11:46:17 am >> DELETE FROM ps_document_detail WHERE id_document = '13496' 17/11/2023 11:46: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 ( '13496' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '18' , '-18' , '4' , '1.5000' , '1.5' , '0' , '5' , '25.65' ) 17/11/2023 12:04:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 12:04:02 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 ( '21' , '275' , '2023-11-17' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , 'SCONTO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 17/11/2023 12:04:02 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 = '89016' 17/11/2023 12:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89016' 17/11/2023 12:04:02 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 ( '89016' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' , '-5' , '4' , '35.00' , '35' , '0' , '40' , '105.00' ) 17/11/2023 12:04:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '276' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 12:04:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '276' , '2023-11-17' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 17/11/2023 12:04:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89017' 17/11/2023 12:04:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89017' 17/11/2023 12:04:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89017' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '15' , '-15' , '4' , '25.00' , '25' , '0' , '100' , '0.00' ) 17/11/2023 12:57:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3650' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 12:57:21 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' , '3650' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '8.11' , NOW() , NOW() ) 17/11/2023 12:57:21 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 = '89018' 17/11/2023 12:57:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89018' 17/11/2023 12:57:21 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 ( '89018' , '6015' , 'LUMINO ELETTRICO A BASSA TENS. - LED' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 17/11/2023 12:57:21 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 ( '89018' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.9' , '5.655737704918' , '22' , '0' , '6.90' ) 17/11/2023 02:48:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '80564' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 17/11/2023 02:48:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '294', document_date = '2023-01-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 = '119.00', price_tax_excluded = '97.54', date_upd = NOW() WHERE id_document = '80564' 17/11/2023 02:48:07 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 = '80564' 17/11/2023 02:48:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '80564' 17/11/2023 02:48:07 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 ( '80564' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '10' , '27.00' ) 17/11/2023 02:48:07 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 ( '80564' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 17/11/2023 02:48:07 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 ( '80564' , '1041' , 'BENEDIZIONI' , '600' , '-600' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '90.00' ) 17/11/2023 03:00:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3651' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/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' , '3651' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 17/11/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 = '89019' 17/11/2023 03:00:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89019' 17/11/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 ( '89019' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '4' , '-4' , '4' , '3.00' , '3' , '0' , '5' , '11.40' ) 17/11/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 ( '89019' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 17/11/2023 04:13:41 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 17/11/2023 04:13:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21843' , '1' , '' , 'nuovo-prodotto' ) 17/11/2023 04:13:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21843' , '1' , '1' , '2' , NOW() , NOW() ) 17/11/2023 04:13:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21843' , '0' , '1' , '0' , '0' ) 17/11/2023 04:14:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801038972' AND id_product != '21843' AND ean13 != '' 17/11/2023 04:14:55 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE VELAR', ean13 = '9788801038972', date_upd = NOW() WHERE id_product = '21843' 17/11/2023 04:14:55 pm >> UPDATE ps_product_lang SET name = 'SAN GIOVANNI DI DIO - J. REDRADO', description = '' WHERE id_product = '21843' 17/11/2023 04:14:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '21843' 17/11/2023 04:14:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '105', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21843' 17/11/2023 04:14:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '21843' 17/11/2023 04:15:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801043938' AND id_product != '4926' AND ean13 != '' 17/11/2023 04:15:52 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/4', ean13 = '9788801043938', date_upd = NOW() WHERE id_product = '4926' 17/11/2023 04:15:52 pm >> UPDATE ps_product_lang SET name = 'IGNAZIO DI LOYOLA - F. OCCHETTA', description = '' WHERE id_product = '4926' 17/11/2023 04:15:52 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '5' WHERE id_product = '4926' 17/11/2023 04:15:52 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '5', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4926' 17/11/2023 04:15:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '4926' 17/11/2023 04:16:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801036626' AND id_product != '9399' AND ean13 != '' 17/11/2023 04:16:37 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801036626', date_upd = NOW() WHERE id_product = '9399' 17/11/2023 04:16:37 pm >> UPDATE ps_product_lang SET name = 'SAN CAMILLO DE LELLIS - F. RUFFINI', description = '' WHERE id_product = '9399' 17/11/2023 04:16:37 pm >> UPDATE ps_product SET wholesale_price = '2.50', on_sale = '0', price = '5.0000' WHERE id_product = '9399' 17/11/2023 04:16:37 pm >> UPDATE ps_product_shop SET wholesale_price = '2.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9399' 17/11/2023 04:16:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '9399' 17/11/2023 04:18:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801031119' AND id_product != '7385' AND ean13 != '' 17/11/2023 04:18:05 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801031119', date_upd = NOW() WHERE id_product = '7385' 17/11/2023 04:18:05 pm >> UPDATE ps_product_lang SET name = 'SAN PIO DA PIETRELCINA - L. DA FARA', description = '' WHERE id_product = '7385' 17/11/2023 04:18:05 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '5.0000' WHERE id_product = '7385' 17/11/2023 04:18:05 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7385' 17/11/2023 04:18:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '7385' 17/11/2023 04:18:43 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21843' 17/11/2023 04:18:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21844' , '1' , '' , 'nuovo-prodotto' ) 17/11/2023 04:18:43 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21844' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21843' 17/11/2023 04:18:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21844' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21843' 17/11/2023 04:19:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788866712541' AND id_product != '21844' AND ean13 != '' 17/11/2023 04:19:30 pm >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE GIREVOLE', ean13 = '9788866712541', date_upd = NOW() WHERE id_product = '21844' 17/11/2023 04:19:30 pm >> UPDATE ps_product_lang SET name = 'SETTE DONI DELLO SPIRITO SANTO', description = '' WHERE id_product = '21844' 17/11/2023 04:19:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.6' WHERE id_product = '21844' 17/11/2023 04:19:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.6', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '234', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21844' 17/11/2023 04:19:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21844' 17/11/2023 04:20:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21844' 17/11/2023 04:20:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21845' , '1' , '' , 'nuovo-prodotto' ) 17/11/2023 04:20:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21845' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21844' 17/11/2023 04:20:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21845' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21844' 17/11/2023 04:21:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791255080763' AND id_product != '21845' AND ean13 != '' 17/11/2023 04:21:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791255080763', date_upd = NOW() WHERE id_product = '21845' 17/11/2023 04:21:52 pm >> UPDATE ps_product_lang SET name = 'VIENI SIGNORE GESU\'!', description = '' WHERE id_product = '21845' 17/11/2023 04:21:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '21845' 17/11/2023 04:21:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21845' 17/11/2023 04:21:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '21845' 17/11/2023 04:22:21 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21845' 17/11/2023 04:22:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21846' , '1' , '' , 'nuovo-prodotto' ) 17/11/2023 04:22:21 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21846' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21845' 17/11/2023 04:22:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21846' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21845' 17/11/2023 04:22:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791255080732' AND id_product != '21846' AND ean13 != '' 17/11/2023 04:22:58 pm >> UPDATE ps_product SET id_supplier = '', reference = 'BANCO', ean13 = '9791255080732', date_upd = NOW() WHERE id_product = '21846' 17/11/2023 04:22:58 pm >> UPDATE ps_product_lang SET name = 'AGENDINA VITA CRISTIANA 2024', description = '' WHERE id_product = '21846' 17/11/2023 04:22:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '21846' 17/11/2023 04:22:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21846' 17/11/2023 04:22:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '21846' 17/11/2023 04:23:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '0' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , 'ins numero' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.25' , '46.25' , NOW() , NOW() ) 17/11/2023 04:23:20 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 = '89020' 17/11/2023 04:23:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89020' 17/11/2023 04:23:20 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 ( '89020' , '9603' , 'SANTA RITA DA CASCIA - V. PERI' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 17/11/2023 04:23:20 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 ( '89020' , '21843' , 'SAN GIOVANNI DI DIO - J. REDRADO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 17/11/2023 04:23:20 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 ( '89020' , '4926' , 'IGNAZIO DI LOYOLA - F. OCCHETTA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 17/11/2023 04:23:20 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 ( '89020' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '9399' , 'SAN CAMILLO DE LELLIS - F. RUFFINI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.5000' ) 17/11/2023 04:23:20 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 ( '89020' , '9429' , 'SAN FRANCESCO DI PAOLA - R. BENVENUTO' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.5000' ) 17/11/2023 04:23:20 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 ( '89020' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 17/11/2023 04:23:20 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 ( '89020' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 17/11/2023 04:23:20 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 ( '89020' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '20' , '20' , '4' , '0.60' , '0.6' , '0' , '50' , '6.0000' ) 17/11/2023 04:23:20 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 ( '89020' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '21845' , 'VIENI SIGNORE GESU!' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.7500' ) 17/11/2023 04:23:20 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 ( '89020' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '3' , '3' , '4' , '7.00' , '7' , '0' , '50' , '.' ) 17/11/2023 04:23:20 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 ( '89020' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '3' , '3' , '4' , '7.00' , '7' , '0' , '0' , '21.0000' ) 17/11/2023 04:24:17 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '0', document_date = '2023-11-17', document_letter = '', id_customer = '0', id_supplier = '0', id_address = '4671003', address1 = '', address2 = '', note = 'ins 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 = '46.25', price_tax_excluded = '46.25', date_upd = NOW() WHERE id_document = '89020' 17/11/2023 04:24: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 = '89020' 17/11/2023 04:24:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89020' 17/11/2023 04:24: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 ( '89020' , '9603' , 'SANTA RITA DA CASCIA - V. PERI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 17/11/2023 04:24: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 ( '89020' , '21843' , 'SAN GIOVANNI DI DIO - J. REDRADO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 17/11/2023 04:24: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 ( '89020' , '4926' , 'IGNAZIO DI LOYOLA - F. OCCHETTA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 17/11/2023 04:24: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 ( '89020' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '9399' , 'SAN CAMILLO DE LELLIS - F. RUFFINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 17/11/2023 04:24: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 ( '89020' , '9429' , 'SAN FRANCESCO DI PAOLA - R. BENVENUTO' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 17/11/2023 04:24: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 ( '89020' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 17/11/2023 04:24: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 ( '89020' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 17/11/2023 04:24: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 ( '89020' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '20' , '20' , '4' , '0.6000' , '0.6' , '0' , '50' , '6.00' ) 17/11/2023 04:24: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 ( '89020' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 17/11/2023 04:24: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 ( '89020' , '21845' , 'VIENI SIGNORE GESU!' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 17/11/2023 04:24: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 ( '89020' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '3' , '3' , '4' , '7.0000' , '7' , '0' , '50' , '0.00' ) 17/11/2023 05:30:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3652' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 05:30:09 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' , '3652' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.70' , '84.75' , NOW() , NOW() ) 17/11/2023 05:30:09 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 = '89021' 17/11/2023 05:30:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89021' 17/11/2023 05:30:09 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 ( '89021' , '8935' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '-2' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '84.00' ) 17/11/2023 05:30:09 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 ( '89021' , '8855' , 'REGISTRO DEL CATECHISTA' , '4' , '-4' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '3.00' ) 17/11/2023 05:30:09 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 ( '89021' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 17/11/2023 05:30:09 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 ( '89021' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 17/11/2023 05:30:09 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 ( '89021' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 17/11/2023 05:30:09 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 ( '89021' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 17/11/2023 05:34:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3653' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 05:34: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' , '3653' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.90' , '9.90' , NOW() , NOW() ) 17/11/2023 05:34: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 = '89022' 17/11/2023 05:34:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89022' 17/11/2023 05:34: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 ( '89022' , '12948' , 'QUADRETTI' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '0' , '9.90' ) 17/11/2023 05:41:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3654' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 05:41:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3654' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 17/11/2023 05:41:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89023' 17/11/2023 05:41:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89023' 17/11/2023 05:41:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89023' , '4889' , 'ICONA LEGNO 30X40 - 1224' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 17/11/2023 05:53:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000466' AND id_product != '17841' AND ean13 != '' 17/11/2023 05:53:13 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '000466', date_upd = NOW() WHERE id_product = '17841' 17/11/2023 05:53:13 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 42X32', description = '' WHERE id_product = '17841' 17/11/2023 05:53:13 pm >> UPDATE ps_product SET wholesale_price = '25.00', on_sale = '0', price = '40.90163934426229' WHERE id_product = '17841' 17/11/2023 05:53:13 pm >> UPDATE ps_product_shop SET wholesale_price = '25.00', price = '40.90163934426229', id_tax_rules_group = '1', id_category_default = '276', 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 = '17841' 17/11/2023 05:53:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '17841' 17/11/2023 05:55:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000466' AND id_product != '17841' AND ean13 != '' 17/11/2023 05:55:21 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '000466', date_upd = NOW() WHERE id_product = '17841' 17/11/2023 05:55:21 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 42X32', description = '' WHERE id_product = '17841' 17/11/2023 05:55:21 pm >> UPDATE ps_product SET wholesale_price = '25.00', on_sale = '0', price = '40.90163934426229' WHERE id_product = '17841' 17/11/2023 05:55:21 pm >> UPDATE ps_product_shop SET wholesale_price = '25.00', price = '40.90163934426229', id_tax_rules_group = '1', id_category_default = '276', 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 = '17841' 17/11/2023 05:55:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '17841' 17/11/2023 06:01:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001966' AND id_product != '19430' AND ean13 != '' 17/11/2023 06:01:49 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '001966', date_upd = NOW() WHERE id_product = '19430' 17/11/2023 06:01:49 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 50X35 - R35', description = '' WHERE id_product = '19430' 17/11/2023 06:01:49 pm >> UPDATE ps_product SET wholesale_price = '45.00', on_sale = '0', price = '73.77049180327869' WHERE id_product = '19430' 17/11/2023 06:01:49 pm >> UPDATE ps_product_shop SET wholesale_price = '45.00', price = '73.77049180327869', id_tax_rules_group = '1', id_category_default = '276', 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 = '19430' 17/11/2023 06:01:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19430' 17/11/2023 06:07:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001966' AND id_product != '19430' AND ean13 != '' 17/11/2023 06:07:35 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = '001966', date_upd = NOW() WHERE id_product = '19430' 17/11/2023 06:07:35 pm >> UPDATE ps_product_lang SET name = 'QUADRO DECORATO 50X35 - R35', description = '' WHERE id_product = '19430' 17/11/2023 06:07:35 pm >> UPDATE ps_product SET wholesale_price = '45.00', on_sale = '0', price = '73.77049180327869' WHERE id_product = '19430' 17/11/2023 06:07:35 pm >> UPDATE ps_product_shop SET wholesale_price = '45.00', price = '73.77049180327869', id_tax_rules_group = '1', id_category_default = '276', 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 = '19430' 17/11/2023 06:07:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '19430' 17/11/2023 06:13: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 ( '31' , '692/2023' , '2023-11-15' , '2023' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '27' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '825.94' , '677.00' , NOW() , NOW() ) 17/11/2023 06:13: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 = '89024' 17/11/2023 06:13:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89024' 17/11/2023 06:13: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 ( '89024' , '19430' , 'QUADRO DECORATO 50X35 - R35' , '6' , '6' , '1' , '70' , '57.377049180328' , '22' , '50' , '256.2000' ) 17/11/2023 06:13:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19430' AND id_supplier = '50' 17/11/2023 06:13:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19430' , '50' , '1' ) 17/11/2023 06:13: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 ( '89024' , '21691' , 'PENDENTE FF 10X11' , '35' , '35' , '1' , '8' , '6.5573770491803' , '22' , '50' , '170.8000' ) 17/11/2023 06:13:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21691' AND id_supplier = '50' 17/11/2023 06:13:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21691' , '50' , '1' ) 17/11/2023 06:13: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 ( '89024' , '17841' , 'QUADRO DECORATO 42X32' , '15' , '15' , '1' , '40' , '32.786885245902' , '22' , '50' , '366.0000' ) 17/11/2023 06:13:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17841' AND id_supplier = '50' 17/11/2023 06:13:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17841' , '50' , '1' ) 17/11/2023 06:16:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002206' AND id_product != '4889' AND ean13 != '' 17/11/2023 06:16:12 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2014', ean13 = '002206', date_upd = NOW() WHERE id_product = '4889' 17/11/2023 06:16:12 pm >> UPDATE ps_product_lang SET name = 'ICONA LEGNO 30X40 - 1224', description = '' WHERE id_product = '4889' 17/11/2023 06:16:12 pm >> UPDATE ps_product SET wholesale_price = '9.65', on_sale = '0', price = '22.1311' WHERE id_product = '4889' 17/11/2023 06:16:12 pm >> UPDATE ps_product_shop SET wholesale_price = '9.65', price = '22.1311', id_tax_rules_group = '1', id_category_default = '95', 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 = '4889' 17/11/2023 06:16:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '4889' 17/11/2023 06:19:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3241' AND id_document != '88405' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-19') 17/11/2023 06:19:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3241', document_date = '2023-10-19', 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 = '90.00', price_tax_excluded = '78.92', date_upd = NOW() WHERE id_document = '88405' 17/11/2023 06:19:31 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 = '88405' 17/11/2023 06:19:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '88405' 17/11/2023 06:19:31 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 ( '88405' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 17/11/2023 06:19:31 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 ( '88405' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 17/11/2023 06:19:31 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 ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 17/11/2023 06:19:31 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 ( '88405' , '3115' , 'CROCE SAN DAMIANO SOTTILE - 1237' , '20' , '-20' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '40.00' ) 17/11/2023 06:19:31 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 ( '88405' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '5' , '23.80' ) 17/11/2023 06:19:31 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 ( '88405' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '17.50' ) 17/11/2023 06:19:31 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 ( '88405' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '5' , '-5' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '3.50' ) 17/11/2023 06:19:31 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 ( '88405' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 17/11/2023 06:51:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '275' AND id_document != '89016' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 06:51:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '275', document_date = '2023-11-17', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = 'SCONTO AUTORE', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '105.00', price_tax_excluded = '105.00', date_upd = NOW() WHERE id_document = '89016' 17/11/2023 06:51: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 = '89016' 17/11/2023 06:51:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89016' 17/11/2023 06:51: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 ( '89016' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '5' , '-5' , '4' , '35.0000' , '35' , '0' , '40' , '105.00' ) 17/11/2023 07:28:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3655' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-17') 17/11/2023 07:28: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' , '3655' , '2023-11-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.55' , '113.55' , NOW() , NOW() ) 17/11/2023 07:28: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 = '89025' 17/11/2023 07:28:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '89025' 17/11/2023 07:28: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 ( '89025' , '10751' , 'TU MI PERDONI' , '5' , '-5' , '4' , '6.90' , '6.9' , '0' , '5' , '32.80' ) 17/11/2023 07:28: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 ( '89025' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' )