18/05/2022 08:19:22 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'tHuIzc4b2lj4apK1' , NOW() , NOW() ) 18/05/2022 08:19:23 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6970' , '1' ) 18/05/2022 08:19:23 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6970' , '2' ) 18/05/2022 08:19:23 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6970' , '3' ) 18/05/2022 08:21:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6970' 18/05/2022 08:21:13 am >> 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 ( '6970' , '10' , '139' , '' , 'TAMBURELLO' , 'TERESA ' , 'VIA BARBIERI 1' , '' , '25080' , 'PADENGHE SUL GARDA' , '' , '' , '3337657672' , '' , '' , NOW() , NOW() ) 18/05/2022 08:21:13 am >> UPDATE ps_customer SET email = 'teresa080259@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6970' 18/05/2022 08:22:58 am >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 08:22: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 ( '21' , '28' , '2022-05-18' , '' , '6970' , '0' , '74680476' , 'VIA BARBIERI 1 25080 PADENGHE SUL GARDA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '42.60' , '42.60' , NOW() , NOW() ) 18/05/2022 08:22: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 = '5216' 18/05/2022 08:22:58 am >> DELETE FROM ps_document_detail WHERE id_document = '5216' 18/05/2022 08:22: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 ( '5216' , '92' , 'LA PREGHIERA DEL ROSARIO' , '15' , '-15' , '4' , '2.38' , '2.38' , '0' , '' , '35.70' ) 18/05/2022 09:20:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1561' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 09:20:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1561' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 18/05/2022 09:20:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57818' 18/05/2022 09:20:39 am >> DELETE FROM ps_document_detail WHERE id_document = '57818' 18/05/2022 09:20:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57818' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '2' , '-2' , '4' , '16.00' , '16' , '0' , '5' , '30.40' ) 18/05/2022 09:20:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '' 18/05/2022 09:20:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '' , '1' ) 18/05/2022 09:23:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1562' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 09:23:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1562' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.01' , '26.81' , NOW() , NOW() ) 18/05/2022 09:23:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57819' 18/05/2022 09:23:37 am >> DELETE FROM ps_document_detail WHERE id_document = '57819' 18/05/2022 09:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57819' , '3433' , 'DIECI COMANDAMENTI' , '2' , '-2' , '4' , '0.20' , '0.2' , '0' , '0' , '0.40' ) 18/05/2022 09:23:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '3433' AND id_supplier = '' 18/05/2022 09:23:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3433' , '' , '1' ) 18/05/2022 09:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57819' , '17127' , 'STABILI E CREDIBILI - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '' , '12.00' ) 18/05/2022 09:23:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '17127' AND id_supplier = '' 18/05/2022 09:23:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17127' , '' , '1' ) 18/05/2022 09:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57819' , '18736' , 'CATECHISTA TESTIMONE - PAPA FRANCESCO' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 18/05/2022 09:23:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18736' AND id_supplier = '' 18/05/2022 09:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18736' , '' , '1' ) 18/05/2022 09:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57819' , '19360' , 'IN PRINCIPIO ERANO FRATELLI - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/05/2022 09:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19360' AND id_supplier = '' 18/05/2022 09:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19360' , '' , '1' ) 18/05/2022 09:23:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57819' , '17748' , 'SEGNALIBRO - PR 349' , '3' , '-3' , '1' , '0.37' , '0.30327868852459' , '22' , '0' , '1.11' ) 18/05/2022 09:23:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17748' AND id_supplier = '' 18/05/2022 09:23:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17748' , '' , '1' ) 18/05/2022 09:25:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1563' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 09:25:04 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' , '1563' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '1.97' , NOW() , NOW() ) 18/05/2022 09:25:04 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 = '57820' 18/05/2022 09:25:04 am >> DELETE FROM ps_document_detail WHERE id_document = '57820' 18/05/2022 09:25:04 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 ( '57820' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 18/05/2022 09:25:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 18/05/2022 09:25:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 18/05/2022 09:27:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1564' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 09:27:00 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' , '1564' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '14.23' , NOW() , NOW() ) 18/05/2022 09:27:00 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 = '57821' 18/05/2022 09:27:00 am >> DELETE FROM ps_document_detail WHERE id_document = '57821' 18/05/2022 09:27:00 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 ( '57821' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 18/05/2022 09:27:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 18/05/2022 09:27:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 18/05/2022 09:27:00 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 ( '57821' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '0' , '6.20' ) 18/05/2022 09:27:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 18/05/2022 09:27:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 18/05/2022 09:49:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1565' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 09:49:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1565' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 18/05/2022 09:49:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57822' 18/05/2022 09:49:11 am >> DELETE FROM ps_document_detail WHERE id_document = '57822' 18/05/2022 09:49:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57822' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' ) 18/05/2022 09:49:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 18/05/2022 09:49:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 18/05/2022 10:05:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1566' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 10:05:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1566' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '12.69' , NOW() , NOW() ) 18/05/2022 10:05:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57823' 18/05/2022 10:05:16 am >> DELETE FROM ps_document_detail WHERE id_document = '57823' 18/05/2022 10:05:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57823' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 18/05/2022 10:05:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 18/05/2022 10:05:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 18/05/2022 10:05:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57823' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 18/05/2022 10:05:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 18/05/2022 10:05:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 18/05/2022 10:05:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57823' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 18/05/2022 10:05:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 18/05/2022 10:05:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 18/05/2022 10:10:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1567' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 10:10:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1567' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '8.85' , NOW() , NOW() ) 18/05/2022 10:10:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57824' 18/05/2022 10:10:36 am >> DELETE FROM ps_document_detail WHERE id_document = '57824' 18/05/2022 10:10:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57824' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '6' , '-6' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '10.80' ) 18/05/2022 10:10:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1935' AND id_supplier = '' 18/05/2022 10:10:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1935' , '' , '1' ) 18/05/2022 10:33:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1568' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 10:33:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1568' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '74.74' , NOW() , NOW() ) 18/05/2022 10:33:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57825' 18/05/2022 10:33:11 am >> DELETE FROM ps_document_detail WHERE id_document = '57825' 18/05/2022 10:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57825' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '15' , '32.30' ) 18/05/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '12816' AND id_supplier = '' 18/05/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12816' , '' , '1' ) 18/05/2022 10:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57825' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '15.20' ) 18/05/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 18/05/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 18/05/2022 10:33:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57825' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 18/05/2022 10:33:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 18/05/2022 10:33:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 18/05/2022 11:00:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1569' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 11:00: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' , '1569' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 18/05/2022 11:00: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 = '57826' 18/05/2022 11:00:13 am >> DELETE FROM ps_document_detail WHERE id_document = '57826' 18/05/2022 11:00: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 ( '57826' , '19560' , 'PERGAMENA 17X25' , '10' , '-10' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '7.00' ) 18/05/2022 11:00:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '' 18/05/2022 11:00:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '' , '1' ) 18/05/2022 11:00: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 ( '57826' , '18220' , 'CATENA CON CROCE - NS020' , '10' , '-10' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '25.00' ) 18/05/2022 11:00:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '18220' AND id_supplier = '' 18/05/2022 11:00:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18220' , '' , '1' ) 18/05/2022 11:00: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 ( '57826' , '13365' , 'SCATOLA 6x4' , '10' , '-10' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '5.00' ) 18/05/2022 11:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '13365' AND id_supplier = '' 18/05/2022 11:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13365' , '' , '1' ) 18/05/2022 11:05:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 11:05:26 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' , '1570' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 18/05/2022 11:05:26 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 = '57827' 18/05/2022 11:05:26 am >> DELETE FROM ps_document_detail WHERE id_document = '57827' 18/05/2022 11:05:26 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 ( '57827' , '19283' , 'quadro 70x70 scompiglio - 110740' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 18/05/2022 11:05:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '19283' AND id_supplier = '' 18/05/2022 11:05:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19283' , '' , '1' ) 18/05/2022 11:12:57 am >> SELECT document_num FROM ps_document WHERE document_num = '1571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 11:12: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' , '1571' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 18/05/2022 11:12: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 = '57828' 18/05/2022 11:12:58 am >> DELETE FROM ps_document_detail WHERE id_document = '57828' 18/05/2022 11:12: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 ( '57828' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 18/05/2022 11:12:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '' 18/05/2022 11:12:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '' , '1' ) 18/05/2022 11:37:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 11:37:28 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' , '1572' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '18.43' , NOW() , NOW() ) 18/05/2022 11:37:28 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 = '57829' 18/05/2022 11:37:28 am >> DELETE FROM ps_document_detail WHERE id_document = '57829' 18/05/2022 11:37:28 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 ( '57829' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/05/2022 11:37:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 18/05/2022 11:37:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 18/05/2022 11:37:28 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 ( '57829' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 18/05/2022 11:37:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 18/05/2022 11:37:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 18/05/2022 11:37:28 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 ( '57829' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/05/2022 11:37:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 18/05/2022 11:37:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 18/05/2022 11:37:28 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 ( '57829' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 18/05/2022 11:37:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 18/05/2022 11:37:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 18/05/2022 11:37:28 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 ( '57829' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 18/05/2022 11:37:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 18/05/2022 11:37:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 18/05/2022 01:13:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1573' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 01:13:28 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' , '1573' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.00' , '56.00' , NOW() , NOW() ) 18/05/2022 01:13: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 = '57830' 18/05/2022 01:13:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '57830' 18/05/2022 01:13: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 ( '57830' , '19560' , 'PERGAMENA 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 18/05/2022 01:13:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19560' AND id_supplier = '' 18/05/2022 01:13:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19560' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 18/05/2022 01:13:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7916' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7916' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '13352' , 'ROSARIO BIANCO - ACQUA' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13352' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13352' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '16.50' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '19202' , 'LETTERA AGLI SPOSI' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '0' , '6.00' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19202' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19202' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '13319' , 'VIVI LA VITA - 30' , '100' , '-100' , '1' , '0.14' , '0.11475409836066' , '22' , '0' , '14.00' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13319' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13319' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '9145' , 'ROSARIO LEGNO NATURALE -MEDIO - OGGETTI' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9145' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9145' , '' , '1' ) 18/05/2022 01:13: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 ( '57830' , '13364' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 18/05/2022 01:13:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13364' AND id_supplier = '' 18/05/2022 01:13:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13364' , '' , '1' ) 18/05/2022 02:41:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/05/2022 02:41:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19563' , '1' , '' , 'nuovo-prodotto' ) 18/05/2022 02:41:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19563' , '1' , '1' , '2' , NOW() , NOW() ) 18/05/2022 02:41:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19563' , '0' , '1' , '0' , '0' ) 18/05/2022 02:42:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872296301' AND id_product != '19563' AND ean13 != '' 18/05/2022 02:42:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788872296301', date_upd = NOW() WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> UPDATE ps_product_lang SET name = 'MEDITAZIONI QUOTIDIANE', description = '' WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29' WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29', id_tax_rules_group = '4', id_category_default = '128', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19563' 18/05/2022 02:42:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19564' , '1' , '' , 'nuovo-prodotto' ) 18/05/2022 02:42:55 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19564' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19563' 18/05/2022 02:42:55 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19564' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19563' 18/05/2022 02:43:18 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' , '2696' , '2022-05-17' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.96' , '102.96' , NOW() , NOW() ) 18/05/2022 02:43: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 = '57831' 18/05/2022 02:43:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '57831' 18/05/2022 02:43: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 ( '57831' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '2' , '2' , '4' , '12.00' , '12' , '0' , '30' , '16.8000' ) 18/05/2022 02:43:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '47' 18/05/2022 02:43:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '47' , '1' ) 18/05/2022 02:43: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 ( '57831' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '3' , '3' , '4' , '12.90' , '12.9' , '0' , '27' , '28.2510' ) 18/05/2022 02:43:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '47' 18/05/2022 02:43:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '47' , '1' ) 18/05/2022 02:43: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 ( '57831' , '19228' , 'DIO CE ED E BELLISSIMO - P. CURTAZ' , '1' , '1' , '4' , '15.90' , '15.9' , '0' , '27' , '11.6070' ) 18/05/2022 02:43:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19228' AND id_supplier = '47' 18/05/2022 02:43:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19228' , '47' , '1' ) 18/05/2022 02:43: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 ( '57831' , '18194' , 'UN MESE CON MARIA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '30' , '2.1000' ) 18/05/2022 02:43:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18194' AND id_supplier = '47' 18/05/2022 02:43:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18194' , '47' , '1' ) 18/05/2022 02:43: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 ( '57831' , '19563' , 'MEDITAZIONI QUOTIDIANE' , '1' , '1' , '4' , '29.00' , '29' , '0' , '30' , '20.3000' ) 18/05/2022 02:43:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19563' AND id_supplier = '47' 18/05/2022 02:43:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19563' , '47' , '1' ) 18/05/2022 02:43: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 ( '57831' , '10527' , 'TEMPO DI PREGHIERA' , '3' , '3' , '4' , '9.00' , '9' , '0' , '30' , '18.9000' ) 18/05/2022 02:43:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10527' AND id_supplier = '47' 18/05/2022 02:43:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10527' , '47' , '1' ) 18/05/2022 04:07:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1574' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 04:07: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' , '1574' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 18/05/2022 04:07: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 = '57832' 18/05/2022 04:07:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '57832' 18/05/2022 04:07: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 ( '57832' , '12824' , 'PIZZO BIANCO ORO MARIANO' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 18/05/2022 04:07:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12824' AND id_supplier = '' 18/05/2022 04:07:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12824' , '' , '1' ) 18/05/2022 04:13:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1575' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 04:13:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1575' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '179.00' , '146.72' , NOW() , NOW() ) 18/05/2022 04:13: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 = '57833' 18/05/2022 04:13:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '57833' 18/05/2022 04:13: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 ( '57833' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '12' , '-12' , '1' , '5' , '4.0983606557377' , '22' , '0' , '60.00' ) 18/05/2022 04:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 18/05/2022 04:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 18/05/2022 04:13: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 ( '57833' , '13886' , 'CANDELABRO BAROCCO ROCCOCO CM 30' , '1' , '-1' , '1' , '105.00' , '86.065573770492' , '22' , '0' , '105.00' ) 18/05/2022 04:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13886' AND id_supplier = '' 18/05/2022 04:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13886' , '' , '1' ) 18/05/2022 04:13: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 ( '57833' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '-2' , '1' , '7' , '5.7377049180328' , '22' , '0' , '14.00' ) 18/05/2022 04:13:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '' 18/05/2022 04:13:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '' , '1' ) 18/05/2022 04:16:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1576' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 04:16: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' , '1576' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.40' , '44.14' , NOW() , NOW() ) 18/05/2022 04:16: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 = '57834' 18/05/2022 04:16:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '57834' 18/05/2022 04:16: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 ( '57834' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/05/2022 04:16:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 18/05/2022 04:16:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 18/05/2022 04:16: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 ( '57834' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 18/05/2022 04:16:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 18/05/2022 04:16:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 18/05/2022 04:16: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 ( '57834' , '15924' , 'OSTIA 3MM - 03M-25' , '1' , '-1' , '3' , '6.00' , '5.7692307692308' , '4' , '0' , '6.00' ) 18/05/2022 04:16:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = '' 18/05/2022 04:16:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' ) 18/05/2022 04:16: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 ( '57834' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 18/05/2022 04:16:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 18/05/2022 04:16:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 18/05/2022 04:16: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 ( '57834' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 18/05/2022 04:16:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 18/05/2022 04:16:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 18/05/2022 04:17:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '59/A' AND id_document != '29452' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2021-06-28') 18/05/2022 04:17:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '59/A', document_date = '2021-06-28', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '567.00', price_tax_excluded = '521.56', date_upd = NOW() WHERE id_document = '29452' 18/05/2022 04:17:59 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 = '29452' 18/05/2022 04:18:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '29452' 18/05/2022 04:18: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 ( '29452' , '1914' , 'CERA DELLA LITURGIA*******' , '72' , '-72' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '252.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 18/05/2022 04:18: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 ( '29452' , '1914' , 'CERA DELLA LITURGIA****' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '100' , '0.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 18/05/2022 04:18: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 ( '29452' , '0' , 'FATIMA CM 27' , '2' , '-2' , '0' , '25.0000' , '25' , '0' , '0' , '50.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 18/05/2022 04:18: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 ( '29452' , '0' , 'FATIMA CM 35' , '2' , '-2' , '0' , '35.0000' , '35' , '0' , '0' , '70.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 18/05/2022 04:18: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 ( '29452' , '0' , 'FATIMA CM 55' , '1' , '-1' , '0' , '75.0000' , '75' , '0' , '0' , '75.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 18/05/2022 04:18: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 ( '29452' , '0' , 'FATIMA CM 70' , '1' , '-1' , '0' , '120.0000' , '120' , '0' , '0' , '120.00' ) 18/05/2022 04:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 18/05/2022 04:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 18/05/2022 04:22:50 pm >> DELETE FROM ps_document WHERE id_document = '49768' 18/05/2022 04:22:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '49768' 18/05/2022 05:14:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '1577' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 05:14:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1577' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '25.00' , NOW() , NOW() ) 18/05/2022 05:14:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57835' 18/05/2022 05:14:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '57835' 18/05/2022 05:14: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 ( '57835' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '3.5' , '3.5' , '0' , '0' , '14.00' ) 18/05/2022 05:14:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 18/05/2022 05:14:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 18/05/2022 05:14: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 ( '57835' , '11151' , 'LIBRI' , '4' , '-4' , '4' , '2' , '2' , '0' , '0' , '8.00' ) 18/05/2022 05:14:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 18/05/2022 05:14:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 18/05/2022 05:14: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 ( '57835' , '19155' , 'TREDICINA A SANTANTONIO - 8042' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 18/05/2022 05:14:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19155' AND id_supplier = '' 18/05/2022 05:14:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19155' , '' , '1' ) 18/05/2022 05:17:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1578' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 05:17:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1578' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.00' , '44.26' , NOW() , NOW() ) 18/05/2022 05:17: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 = '57836' 18/05/2022 05:17:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '57836' 18/05/2022 05:17: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 ( '57836' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '30' , '-30' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '54.00' ) 18/05/2022 05:17:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 18/05/2022 05:17:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 18/05/2022 05:20:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 05:20:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '17' , '2022-05-18' , '' , '188' , '0' , '4668955' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.20' , '28.03' , NOW() , NOW() ) 18/05/2022 05:20:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57837' 18/05/2022 05:20:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '57837' 18/05/2022 05:20:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57837' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '10' , '34.20' ) 18/05/2022 05:20:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '38/A' AND id_document != '57837' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 05:20:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '38/A', document_date = '2022-05-18', document_letter = 'A', id_customer = '188', id_supplier = '', id_address = '4668955', address1 = 'VIA ROMA 84121 SALERNO', 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 = '34.20', price_tax_excluded = '28.03', date_upd = NOW() WHERE id_document = '57837' 18/05/2022 05:20: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 = '57837' 18/05/2022 05:20:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '57837' 18/05/2022 05:20: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 ( '57837' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '38.0000' , '31.147540983607' , '22' , '10' , '34.20' ) 18/05/2022 05:20:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 18/05/2022 05:20:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 18/05/2022 05:51:36 pm >> DELETE FROM ps_document WHERE id_document = '56711' 18/05/2022 05:51:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '56711' 18/05/2022 05:56: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 ( '31' , '115/22' , '2022-05-10' , '22' , '0' , '0' , '4671003' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '26.50' , '26.50' , NOW() , NOW() ) 18/05/2022 05:56: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 = '57838' 18/05/2022 05:56:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '57838' 18/05/2022 05:56: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 ( '57838' , '9436' , 'SAN GABRIELE DELL\'ADDOLORATA - V.SALVOLDI' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.0000' ) 18/05/2022 05:56: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 ( '57838' , '9613' , 'SANTA TERESA DI LISIEUX' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 18/05/2022 05:56: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 ( '57838' , '3625' , 'DOMENICO SAVIO - T.BOSCO' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.0000' ) 18/05/2022 05:56: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 ( '57838' , '9549' , 'SANTA CATERINA LABOURÉ - M.TARONI' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 18/05/2022 05:56: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 ( '57838' , '6055' , 'MADONNA DEL CARMINE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.7500' ) 18/05/2022 05:56: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 ( '57838' , '19552' , 'MADONNA CHE SCIOGLIE I NODI - A. CAMPAGNA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 18/05/2022 05:56: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 ( '57838' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.0000' ) 18/05/2022 06:13:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1579' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 06:13:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1579' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 18/05/2022 06:13: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 = '57839' 18/05/2022 06:13:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '57839' 18/05/2022 06:13: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 ( '57839' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/05/2022 06:13:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 18/05/2022 06:13:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 18/05/2022 06:13: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 ( '57839' , '19375' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 18/05/2022 06:13:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19375' AND id_supplier = '' 18/05/2022 06:13:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19375' , '' , '1' ) 18/05/2022 07:25:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1580' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 07:25:13 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' , '1580' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 18/05/2022 07:25: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 = '57840' 18/05/2022 07:25:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '57840' 18/05/2022 07:25: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 ( '57840' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '46' , '37.704918032787' , '22' , '0' , '46.00' ) 18/05/2022 07:25:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 18/05/2022 07:25:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 18/05/2022 07:35:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1387' AND id_document != '56578' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 18/05/2022 07:35:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1387', document_date = '2022-05-04', 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 = '120.00', price_tax_excluded = '105.67', date_upd = NOW() WHERE id_document = '56578' 18/05/2022 07:35:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56578' 18/05/2022 07:35:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '56578' 18/05/2022 07:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/05/2022 07:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 18/05/2022 07:35:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 18/05/2022 07:35:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 18/05/2022 07:35:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 18/05/2022 07:35: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 ( '56578' , '9602' , 'SANTA RITA DA CASCIA - RITA DA CASCIA' , '1' , '-1' , '4' , '9.44' , '9.44' , '0' , '0' , '9.44' ) 18/05/2022 07:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9602' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9602' , '' , '1' ) 18/05/2022 07:35: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 ( '56578' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 18/05/2022 07:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 18/05/2022 07:35: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 ( '56578' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '48.00' ) 18/05/2022 07:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 18/05/2022 07:35: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 ( '56578' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 18/05/2022 07:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 18/05/2022 07:35: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 ( '56578' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 18/05/2022 07:35:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18906' AND id_supplier = '' 18/05/2022 07:35:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18906' , '' , '1' ) 18/05/2022 07:44:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1581' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 07:44:56 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' , '1581' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 18/05/2022 07:44: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 = '57841' 18/05/2022 07:44:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '57841' 18/05/2022 07:44: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 ( '57841' , '19501' , 'PACE INTERIORE - CHIARA AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 18/05/2022 07:44:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 18/05/2022 07:44:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 18/05/2022 07:47:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1582' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 18/05/2022 07:47:28 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' , '1582' , '2022-05-18' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 18/05/2022 07:47: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 = '57842' 18/05/2022 07:47:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '57842' 18/05/2022 07:47: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 ( '57842' , '2979' , 'CROCE EFFETTO PIETRA AVE MARIA - 2827/T0015 2' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 18/05/2022 07:47:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2979' AND id_supplier = '' 18/05/2022 07:47:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2979' , '' , '1' ) 18/05/2022 07:58:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '712' AND id_document != '53195' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-10') 18/05/2022 07:58:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '712', document_date = '2022-03-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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '53195' 18/05/2022 07:58:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '53195' 18/05/2022 07:58:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '53195' 18/05/2022 07:58:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53195' , '2979' , 'CROCE EFFETTO PIETRA AVE MARIA - 2827/T0015 2' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/05/2022 07:58:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2979' AND id_supplier = '' 18/05/2022 07:58:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2979' , '' , '1' ) 18/05/2022 07:58:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '53195' , '13340' , 'CORONA FEDI' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 18/05/2022 07:58:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13340' AND id_supplier = '' 18/05/2022 07:58:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13340' , '' , '1' )