09/02/2023 09:26:03 am >> SELECT document_num FROM ps_document WHERE document_num = '455' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 09:26:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '455' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '10.62' , NOW() , NOW() ) 09/02/2023 09:26:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81282' 09/02/2023 09:26:03 am >> DELETE FROM ps_document_detail WHERE id_document = '81282' 09/02/2023 09:26:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81282' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 09/02/2023 09:26:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81282' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 09/02/2023 09:26:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81282' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 09/02/2023 09:55:12 am >> SELECT document_num FROM ps_document WHERE document_num = '277' AND id_document != '80546' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-26') 09/02/2023 09:55:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '277', document_date = '2023-01-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.90', price_tax_excluded = '64.04', date_upd = NOW() WHERE id_document = '80546' 09/02/2023 09:55:12 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 = '80546' 09/02/2023 09:55:12 am >> DELETE FROM ps_document_detail WHERE id_document = '80546' 09/02/2023 09:55:12 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 ( '80546' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 09/02/2023 09:55:12 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 ( '80546' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '8.50' ) 09/02/2023 09:55:12 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 ( '80546' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.82' , '3.82' , '0' , '0' , '3.82' ) 09/02/2023 09:55:12 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 ( '80546' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 09/02/2023 09:55:12 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 ( '80546' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '159' , '-159' , '4' , '0.02' , '0.02' , '0' , '0' , '3.18' ) 09/02/2023 09:57:17 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 ( '31' , '13' , '2023-02-07' , '' , '2765' , '0' , '11512' , 'C.SO UMBERTO I , 70 80034 MARIGLIANO' , '' , '' , '0.06' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '128.40' , '128.40' , NOW() , NOW() ) 09/02/2023 09:57:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81283' 09/02/2023 09:57:17 am >> DELETE FROM ps_document_detail WHERE id_document = '81283' 09/02/2023 09:57:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81283' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '4960' , '4960' , '4' , '0.0345' , '0.0345' , '0' , '25' , '128.3400' ) 09/02/2023 10:41:34 am >> SELECT document_num FROM ps_document WHERE document_num = '456' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 10:41: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' , '456' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 09/02/2023 10:41: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 = '81284' 09/02/2023 10:41:34 am >> DELETE FROM ps_document_detail WHERE id_document = '81284' 09/02/2023 10:41: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 ( '81284' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 09/02/2023 11:03:18 am >> DELETE FROM ps_document WHERE id_document = '81273' 09/02/2023 11:03:18 am >> DELETE FROM ps_document_detail WHERE id_document = '81273' 09/02/2023 11:12:00 am >> SELECT document_num FROM ps_document WHERE document_num = '457' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 11:12:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '457' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 09/02/2023 11:12:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81285' 09/02/2023 11:12:00 am >> DELETE FROM ps_document_detail WHERE id_document = '81285' 09/02/2023 11:12:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81285' , '16056' , 'CROCE TRINITA - G451' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 09/02/2023 11:14:09 am >> SELECT document_num FROM ps_document WHERE document_num = '458' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 11:14:09 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' , '458' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '50.00' , NOW() , NOW() ) 09/02/2023 11:14:09 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 = '81286' 09/02/2023 11:14:09 am >> DELETE FROM ps_document_detail WHERE id_document = '81286' 09/02/2023 11:14:09 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 ( '81286' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 09/02/2023 11:14:09 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 ( '81286' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 09/02/2023 11:14:09 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 ( '81286' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '-1' , '4' , '14.80' , '14.8' , '0' , '5' , '14.06' ) 09/02/2023 11:14:09 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 ( '81286' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11.24' , '11.24' , '0' , '0' , '11.24' ) 09/02/2023 11:15:19 am >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '78795' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 09/02/2023 11:15:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2023-01-12', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', address2 = '', note = 'ACCONTO € 50,00', 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 = '132.62', price_tax_excluded = '132.62', date_upd = NOW() WHERE id_document = '78795' 09/02/2023 11:15:19 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 = '78795' 09/02/2023 11:15:19 am >> DELETE FROM ps_document_detail WHERE id_document = '78795' 09/02/2023 11:15:19 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 ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '2' , '-2' , '4' , '14.8000' , '14.8' , '0' , '5' , '28.12' ) 09/02/2023 11:15:19 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 ( '78795' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 09/02/2023 11:15:19 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 ( '78795' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 09/02/2023 11:15:19 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 ( '78795' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 09/02/2023 11:15:19 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 ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' , '-4' , '4' , '13.00' , '13' , '0' , '5' , '49.40' ) 09/02/2023 11:15:36 am >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '78795' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 09/02/2023 11:15:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2023-01-12', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '132.62', price_tax_excluded = '132.62', date_upd = NOW() WHERE id_document = '78795' 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78795' 09/02/2023 11:15:36 am >> DELETE FROM ps_document_detail WHERE id_document = '78795' 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '2' , '-2' , '4' , '14.8000' , '14.8' , '0' , '5' , '28.12' ) 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 09/02/2023 11:15:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' , '-4' , '4' , '13.0000' , '13' , '0' , '5' , '49.40' ) 09/02/2023 11:16:24 am >> SELECT document_num FROM ps_document WHERE document_num = '458' AND id_document != '81286' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 11:16:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '458', document_date = '2023-02-09', 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 = '50.00', price_tax_excluded = '50.00', date_upd = NOW() WHERE id_document = '81286' 09/02/2023 11:16:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81286' 09/02/2023 11:16:24 am >> DELETE FROM ps_document_detail WHERE id_document = '81286' 09/02/2023 11:16: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 ( '81286' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 09/02/2023 11:16: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 ( '81286' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 09/02/2023 11:16: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 ( '81286' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '-1' , '4' , '14.8000' , '14.8' , '0' , '5' , '14.06' ) 09/02/2023 11:16: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 ( '81286' , '20464' , 'TI RACCONTO IL VANGELO MATTEO - PAPA FRANCESCO' , '1' , '-1' , '4' , '11.24' , '11.24' , '0' , '0' , '11.24' ) 09/02/2023 11:17:31 am >> SELECT document_num FROM ps_document WHERE document_num = '258' AND id_document != '80512' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 09/02/2023 11:17:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '258', document_date = '2023-01-24', 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 = '2.70', price_tax_excluded = '2.21', date_upd = NOW() WHERE id_document = '80512' 09/02/2023 11:17:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80512' 09/02/2023 11:17:31 am >> DELETE FROM ps_document_detail WHERE id_document = '80512' 09/02/2023 11:17:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80512' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 09/02/2023 11:17:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80512' , '7942' , 'PERGAMENE - OCCASIONI MOD. B' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 09/02/2023 11:17:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80512' , '16056' , 'CROCE TRINITA - G451' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 09/02/2023 11:35:40 am >> SELECT document_num FROM ps_document WHERE document_num = '459' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 11:35:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '459' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '270.00' , '221.31' , NOW() , NOW() ) 09/02/2023 11:35:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81287' 09/02/2023 11:35:40 am >> DELETE FROM ps_document_detail WHERE id_document = '81287' 09/02/2023 11:35:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81287' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 09/02/2023 11:47:26 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '13092' 09/02/2023 11:47:26 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '13092' 09/02/2023 11:58:09 am >> SELECT document_num FROM ps_document WHERE document_num = '460' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 11:58:09 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' , '460' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '52.88' , NOW() , NOW() ) 09/02/2023 11:58:09 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 = '81288' 09/02/2023 11:58:09 am >> DELETE FROM ps_document_detail WHERE id_document = '81288' 09/02/2023 11:58:09 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 ( '81288' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 09/02/2023 11:58:09 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 ( '81288' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 09/02/2023 12:13:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 12:13:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '461' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 09/02/2023 12:13:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81289' 09/02/2023 12:13:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '81289' 09/02/2023 12:13:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81289' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 09/02/2023 12:17:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '462' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 12:17:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '462' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 09/02/2023 12:17:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81290' 09/02/2023 12:17:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '81290' 09/02/2023 12:17: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 ( '81290' , '8433' , 'PRESENZA VIVA DI SANTA RITA - M. PATRIZI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 09/02/2023 12:22:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '463' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 12:22:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '463' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '74.00' , '60.66' , NOW() , NOW() ) 09/02/2023 12:22:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81291' 09/02/2023 12:22:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '81291' 09/02/2023 12:22:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81291' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '74' , '60.655737704918' , '22' , '0' , '74.00' ) 09/02/2023 12:33:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '463' AND id_document != '81291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 12:33:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '463', document_date = '2023-02-09', 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 = '74.00', price_tax_excluded = '60.66', date_upd = NOW() WHERE id_document = '81291' 09/02/2023 12:33:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81291' 09/02/2023 12:33:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '81291' 09/02/2023 12:33:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81291' , '13642' , 'PIATTINO 1006/15' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 09/02/2023 12:33:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81291' , '15389' , 'AMPOLLA 728' , '1' , '-1' , '1' , '44' , '36.065573770492' , '22' , '0' , '44.00' ) 09/02/2023 02:52:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '177' AND id_document != '79370' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-17') 09/02/2023 02:52:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '177', document_date = '2023-01-17', 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 = '50.80', price_tax_excluded = '47.30', date_upd = NOW() WHERE id_document = '79370' 09/02/2023 02:52:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79370' 09/02/2023 02:52:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '79370' 09/02/2023 02:52:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '20620' , 'OMELIE DI PENTLING' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 09/02/2023 02:52:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 09/02/2023 02:52:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q 1010-OX' , '1' , '-1' , '1' , '16.9000' , '13.852459016393' , '22' , '0' , '16.90' ) 09/02/2023 02:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 09/02/2023 02:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '18942' , 'DI DOMENICA, UNA PAROLA - ANNO C - E. ABBATTISTA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 09/02/2023 02:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79370' , '18043' , 'MESSA INCONTRO CON IL RISORTO - A. ZIRONI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 09/02/2023 02:55:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '184' AND id_document != '79379' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-18') 09/02/2023 02:55:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '184', document_date = '2023-01-18', 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 = '45.00', price_tax_excluded = '45.00', date_upd = NOW() WHERE id_document = '79379' 09/02/2023 02:55: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 = '79379' 09/02/2023 02:55:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '79379' 09/02/2023 02:55:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79379' , '17333' , 'PENTATEUCO' , '1' , '-1' , '4' , '25' , '25' , '0' , '0' , '25.00' ) 09/02/2023 02:55:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79379' , '16043' , 'MATTEO - NUOVA TRADUZIONE' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 09/02/2023 03:16:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '237' AND id_document != '80483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 09/02/2023 03:16:02 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '237', document_date = '2023-01-24', 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 = '44.50', price_tax_excluded = '43.15', date_upd = NOW() WHERE id_document = '80483' 09/02/2023 03:16:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80483' 09/02/2023 03:16:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '80483' 09/02/2023 03:16: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 ( '80483' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 09/02/2023 03:16: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 ( '80483' , '15827' , 'ASCOLTARE E CURARE IL CUORE - M. SEMERARO' , '1' , '-1' , '4' , '9.5' , '9.5' , '0' , '0' , '9.50' ) 09/02/2023 03:16:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '327' AND id_document != '80601' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 09/02/2023 03:16:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '327', document_date = '2023-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '80601' 09/02/2023 03:16:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80601' 09/02/2023 03:16:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '80601' 09/02/2023 03:16:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80601' , '14077' , 'CHIESA IN USCITA DI PAPA FRANCESCO - L. GEROSA' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 09/02/2023 03:17:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '359' AND id_document != '81154' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-01') 09/02/2023 03:17:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '359', document_date = '2023-02-01', 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 = '19.40', price_tax_excluded = '19.40', date_upd = NOW() WHERE id_document = '81154' 09/02/2023 03:17: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 = '81154' 09/02/2023 03:17:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '81154' 09/02/2023 03:17: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 ( '81154' , '17009' , 'SFIDE DEL GOVERNO PASTORALE - F. CASAZZA' , '1' , '-1' , '4' , '19.4' , '19.4' , '0' , '0' , '19.40' ) 09/02/2023 03:18:27 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '15436' 09/02/2023 03:18:27 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '15436' 09/02/2023 03:20:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '190' AND id_document != '79905' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-19') 09/02/2023 03:20:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '190', document_date = '2023-01-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.90', price_tax_excluded = '6.90', date_upd = NOW() WHERE id_document = '79905' 09/02/2023 03:20:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79905' 09/02/2023 03:20:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '79905' 09/02/2023 03:20:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79905' , '12176' , 'DONNA E MADRE IN CAMMINO CON NOI - M. MAZZEO' , '1' , '-1' , '4' , '6.9' , '6.9' , '0' , '0' , '6.90' ) 09/02/2023 03:28:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '80462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 09/02/2023 03:28:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '223', document_date = '2023-01-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '117.00', price_tax_excluded = '117.00', date_upd = NOW() WHERE id_document = '80462' 09/02/2023 03:28:23 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 = '80462' 09/02/2023 03:28:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '80462' 09/02/2023 03:28:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '63.8' , '63.8' , '0' , '0' , '63.80' ) 09/02/2023 03:28:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '12590' , 'VANGELO DI GIOVANNI - S. FAUSTI' , '1' , '-1' , '4' , '44.00' , '44' , '0' , '5' , '41.80' ) 09/02/2023 03:28:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '12921' , 'BARTOLO LONGO DAL SALENTO A POMPEI - A. ILLIBATO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 09/02/2023 03:28:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '187' AND id_document != '79897' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-18') 09/02/2023 03:28:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '187', document_date = '2023-01-18', 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 = '6.00', price_tax_excluded = '6.00', date_upd = NOW() WHERE id_document = '79897' 09/02/2023 03:28:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '79897' 09/02/2023 03:28:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '79897' 09/02/2023 03:28:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '79897' , '16300' , 'MARIA MADRE DELLA CHIESA - M.E. PATRIZI' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 09/02/2023 03:30:11 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '9477' 09/02/2023 03:30:11 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '9477' 09/02/2023 03:30:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '80462' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-21') 09/02/2023 03:30:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '223', document_date = '2023-01-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '117.00', price_tax_excluded = '117.00', date_upd = NOW() WHERE id_document = '80462' 09/02/2023 03:30:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80462' 09/02/2023 03:30:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '80462' 09/02/2023 03:30:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '40.05' , '40.05' , '0' , '0' , '40.05' ) 09/02/2023 03:30:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '12590' , 'VANGELO DI GIOVANNI - S. FAUSTI' , '1' , '-1' , '4' , '44.0000' , '44' , '0' , '5' , '41.80' ) 09/02/2023 03:30:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '12921' , 'BARTOLO LONGO DAL SALENTO A POMPEI - A. ILLIBATO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 09/02/2023 03:30:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80462' , '15308' , 'CHI E PAOLO - G. LAJOLO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 09/02/2023 03:41:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 03:41:39 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' , '29' , '2023-02-09' , '' , '3536' , '0' , '4673201' , 'VIA SANT\\\'ANNA 4 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '21.28' , '21.28' , NOW() , NOW() ) 09/02/2023 03:41:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81292' 09/02/2023 03:41:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81292' 09/02/2023 03:41:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81292' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '14' , '-14' , '4' , '1.60' , '1.6' , '0' , '5' , '21.28' ) 09/02/2023 03:44:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '464' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 03:44:40 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' , '464' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 09/02/2023 03:44:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81293' 09/02/2023 03:44:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '81293' 09/02/2023 03:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81293' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 09/02/2023 03:50:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '465' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 03:50: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' , '465' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.30' , '20.81' , NOW() , NOW() ) 09/02/2023 03:50: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 = '81294' 09/02/2023 03:50:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '81294' 09/02/2023 03:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81294' , '11363' , 'VICINO A GESÙ... PER SERVIRLO! - M. CHIESA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 09/02/2023 03:50:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81294' , '20706' , 'ANGELO PENDENTE - AM' , '1' , '-1' , '1' , '13.80' , '11.311475409836' , '22' , '0' , '13.80' ) 09/02/2023 03:55:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '466' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 03:55:39 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' , '466' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.90' , NOW() , NOW() ) 09/02/2023 03:55:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81295' 09/02/2023 03:55:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81295' 09/02/2023 03:55:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81295' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 09/02/2023 03:58:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '466' AND id_document != '81295' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 03:58:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '466', document_date = '2023-02-09', 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 = '2.90', price_tax_excluded = '2.90', date_upd = NOW() WHERE id_document = '81295' 09/02/2023 03:58:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81295' 09/02/2023 03:58:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '81295' 09/02/2023 03:58:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81295' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 09/02/2023 04:24:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '467' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:24:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '467' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 09/02/2023 04:24:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81296' 09/02/2023 04:24:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81296' 09/02/2023 04:24:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81296' , '13392' , 'STATUETTA BOTTIGLIA LOURDES' , '50' , '-50' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '45.00' ) 09/02/2023 04:32:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:32: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 ( '24' , '21/A' , '2023-02-09' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , 'OSP. S. LEONARDO' , 'OSP. S. LEONARDO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.80' , '31.80' , NOW() , NOW() ) 09/02/2023 04:32: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 = '81297' 09/02/2023 04:32:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '81297' 09/02/2023 04:32: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 ( '81297' , '20071' , 'ROSARIO MISSIONARIO MM8' , '24' , '-24' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '28.80' ) 09/02/2023 04:32: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 ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 09/02/2023 04:33:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '468' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:33:58 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' , '468' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.80' , '32.98' , NOW() , NOW() ) 09/02/2023 04:33: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 = '81298' 09/02/2023 04:33:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81298' 09/02/2023 04:33: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 ( '81298' , '20071' , 'ROSARIO MISSIONARIO MM8' , '24' , '-24' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '28.80' ) 09/02/2023 04:33: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 ( '81298' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '9.00' ) 09/02/2023 04:33: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 ( '81298' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 09/02/2023 04:34:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '21/A' AND id_document != '81297' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:34:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '21/A', document_date = '2023-02-09', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'OSP. S. LEONARDO', note = 'OSP. S. LEONARDO', 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 = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '81297' 09/02/2023 04:34: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 = '81297' 09/02/2023 04:34:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81297' 09/02/2023 04:34: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 ( '81297' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 09/02/2023 04:37:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '469' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:37:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '469' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.21' , '6.58' , NOW() , NOW() ) 09/02/2023 04:37:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81299' 09/02/2023 04:37:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '81299' 09/02/2023 04:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81299' , '6074' , 'MADONNA DI LOURDES - 120' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 09/02/2023 04:37:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81299' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 09/02/2023 04:38:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '470' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:38:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '470' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.80' , '1.80' , NOW() , NOW() ) 09/02/2023 04:38:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81300' 09/02/2023 04:38:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '81300' 09/02/2023 04:38:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81300' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 09/02/2023 04:48:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '811/23' , '2023-02-09' , '23' , '0' , '125' , '4669745' , 'VIA SIBELLUCCIA, AREA P.I.P. 84088 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 09/02/2023 04:48: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 = '81301' 09/02/2023 04:48:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '81301' 09/02/2023 04:48:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81301' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - PADRE G. VALSECCHI' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 09/02/2023 04:48:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20652' AND id_supplier = '125' 09/02/2023 04:48:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20652' , '125' , '1' ) 09/02/2023 04:48:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81301' , '20722' , 'SEMINATORI DI GIOIA' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 09/02/2023 04:48:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20722' AND id_supplier = '125' 09/02/2023 04:48:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20722' , '125' , '1' ) 09/02/2023 04:48:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81301' , '20719' , 'CORONA DELL’ADDOLORATA' , '3000' , '3000' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 09/02/2023 04:48:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20719' AND id_supplier = '125' 09/02/2023 04:48:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20719' , '125' , '1' ) 09/02/2023 04:55:48 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'OaatAsskfEyHGuHH' , NOW() , NOW() ) 09/02/2023 04:55:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7031' , '1' ) 09/02/2023 04:55:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7031' , '2' ) 09/02/2023 04:55:48 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7031' , '3' ) 09/02/2023 04:56:48 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7031' 09/02/2023 04:56:48 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7031' , '10' , '210' , '' , 'RESTAINO' , 'MATTEO' , 'VIA DELLA RESISTENZA 83/S' , '' , '84018' , 'SCAFATI' , '' , '3349095999' , '' , '' , '' , NOW() , NOW() ) 09/02/2023 04:56:48 pm >> UPDATE ps_customer SET email = 'matteorestaino51@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7031' 09/02/2023 04:57:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 04:57:57 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' , '5' , '2023-02-09' , '' , '7031' , '0' , '112017948' , 'VIA DELLA RESISTENZA 83/S 84018 SCAFATI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 09/02/2023 04:57:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9515' 09/02/2023 04:57:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '9515' 09/02/2023 04:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9515' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '15' , '15.30' ) 09/02/2023 04:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9515' , '' , 'SPESE DI SPEDIZIONE ' , '1' , '-1' , '4' , '3.7' , '3.7' , '0' , '0' , '3.70' ) 09/02/2023 05:01:53 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7031' 09/02/2023 05:01:53 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 ( '7031' , '10' , '210' , '' , 'RESTAINO' , 'MATTEO' , 'VIA DELLA RESISTENZA 83/S' , '' , '84018' , 'SCAFATI' , '' , '' , '3349095999' , '' , '' , NOW() , NOW() ) 09/02/2023 05:01:53 pm >> UPDATE ps_customer SET email = 'matteorestaino51@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7031' 09/02/2023 05:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '471' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 05:31:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '471' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 09/02/2023 05:31:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81302' 09/02/2023 05:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '81302' 09/02/2023 05:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81302' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 09/02/2023 05:31:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '472' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 05:31:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '472' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 09/02/2023 05:31:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81303' 09/02/2023 05:31:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '81303' 09/02/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81303' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 09/02/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81303' , '15276' , 'SCOLLINARE O SRADICARE - VIA CRUCIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 09/02/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81303' , '20710' , 'VIA CRUCIS DELLA PACE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 09/02/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81303' , '20711' , 'VIA CRUCIS IN CAMMINO CON LA CHIESA ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 09/02/2023 05:31:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '473' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-09') 09/02/2023 05:31:57 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' , '473' , '2023-02-09' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.85' , '2.85' , NOW() , NOW() ) 09/02/2023 05:31:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81304' 09/02/2023 05:31:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '81304' 09/02/2023 05:31:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81304' , '19304' , 'VIA CRUCIS - 8076' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' )