02/12/2022 08:58:45 am >> UPDATE ps_document SET id_document_type = '31', document_num = '1095/2022', document_date = '2022-11-30', document_letter = '2022', id_customer = '0', id_supplier = '', id_address = '2618', address1 = 'V.LE ISONZO, 52 20135 MILANO', address2 = '', note = 'CONTROLLARE NUMERO', price_shipping = '16.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '207.92', price_tax_excluded = '170.43', date_upd = NOW() WHERE id_document = '74890' 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74890' 02/12/2022 08:58:45 am >> DELETE FROM ps_document_detail WHERE id_document = '74890' 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '4997' , 'IMMAGINE SANTA LUCIA' , '50' , '50' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '18.30' ) 02/12/2022 08:58:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '4997' AND id_supplier = '' 02/12/2022 08:58:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4997' , '' , '1' ) 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '4374' , 'GESÙ BAMBINO - 273' , '300' , '300' , '1' , '0.0650' , '0.05327868852459' , '22' , '25' , '17.84' ) 02/12/2022 08:58:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '4374' AND id_supplier = '' 02/12/2022 08:58:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4374' , '' , '1' ) 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '17617' , 'IMMAGINI ISONZO X 100' , '70' , '70' , '1' , '2.0000' , '1.6393442622951' , '22' , '25' , '128.1000' ) 02/12/2022 08:58:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '17617' AND id_supplier = '' 02/12/2022 08:58:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17617' , '' , '1' ) 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '13315' , 'SEGNALIBRI VIENI BAMBINO GESU - 119' , '200' , '200' , '1' , '0.0660' , '0.054098360655738' , '22' , '25' , '12.08' ) 02/12/2022 08:58:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '13315' AND id_supplier = '' 02/12/2022 08:58:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13315' , '' , '1' ) 02/12/2022 08:58:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74890' , '13316' , 'SEGNALIBRI E NATALE - 120' , '200' , '200' , '1' , '0.0660' , '0.054098360655738' , '22' , '25' , '12.08' ) 02/12/2022 08:58:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '13316' AND id_supplier = '' 02/12/2022 08:58:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13316' , '' , '1' ) 02/12/2022 10:07:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:07:24 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' , '3708' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.30' , '5.45' , NOW() , NOW() ) 02/12/2022 10:07:24 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 = '75515' 02/12/2022 10:07:24 am >> DELETE FROM ps_document_detail WHERE id_document = '75515' 02/12/2022 10:07:24 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 ( '75515' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 02/12/2022 10:07:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '11677' AND id_supplier = '' 02/12/2022 10:07:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11677' , '' , '1' ) 02/12/2022 10:07:24 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 ( '75515' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/12/2022 10:07:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18619' AND id_supplier = '' 02/12/2022 10:07:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18619' , '' , '1' ) 02/12/2022 10:07:24 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 ( '75515' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 02/12/2022 10:07:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 02/12/2022 10:07:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 02/12/2022 10:07:24 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 ( '75515' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '-1' , '4' , '1.60' , '1.6' , '0' , '0' , '1.60' ) 02/12/2022 10:07:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 02/12/2022 10:07:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 02/12/2022 10:07:24 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 ( '75515' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 02/12/2022 10:07:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '7942' AND id_supplier = '' 02/12/2022 10:07:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7942' , '' , '1' ) 02/12/2022 10:10:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:10:40 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' , '3709' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.88' , '30.88' , NOW() , NOW() ) 02/12/2022 10:10:40 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 = '75516' 02/12/2022 10:10:40 am >> DELETE FROM ps_document_detail WHERE id_document = '75516' 02/12/2022 10:10: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 ( '75516' , '11096' , 'VANGELO E ATTI DEGLI AP. INTERLINEARE' , '1' , '-1' , '4' , '32.50' , '32.5' , '0' , '5' , '30.88' ) 02/12/2022 10:10:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '11096' AND id_supplier = '' 02/12/2022 10:10:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11096' , '' , '1' ) 02/12/2022 10:26:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:26:14 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' , '3710' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.30' , '42.30' , NOW() , NOW() ) 02/12/2022 10:26:14 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 = '75517' 02/12/2022 10:26:14 am >> DELETE FROM ps_document_detail WHERE id_document = '75517' 02/12/2022 10:26:14 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 ( '75517' , '18776' , 'GESU A COLORI' , '5' , '-5' , '4' , '8.90' , '8.9' , '0' , '5' , '42.30' ) 02/12/2022 10:26:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '18776' AND id_supplier = '' 02/12/2022 10:26:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18776' , '' , '1' ) 02/12/2022 10:27:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:27:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3711' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 02/12/2022 10:27:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75518' 02/12/2022 10:27:58 am >> DELETE FROM ps_document_detail WHERE id_document = '75518' 02/12/2022 10:27:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75518' , '18163' , 'GIOCO DELLE PAROLE DI DIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 02/12/2022 10:27:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '18163' AND id_supplier = '' 02/12/2022 10:27:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18163' , '' , '1' ) 02/12/2022 10:38:52 am >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:38:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '106/A' , '2022-12-02' , 'A' , '396' , '0' , '4673404' , 'L.GO S. TOMMASO D\\\'AQUINO 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.75' , '29.75' , NOW() , NOW() ) 02/12/2022 10:38:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75519' 02/12/2022 10:38:52 am >> DELETE FROM ps_document_detail WHERE id_document = '75519' 02/12/2022 10:38:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75519' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 02/12/2022 10:41:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:41: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' , '3712' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.08' , '8.08' , NOW() , NOW() ) 02/12/2022 10:41: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 = '75520' 02/12/2022 10:41:25 am >> DELETE FROM ps_document_detail WHERE id_document = '75520' 02/12/2022 10:41: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 ( '75520' , '1763' , 'CASTELLO INTERIORE - TERESA DAVILA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 02/12/2022 10:41:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '1763' AND id_supplier = '' 02/12/2022 10:41:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1763' , '' , '1' ) 02/12/2022 10:51:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 10:51:13 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' , '3713' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 02/12/2022 10:51:13 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 = '75521' 02/12/2022 10:51:13 am >> DELETE FROM ps_document_detail WHERE id_document = '75521' 02/12/2022 10:51:13 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 ( '75521' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2022 10:51:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 02/12/2022 10:51:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 02/12/2022 11:20:01 am >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:20:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '321' , '2022-12-02' , '' , '169' , '0' , '4663860' , 'PIAZZA SANTA CROCE 84086 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.15' , '70.15' , NOW() , NOW() ) 02/12/2022 11:20:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75522' 02/12/2022 11:20:01 am >> DELETE FROM ps_document_detail WHERE id_document = '75522' 02/12/2022 11:20:01 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 ( '75522' , '2679' , 'CONOSCERE GESU\'' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '15' , '14.88' ) 02/12/2022 11:20:01 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 ( '75522' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 11:20:01 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 ( '75522' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.50' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 11:20:01 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 ( '75522' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 11:20:01 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 ( '75522' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 11:23:55 am >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:23: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 ( '21' , '322' , '2022-12-02' , '' , '3213' , '0' , '4669539' , 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '99.89' , '99.89' , NOW() , NOW() ) 02/12/2022 11:23: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 = '75523' 02/12/2022 11:23:55 am >> DELETE FROM ps_document_detail WHERE id_document = '75523' 02/12/2022 11:23: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 ( '75523' , '2679' , 'CONOSCERE GESU\'' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '15' , '14.88' ) 02/12/2022 11:23: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 ( '75523' , '5457' , 'IO SONO CON VOI 1 PARTE' , '11' , '-11' , '4' , '2.50' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 11:23: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 ( '75523' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 11:23: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 ( '75523' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.50' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 11:23: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 ( '75523' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '15' , '17.00' ) 02/12/2022 11:26:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3714' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:26:23 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' , '3714' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 02/12/2022 11:26:23 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 = '75524' 02/12/2022 11:26:23 am >> DELETE FROM ps_document_detail WHERE id_document = '75524' 02/12/2022 11:26:23 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 ( '75524' , '16329' , 'GRUPPO NATIVITA CM 11' , '7' , '-7' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '31.50' ) 02/12/2022 11:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16329' AND id_supplier = '' 02/12/2022 11:26:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16329' , '' , '1' ) 02/12/2022 11:26:23 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 ( '75524' , '14788' , 'NATIVITA 9 CM' , '5' , '-5' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '22.50' ) 02/12/2022 11:26:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '14788' AND id_supplier = '' 02/12/2022 11:26:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14788' , '' , '1' ) 02/12/2022 11:27:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3715' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:27:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3715' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '29.10' , NOW() , NOW() ) 02/12/2022 11:27:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75525' 02/12/2022 11:27:49 am >> DELETE FROM ps_document_detail WHERE id_document = '75525' 02/12/2022 11:27:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75525' , '11193' , 'VENITE CON ME CAT.' , '5' , '-5' , '4' , '5' , '5' , '0' , '0' , '25.00' ) 02/12/2022 11:27:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 02/12/2022 11:27:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 02/12/2022 11:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75525' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/12/2022 11:27:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 02/12/2022 11:27:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 02/12/2022 11:32:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3716' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:32: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' , '3716' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '121.00' , '119.92' , NOW() , NOW() ) 02/12/2022 11:32: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 = '75526' 02/12/2022 11:32:05 am >> DELETE FROM ps_document_detail WHERE id_document = '75526' 02/12/2022 11:32: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 ( '75526' , '5444' , 'IO SONO CON VOI - CAT.' , '12' , '-12' , '4' , '5' , '5' , '0' , '0' , '60.00' ) 02/12/2022 11:32:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 02/12/2022 11:32:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 02/12/2022 11:32: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 ( '75526' , '11193' , 'VENITE CON ME CAT.' , '11' , '-11' , '4' , '5' , '5' , '0' , '' , '55.00' ) 02/12/2022 11:32:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 02/12/2022 11:32:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 02/12/2022 11:32: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 ( '75526' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 02/12/2022 11:32:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 02/12/2022 11:32:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 02/12/2022 11:36:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3527' AND id_document != '74245' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 11:36:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3527', document_date = '2022-11-21', 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 = '18.25', price_tax_excluded = '18.25', date_upd = NOW() WHERE id_document = '74245' 02/12/2022 11:36: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 = '74245' 02/12/2022 11:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '74245' 02/12/2022 11:36: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 ( '74245' , '20426' , 'PERCHE CREDERE? - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 02/12/2022 11:36:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20426' AND id_supplier = '' 02/12/2022 11:36:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20426' , '' , '1' ) 02/12/2022 11:36: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 ( '74245' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '1.15' , '1.15' , '0' , '0' , '1.15' ) 02/12/2022 11:36:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '' 02/12/2022 11:36:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '' , '1' ) 02/12/2022 11:39:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3717' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 11:39: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' , '3717' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.20' , '24.71' , NOW() , NOW() ) 02/12/2022 11:39: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 = '75527' 02/12/2022 11:39:51 am >> DELETE FROM ps_document_detail WHERE id_document = '75527' 02/12/2022 11:39: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 ( '75527' , '17797' , 'SAN FRANCESCO cm 15 - 023 SF/15E' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 02/12/2022 11:39:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '17797' AND id_supplier = '' 02/12/2022 11:39:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17797' , '' , '1' ) 02/12/2022 11:39: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 ( '75527' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/12/2022 11:39:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 02/12/2022 11:39:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 02/12/2022 11:39: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 ( '75527' , '7673' , 'PARTICOLE MM38' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/12/2022 11:39:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '7673' AND id_supplier = '' 02/12/2022 11:39:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7673' , '' , '1' ) 02/12/2022 11:39: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 ( '75527' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 02/12/2022 11:39:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 02/12/2022 11:39:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 02/12/2022 12:15:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:15: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' , '3718' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '163.93' , NOW() , NOW() ) 02/12/2022 12:15: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 = '75528' 02/12/2022 12:15:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '75528' 02/12/2022 12:15: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 ( '75528' , '12460' , 'CANDELABRO BOLOGNA ORO - CM 27' , '2' , '-2' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '130.00' ) 02/12/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12460' AND id_supplier = '' 02/12/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12460' , '' , '1' ) 02/12/2022 12:15: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 ( '75528' , '4198' , 'FINTA CANDELA 2,5X40 - 125' , '2' , '-2' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '9.00' ) 02/12/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4198' AND id_supplier = '' 02/12/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4198' , '' , '1' ) 02/12/2022 12:15: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 ( '75528' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13' , '10.655737704918' , '22' , '0' , '26.00' ) 02/12/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 02/12/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 02/12/2022 12:15: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 ( '75528' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 02/12/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 02/12/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 02/12/2022 12:15: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 ( '75528' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/12/2022 12:15:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 02/12/2022 12:15:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 02/12/2022 12:17:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3718' AND id_document != '75528' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:17:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3718', document_date = '2022-12-02', 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 = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '75528' 02/12/2022 12:17: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 = '75528' 02/12/2022 12:17:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '75528' 02/12/2022 12:17: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 ( '75528' , '12460' , 'CANDELABRO BOLOGNA ORO - CM 27' , '2' , '-2' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '130.00' ) 02/12/2022 12:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12460' AND id_supplier = '' 02/12/2022 12:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12460' , '' , '1' ) 02/12/2022 12:17: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 ( '75528' , '4198' , 'FINTA CANDELA 2,5X40 - 125' , '2' , '-2' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '9.00' ) 02/12/2022 12:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4198' AND id_supplier = '' 02/12/2022 12:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4198' , '' , '1' ) 02/12/2022 12:17: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 ( '75528' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '26' , '21.311475409836' , '22' , '0' , '26.00' ) 02/12/2022 12:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 02/12/2022 12:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 02/12/2022 12:17: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 ( '75528' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 02/12/2022 12:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 02/12/2022 12:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 02/12/2022 12:17: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 ( '75528' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '5.00' ) 02/12/2022 12:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 02/12/2022 12:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 02/12/2022 12:27:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:27: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 ( '21' , '132' , '2022-12-02' , '' , '2173' , '0' , '88682004' , 'VIA ROMA 32 67030 BARREA' , '' , '' , '5.8' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 02/12/2022 12:27: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 = '9234' 02/12/2022 12:27:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '9234' 02/12/2022 12:27: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 ( '9234' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 02/12/2022 12:29:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '323' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:29:31 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' , '323' , '2022-12-02' , '' , '2843' , '0' , '4673405' , 'V. PICENZA, 63 BIS 84131 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '42.50' , NOW() , NOW() ) 02/12/2022 12:29: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 = '75529' 02/12/2022 12:29:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '75529' 02/12/2022 12:29: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 ( '75529' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 12:29: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 ( '75529' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 12:31:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '75522' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:31:28 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '321', document_date = '2022-12-02', document_letter = '', id_customer = '169', id_supplier = '', id_address = '4663860', address1 = 'PIAZZA SANTA CROCE 84086 MERCATO S. SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '70.15', price_tax_excluded = '70.15', date_upd = NOW() WHERE id_document = '75522' 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75522' 02/12/2022 12:31:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '75522' 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75522' , '2679' , 'CONOSCERE GESU\'' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 02/12/2022 12:31:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 12:31:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75522' , '5458' , 'IO SONO CON VOI 2 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 12:31:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 12:31:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75522' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.5000' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 12:31:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 12:31:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75522' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 12:31:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 12:31:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 12:31:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75522' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '-5' , '4' , '2.5000' , '2.5' , '0' , '15' , '10.63' ) 02/12/2022 12:31:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 02/12/2022 12:31:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 02/12/2022 12:31:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '75523' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:31:40 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '322', document_date = '2022-12-02', document_letter = '', id_customer = '3213', id_supplier = '', id_address = '4669539', address1 = 'VIA MONTICELLI DI SOTTO 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '99.89', price_tax_excluded = '99.89', date_upd = NOW() WHERE id_document = '75523' 02/12/2022 12:31:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75523' 02/12/2022 12:31:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '75523' 02/12/2022 12:31:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75523' , '2679' , 'CONOSCERE GESU\'' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '15' , '14.88' ) 02/12/2022 12:31:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 12:31:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 12:31:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75523' , '5457' , 'IO SONO CON VOI 1 PARTE' , '11' , '-11' , '4' , '2.5000' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 12:31:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 12:31:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 12:31:41 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 ( '75523' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 12:31:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 12:31:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 12:31:41 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 ( '75523' , '11191' , 'VENITE CON ME 1 PARTE' , '11' , '-11' , '4' , '2.5000' , '2.5' , '0' , '15' , '23.38' ) 02/12/2022 12:31:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 12:31:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 12:31:41 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 ( '75523' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '-8' , '4' , '2.5000' , '2.5' , '0' , '15' , '17.00' ) 02/12/2022 12:31:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '' 02/12/2022 12:31:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '' , '1' ) 02/12/2022 12:31:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '323' AND id_document != '75529' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:31:51 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '323', document_date = '2022-12-02', document_letter = '', id_customer = '2843', id_supplier = '', id_address = '4673405', address1 = 'V. PICENZA, 63 BIS 84131 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '42.50', price_tax_excluded = '42.50', date_upd = NOW() WHERE id_document = '75529' 02/12/2022 12:31:51 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 = '75529' 02/12/2022 12:31:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '75529' 02/12/2022 12:31:51 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 ( '75529' , '5458' , 'IO SONO CON VOI 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 12:31:51 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 ( '75529' , '11192' , 'VENITE CON ME 2 PARTE' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 02/12/2022 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 12:44:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3719' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 12:44:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3719' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '2.70' , NOW() , NOW() ) 02/12/2022 12:44: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 = '75530' 02/12/2022 12:44:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '75530' 02/12/2022 12:44: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 ( '75530' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 02/12/2022 12:44:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1951' AND id_supplier = '' 02/12/2022 12:44:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1951' , '' , '1' ) 02/12/2022 12:55:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2683' AND id_document != '61734' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-08') 02/12/2022 12:55:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2683', document_date = '2022-09-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '61734' 02/12/2022 12:55:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61734' 02/12/2022 12:55:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '61734' 02/12/2022 12:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61734' , '15708' , 'CROCE IN LEGNO DULIVO CM 30 - 4116' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 02/12/2022 12:55:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15708' AND id_supplier = '' 02/12/2022 12:55:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15708' , '' , '1' ) 02/12/2022 12:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61734' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2022 12:55:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 02/12/2022 12:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 02/12/2022 12:55:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61734' , '19769' , 'BRACCIALE ARGENTO S. BENEDETTO' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 02/12/2022 12:55:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19769' AND id_supplier = '' 02/12/2022 12:55:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19769' , '' , '1' ) 02/12/2022 02:00:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '324' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 02:00:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '324' , '2022-12-02' , '' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , 'PADRE GIANCARLO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '34.00' , NOW() , NOW() ) 02/12/2022 02:00:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75531' 02/12/2022 02:00:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '75531' 02/12/2022 02:00:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75531' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '0' , '34.00' , '34' , '' , '0' , '34.00' ) 02/12/2022 02:00:52 pm >> DELETE FROM ps_document WHERE id_document = '75531' 02/12/2022 02:00:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '75531' 02/12/2022 03:00:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '15' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 03:00:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '15' , '2022-12-02' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2370.00' , '2370.00' , NOW() , NOW() ) 02/12/2022 03:00:36 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 = '9235' 02/12/2022 03:00:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '9235' 02/12/2022 03:00:36 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 ( '9235' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '300' , '-300' , '4' , '1.50' , '1.5' , '0' , '0' , '450.00' ) 02/12/2022 03:00:36 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 ( '9235' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '480' , '-480' , '4' , '2.50' , '2.5' , '0' , '0' , '1200.00' ) 02/12/2022 03:00:36 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 ( '9235' , '117' , 'La preghiera delle cinque dita n.e.' , '400' , '-400' , '4' , '1.80' , '1.8' , '0' , '0' , '720.00' ) 02/12/2022 03:03:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 03:03:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '36' , '2022-12-02' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2705.00' , '2705.00' , NOW() , NOW() ) 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75532' 02/12/2022 03:03:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '75532' 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75532' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '320' , '-320' , '4' , '3.50' , '3.5' , '0' , '0' , '1120.00' ) 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75532' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '50' , '-50' , '4' , '8.00' , '8' , '0' , '0' , '400.00' ) 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75532' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '20' , '-20' , '4' , '25.00' , '25' , '0' , '0' , '500.00' ) 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75532' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '160' , '-160' , '4' , '3.50' , '3.5' , '0' , '0' , '560.00' ) 02/12/2022 03:03:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75532' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '0' , '125.00' ) 02/12/2022 03:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '50/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 03:06: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 ( '23' , '50/E' , '2022-12-02' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1224.00' , '1003.28' , NOW() , NOW() ) 02/12/2022 03:06: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 = '75533' 02/12/2022 03:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '75533' 02/12/2022 03:06: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 ( '75533' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 02/12/2022 03:06: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 ( '75533' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 02/12/2022 03:06: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 ( '75533' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 02/12/2022 03:06: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 ( '75533' , '12849' , 'LIBRO DELLE SS. MESSE' , '30' , '-30' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '360.00' ) 02/12/2022 03:31:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '75455' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 02/12/2022 03:31:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3663', document_date = '2022-11-29', 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 = '25.96', price_tax_excluded = '23.98', date_upd = NOW() WHERE id_document = '75455' 02/12/2022 03:31: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 = '75455' 02/12/2022 03:31:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '75455' 02/12/2022 03:31: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 ( '75455' , '18129' , 'TAU COLORATO - T56' , '11' , '-11' , '1' , '1' , '0.81967213114754' , '22' , '0' , '11.00' ) 02/12/2022 03:31:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '' 02/12/2022 03:31:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' ) 02/12/2022 03:31: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 ( '75455' , '20237' , 'SIATE FELICI - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.9600' , '14.96' , '0' , '0' , '14.96' ) 02/12/2022 03:31:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20237' AND id_supplier = '' 02/12/2022 03:31:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20237' , '' , '1' ) 02/12/2022 04:07:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 04:07:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '107/A' , '2022-12-02' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , 'PADRE GIANMARIO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.00' , '79.00' , NOW() , NOW() ) 02/12/2022 04:07:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75534' 02/12/2022 04:07:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '75534' 02/12/2022 04:07:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75534' , '19607' , 'CLERGY F/F COTONE ML ' , '2' , '-2' , '0' , '39.50' , '39.5' , '' , '0' , '79.00' ) 02/12/2022 04:07:22 pm >> DELETE FROM ps_document WHERE id_document = '75534' 02/12/2022 04:07:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '75534' 02/12/2022 04:09:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 04:09:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '107/A' , '2022-12-02' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '317.00' , '317.00' , NOW() , NOW() ) 02/12/2022 04:09: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 = '75535' 02/12/2022 04:09:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '75535' 02/12/2022 04:09: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 ( '75535' , '19599' , 'ROSARIO PERLA PRIMA COMUNIONE - 197/13' , '3' , '-3' , '0' , '2.80' , '2.8' , '' , '0' , '8.40' ) 02/12/2022 04:09: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 ( '75535' , '8178' , 'PORTACORONA - 016' , '3' , '-3' , '0' , '1.70' , '1.7' , '' , '0' , '5.10' ) 02/12/2022 04:09:36 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 ( '75535' , '6014' , 'LUMINO BIANCO - 10B' , '192' , '-192' , '4' , '0.50' , '0.5' , '0' , '0' , '96.00' ) 02/12/2022 04:09:36 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 ( '75535' , '15916' , 'CASULA - PCA033' , '1' , '-1' , '0' , '79.00' , '79' , '' , '0' , '79.00' ) 02/12/2022 04:09:36 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 ( '75535' , '14085' , 'CAMICIA PER TALARE 43 - MISTO' , '1' , '-1' , '0' , '39.00' , '39' , '' , '0' , '39.00' ) 02/12/2022 04:09:36 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 ( '75535' , '4385' , 'GESÙ BAMBINO C/CULLA CM 18' , '1' , '-1' , '0' , '15.00' , '15' , '' , '0' , '15.00' ) 02/12/2022 04:09:36 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 ( '75535' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '0' , '36.50' , '36.5' , '' , '0' , '36.50' ) 02/12/2022 04:09:36 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 ( '75535' , '' , 'MAGLIONE' , '1' , '-1' , '0' , '38' , '38' , '' , '0' , '38.00' ) 02/12/2022 04:09:49 pm >> DELETE FROM ps_document WHERE id_document = '75535' 02/12/2022 04:09:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '75535' 02/12/2022 04:10:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3635' AND id_document != '74905' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-26') 02/12/2022 04:10:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3635', document_date = '2022-11-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 = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '74905' 02/12/2022 04:10:56 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 = '74905' 02/12/2022 04:10:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '74905' 02/12/2022 04:10:56 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 ( '74905' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '200' , '-200' , '1' , '0.2000' , '0.16393442622951' , '22' , '0' , '40.00' ) 02/12/2022 04:10:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '' 02/12/2022 04:10:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '' , '1' ) 02/12/2022 04:10:56 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 ( '74905' , '8178' , 'PORTACORONA - 016' , '3' , '-3' , '1' , '1' , '0.81967213114754' , '22' , '0' , '3.00' ) 02/12/2022 04:10:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8178' AND id_supplier = '' 02/12/2022 04:10:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8178' , '' , '1' ) 02/12/2022 04:10:57 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 ( '74905' , '19599' , 'ROSARIO PERLA PRIMA COMUNIONE - 197/13' , '3' , '-3' , '1' , '2' , '1.6393442622951' , '22' , '0' , '6.00' ) 02/12/2022 04:10:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19599' AND id_supplier = '' 02/12/2022 04:10:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19599' , '' , '1' ) 02/12/2022 04:11:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3033' AND id_document != '66336' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-13') 02/12/2022 04:11:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3033', document_date = '2022-10-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '66336' 02/12/2022 04:11: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 = '66336' 02/12/2022 04:11:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '66336' 02/12/2022 04:11: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 ( '66336' , '15916' , 'CASULA - PCA033' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 02/12/2022 04:11:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15916' AND id_supplier = '' 02/12/2022 04:11:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15916' , '' , '1' ) 02/12/2022 04:12:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2878' AND id_document != '63034' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-30') 02/12/2022 04:12:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2878', document_date = '2022-09-30', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '63034' 02/12/2022 04:12:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63034' 02/12/2022 04:12:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '63034' 02/12/2022 04:12:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63034' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2022 04:12:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 02/12/2022 04:12:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 02/12/2022 04:12:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63034' , '4385' , 'GESÙ BAMBINO C/CULLA CM 18' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 02/12/2022 04:12:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4385' AND id_supplier = '' 02/12/2022 04:12:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4385' , '' , '1' ) 02/12/2022 04:13:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2939' AND id_document != '65168' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-05') 02/12/2022 04:13:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2939', document_date = '2022-10-05', 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 = '200.00', price_tax_excluded = '163.93', date_upd = NOW() WHERE id_document = '65168' 02/12/2022 04:13:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65168' 02/12/2022 04:13:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '65168' 02/12/2022 04:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65168' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3' , '2.4590163934426' , '22' , '0' , '15.00' ) 02/12/2022 04:13:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 02/12/2022 04:13:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 02/12/2022 04:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65168' , '15387' , 'VESTINA BATTESIMALE ' , '60' , '-60' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '150.00' ) 02/12/2022 04:13:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 02/12/2022 04:13:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 02/12/2022 04:13:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65168' , '14085' , 'CAMICIA PER TALARE 43 - MISTO' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 02/12/2022 04:13:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14085' AND id_supplier = '' 02/12/2022 04:13:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14085' , '' , '1' ) 02/12/2022 04:14:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2518' AND id_document != '60000' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-12') 02/12/2022 04:14:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2518', document_date = '2022-08-12', 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 = '285.00', price_tax_excluded = '233.61', date_upd = NOW() WHERE id_document = '60000' 02/12/2022 04:14:36 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 = '60000' 02/12/2022 04:14:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '60000' 02/12/2022 04:14:36 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 ( '60000' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27.4' , '22.459016393443' , '22' , '0' , '27.40' ) 02/12/2022 04:14:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 02/12/2022 04:14:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 02/12/2022 04:14:36 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 ( '60000' , '20225' , 'BAMBINELLO GESSO CM 40 - J202/40' , '1' , '-1' , '1' , '200.0000' , '163.93442622951' , '22' , '0' , '200.00' ) 02/12/2022 04:14:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20225' AND id_supplier = '' 02/12/2022 04:14:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20225' , '' , '1' ) 02/12/2022 04:14:36 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 ( '60000' , '20437' , 'LUMINO BIANCO 10BTS000' , '192' , '-192' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '57.60' ) 02/12/2022 04:14:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20437' AND id_supplier = '' 02/12/2022 04:14:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20437' , '' , '1' ) 02/12/2022 05:26:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/12/2022 05:26:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20486' , '1' , '' , 'nuovo-prodotto' ) 02/12/2022 05:26:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20486' , '1' , '1' , '2' , NOW() , NOW() ) 02/12/2022 05:26:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20486' , '0' , '1' , '0' , '0' ) 02/12/2022 05:27:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002079' AND id_product != '20486' AND ean13 != '' 02/12/2022 05:27:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002079', date_upd = NOW() WHERE id_product = '20486' 02/12/2022 05:27:27 pm >> UPDATE ps_product_lang SET name = 'RAGGIERA CM 30', description = '' WHERE id_product = '20486' 02/12/2022 05:27:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20486' 02/12/2022 05:27:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '424', 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 = '20486' 02/12/2022 05:27:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20486' 02/12/2022 05:27:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002079' AND id_product != '20486' AND ean13 != '' 02/12/2022 05:27:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002079', date_upd = NOW() WHERE id_product = '20486' 02/12/2022 05:27:40 pm >> UPDATE ps_product_lang SET name = 'RAGGIERA CM 30 - ART.25', description = '' WHERE id_product = '20486' 02/12/2022 05:27:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20486' 02/12/2022 05:27:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '424', 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 = '20486' 02/12/2022 05:27:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20486' 02/12/2022 05:29:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/12/2022 05:29:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20487' , '1' , '' , 'nuovo-prodotto' ) 02/12/2022 05:29:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20487' , '1' , '1' , '2' , NOW() , NOW() ) 02/12/2022 05:29:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20487' , '0' , '1' , '0' , '0' ) 02/12/2022 05:30:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002080' AND id_product != '20487' AND ean13 != '' 02/12/2022 05:30:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002080', date_upd = NOW() WHERE id_product = '20487' 02/12/2022 05:30:41 pm >> UPDATE ps_product_lang SET name = 'STELLARIO CM 14 - ART. 70', description = '' WHERE id_product = '20487' 02/12/2022 05:30:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '20487' 02/12/2022 05:30:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '424', 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 = '20487' 02/12/2022 05:30:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '20487' 02/12/2022 05:31:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002080' AND id_product != '20487' AND ean13 != '' 02/12/2022 05:31:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002080', date_upd = NOW() WHERE id_product = '20487' 02/12/2022 05:31:28 pm >> UPDATE ps_product_lang SET name = 'STELLARIO CM 14 - ART. 70', description = '' WHERE id_product = '20487' 02/12/2022 05:31:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '20487' 02/12/2022 05:31:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '424', 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 = '20487' 02/12/2022 05:31:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '20487' 02/12/2022 05:32:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '289/A' , '2022-12-01' , 'A' , '0' , '116' , '4669160' , 'VIA SAN DOMENICO snc 80044 OTTAVIANO' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '183.73' , '150.60' , NOW() , NOW() ) 02/12/2022 05:32:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75536' 02/12/2022 05:32:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '75536' 02/12/2022 05:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75536' , '20486' , 'RAGGIERA CM 30 - ART.25' , '1' , '1' , '1' , '176' , '144.26229508197' , '22' , '45' , '118.0960' ) 02/12/2022 05:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20486' AND id_supplier = '116' 02/12/2022 05:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20486' , '116' , '1' ) 02/12/2022 05:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75536' , '14064' , 'STELLARIO PLEX CM 16' , '5' , '5' , '1' , '7.6' , '6.2295081967213' , '22' , '45' , '25.4980' ) 02/12/2022 05:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14064' AND id_supplier = '116' 02/12/2022 05:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14064' , '116' , '1' ) 02/12/2022 05:32:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75536' , '20487' , 'STELLARIO CM 14 - ART. 70' , '5' , '5' , '1' , '7.6' , '6.2295081967213' , '22' , '45' , '25.4980' ) 02/12/2022 05:32:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20487' AND id_supplier = '116' 02/12/2022 05:32:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20487' , '116' , '1' ) 02/12/2022 05:37:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3720' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 05:37: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' , '3720' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 02/12/2022 05:37: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 = '75537' 02/12/2022 05:37:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '75537' 02/12/2022 05:37: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 ( '75537' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 02/12/2022 05:37:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 02/12/2022 05:37:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 02/12/2022 05:37: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 ( '75537' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 02/12/2022 05:37:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 02/12/2022 05:37:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 02/12/2022 05:48:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '70378' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-05') 02/12/2022 05:48:12 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '245', document_date = '2022-11-05', document_letter = '', id_customer = '3959', id_supplier = '', id_address = '4676367', address1 = 'VIA TOMMASO MARTELLI 13 40138 BOLOGNA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '33.14', price_tax_excluded = '33.14', date_upd = NOW() WHERE id_document = '70378' 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70378' 02/12/2022 05:48:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '70378' 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15030' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15030' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '5' , '0.76' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15019' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15019' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '17582' , 'SAN CESARE DE BUS' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17582' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17582' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '18629' , 'SPERANZA POSSIBILE?' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18629' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18629' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '5' , '7.13' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14330' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14330' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '9564' , 'SANTA GERTRUDE DI HELFTA - M. TESCARI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9564' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9564' , '' , '1' ) 02/12/2022 05:48:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '8206' , 'POTENZE MALEFICHE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 02/12/2022 05:48:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8206' AND id_supplier = '' 02/12/2022 05:48:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8206' , '' , '1' ) 02/12/2022 05:48:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70378' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 02/12/2022 05:48:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:48:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:49:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '70379' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-05') 02/12/2022 05:49:10 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '246', document_date = '2022-11-05', document_letter = '', id_customer = '56', id_supplier = '', id_address = '4669507', address1 = 'VIA PAPA GIOVANNI PAOLO II 84081 AIELLO DI BARONISSI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '54.95', price_tax_excluded = '54.95', date_upd = NOW() WHERE id_document = '70379' 02/12/2022 05:49:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70379' 02/12/2022 05:49:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '70379' 02/12/2022 05:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70379' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '10' , '-10' , '4' , '6.2000' , '6.2' , '0' , '15' , '52.70' ) 02/12/2022 05:49:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '107' AND id_supplier = '' 02/12/2022 05:49:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '107' , '' , '1' ) 02/12/2022 05:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70379' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.25' , '2.25' , '0' , '0' , '2.25' ) 02/12/2022 05:49:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:49:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:50:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '248' AND id_document != '70385' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-05') 02/12/2022 05:50:52 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '248', document_date = '2022-11-05', document_letter = '', id_customer = '3960', id_supplier = '', id_address = '4676369', address1 = 'PIAZZA MUNICIPIO 1 88050 MARCEDUSA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '87.39', price_tax_excluded = '87.39', date_upd = NOW() WHERE id_document = '70385' 02/12/2022 05:50: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 = '70385' 02/12/2022 05:50:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '70385' 02/12/2022 05:50: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 ( '70385' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 02/12/2022 05:50:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:50:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9677' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9677' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1833' AND id_supplier = '' 02/12/2022 05:50:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1833' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '13397' , 'MIO GESU\'' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4479' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4479' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4480' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4480' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '13956' , 'MIRACOLI DI GESU\'' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13956' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13956' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '7543' , 'PARABOLE DI GESÙ' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '-1' , '4' , '1.6000' , '1.6' , '0' , '5' , '1.52' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '1' , '-1' , '4' , '1.6000' , '1.6' , '0' , '5' , '1.52' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '-1' , '4' , '1.6000' , '1.6' , '0' , '5' , '1.52' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '14487' , 'PREGHIERA DELLE 5 DITA' , '10' , '-10' , '4' , '1.8000' , '1.8' , '0' , '5' , '17.10' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14487' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14487' , '' , '1' ) 02/12/2022 05:50: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 ( '70385' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/12/2022 05:50:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 05:50:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 05:52:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '249' AND id_document != '70899' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-05') 02/12/2022 05:52:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '249', document_date = '2022-11-05', document_letter = '', id_customer = '3961', id_supplier = '', id_address = '4676522', address1 = 'Via Mastruccia , 164 03100 Frosinone ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '286.30', price_tax_excluded = '286.30', date_upd = NOW() WHERE id_document = '70899' 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70899' 02/12/2022 05:52:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '70899' 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '5' , '66.60' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '5' , '66.60' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:52:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:52:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 02/12/2022 05:52:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 02/12/2022 05:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '5' , '66.60' ) 02/12/2022 05:52:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 05:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.9' , '1.9' , '0' , '0' , '3.80' ) 02/12/2022 05:52:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 05:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 02/12/2022 05:52:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14223' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14223' , '' , '1' ) 02/12/2022 05:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '4' , '-4' , '4' , '6.0000' , '6' , '0' , '5' , '22.80' ) 02/12/2022 05:52:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16041' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16041' , '' , '1' ) 02/12/2022 05:52:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70899' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/12/2022 05:52:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 05:52:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 05:56:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '70923' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-07') 02/12/2022 05:56:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '252', document_date = '2022-11-07', document_letter = '', id_customer = '546', id_supplier = '', id_address = '4672213', address1 = 'L.GO CHIESA 88050 PETRONA\\\'', address2 = '', note = '', price_shipping = '1.55', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '281.21', price_tax_excluded = '281.21', date_upd = NOW() WHERE id_document = '70923' 02/12/2022 05:56: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 = '70923' 02/12/2022 05:56:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '70923' 02/12/2022 05:56: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 ( '70923' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 02/12/2022 05:56:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 05:56:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 05:56: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 ( '70923' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '44' , '-44' , '4' , '3.5000' , '3.5' , '0' , '15' , '130.90' ) 02/12/2022 05:56:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:56:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:56: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 ( '70923' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 02/12/2022 05:56:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 05:56:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 05:57:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '70923' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-07') 02/12/2022 05:57:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '252', document_date = '2022-11-07', document_letter = '', id_customer = '546', id_supplier = '', id_address = '4672213', address1 = 'L.GO CHIESA 88050 PETRONA\\\'', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '282.21', price_tax_excluded = '282.21', date_upd = NOW() WHERE id_document = '70923' 02/12/2022 05:57: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 = '70923' 02/12/2022 05:57:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '70923' 02/12/2022 05:57: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 ( '70923' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 02/12/2022 05:57:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 05:57:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 05:57: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 ( '70923' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '44' , '-44' , '4' , '3.5000' , '3.5' , '0' , '15' , '130.90' ) 02/12/2022 05:57:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:57:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 05:57: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 ( '70923' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 02/12/2022 05:57:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 05:57:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 05:57: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 ( '70923' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '0.85' , '0.85' , '0' , '0' , '2.55' ) 02/12/2022 05:57:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 02/12/2022 05:57:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 02/12/2022 05:58:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '253' AND id_document != '70924' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-07') 02/12/2022 05:58:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '253', document_date = '2022-11-07', document_letter = '', id_customer = '2320', id_supplier = '', id_address = '4671036', address1 = 'VIA CONVENTO, 12 75011 ACCETTURA', 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 = '162.19', price_tax_excluded = '162.19', date_upd = NOW() WHERE id_document = '70924' 02/12/2022 05:58: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 = '70924' 02/12/2022 05:58:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '70924' 02/12/2022 05:58: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 ( '70924' , '11191' , 'VENITE CON ME 1 PARTE' , '14' , '-14' , '4' , '2.5000' , '2.5' , '0' , '15' , '29.75' ) 02/12/2022 05:58:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 05:58:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 05:58: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 ( '70924' , '11192' , 'VENITE CON ME 2 PARTE' , '12' , '-12' , '4' , '2.5000' , '2.5' , '0' , '15' , '25.50' ) 02/12/2022 05:58:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 05:58:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 05:58: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 ( '70924' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 02/12/2022 05:58:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 05:58:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 05:58:36 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 ( '70924' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 02/12/2022 05:58:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 05:58:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 05:58:36 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 ( '70924' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '2' , '-2' , '4' , '1.9000' , '1.9' , '0' , '15' , '3.23' ) 02/12/2022 05:58:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 02/12/2022 05:58:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 02/12/2022 05:58:36 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 ( '70924' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 02/12/2022 05:58:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1829' AND id_supplier = '' 02/12/2022 05:58:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1829' , '' , '1' ) 02/12/2022 05:58:36 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 ( '70924' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '3.4' , '3.4' , '0' , '0' , '34.00' ) 02/12/2022 05:58:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 05:58:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:00:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '255' AND id_document != '71439' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-07') 02/12/2022 06:00:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '255', document_date = '2022-11-07', document_letter = '', id_customer = '3963', id_supplier = '', id_address = '4676678', address1 = 'Via Urano Sarti 89 , 89 57128 LIVORNO ', address2 = '', note = '', price_shipping = '0.97', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '99.80', price_tax_excluded = '99.80', date_upd = NOW() WHERE id_document = '71439' 02/12/2022 06:00:36 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 = '71439' 02/12/2022 06:00:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '71439' 02/12/2022 06:00:36 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 ( '71439' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '5' , '45.60' ) 02/12/2022 06:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 02/12/2022 06:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 02/12/2022 06:00:36 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 ( '71439' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 02/12/2022 06:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8489' AND id_supplier = '' 02/12/2022 06:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8489' , '' , '1' ) 02/12/2022 06:00:36 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 ( '71439' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 02/12/2022 06:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:00:36 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 ( '71439' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/12/2022 06:00:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 06:00:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 06:02:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '258' AND id_document != '71462' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-08') 02/12/2022 06:02:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '258', document_date = '2022-11-08', document_letter = '', id_customer = '3964', id_supplier = '', id_address = '4676680', address1 = 'VIA SARDEGNA 45 87055 SAN GIOVANNI IN FIORA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '274.90', price_tax_excluded = '274.90', date_upd = NOW() WHERE id_document = '71462' 02/12/2022 06:02: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 = '71462' 02/12/2022 06:02:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '71462' 02/12/2022 06:02: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 ( '71462' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.5000' , '2.5' , '0' , '15' , '63.75' ) 02/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 06:02: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 ( '71462' , '4154' , 'FESTA DEL PERDONO' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 02/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 02/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 02/12/2022 06:02: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 ( '71462' , '5457' , 'IO SONO CON VOI 1 PARTE' , '30' , '-30' , '4' , '2.5000' , '2.5' , '0' , '15' , '63.75' ) 02/12/2022 06:02:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 06:02:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 06:02: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 ( '71462' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.5000' , '2.5' , '0' , '15' , '63.75' ) 02/12/2022 06:02:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 06:02:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 06:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71462' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 02/12/2022 06:02:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 02/12/2022 06:02:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 02/12/2022 06:02:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71462' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/12/2022 06:02:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 06:02:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 06:04:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '259' AND id_document != '71466' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-09') 02/12/2022 06:04:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '259', document_date = '2022-11-09', document_letter = '', id_customer = '3389', id_supplier = '', id_address = '4676360', address1 = 'P. ZZA DANTE, 9 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '68.00', price_tax_excluded = '68.00', date_upd = NOW() WHERE id_document = '71466' 02/12/2022 06:04:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71466' 02/12/2022 06:04:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '71466' 02/12/2022 06:04:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71466' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '22' , '-22' , '4' , '3.50' , '3.5' , '0' , '15' , '65.45' ) 02/12/2022 06:04:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:04:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:04:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71466' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '2.55' , '2.55' , '0' , '0' , '2.55' ) 02/12/2022 06:04:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:04:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:09:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '72054' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-12') 02/12/2022 06:09:27 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '268', document_date = '2022-11-12', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '178.75', price_tax_excluded = '178.75', date_upd = NOW() WHERE id_document = '72054' 02/12/2022 06:09:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '72054' 02/12/2022 06:09:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '72054' 02/12/2022 06:09:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '12813' , 'MARIA MADRE NOSTRA' , '9' , '-9' , '4' , '3.0000' , '3' , '0' , '15' , '22.95' ) 02/12/2022 06:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 02/12/2022 06:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 02/12/2022 06:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.5000' , '3.5' , '0' , '15' , '11.90' ) 02/12/2022 06:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 06:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 06:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '4120' , 'FEDE NELLO ZAINETTO' , '15' , '-15' , '4' , '5.0000' , '5' , '0' , '10' , '67.50' ) 02/12/2022 06:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 02/12/2022 06:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 02/12/2022 06:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 02/12/2022 06:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:09:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72054' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.02' , '2.02' , '0' , '0' , '2.02' ) 02/12/2022 06:09:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 06:09:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 06:13:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '276' AND id_document != '73098' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-14') 02/12/2022 06:13:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '276', document_date = '2022-11-14', document_letter = '', id_customer = '3973', id_supplier = '', id_address = '4677173', address1 = 'VIA CHIESA 81010 RUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '76.09', price_tax_excluded = '76.09', date_upd = NOW() WHERE id_document = '73098' 02/12/2022 06:13: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 = '73098' 02/12/2022 06:13:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '73098' 02/12/2022 06:13: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 ( '73098' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '10' , '4.50' ) 02/12/2022 06:13:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '' 02/12/2022 06:13:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '14031' , 'SEGNO DELLA CROCE' , '2' , '-2' , '4' , '3.0000' , '3' , '0' , '10' , '5.40' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14031' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14031' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '18627' , 'GIOVEDI\' SANTO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '10' , '2.70' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18627' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18627' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9677' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9677' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '10' , '2.25' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16065' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16065' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '3.2' , '3.2' , '0' , '0' , '3.20' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 06:13: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 ( '73098' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 02/12/2022 06:13:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:13:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:17:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '73137' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-16') 02/12/2022 06:17:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '281', document_date = '2022-11-16', document_letter = '', id_customer = '3964', id_supplier = '', id_address = '4676683', address1 = 'VIA SARDEGNA 45 87055 SAN GIOVANNI IN FIORE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '266.15', price_tax_excluded = '266.15', date_upd = NOW() WHERE id_document = '73137' 02/12/2022 06:17: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 = '73137' 02/12/2022 06:17:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '73137' 02/12/2022 06:17: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 ( '73137' , '11193' , 'VENITE CON ME CAT.' , '30' , '-30' , '4' , '5.5000' , '5.5' , '0' , '5' , '156.75' ) 02/12/2022 06:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 02/12/2022 06:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 02/12/2022 06:17: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 ( '73137' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '15' , '15.30' ) 02/12/2022 06:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 02/12/2022 06:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 02/12/2022 06:17: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 ( '73137' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 02/12/2022 06:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 06:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 06:17: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 ( '73137' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 02/12/2022 06:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:17: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 ( '73137' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '2.35' , '2.35' , '0' , '0' , '2.35' ) 02/12/2022 06:17:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 06:17:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 06:18:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '282' AND id_document != '73140' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-16') 02/12/2022 06:18:37 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '282', document_date = '2022-11-16', document_letter = '', id_customer = '3976', id_supplier = '', id_address = '4677185', address1 = 'VIA UMBERTO I 4 62010 MOGLIANO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '22.15', price_tax_excluded = '22.15', date_upd = NOW() WHERE id_document = '73140' 02/12/2022 06:18:37 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 = '73140' 02/12/2022 06:18:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '73140' 02/12/2022 06:18:37 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 ( '73140' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 02/12/2022 06:18:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 06:18:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 06:18:37 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 ( '73140' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/12/2022 06:18:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 02/12/2022 06:18:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 02/12/2022 06:18:37 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 ( '73140' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '2.35' , '2.35' , '0' , '0' , '2.35' ) 02/12/2022 06:18:37 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:18:37 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:21:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '73174' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-17') 02/12/2022 06:21:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '288', document_date = '2022-11-17', document_letter = '', id_customer = '3799', id_supplier = '', id_address = '4672355', address1 = 'VIA SAN NICOLA 84084 FISCIANO - CARPINETO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '332.96', price_tax_excluded = '332.96', date_upd = NOW() WHERE id_document = '73174' 02/12/2022 06:21:13 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 = '73174' 02/12/2022 06:21:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '73174' 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '2679' , 'CONOSCERE GESU\'' , '12' , '-12' , '4' , '3.5000' , '3.5' , '0' , '15' , '35.70' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '16' , '-16' , '4' , '3.5000' , '3.5' , '0' , '15' , '47.60' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '33' , '-33' , '4' , '2.4000' , '2.4' , '0' , '15' , '67.32' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 02/12/2022 06:21:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73174' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/12/2022 06:21:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 02/12/2022 06:21:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 02/12/2022 06:23:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '73187' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-18') 02/12/2022 06:23:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '290', document_date = '2022-11-18', document_letter = '', id_customer = '2854', id_supplier = '', id_address = '4671051', address1 = 'PIAZZA MADONNA DI FATIMA 84129 SALERNO', address2 = '', note = '', price_shipping = '1.7', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '108.80', price_tax_excluded = '108.80', date_upd = NOW() WHERE id_document = '73187' 02/12/2022 06:23:13 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 = '73187' 02/12/2022 06:23:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '73187' 02/12/2022 06:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73187' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '100' , '0.00' ) 02/12/2022 06:23:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '' 02/12/2022 06:23:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '' , '1' ) 02/12/2022 06:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73187' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '36' , '-36' , '4' , '3.50' , '3.5' , '0' , '15' , '107.10' ) 02/12/2022 06:23:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:23:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:25:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '73728' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 02/12/2022 06:25:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2022-11-19', document_letter = '', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', 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 = '52.28', price_tax_excluded = '52.28', date_upd = NOW() WHERE id_document = '73728' 02/12/2022 06:25: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 = '73728' 02/12/2022 06:25:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 02/12/2022 06:25: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 ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 02/12/2022 06:25:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 02/12/2022 06:25:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 02/12/2022 06:25:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 02/12/2022 06:25:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 02/12/2022 06:25:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 02/12/2022 06:25:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 02/12/2022 06:25:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 06:25:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 06:26:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '73728' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-19') 02/12/2022 06:26:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '294', document_date = '2022-11-19', document_letter = '', id_customer = '973', id_supplier = '', id_address = '4677360', address1 = 'VIA MUNICIPIO 83020 TORCHIATI-MONTORO ', address2 = '', note = 'DA SALDARE', 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 = '52.28', price_tax_excluded = '52.28', date_upd = NOW() WHERE id_document = '73728' 02/12/2022 06:26: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 = '73728' 02/12/2022 06:26:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '73728' 02/12/2022 06:26: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 ( '73728' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 02/12/2022 06:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 02/12/2022 06:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 02/12/2022 06:26:36 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 ( '73728' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 02/12/2022 06:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 02/12/2022 06:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 02/12/2022 06:26:36 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 ( '73728' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.5000' , '2.5' , '0' , '15' , '42.50' ) 02/12/2022 06:26:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 06:26:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 06:28:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '74243' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 06:28:33 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '296', document_date = '2022-11-21', document_letter = '', id_customer = '260', id_supplier = '', id_address = '4670956', address1 = 'PIAZZA UMBERTO I, 2 03032 ARCE', address2 = '', note = '', price_shipping = '0.85', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '391.95', price_tax_excluded = '391.95', date_upd = NOW() WHERE id_document = '74243' 02/12/2022 06:28:33 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 = '74243' 02/12/2022 06:28:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '74243' 02/12/2022 06:28:33 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 ( '74243' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '66' , '-66' , '4' , '3.5000' , '3.5' , '0' , '15' , '196.35' ) 02/12/2022 06:28:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 02/12/2022 06:28:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 02/12/2022 06:28:33 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 ( '74243' , '20435' , 'BIBBIA E IL TESORO NASCOSTO' , '25' , '-25' , '4' , '4.5000' , '4.5' , '0' , '10' , '101.25' ) 02/12/2022 06:28:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20435' AND id_supplier = '' 02/12/2022 06:28:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20435' , '' , '1' ) 02/12/2022 06:28:33 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 ( '74243' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '40' , '-40' , '4' , '2.4000' , '2.4' , '0' , '15' , '81.60' ) 02/12/2022 06:28:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 02/12/2022 06:28:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 02/12/2022 06:28:33 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 ( '74243' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 02/12/2022 06:28:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:28:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:30:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '298' AND id_document != '74246' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 06:30:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '298', document_date = '2022-11-21', document_letter = '', id_customer = '2085', id_supplier = '', id_address = '4677364', address1 = 'VIA COLLEGIATA 84057 LAURINO', address2 = '', note = '', price_shipping = '1.52', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '95.89', price_tax_excluded = '95.89', date_upd = NOW() WHERE id_document = '74246' 02/12/2022 06:30: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 = '74246' 02/12/2022 06:30:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '74246' 02/12/2022 06:30: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 ( '74246' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.5000' , '3.5' , '0' , '15' , '32.73' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 06:30: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 ( '74246' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 02/12/2022 06:30: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 ( '74246' , '11192' , 'VENITE CON ME 2 PARTE' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 06:30: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 ( '74246' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '8' , '-8' , '4' , '2.5000' , '2.5' , '0' , '15' , '17.00' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 02/12/2022 06:30: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 ( '74246' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 02/12/2022 06:30: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 ( '74246' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '15' , '2.98' ) 02/12/2022 06:30:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:30:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:30:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '74249' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 06:30:58 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '299', document_date = '2022-11-21', document_letter = '', id_customer = '2320', id_supplier = '', id_address = '4671036', address1 = 'VIA CONVENTO, 12 75011 ACCETTURA', 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 = '195.50', price_tax_excluded = '195.50', date_upd = NOW() WHERE id_document = '74249' 02/12/2022 06:30:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74249' 02/12/2022 06:30:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '74249' 02/12/2022 06:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74249' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '100' , '-100' , '4' , '1.9000' , '1.9' , '0' , '15' , '161.50' ) 02/12/2022 06:30:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 02/12/2022 06:30:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 02/12/2022 06:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74249' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.4' , '3.4' , '0' , '0' , '34.00' ) 02/12/2022 06:30:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 06:30:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 06:32:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '74252' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 06:32:07 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '300', document_date = '2022-11-21', document_letter = '', id_customer = '6', id_supplier = '', id_address = '4670981', address1 = 'VIA ROMOLO BALZANO, 74 00177 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '47.60', price_tax_excluded = '47.60', date_upd = NOW() WHERE id_document = '74252' 02/12/2022 06:32: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 = '74252' 02/12/2022 06:32:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '74252' 02/12/2022 06:32: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 ( '74252' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '16' , '-16' , '4' , '3.5' , '3.5' , '0' , '15' , '47.60' ) 02/12/2022 06:32:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:32:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:33:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '74257' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-21') 02/12/2022 06:33:34 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '303', document_date = '2022-11-21', document_letter = '', id_customer = '559', id_supplier = '', id_address = '4677368', address1 = 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '230.35', price_tax_excluded = '230.35', date_upd = NOW() WHERE id_document = '74257' 02/12/2022 06:33:34 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 = '74257' 02/12/2022 06:33:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '74257' 02/12/2022 06:33:34 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 ( '74257' , '2679' , 'CONOSCERE GESU\'' , '19' , '-19' , '4' , '3.5000' , '3.5' , '0' , '15' , '56.52' ) 02/12/2022 06:33:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 02/12/2022 06:33:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 02/12/2022 06:33:34 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 ( '74257' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '22' , '-22' , '4' , '3.5000' , '3.5' , '0' , '15' , '65.45' ) 02/12/2022 06:33:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 02/12/2022 06:33:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 02/12/2022 06:33:34 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 ( '74257' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/12/2022 06:33:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 02/12/2022 06:33:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 02/12/2022 06:33:34 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 ( '74257' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '35' , '-35' , '4' , '3.5' , '3.5' , '0' , '15' , '104.13' ) 02/12/2022 06:33:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:33:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:34:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '289' AND id_document != '73182' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-18') 02/12/2022 06:34:39 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '289', document_date = '2022-11-18', document_letter = '', id_customer = '3978', id_supplier = '', id_address = '4677190', address1 = 'VIA MALTA 3 83100 AVELLINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '279.66', price_tax_excluded = '279.66', date_upd = NOW() WHERE id_document = '73182' 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '73182' 02/12/2022 06:34:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '73182' 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 02/12/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 02/12/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 02/12/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '15' , '42.50' ) 02/12/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 02/12/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '15' , '21.25' ) 02/12/2022 06:34:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 02/12/2022 06:34:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 02/12/2022 06:34:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 02/12/2022 06:34:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:34:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:34:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 02/12/2022 06:34:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 02/12/2022 06:34:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 02/12/2022 06:34:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/12/2022 06:34:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 02/12/2022 06:34:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 02/12/2022 06:34:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 02/12/2022 06:34:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 02/12/2022 06:34:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 02/12/2022 06:34:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73182' , '15020' , 'PREGARE OGNI GIORNO' , '17' , '-17' , '4' , '1.00' , '1' , '0' , '0' , '17.00' ) 02/12/2022 06:34:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 02/12/2022 06:34:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 02/12/2022 06:37:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '74790' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-22') 02/12/2022 06:37:02 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '307', document_date = '2022-11-22', document_letter = '', id_customer = '3981', id_supplier = '', id_address = '4677536', address1 = 'Via Mendel , 6 70011 Alberobello ', address2 = '', note = '', price_shipping = '4.32', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '43.00', date_upd = NOW() WHERE id_document = '74790' 02/12/2022 06:37: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 = '74790' 02/12/2022 06:37:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '74790' 02/12/2022 06:37: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 ( '74790' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 02/12/2022 06:37:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 02/12/2022 06:37:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 02/12/2022 06:38:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3721' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 06:38: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' , '3721' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.66' , '27.45' , NOW() , NOW() ) 02/12/2022 06:38: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 = '75538' 02/12/2022 06:38:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '75538' 02/12/2022 06:38: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 ( '75538' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 02/12/2022 06:38:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 02/12/2022 06:38:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 02/12/2022 06:38: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 ( '75538' , '18355' , 'ESPRIMERSI EMOZIONARSI CONTARE - D. CRAVERO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 02/12/2022 06:38:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18355' AND id_supplier = '' 02/12/2022 06:38:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18355' , '' , '1' ) 02/12/2022 06:38: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 ( '75538' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/12/2022 06:38:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18223' AND id_supplier = '' 02/12/2022 06:38:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18223' , '' , '1' ) 02/12/2022 06:38: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 ( '75538' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 02/12/2022 06:38:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '' 02/12/2022 06:38:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '' , '1' ) 02/12/2022 06:38:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75538' , '9799' , 'SEGNALIBRO M. TERESA - 126' , '1' , '-1' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.15' ) 02/12/2022 06:38:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9799' AND id_supplier = '' 02/12/2022 06:38:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9799' , '' , '1' ) 02/12/2022 06:41:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '74881' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-25') 02/12/2022 06:41:20 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '315', document_date = '2022-11-25', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4677540', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', 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 = '352.34', price_tax_excluded = '352.34', date_upd = NOW() WHERE id_document = '74881' 02/12/2022 06:41: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 = '74881' 02/12/2022 06:41:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '74881' 02/12/2022 06:41: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 ( '74881' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '5446' , 'IO SONO CON VOI - GUIDA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '15' , '6.80' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5446' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5446' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 02/12/2022 06:41:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 06:41:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 02/12/2022 06:41:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 02/12/2022 06:41:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 02/12/2022 06:41:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 02/12/2022 06:41:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 02/12/2022 06:41: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 ( '74881' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.5' , '3.5' , '0' , '15' , '68.42' ) 02/12/2022 06:41:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 02/12/2022 06:41:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 02/12/2022 06:56:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3722' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 06:56:50 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' , '3722' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.26' , NOW() , NOW() ) 02/12/2022 06:56:50 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 = '75539' 02/12/2022 06:56:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '75539' 02/12/2022 06:56:50 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 ( '75539' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/12/2022 06:56:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 02/12/2022 06:56:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 02/12/2022 06:56:50 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 ( '75539' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 02/12/2022 06:56:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 02/12/2022 06:56:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 02/12/2022 06:56:50 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 ( '75539' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 02/12/2022 06:56:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 02/12/2022 06:56:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 02/12/2022 07:13:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '74824' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-23') 02/12/2022 07:13:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '310', document_date = '2022-11-23', document_letter = '', id_customer = '979', id_supplier = '', id_address = '4671729', address1 = 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '17.00', price_tax_excluded = '17.00', date_upd = NOW() WHERE id_document = '74824' 02/12/2022 07:13:48 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 = '74824' 02/12/2022 07:13:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '74824' 02/12/2022 07:13:48 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 ( '74824' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '15' , '14.88' ) 02/12/2022 07:13:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 02/12/2022 07:13:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 02/12/2022 07:13:48 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 ( '74824' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.12' , '2.12' , '0' , '0' , '2.12' ) 02/12/2022 07:13:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 02/12/2022 07:13:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 02/12/2022 07:16:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884246127' AND id_product != '17286' AND ean13 != '' 02/12/2022 07:16:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/7', ean13 = '9788884246127', date_upd = NOW() WHERE id_product = '17286' 02/12/2022 07:16:46 pm >> UPDATE ps_product_lang SET name = 'VIVERE DA ORIGINALI - C. GALATOLO', description = '' WHERE id_product = '17286' 02/12/2022 07:16:46 pm >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '17286' 02/12/2022 07:16:46 pm >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '49', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17286' 02/12/2022 07:16:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '17286' 02/12/2022 07:16:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2942' AND id_document != '65177' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-06') 02/12/2022 07:16:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2942', document_date = '2022-10-06', 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 = '28.65', price_tax_excluded = '28.65', date_upd = NOW() WHERE id_document = '65177' 02/12/2022 07:16:57 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 = '65177' 02/12/2022 07:16:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '65177' 02/12/2022 07:16:57 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 ( '65177' , '18290' , 'BATTESIMO - N.E. ' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 02/12/2022 07:16:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18290' AND id_supplier = '' 02/12/2022 07:16:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18290' , '' , '1' ) 02/12/2022 07:16:57 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 ( '65177' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 02/12/2022 07:16:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 02/12/2022 07:16:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 02/12/2022 07:16:57 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 ( '65177' , '17286' , 'VIVERE DA ORIGINALI - C. GALATOLO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/12/2022 07:16:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17286' AND id_supplier = '' 02/12/2022 07:16:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17286' , '' , '1' ) 02/12/2022 07:17:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3272' AND id_document != '70273' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-31') 02/12/2022 07:17:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3272', document_date = '2022-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '86.99', date_upd = NOW() WHERE id_document = '70273' 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70273' 02/12/2022 07:17:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '70273' 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 02/12/2022 07:17:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 02/12/2022 07:17:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 02/12/2022 07:17:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 02/12/2022 07:17:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.45' , '1.45' , '0' , '0' , '1.45' ) 02/12/2022 07:17:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 02/12/2022 07:17:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '20057' , 'CINQUE PANI DORZO 2023' , '2' , '-2' , '4' , '6.9000' , '6.9' , '0' , '5' , '13.12' ) 02/12/2022 07:17:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20057' AND id_supplier = '' 02/12/2022 07:17:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20057' , '' , '1' ) 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '17416' , 'RETINA RICAMBIO ART 355' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 02/12/2022 07:17:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17416' AND id_supplier = '' 02/12/2022 07:17:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17416' , '' , '1' ) 02/12/2022 07:17:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70273' , '18031' , 'BRUCIAINCENSO H 8' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 02/12/2022 07:17:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18031' AND id_supplier = '' 02/12/2022 07:17:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18031' , '' , '1' ) 02/12/2022 07:17:50 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 ( '70273' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '29.6300' , '24.286885245902' , '22' , '0' , '29.63' ) 02/12/2022 07:17:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19101' AND id_supplier = '' 02/12/2022 07:17:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19101' , '' , '1' ) 02/12/2022 07:17:50 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 ( '70273' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 02/12/2022 07:17:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 02/12/2022 07:17:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 02/12/2022 07:17:50 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 ( '70273' , '18846' , 'QUADRETTO MODELLO CAPANNA - P511' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 02/12/2022 07:17:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18846' AND id_supplier = '' 02/12/2022 07:17:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18846' , '' , '1' ) 02/12/2022 07:17:50 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 ( '70273' , '17713' , 'FARSI SANTI CON CIO CHE C\'E\' - L. EPICOCO' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 02/12/2022 07:17:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17713' AND id_supplier = '' 02/12/2022 07:17:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17713' , '' , '1' ) 02/12/2022 07:19:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3191' AND id_document != '68624' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-26') 02/12/2022 07:19:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3191', document_date = '2022-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 = '0', id_causal = '0', price_tax_included = '16.30', price_tax_excluded = '13.54', date_upd = NOW() WHERE id_document = '68624' 02/12/2022 07:19: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 = '68624' 02/12/2022 07:19:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '68624' 02/12/2022 07:19: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 ( '68624' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 02/12/2022 07:19:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1425' AND id_supplier = '' 02/12/2022 07:19:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1425' , '' , '1' ) 02/12/2022 07:19: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 ( '68624' , '14543' , 'CALENDARIO LITURGICO MARIANO 2023' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 02/12/2022 07:19:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14543' AND id_supplier = '' 02/12/2022 07:19:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14543' , '' , '1' ) 02/12/2022 07:19: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 ( '68624' , '6336' , 'MEDAGLIA OVALE DECORATA - S.RITA - G291-D' , '2' , '-2' , '1' , '0.65' , '0.5327868852459' , '22' , '0' , '1.30' ) 02/12/2022 07:19:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6336' AND id_supplier = '' 02/12/2022 07:19:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6336' , '' , '1' ) 02/12/2022 07:29:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3723' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-02') 02/12/2022 07:29:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3723' , '2022-12-02' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '11.00' , NOW() , NOW() ) 02/12/2022 07:29:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75540' 02/12/2022 07:29:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '75540' 02/12/2022 07:29:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75540' , '20446' , 'PREFAZI E PREGHIERE EUCARISTICHE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 02/12/2022 07:29:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20446' AND id_supplier = '' 02/12/2022 07:29:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20446' , '' , '1' ) 02/12/2022 07:29:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75540' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/12/2022 07:29:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 02/12/2022 07:29:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 02/12/2022 07:29:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75540' , '1077' , 'BERNADETTE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/12/2022 07:29:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1077' AND id_supplier = '' 02/12/2022 07:29:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1077' , '' , '1' ) 02/12/2022 07:31:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2973' AND id_document != '65220' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-08') 02/12/2022 07:31:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2973', document_date = '2022-10-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '88.90', price_tax_excluded = '76.66', date_upd = NOW() WHERE id_document = '65220' 02/12/2022 07:31:48 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 = '65220' 02/12/2022 07:31:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '65220' 02/12/2022 07:31:48 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 ( '65220' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/12/2022 07:31:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 02/12/2022 07:31:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 02/12/2022 07:31:48 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 ( '65220' , '18700' , 'DIO CAPOVOLTO - B. MAGGIONI' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 02/12/2022 07:31:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18700' AND id_supplier = '' 02/12/2022 07:31:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18700' , '' , '1' ) 02/12/2022 07:31:48 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 ( '65220' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2022 07:31:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 02/12/2022 07:31:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 02/12/2022 07:31:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65220' , '19561' , 'CARD SAN GIUDA TADDEO' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 02/12/2022 07:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19561' AND id_supplier = '' 02/12/2022 07:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19561' , '' , '1' ) 02/12/2022 07:32:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2637' AND id_document != '61166' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-05') 02/12/2022 07:32:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2637', document_date = '2022-09-05', 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 = '16.50', price_tax_excluded = '13.52', date_upd = NOW() WHERE id_document = '61166' 02/12/2022 07:32:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61166' 02/12/2022 07:32:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '61166' 02/12/2022 07:32:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61166' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '6.50' ) 02/12/2022 07:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 02/12/2022 07:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 02/12/2022 07:32:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61166' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/12/2022 07:32:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 02/12/2022 07:32:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' )