04/10/2022 08:55:45 am >> SELECT document_num FROM ps_document WHERE document_num = '88' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 08:55:45 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' , '88' , '2022-10-04' , '' , '3421' , '0' , '4670167' , 'VIA GENERALE MESSINA 131 74121 TARANTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 04/10/2022 08:55:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6878' 04/10/2022 08:55:45 am >> DELETE FROM ps_document_detail WHERE id_document = '6878' 04/10/2022 08:55:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6878' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 04/10/2022 09:01:34 am >> SELECT document_num FROM ps_document WHERE document_num = '2905' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 09:01:34 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' , '2905' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '24.65' , NOW() , NOW() ) 04/10/2022 09:01:34 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 = '63585' 04/10/2022 09:01:34 am >> DELETE FROM ps_document_detail WHERE id_document = '63585' 04/10/2022 09:01:34 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 ( '63585' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5' , '3.5' , '0' , '0' , '21.00' ) 04/10/2022 09:01:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 09:01:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 09:01:34 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 ( '63585' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 04/10/2022 09:01:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/10/2022 09:01:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/10/2022 09:42:41 am >> SELECT document_num FROM ps_document WHERE document_num = '87' AND id_document != '6877' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-03') 04/10/2022 09:42:41 am >> UPDATE ps_document SET id_document_type = '21', document_num = '87', document_date = '2022-10-03', document_letter = '', id_customer = '6989', id_supplier = '', id_address = '84014825', address1 = 'LOCALITA\\\' SANT\\\'EUSEBIO 9 52044 CORTONA', address2 = '', note = '', price_shipping = '6.9', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '60.90', price_tax_excluded = '60.90', date_upd = NOW() WHERE id_document = '6877' 04/10/2022 09:42:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6877' 04/10/2022 09:42:41 am >> DELETE FROM ps_document_detail WHERE id_document = '6877' 04/10/2022 09:42:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6877' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '3' , '-3' , '4' , '18.0000' , '18' , '0' , '0' , '54.00' ) 04/10/2022 09:42:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 04/10/2022 09:42:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 04/10/2022 10:03:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 10:03:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2906' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.60' , '130.71' , NOW() , NOW() ) 04/10/2022 10:03:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63586' 04/10/2022 10:03:53 am >> DELETE FROM ps_document_detail WHERE id_document = '63586' 04/10/2022 10:03:54 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 ( '63586' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '-1' , '1' , '135.00' , '110.65573770492' , '22' , '0' , '135.00' ) 04/10/2022 10:03:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = '' 04/10/2022 10:03:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '' , '1' ) 04/10/2022 10:03:54 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 ( '63586' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '7.60' ) 04/10/2022 10:03:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 04/10/2022 10:03:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 04/10/2022 10:03:54 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 ( '63586' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 04/10/2022 10:03:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 04/10/2022 10:03:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 04/10/2022 10:03:54 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 ( '63586' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/10/2022 10:03:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '18748' AND id_supplier = '' 04/10/2022 10:03:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18748' , '' , '1' ) 04/10/2022 10:24:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 10:24:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2907' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.05' , '16.43' , NOW() , NOW() ) 04/10/2022 10:24:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63587' 04/10/2022 10:24:25 am >> DELETE FROM ps_document_detail WHERE id_document = '63587' 04/10/2022 10:24:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63587' , '18891' , 'ROSARIO LEGNO - R984' , '12' , '-12' , '1' , '0.90' , '0.73770491803279' , '22' , '0' , '10.80' ) 04/10/2022 10:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18891' AND id_supplier = '' 04/10/2022 10:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18891' , '' , '1' ) 04/10/2022 10:24:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63587' , '9125' , 'ROSARIO IN PLASTICA - NERO' , '37' , '-37' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '9.25' ) 04/10/2022 10:24:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '9125' AND id_supplier = '' 04/10/2022 10:24:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9125' , '' , '1' ) 04/10/2022 10:32:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 10:32:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2908' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.10' , '21.83' , NOW() , NOW() ) 04/10/2022 10:32:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63588' 04/10/2022 10:32:59 am >> DELETE FROM ps_document_detail WHERE id_document = '63588' 04/10/2022 10:32:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63588' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '-1' , '4' , '18.10' , '18.1' , '0' , '0' , '18.10' ) 04/10/2022 10:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '' 04/10/2022 10:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '' , '1' ) 04/10/2022 10:32:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63588' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 04/10/2022 10:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/10/2022 10:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/10/2022 10:32:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63588' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 04/10/2022 10:32:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '7098' AND id_supplier = '' 04/10/2022 10:32:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7098' , '' , '1' ) 04/10/2022 10:49:15 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'W8rlAysxBLCCll8s' , NOW() , NOW() ) 04/10/2022 10:49:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3923' , '1' ) 04/10/2022 10:49:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3923' , '2' ) 04/10/2022 10:49:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3923' , '3' ) 04/10/2022 10:52:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3923' 04/10/2022 10:52:12 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 ( '3923' , '10' , '164' , 'PARR. NATIVITA\' MARIA SS.' , 'ALBERTO' , 'DON MARIO' , 'CORSO LIMONE PIEMONTE 53' , '' , '18039' , 'VENTIMIGLIA' , '' , '0184351927' , '' , '' , '' , NOW() , NOW() ) 04/10/2022 10:52:12 am >> UPDATE ps_customer SET email = 'p.nativitadimaria@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3923' 04/10/2022 10:53:34 am >> SELECT document_num FROM ps_document WHERE document_num = '140' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 10:53:34 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' , '140' , '2022-10-04' , '' , '3923' , '0' , '4675304' , 'CORSO LIMONE PIEMONTE 53 18039 VENTIMIGLIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '144.40' , '144.40' , NOW() , NOW() ) 04/10/2022 10:53:34 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 = '63589' 04/10/2022 10:53:34 am >> DELETE FROM ps_document_detail WHERE id_document = '63589' 04/10/2022 10:53:34 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 ( '63589' , '15743' , 'PREGHIERA DEL ROSARIO' , '56' , '-56' , '4' , '2.50' , '2.5' , '0' , '5' , '133.00' ) 04/10/2022 10:53:34 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 ( '63589' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 04/10/2022 11:16:19 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14497' 04/10/2022 11:16:19 am >> UPDATE ps_stock_available SET quantity = quantity + '-17' WHERE id_product = '14497' 04/10/2022 11:16:38 am >> SELECT document_num FROM ps_document WHERE document_num = '20/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 11:16:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '20/S' , '2022-10-04' , 'S' , '402' , '0' , '4670248' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1073.16' , '1073.16' , NOW() , NOW() ) 04/10/2022 11:16:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7134' 04/10/2022 11:16:38 am >> DELETE FROM ps_document_detail WHERE id_document = '7134' 04/10/2022 11:16: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 ( '7134' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '30' , '-30' , '4' , '18.00' , '18' , '0' , '35' , '351.00' ) 04/10/2022 11:16: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 ( '7134' , '33' , '100 GIORNI CON LO SPIRITO' , '10' , '-10' , '4' , '7.50' , '7.5' , '0' , '35' , '48.75' ) 04/10/2022 11:16: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 ( '7134' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '35' , '16.25' ) 04/10/2022 11:16: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 ( '7134' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '40' , '-40' , '4' , '2.50' , '2.5' , '0' , '35' , '65.00' ) 04/10/2022 11:16: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 ( '7134' , '17' , 'LA FEDE NELLO ZAINETTO' , '40' , '-40' , '4' , '5.00' , '5' , '0' , '35' , '130.00' ) 04/10/2022 11:16: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 ( '7134' , '125' , 'MIE PREGHIERINE - N. E.' , '30' , '-30' , '4' , '1.50' , '1.5' , '0' , '35' , '29.25' ) 04/10/2022 11:16: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 ( '7134' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '35' , '81.25' ) 04/10/2022 11:16: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 ( '7134' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '35' , '32.50' ) 04/10/2022 11:16: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 ( '7134' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '35' , '19.50' ) 04/10/2022 11:16: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 ( '7134' , '92' , 'LA PREGHIERA DEL ROSARIO' , '120' , '-120' , '4' , '2.50' , '2.5' , '0' , '35' , '195.00' ) 04/10/2022 11:16: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 ( '7134' , '117' , 'La preghiera delle cinque dita n.e.' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '35' , '23.40' ) 04/10/2022 11:16: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 ( '7134' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '40' , '-40' , '4' , '1.50' , '1.5' , '0' , '35' , '39.00' ) 04/10/2022 11:16: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 ( '7134' , '94' , 'IL BATTESIMO' , '5' , '-5' , '4' , '1.50' , '1.5' , '0' , '35' , '4.88' ) 04/10/2022 11:16: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 ( '7134' , '126' , 'SACRAMENTO DEL PERDONO' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '35' , '26.00' ) 04/10/2022 11:16: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 ( '7134' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '35' , '4.88' ) 04/10/2022 11:16: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 ( '7134' , '29' , 'UNA SPERANZA POSSIBILE' , '5' , '-5' , '4' , '2.00' , '2' , '0' , '35' , '6.50' ) 04/10/2022 11:26:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 11:26: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' , '2909' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '153.00' , '125.41' , NOW() , NOW() ) 04/10/2022 11:26: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 = '63590' 04/10/2022 11:26:05 am >> DELETE FROM ps_document_detail WHERE id_document = '63590' 04/10/2022 11:26: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 ( '63590' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '18' , '-18' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '144.00' ) 04/10/2022 11:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '739' AND id_supplier = '' 04/10/2022 11:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '739' , '' , '1' ) 04/10/2022 11:26: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 ( '63590' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 04/10/2022 11:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/10/2022 11:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/10/2022 11:26: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 ( '63590' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 04/10/2022 11:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 04/10/2022 11:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 04/10/2022 11:26: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 ( '63590' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/10/2022 11:26:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 04/10/2022 11:26:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 04/10/2022 11:26:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 11:26:20 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' , '2910' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '28.44' , NOW() , NOW() ) 04/10/2022 11:26:20 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 = '63591' 04/10/2022 11:26:20 am >> DELETE FROM ps_document_detail WHERE id_document = '63591' 04/10/2022 11:26:20 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 ( '63591' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 04/10/2022 11:26:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 04/10/2022 11:26:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 04/10/2022 11:26:20 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 ( '63591' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 04/10/2022 11:26:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 04/10/2022 11:26:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 04/10/2022 11:44:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 11:44: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' , '2911' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '127.28' , NOW() , NOW() ) 04/10/2022 11:44: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 = '63592' 04/10/2022 11:44:23 am >> DELETE FROM ps_document_detail WHERE id_document = '63592' 04/10/2022 11:44: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 ( '63592' , '11151' , 'LIBRI' , '8' , '-8' , '4' , '3.5' , '3.5' , '0' , '0' , '28.00' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '19.00' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '3.80' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.9' , '1.9' , '0' , '0' , '3.80' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 04/10/2022 11:44:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45.2' , '37.049180327869' , '22' , '0' , '45.20' ) 04/10/2022 11:44:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '' 04/10/2022 11:44:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '' , '1' ) 04/10/2022 11:44: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 ( '63592' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 04/10/2022 11:44:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13142' AND id_supplier = '' 04/10/2022 11:44:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13142' , '' , '1' ) 04/10/2022 12:20:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 12:20:22 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' , '2912' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.20' , '25.13' , NOW() , NOW() ) 04/10/2022 12:20:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63593' 04/10/2022 12:20:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '63593' 04/10/2022 12:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 04/10/2022 12:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 04/10/2022 12:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 04/10/2022 12:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '14129' , 'SANTO STEFANO PROTO MARTIRE - 57' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 04/10/2022 12:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14129' AND id_supplier = '' 04/10/2022 12:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14129' , '' , '1' ) 04/10/2022 12:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/10/2022 12:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 04/10/2022 12:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 04/10/2022 12:20:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '3.5' , '3.5' , '0' , '0' , '7.00' ) 04/10/2022 12:20:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 12:20:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 12:21:00 pm >> DELETE FROM ps_document WHERE id_document = '60005' 04/10/2022 12:21:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '60005' 04/10/2022 12:23:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 12:23:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2913' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.40' , '26.60' , NOW() , NOW() ) 04/10/2022 12:23:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63594' 04/10/2022 12:23:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '63594' 04/10/2022 12:23:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63594' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.4' , '18.4' , '0' , '0' , '18.40' ) 04/10/2022 12:23:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 12:23:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 12:23:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63594' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/10/2022 12:23:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 04/10/2022 12:23:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 04/10/2022 12:37:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/s' AND id_document != '6081' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-01') 04/10/2022 12:38:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/S' AND id_document != '6081' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-30') 04/10/2022 12:38:01 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '18/S', document_date = '2022-09-30', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '4670192', address1 = 'VIA TORQUATO TASSO, 10 24020 GORLE', 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 = '369.00', price_tax_excluded = '369.00', date_upd = NOW() WHERE id_document = '6081' 04/10/2022 12:38: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 = '6081' 04/10/2022 12:38:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '6081' 04/10/2022 12:38: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 ( '6081' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '10' , '-10' , '4' , '18.0000' , '18' , '0' , '50' , '90.00' ) 04/10/2022 12:38:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 04/10/2022 12:38:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 04/10/2022 12:38: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 ( '6081' , '111' , 'I NONNI SONO UN TESORO' , '310' , '-310' , '4' , '1.8000' , '1.8' , '0' , '50' , '279.00' ) 04/10/2022 12:38:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '' 04/10/2022 12:38:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '' , '1' ) 04/10/2022 12:40:05 pm >> DELETE FROM ps_document WHERE id_document = '6081' 04/10/2022 12:40:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '6081' 04/10/2022 12:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/S' AND id_document != '6365' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-01') 04/10/2022 12:40:16 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '18/S', document_date = '2022-10-01', document_letter = 'S', id_customer = '3352', id_supplier = '', id_address = '4670151', address1 = 'VIA RASPOLO, 5 80069 VICO EQUENSE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '180.00', price_tax_excluded = '180.00', date_upd = NOW() WHERE id_document = '6365' 04/10/2022 12:40:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6365' 04/10/2022 12:40:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '6365' 04/10/2022 12:40:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6365' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '10' , '-10' , '4' , '18.0000' , '18' , '0' , '0' , '180.00' ) 04/10/2022 12:40:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '133' AND id_supplier = '' 04/10/2022 12:40:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '133' , '' , '1' ) 04/10/2022 12:41:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-01') 04/10/2022 12:41:07 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '19/S' , '2022-10-01' , 'S' , '3487' , '0' , '4670192' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '369.00' , '369.00' , NOW() , NOW() ) 04/10/2022 12:41:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7135' 04/10/2022 12:41:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '7135' 04/10/2022 12:41:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7135' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '10' , '-10' , '4' , '18.00' , '18' , '0' , '50' , '90.00' ) 04/10/2022 12:41:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7135' , '111' , 'I NONNI SONO UN TESORO' , '310' , '-310' , '4' , '1.80' , '1.8' , '0' , '50' , '279.00' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '20/S' , '2022-10-04' , 'S' , '0' , '127' , '4670004' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '00.01' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1073.16' , '1073.16' , NOW() , NOW() ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63595' 04/10/2022 12:53:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '63595' 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '30' , '30' , '4' , '18.00' , '18' , '0' , '35' , '351.0000' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19911' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19911' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '14330' , '100 GIORNI CON LO SPIRITO' , '10' , '10' , '4' , '7.50' , '7.5' , '0' , '35' , '48.7500' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14330' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14330' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '10' , '10' , '4' , '2.50' , '2.5' , '0' , '35' , '16.2500' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16065' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16065' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '40' , '40' , '4' , '2.50' , '2.5' , '0' , '35' , '65.0000' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15251' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15251' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '4120' , 'FEDE NELLO ZAINETTO' , '40' , '40' , '4' , '5.00' , '5' , '0' , '35' , '130.0000' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '18357' , 'MIE PREGHIERINE N.E.' , '30' , '30' , '4' , '1.50' , '1.5' , '0' , '35' , '29.2500' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '50' , '4' , '2.50' , '2.5' , '0' , '35' , '81.2500' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '20' , '20' , '4' , '2.50' , '2.5' , '0' , '35' , '32.5000' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18049' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18049' , '127' , '1' ) 04/10/2022 12:53:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '18658' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '10' , '10' , '4' , '3.00' , '3' , '0' , '35' , '19.5000' ) 04/10/2022 12:53:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18658' AND id_supplier = '127' 04/10/2022 12:53:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18658' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '15743' , 'PREGHIERA DEL ROSARIO' , '120' , '120' , '4' , '2.50' , '2.5' , '0' , '35' , '195.0000' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15743' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15743' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '14487' , 'PREGHIERA DELLE 5 DITA' , '20' , '20' , '4' , '1.80' , '1.8' , '0' , '35' , '23.4000' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14487' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14487' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '13463' , 'PREGHIERE DEI RAGAZZI - N.E.' , '40' , '40' , '4' , '1.50' , '1.5' , '0' , '35' , '39.0000' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13463' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13463' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '14492' , 'SACRAMENTI SPIEGATI AI RAGAZZI - BATTESIMO' , '5' , '5' , '4' , '1.50' , '1.5' , '0' , '35' , '4.8750' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14492' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14492' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '17034' , 'SACRAMENTO DEL PERDONO' , '20' , '20' , '4' , '2.00' , '2' , '0' , '35' , '26.0000' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17034' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17034' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '14486' , 'SEMPRE CON TE ' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '35' , '4.8750' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14486' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14486' , '127' , '1' ) 04/10/2022 12:53:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63595' , '18629' , 'SPERANZA POSSIBILE?' , '5' , '5' , '4' , '2.00' , '2' , '0' , '35' , '6.5000' ) 04/10/2022 12:53:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18629' AND id_supplier = '127' 04/10/2022 12:53:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18629' , '127' , '1' ) 04/10/2022 02:27:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '141' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 02:27:12 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' , '141' , '2022-10-04' , '' , '1832' , '0' , '4670920' , 'C.DA PANTANO 85010 PIGNOLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '205.70' , '205.70' , NOW() , NOW() ) 04/10/2022 02:27:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63596' 04/10/2022 02:27:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '63596' 04/10/2022 02:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8408' , 'PRENDETE E MANGIATE' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 04/10/2022 02:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 04/10/2022 02:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '4120' , 'FEDE NELLO ZAINETTO' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '15' , '72.25' ) 04/10/2022 02:27:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '7543' , 'PARABOLE DI GESÙ' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '5' , '37.05' ) 04/10/2022 02:27: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 ( '63596' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 04/10/2022 02:27: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 ( '63596' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 04/10/2022 02:27: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 ( '63596' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '15' , '17.00' ) 04/10/2022 02:27: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 ( '63596' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '15' , '0.77' ) 04/10/2022 02:29:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '120' AND id_document != '20685' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2019-08-26') 04/10/2022 02:29:46 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '120', document_date = '2019-08-26', document_letter = '', id_customer = '3381', id_supplier = '', id_address = '4670592', address1 = 'VIA PADRE EMILIO VENTURINI, 1/B - SOTTOMARINA 30015 CHIOGGIA', address2 = '', note = '', price_shipping = '10.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '78.00', price_tax_excluded = '78.00', date_upd = NOW() WHERE id_document = '20685' 04/10/2022 02:29:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '20685' 04/10/2022 02:29:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '20685' 04/10/2022 02:29:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '20685' , '15020' , 'PREGARE OGNI GIORNO' , '80' , '-80' , '4' , '1.00' , '1' , '0' , '15' , '68.00' ) 04/10/2022 02:29:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/10/2022 02:29:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/10/2022 02:31:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '173/D' AND id_document != '6058' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2017-12-18') 04/10/2022 02:31:31 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '173/D', document_date = '2017-12-18', document_letter = 'D', 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 = '15', id_causal = '0', price_tax_included = '320.00', price_tax_excluded = '320.00', date_upd = NOW() WHERE id_document = '6058' 04/10/2022 02:31:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '6058' 04/10/2022 02:31:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '6058' 04/10/2022 02:31:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6058' , '8243' , 'PREGARE OGNI GIORNO' , '291' , '-291' , '4' , '1.0000' , '1' , '0' , '20' , '232.80' ) 04/10/2022 02:31:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8243' AND id_supplier = '' 04/10/2022 02:31:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8243' , '' , '1' ) 04/10/2022 02:31:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '6058' , '15020' , 'PREGARE OGNI GIORNO' , '109' , '-109' , '4' , '1.00' , '1' , '0' , '20' , '87.20' ) 04/10/2022 02:31:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/10/2022 02:31:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/10/2022 03:27:34 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'oYxwl7wrjgXvucIo' , NOW() , NOW() ) 04/10/2022 03:27:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3924' , '1' ) 04/10/2022 03:27:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3924' , '2' ) 04/10/2022 03:27:34 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3924' , '3' ) 04/10/2022 03:28:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3924' 04/10/2022 03:28:58 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 ( '3924' , '10' , '124' , 'PARROCCHIA SANTA MARIA E REMIGIO' , 'ORSINI' , 'DON LUCIANO' , 'VIA MENADA 1' , '' , '15040' , 'PECETTO' , '' , '' , '3401280335' , '' , '' , NOW() , NOW() ) 04/10/2022 03:28:58 pm >> UPDATE ps_customer SET email = 'd.lucianoorsini@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3924' 04/10/2022 03:33:18 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3924' 04/10/2022 03:33:18 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 ( '3924' , '10' , '124' , 'PARROCCHIA SANTA MARIA E REMIGIO' , 'ORSINI' , 'DON LUCIANO' , 'VIA MENADA 1' , '' , '15040' , 'PECETTO' , '' , '' , '3401280335' , '' , '86004190061' , NOW() , NOW() ) 04/10/2022 03:33:18 pm >> UPDATE ps_customer SET email = 'd.lucianoorsini@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3924' 04/10/2022 03:34:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '142' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 03:34:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '142' , '2022-10-04' , '' , '3924' , '0' , '4675306' , 'VIA MENADA 1 15040 PECETTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '116.80' , '116.80' , NOW() , NOW() ) 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63597' 04/10/2022 03:34:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '63597' 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63597' , '6629' , 'MIA PREGHIERA' , '50' , '-50' , '4' , '0.90' , '0.9' , '0' , '15' , '38.25' ) 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63597' , '17257' , 'IO TI BATTEZZO ' , '5' , '-5' , '4' , '1.80' , '1.8' , '0' , '15' , '7.65' ) 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63597' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '50' , '-50' , '4' , '1.00' , '1' , '0' , '15' , '42.50' ) 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63597' , '18357' , 'MIE PREGHIERINE N.E.' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '15' , '25.50' ) 04/10/2022 03:34:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63597' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/10/2022 03:34:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3924' 04/10/2022 03:34:37 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 ( '3924' , '10' , '124' , 'PARROCCHIA SANTA MARIA E REMIGIO' , 'ORSINI' , 'DON LUCIANO' , 'VIA MENADA 1' , '' , '15040' , 'PECETTO' , 'orsini marisa' , '' , '3401280335' , '' , '86004190061' , NOW() , NOW() ) 04/10/2022 03:34:37 pm >> UPDATE ps_customer SET email = 'd.lucianoorsini@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3924' 04/10/2022 03:36:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 03:36:53 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' , '2914' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '95.00' , NOW() , NOW() ) 04/10/2022 03:36:53 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 = '63598' 04/10/2022 03:36:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '63598' 04/10/2022 03:36:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63598' , '20045' , 'VIA DEL CUORE - T. GUADAGNO' , '10' , '-10' , '4' , '10.00' , '10' , '0' , '5' , '95.00' ) 04/10/2022 03:36:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20045' AND id_supplier = '' 04/10/2022 03:36:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20045' , '' , '1' ) 04/10/2022 03:44:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '141' AND id_document != '63596' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 03:44:03 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '141', document_date = '2022-10-04', document_letter = '', id_customer = '1832', id_supplier = '', id_address = '4670920', address1 = 'C.DA PANTANO 85010 PIGNOLA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '205.70', price_tax_excluded = '205.70', date_upd = NOW() WHERE id_document = '63596' 04/10/2022 03:44:03 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 = '63596' 04/10/2022 03:44:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '63596' 04/10/2022 03:44:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8408' , 'PRENDETE E MANGIATE' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 04/10/2022 03:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 04/10/2022 03:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 04/10/2022 03:44:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '4120' , 'FEDE NELLO ZAINETTO' , '17' , '-17' , '4' , '5.0000' , '5' , '0' , '15' , '72.25' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '7543' , 'PARABOLE DI GESÙ' , '13' , '-13' , '4' , '3.0000' , '3' , '0' , '5' , '37.05' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7543' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7543' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '15020' , 'PREGARE OGNI GIORNO' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '15' , '17.00' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 04/10/2022 03:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63596' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '15' , '0.77' ) 04/10/2022 03:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 04/10/2022 03:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 04/10/2022 03:48:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2915' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 03:48: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' , '2915' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.51' , '43.45' , NOW() , NOW() ) 04/10/2022 03:48: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 = '63599' 04/10/2022 03:48:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '63599' 04/10/2022 03:48: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 ( '63599' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '5' , '9.50' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '19805' , 'DESIDERIO DESIDERAVI' , '3' , '-3' , '4' , '2.00' , '2' , '0' , '5' , '5.70' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '13460' , 'VERITATIS GAUDIUM' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13460' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13460' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '17342' , 'SCRIPTURAE SACRAE AFFECTUS ' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17342' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17342' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19050' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19050' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17583' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17583' , '' , '1' ) 04/10/2022 03:48: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 ( '63599' , '19923' , 'AGENDA LITURGICO PASTORALE 2023 - 40807' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 04/10/2022 03:48:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19923' AND id_supplier = '' 04/10/2022 03:48:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19923' , '' , '1' ) 04/10/2022 04:37:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '89' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 04:37: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' , '89' , '2022-10-04' , '' , '3400' , '0' , '4670158' , 'VIA G. GARIBALDI, 69 26040 SCANDOLARA RAVARA' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 04/10/2022 04:37: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 = '7136' 04/10/2022 04:37:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '7136' 04/10/2022 04:37: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 ( '7136' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 04/10/2022 05:22:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 05:22:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '74/A' , '2022-10-04' , 'A' , '189' , '0' , '4670598' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1633.70' , '1633.70' , NOW() , NOW() ) 04/10/2022 05:22:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63600' 04/10/2022 05:22:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '63600' 04/10/2022 05:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63600' , '5457' , 'IO SONO CON VOI 1 PARTE' , '600' , '-600' , '4' , '2.50' , '2.5' , '0' , '38' , '930.00' ) 04/10/2022 05:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63600' , '11191' , 'VENITE CON ME 1 PARTE' , '360' , '-360' , '4' , '2.50' , '2.5' , '0' , '38' , '558.00' ) 04/10/2022 05:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63600' , '2679' , 'CONOSCERE GESU\'' , '50' , '-50' , '4' , '3.50' , '3.5' , '0' , '38' , '108.50' ) 04/10/2022 05:22:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63600' , '12819' , 'REGISTRO DEL CATECHISTA ' , '60' , '-60' , '0' , '1.00' , '1' , '' , '38' , '37.20' ) 04/10/2022 05:43:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 05:43:26 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' , '2916' , '2022-10-04' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 04/10/2022 05:43:26 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 = '63601' 04/10/2022 05:43:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '63601' 04/10/2022 05:43:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63601' , '20017' , 'CHI DORME NON PIGLIA CRISTO - M. POZZA' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 04/10/2022 05:43:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20017' AND id_supplier = '' 04/10/2022 05:43:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20017' , '' , '1' ) 04/10/2022 06:16:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2912' AND id_document != '63593' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 06:16:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2912', document_date = '2022-10-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 = '28.20', price_tax_excluded = '25.13', date_upd = NOW() WHERE id_document = '63593' 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63593' 04/10/2022 06:16:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '63593' 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.7000' , '0.7' , '0' , '0' , '4.20' ) 04/10/2022 06:16:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 04/10/2022 06:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '14129' , 'SANTO STEFANO PROTO MARTIRE - 57' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 04/10/2022 06:16:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14129' AND id_supplier = '' 04/10/2022 06:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14129' , '' , '1' ) 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 04/10/2022 06:16:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 04/10/2022 06:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.1' , '4.1' , '0' , '0' , '4.10' ) 04/10/2022 06:16:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 04/10/2022 06:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 04/10/2022 06:16:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63593' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 04/10/2022 06:16:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 04/10/2022 06:16:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 04/10/2022 06:37:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '143' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 06:37: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 ( '21' , '143' , '2022-10-04' , '' , '3921' , '' , '4675300' , 'Strada della Romagna , 152 61121 Pesaro ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 04/10/2022 06:37: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 = '64113' 04/10/2022 06:37:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '64113' 04/10/2022 06:37: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 ( '64113' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '5' , '57.00' ) 04/10/2022 06:37:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 04/10/2022 06:37:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 04/10/2022 06:42:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '143' AND id_document != '64113' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 06:42:58 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '143', document_date = '2022-10-04', document_letter = '', id_customer = '3921', id_supplier = '', id_address = '4675300', address1 = 'Strada della Romagna , 152 61121 Pesaro ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '64.90', price_tax_excluded = '64.90', date_upd = NOW() WHERE id_document = '64113' 04/10/2022 06:42:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64113' 04/10/2022 06:42:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '64113' 04/10/2022 06:42: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 ( '64113' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '5' , '57.00' ) 04/10/2022 06:42:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 04/10/2022 06:42:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' ) 04/10/2022 06:42:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64113' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 04/10/2022 06:42:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 04/10/2022 06:42:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 04/10/2022 06:43:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '143' AND id_document != '64113' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-04') 04/10/2022 06:43:35 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '143', document_date = '2022-10-04', document_letter = '', id_customer = '3921', id_supplier = '', id_address = '4675300', address1 = 'Strada della Romagna , 152 61121 Pesaro ', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '57.00', price_tax_excluded = '57.00', date_upd = NOW() WHERE id_document = '64113' 04/10/2022 06:43:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '64113' 04/10/2022 06:43:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '64113' 04/10/2022 06:43:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '64113' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '5' , '57.00' ) 04/10/2022 06:43:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8488' AND id_supplier = '' 04/10/2022 06:43:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8488' , '' , '1' )