10/11/2022 09:46:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3403' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 09:46:57 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' , '3403' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 10/11/2022 09:46:57 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 = '71495' 10/11/2022 09:46:57 am >> DELETE FROM ps_document_detail WHERE id_document = '71495' 10/11/2022 09:46:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71495' , '9011' , 'RITO DEL MATRIMONIO - RP29' , '25' , '-25' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '7.50' ) 10/11/2022 09:46:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '9011' AND id_supplier = '' 10/11/2022 09:46:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9011' , '' , '1' ) 10/11/2022 09:52:56 am >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '70325' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-03') 10/11/2022 09:52:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2022-11-03', document_letter = 'A', id_customer = '321', id_supplier = '', id_address = '4672782', address1 = 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.', address2 = '', note = 'DA PREPARARE', 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 = '420.31', price_tax_excluded = '420.31', date_upd = NOW() WHERE id_document = '70325' 10/11/2022 09:52:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '70325' 10/11/2022 09:52:56 am >> DELETE FROM ps_document_detail WHERE id_document = '70325' 10/11/2022 09:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '2679' , 'CONOSCERE GESU\'' , '24' , '-24' , '4' , '3.5000' , '3.5' , '0' , '15' , '71.40' ) 10/11/2022 09:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 10/11/2022 09:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 10/11/2022 09:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5457' , 'IO SONO CON VOI 1 PARTE' , '21' , '-21' , '4' , '2.5000' , '2.5' , '0' , '15' , '44.63' ) 10/11/2022 09:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 10/11/2022 09:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 10/11/2022 09:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5444' , 'IO SONO CON VOI - CAT.' , '21' , '-21' , '4' , '5.5000' , '5.5' , '0' , '10' , '103.95' ) 10/11/2022 09:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 10/11/2022 09:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 10/11/2022 09:52:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '5458' , 'IO SONO CON VOI 2 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 10/11/2022 09:52:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 10/11/2022 09:52:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 10/11/2022 09:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '11191' , 'VENITE CON ME 1 PARTE' , '16' , '-16' , '4' , '2.5000' , '2.5' , '0' , '15' , '34.00' ) 10/11/2022 09:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 10/11/2022 09:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 10/11/2022 09:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '11193' , 'VENITE CON ME CAT.' , '16' , '-16' , '4' , '5.5000' , '5.5' , '0' , '10' , '79.20' ) 10/11/2022 09:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 10/11/2022 09:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 10/11/2022 09:52:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '70325' , '11192' , 'VENITE CON ME 2 PARTE' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '15' , '53.13' ) 10/11/2022 09:52:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 10/11/2022 09:52:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 10/11/2022 09:58:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3404' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 09:58:44 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' , '3404' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.18' , '42.18' , NOW() , NOW() ) 10/11/2022 09:58:44 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 = '71496' 10/11/2022 09:58:44 am >> DELETE FROM ps_document_detail WHERE id_document = '71496' 10/11/2022 09:58:44 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 ( '71496' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 10/11/2022 09:58:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 10/11/2022 09:58:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 10/11/2022 09:58:44 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 ( '71496' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 10/11/2022 09:58:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 10/11/2022 09:58:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 10/11/2022 09:58:44 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 ( '71496' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/11/2022 09:58:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11183' AND id_supplier = '' 10/11/2022 09:58:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11183' , '' , '1' ) 10/11/2022 09:58:44 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 ( '71496' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.40' , '2.4' , '0' , '5' , '2.28' ) 10/11/2022 09:58:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 10/11/2022 09:58:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 10/11/2022 09:58:44 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 ( '71496' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 10/11/2022 09:58:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '2680' AND id_supplier = '' 10/11/2022 09:58:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2680' , '' , '1' ) 10/11/2022 11:02:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 11:02:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3405' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 10/11/2022 11:02:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71497' 10/11/2022 11:02:35 am >> DELETE FROM ps_document_detail WHERE id_document = '71497' 10/11/2022 11:02:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71497' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 10/11/2022 11:02:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/11/2022 11:02:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/11/2022 11:18:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3406' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 11:18: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' , '3406' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '430.00' , '352.46' , NOW() , NOW() ) 10/11/2022 11:18: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 = '71498' 10/11/2022 11:18:05 am >> DELETE FROM ps_document_detail WHERE id_document = '71498' 10/11/2022 11:18: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 ( '71498' , '20270' , 'PALLONCINO MAGNETE - personalizzato' , '30' , '-30' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '420.00' ) 10/11/2022 11:18:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20270' AND id_supplier = '' 10/11/2022 11:18:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20270' , '' , '1' ) 10/11/2022 11:18: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 ( '71498' , '20270' , 'PALLONCINO MAGNETE - personalizzato' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 10/11/2022 11:18:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '20270' AND id_supplier = '' 10/11/2022 11:18:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20270' , '' , '1' ) 10/11/2022 11:18: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 ( '71498' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '100' , '0.00' ) 10/11/2022 11:18:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 10/11/2022 11:18:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 10/11/2022 11:42:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 11:42: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' , '3407' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '336.21' , '325.27' , NOW() , NOW() ) 10/11/2022 11:42: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 = '71499' 10/11/2022 11:42:23 am >> DELETE FROM ps_document_detail WHERE id_document = '71499' 10/11/2022 11:42: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 ( '71499' , '14529' , 'PANE E VINO - SUSSIDIO' , '10' , '-10' , '4' , '4.5' , '4.5' , '0' , '0' , '45.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '14529' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14529' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '10' , '-10' , '4' , '4.5' , '4.5' , '0' , '0' , '45.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '12922' , 'IMPRONTE DI MISERICORDIA - GUIDA 2' , '2' , '-2' , '4' , '13.5' , '13.5' , '0' , '0' , '27.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12922' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12922' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '14530' , 'PANE E VINO - GUIDA 3' , '2' , '-2' , '4' , '13.5' , '13.5' , '0' , '0' , '27.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '1' , '1' , '0' , '0' , '5.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '11193' , 'VENITE CON ME CAT.' , '4' , '-4' , '4' , '5' , '5' , '0' , '0' , '20.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 10/11/2022 11:42:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 10/11/2022 11:42:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '13197' , 'NATALE CHE EMOZIONE! - NEGRO/PIOVANO' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13197' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13197' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '10' , '-10' , '4' , '1.35' , '1.35' , '0' , '0' , '13.50' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '18357' , 'MIE PREGHIERINE N.E.' , '10' , '-10' , '4' , '1.35' , '1.35' , '0' , '0' , '13.50' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '6811' , 'MOCCOLO 80X200' , '5' , '-5' , '1' , '9' , '7.3770491803279' , '22' , '0' , '45.00' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '5587' , 'LECTIO DIVINA OGNI GIORNO - 13' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '5587' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5587' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4948' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4948' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '15602' , 'AMICO GESU ALBUM' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '100' , '0.00' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15602' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15602' , '' , '1' ) 10/11/2022 11:42: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 ( '71499' , '13441' , 'SPIRITUALITA E BIBBIA - G. RAVASI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 10/11/2022 11:42:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13441' AND id_supplier = '' 10/11/2022 11:42:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13441' , '' , '1' ) 10/11/2022 11:59:21 am >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 11:59:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '47/E' , '2022-11-10' , 'E' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '238.60' , '238.60' , NOW() , NOW() ) 10/11/2022 11:59:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71500' 10/11/2022 11:59:21 am >> DELETE FROM ps_document_detail WHERE id_document = '71500' 10/11/2022 11:59:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71500' , '8408' , 'PRENDETE E MANGIATE' , '90' , '-90' , '4' , '3.00' , '3' , '0' , '38' , '167.40' ) 10/11/2022 11:59:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71500' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '30' , '-30' , '4' , '2.40' , '2.4' , '0' , '15' , '61.20' ) 10/11/2022 11:59:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71500' , '' , 'spese di spedizione ' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 10/11/2022 12:04:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3408' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 12:04:30 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' , '3408' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.01' , '17.01' , NOW() , NOW() ) 10/11/2022 12:04:30 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 = '71501' 10/11/2022 12:04:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '71501' 10/11/2022 12:04:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71501' , '18722' , 'SEGRETO DI MIO FIGLIO - A.S. ACUTIS' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '5' , '17.01' ) 10/11/2022 12:04:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18722' AND id_supplier = '' 10/11/2022 12:04:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18722' , '' , '1' ) 10/11/2022 12:09:31 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3532' 10/11/2022 12:09:31 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3532' , '10' , '210' , '' , 'VASSALLO' , 'MARIA' , 'PIAZZA PADRE ROCCO SERRA 26' , '' , '84060' , 'MONTANO ANTILIA' , '' , '0974951388' , '' , '' , '' , NOW() , NOW() ) 10/11/2022 12:09:31 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3532' 10/11/2022 12:09:48 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3532' 10/11/2022 12:09:48 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3532' , '10' , '210' , '' , 'VASSALLO' , 'MARIA' , 'PIAZZA PADRE ROCCO SERRA 26' , '' , '84060' , 'MONTANO ANTILIA' , '' , '0974951388' , '3205337898' , '' , '' , NOW() , NOW() ) 10/11/2022 12:09:48 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3532' 10/11/2022 12:12:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 12:12:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '264' , '2022-11-10' , '' , '3532' , '0' , '4676687' , 'PIAZZA PADRE ROCCO SERRA 26 84060 MONTANO ANTILIA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.77' , '39.77' , NOW() , NOW() ) 10/11/2022 12:12:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71502' 10/11/2022 12:12:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '71502' 10/11/2022 12:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71502' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.22' ) 10/11/2022 12:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71502' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 10/11/2022 12:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71502' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '-5' , '4' , '2.40' , '2.4' , '0' , '5' , '11.40' ) 10/11/2022 12:12:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71502' , '' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 10/11/2022 12:12:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '71502' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 12:12:57 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '264', document_date = '2022-11-10', document_letter = '', id_customer = '3532', id_supplier = '', id_address = '4676687', address1 = 'PIAZZA PADRE ROCCO SERRA 26 84060 MONTANO ANTILIA', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '38.77', price_tax_excluded = '38.77', date_upd = NOW() WHERE id_document = '71502' 10/11/2022 12:12: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 = '71502' 10/11/2022 12:12:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '71502' 10/11/2022 12:12: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 ( '71502' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '5' , '5.22' ) 10/11/2022 12:12:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 10/11/2022 12:12:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 10/11/2022 12:12: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 ( '71502' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.0000' , '3' , '0' , '5' , '14.25' ) 10/11/2022 12:12:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 10/11/2022 12:12:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 10/11/2022 12:12: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 ( '71502' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '5' , '-5' , '4' , '2.4000' , '2.4' , '0' , '5' , '11.40' ) 10/11/2022 12:12:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 10/11/2022 12:12:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 10/11/2022 12:12: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 ( '71502' , '0' , 'SPESE DI CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 10/11/2022 12:12:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 10/11/2022 12:12:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 10/11/2022 12:24:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3532' 10/11/2022 12:24:50 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3532' , '10' , '210' , '' , 'VASSALLO' , 'MARIA' , 'PIAZZA PADRE ROCCO SERRA 26' , '' , '84060' , 'ABATEMARCO' , '' , '0974951388' , '3205337898' , '' , '' , NOW() , NOW() ) 10/11/2022 12:24:50 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3532' 10/11/2022 12:26:49 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3532' 10/11/2022 12:26:49 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3532' , '10' , '210' , '' , 'VASSALLO' , 'MARIA' , 'PIAZZA PADRE ROCCO SERRA 26' , '' , '84060' , 'ABATEMARCO' , '' , '0974951388' , '3205337898' , '' , '' , NOW() , NOW() ) 10/11/2022 12:26:49 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3532' 10/11/2022 02:13: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 ( '33' , '003236' , '2022-11-08' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '214.15' , '214.15' , NOW() , NOW() ) 10/11/2022 02:13: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 = '71503' 10/11/2022 02:13:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '71503' 10/11/2022 02:13: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 ( '71503' , '13460' , 'VERITATIS GAUDIUM' , '1' , '1' , '4' , '5.00' , '5' , '0' , '45' , '2.7500' ) 10/11/2022 02:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13460' AND id_supplier = '79' 10/11/2022 02:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13460' , '79' , '1' ) 10/11/2022 02:13: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 ( '71503' , '11233' , 'VERITÀ VI FARÀ LIBERI' , '4' , '4' , '4' , '15.50' , '15.5' , '0' , '30' , '43.4000' ) 10/11/2022 02:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11233' AND id_supplier = '79' 10/11/2022 02:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11233' , '79' , '1' ) 10/11/2022 02:13: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 ( '71503' , '17330' , 'MESSALE ROMANO DALTARE N. E. TAGLIO ORO' , '1' , '1' , '4' , '130.00' , '130' , '0' , '30' , '91.0000' ) 10/11/2022 02:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17330' AND id_supplier = '79' 10/11/2022 02:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17330' , '79' , '1' ) 10/11/2022 02:13: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 ( '71503' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 10/11/2022 02:13:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 10/11/2022 02:13:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 10/11/2022 02:17:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '71497' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 02:17:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3405', document_date = '2022-11-10', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '71497' 10/11/2022 02:17:38 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 = '71497' 10/11/2022 02:17:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '71497' 10/11/2022 02:17:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71497' , '20270' , 'PALLONCINO MAGNETE - personalizzato' , '14' , '-14' , '1' , '10' , '8.1967213114754' , '22' , '0' , '140.00' ) 10/11/2022 02:17:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20270' AND id_supplier = '' 10/11/2022 02:17:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20270' , '' , '1' ) 10/11/2022 03:04:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3409' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 03:04:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3409' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.50' , NOW() , NOW() ) 10/11/2022 03:04:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71504' 10/11/2022 03:04:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '71504' 10/11/2022 03:04:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71504' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 10/11/2022 03:04:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 10/11/2022 03:04:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 10/11/2022 03:04:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3410' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 03:04:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3410' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.40' , '20.28' , NOW() , NOW() ) 10/11/2022 03:04: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 = '71505' 10/11/2022 03:04:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '71505' 10/11/2022 03:04: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 ( '71505' , '20250' , 'PREGA MANGIA AMA - L. M. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 10/11/2022 03:04:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20250' AND id_supplier = '' 10/11/2022 03:04:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20250' , '' , '1' ) 10/11/2022 03:04: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 ( '71505' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 10/11/2022 03:04:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 10/11/2022 03:04:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 10/11/2022 04:30:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3411' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 04:30:55 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' , '3411' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 10/11/2022 04:30:55 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 = '71506' 10/11/2022 04:30:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '71506' 10/11/2022 04:30:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71506' , '19922' , 'AGENDA DEVOZIONALE 2023 - 40808' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '19.00' ) 10/11/2022 04:30:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19922' AND id_supplier = '' 10/11/2022 04:30:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19922' , '' , '1' ) 10/11/2022 04:53:28 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 10/11/2022 04:53:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20300' , '1' , '' , 'nuovo-prodotto' ) 10/11/2022 04:53:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20300' , '1' , '1' , '2' , NOW() , NOW() ) 10/11/2022 04:53:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20300' , '0' , '1' , '0' , '0' ) 10/11/2022 04:53:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688412' AND id_product != '20300' AND ean13 != '' 10/11/2022 04:53:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788887688412', date_upd = NOW() WHERE id_product = '20300' 10/11/2022 04:54:00 pm >> UPDATE ps_product_lang SET name = 'PSICOLOGIA PRATICA PER EDUCATORI', description = '' WHERE id_product = '20300' 10/11/2022 04:54:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.5' WHERE id_product = '20300' 10/11/2022 04:54:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.5', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '8', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20300' 10/11/2022 04:54:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20300' 10/11/2022 05:03:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '71484' AND id_document_type LIKE '26' AND YEAR(document_date) = YEAR('2022-11-09') 10/11/2022 05:03:48 pm >> UPDATE ps_document SET id_document_type = '26', document_num = '1', document_date = '2022-11-09', document_letter = '', id_customer = '3965', id_supplier = '', id_address = '4676684', address1 = 'PIAZZA GARIBALDI 84020 OLIVETO CITRA', 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 = '435.04', price_tax_excluded = '435.04', date_upd = NOW() WHERE id_document = '71484' 10/11/2022 05:03: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 = '71484' 10/11/2022 05:03:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '71484' 10/11/2022 05:03: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 ( '71484' , '20277' , 'Grand Central dream' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20277' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20277' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20278' , 'Violenze e fascismo nel napoletano' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20278' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20278' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20279' , 'Heinrich Schliemann a Napoli' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20279' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20279' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20280' , 'C’era una volta Storybrooke' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20280' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20280' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20281' , 'Bibliografia degli scritti' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20281' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20281' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20285' , 'Quid est veritas?' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20285' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20285' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20283' , 'conquista normanna del meridione d’Italia' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20283' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20283' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20284' , 'bizantini nel Mezzogiorno d’Italia' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20284' AND id_supplier = '' 10/11/2022 05:03:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20284' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20286' , 'Chirone d’Achille' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 10/11/2022 05:03:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20286' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20286' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20287' , 'geopolitica di Francesco' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20287' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20287' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20288' , 'Codice Corallino' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20288' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20288' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20289' , 'Folia Follia' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20289' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20289' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20290' , 'Raffaella Carrà una leggenda in tre minuti' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20290' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20290' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20291' , 'Futurvesuvio' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20291' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20291' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20292' , 'A vita nova' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20292' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20292' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20282' , 'Storia politica della Langobardia minore' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20282' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20282' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20295' , 'GUIDA PER BAMBINE RIBELLI' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20295' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20295' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20294' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI ' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20294' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20294' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20293' , 'Storie della buona notte PER BAMBINE RIBELLI 2' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20293' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20293' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20297' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 DONNE...' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 10/11/2022 05:03:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20297' AND id_supplier = '' 10/11/2022 05:03:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20297' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20296' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 RAGAZZE...' , '1' , '0' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20296' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20296' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20298' , 'COFANETTO STORIE PER BAMBINI VOL 1 E 2' , '1' , '0' , '4' , '29.9000' , '29.9' , '0' , '5' , '28.40' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20298' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20298' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20299' , 'DONNE E SCIENZA' , '1' , '0' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20299' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20299' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15' , '15' , '0' , '5' , '14.25' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18291' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18291' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '0' , '4' , '15' , '15' , '0' , '5' , '14.25' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17630' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17630' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '14693' , 'VITE MERAVIGLIOSE - P. MARTINELLI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14693' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14693' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '11838' , 'UNA TERRA BAGNATA DAL SANGUE - A. PALINI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11838' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11838' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '10052' , 'SOLE A MEZZANOTTE M. GARGANI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10052' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10052' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12' , '12' , '0' , '5' , '11.40' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18052' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18052' , '' , '1' ) 10/11/2022 05:03: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 ( '71484' , '20300' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '0' , '4' , '8.66' , '8.66' , '0' , '5' , '8.23' ) 10/11/2022 05:03:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20300' AND id_supplier = '' 10/11/2022 05:03:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20300' , '' , '1' ) 10/11/2022 06:11:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 06:11: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 ( '21' , '265' , '2022-11-10' , '' , '3805' , '0' , '4672214' , 'VIA S. MARIA DELLE GRAZIE 84030 PERTOSA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '157.55' , '157.55' , NOW() , NOW() ) 10/11/2022 06:11: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 = '71507' 10/11/2022 06:11:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '71507' 10/11/2022 06:11: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 ( '71507' , '2679' , 'CONOSCERE GESU\'' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 10/11/2022 06:11: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 ( '71507' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 10/11/2022 06:11: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 ( '71507' , '4154' , 'FESTA DEL PERDONO' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '15' , '17.85' ) 10/11/2022 06:11: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 ( '71507' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 10/11/2022 06:11: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 ( '71507' , '8408' , 'PRENDETE E MANGIATE' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '15' , '15.30' ) 10/11/2022 06:11: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 ( '71507' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '15' , '12.75' ) 10/11/2022 06:11: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 ( '71507' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '-1' , '4' , '5.16' , '5.16' , '0' , '15' , '4.39' ) 10/11/2022 06:11: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 ( '71507' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '15' , '5.27' ) 10/11/2022 06:11: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 ( '71507' , '14487' , 'PREGHIERA DELLE 5 DITA' , '40' , '-40' , '4' , '1.80' , '1.8' , '0' , '15' , '61.20' ) 10/11/2022 06:11: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 ( '71507' , '13462' , 'SE MI AMI NON PIANGERE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '15' , '1.27' ) 10/11/2022 06:22:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3412' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 06:22: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' , '3412' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.00' , '141.80' , NOW() , NOW() ) 10/11/2022 06:22: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 = '71508' 10/11/2022 06:22:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '71508' 10/11/2022 06:22: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 ( '71508' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '18.00' ) 10/11/2022 06:22:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/11/2022 06:22:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/11/2022 06:22: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 ( '71508' , '17858' , 'LAMPADA IHS - 096DP1K' , '2' , '-2' , '1' , '40' , '32.786885245902' , '22' , '0' , '80.00' ) 10/11/2022 06:22:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17858' AND id_supplier = '' 10/11/2022 06:22:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17858' , '' , '1' ) 10/11/2022 06:22: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 ( '71508' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 10/11/2022 06:22:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 10/11/2022 06:22:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 10/11/2022 06:28:38 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3510' 10/11/2022 06:28:38 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3510' , '10' , '210' , 'PARROCCHIA S. ANDREA E LORENZO' , 'PAGANO' , 'DON ENRICO' , 'P.ZZA MACCHIARELLI' , '' , '84084' , 'VILLA DI FISCIANO' , '' , '' , '' , '' , '95017700659' , NOW() , NOW() ) 10/11/2022 06:28:38 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3510' 10/11/2022 06:49:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3413' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 06:49:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3413' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 10/11/2022 06:49: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 = '71509' 10/11/2022 06:49:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '71509' 10/11/2022 06:49: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 ( '71509' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 10/11/2022 06:49:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12864' AND id_supplier = '' 10/11/2022 06:49:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12864' , '' , '1' ) 10/11/2022 06:51:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3414' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 06:51:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3414' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 10/11/2022 06:51:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71510' 10/11/2022 06:51:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '71510' 10/11/2022 06:51:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71510' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 10/11/2022 06:51:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18215' AND id_supplier = '' 10/11/2022 06:51:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18215' , '' , '1' ) 10/11/2022 06:54:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3415' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-10') 10/11/2022 06:54:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3415' , '2022-11-10' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.00' , NOW() , NOW() ) 10/11/2022 06:54: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 = '71511' 10/11/2022 06:54:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '71511' 10/11/2022 06:54: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 ( '71511' , '8439' , 'PRESEPE COMPONIBILE IN MDF CON 5 PZ - OGGETTI' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 10/11/2022 06:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8439' AND id_supplier = '' 10/11/2022 06:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8439' , '' , '1' ) 10/11/2022 06:54: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 ( '71511' , '13397' , 'MIO GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 10/11/2022 06:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13397' AND id_supplier = '' 10/11/2022 06:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13397' , '' , '1' ) 10/11/2022 06:54: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 ( '71511' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.2' , '2.2' , '0' , '0' , '2.20' ) 10/11/2022 06:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 10/11/2022 06:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' )