30/11/2022 08:20:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3381' AND id_document != '71467' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-09') 30/11/2022 08:20:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3381', document_date = '2022-11-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 = '25.00', price_tax_excluded = '25.00', date_upd = NOW() WHERE id_document = '71467' 30/11/2022 08:20:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '71467' 30/11/2022 08:20:58 am >> DELETE FROM ps_document_detail WHERE id_document = '71467' 30/11/2022 08:20:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '71467' , '19271' , 'SIGNORE MI CONDUSSE - G. SALONIA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 30/11/2022 08:20:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19271' AND id_supplier = '' 30/11/2022 08:20:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19271' , '' , '1' ) 30/11/2022 08:20: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 ( '71467' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.70' , '3.7' , '0' , '' , '3.70' ) 30/11/2022 08:20:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 30/11/2022 08:20:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 30/11/2022 08:20: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 ( '71467' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 30/11/2022 08:20:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 30/11/2022 08:20:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 30/11/2022 08:21:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3422' AND id_document != '72037' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-11') 30/11/2022 08:21:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3422', document_date = '2022-11-11', 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 = '121.80', price_tax_excluded = '105.42', date_upd = NOW() WHERE id_document = '72037' 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '72037' 30/11/2022 08:21:46 am >> DELETE FROM ps_document_detail WHERE id_document = '72037' 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72037' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 30/11/2022 08:21:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 30/11/2022 08:21:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72037' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '3.80' ) 30/11/2022 08:21:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/11/2022 08:21:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72037' , '20313' , 'TERRA DI DIO - M.S. MOSTAJO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '' , '14.00' ) 30/11/2022 08:21:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20313' AND id_supplier = '' 30/11/2022 08:21:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20313' , '' , '1' ) 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72037' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 30/11/2022 08:21:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20275' AND id_supplier = '' 30/11/2022 08:21:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20275' , '' , '1' ) 30/11/2022 08:21:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '72037' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '2' , '-2' , '4' , '4.75' , '4.75' , '0' , '0' , '9.50' ) 30/11/2022 08:21:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 30/11/2022 08:21:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 30/11/2022 08:22:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3497' AND id_document != '73178' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-18') 30/11/2022 08:22:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3497', document_date = '2022-11-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 = '8.40', price_tax_excluded = '8.40', date_upd = NOW() WHERE id_document = '73178' 30/11/2022 08:22:48 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 = '73178' 30/11/2022 08:22:49 am >> DELETE FROM ps_document_detail WHERE id_document = '73178' 30/11/2022 08:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '40' , '-40' , '4' , '0.0300' , '0.03' , '0' , '0' , '1.20' ) 30/11/2022 08:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 30/11/2022 08:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 30/11/2022 08:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.45' , '2.45' , '0' , '0' , '2.45' ) 30/11/2022 08:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 30/11/2022 08:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 30/11/2022 08:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '73178' , '20054' , 'MESSALINO QUOTIDIANO - NOV/DIC/GEN 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2022 08:22:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '20054' AND id_supplier = '' 30/11/2022 08:22:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20054' , '' , '1' ) 30/11/2022 08:26:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2030' AND id_document != '58883' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 30/11/2022 08:26:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2030', document_date = '2022-06-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 = '220.00', price_tax_excluded = '180.82', date_upd = NOW() WHERE id_document = '58883' 30/11/2022 08:26:48 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 = '58883' 30/11/2022 08:26:48 am >> DELETE FROM ps_document_detail WHERE id_document = '58883' 30/11/2022 08:26:48 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 ( '58883' , '4195' , 'FINTA CANDELA 8X30 - 180' , '2' , '-2' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '46.00' ) 30/11/2022 08:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '4195' AND id_supplier = '' 30/11/2022 08:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4195' , '' , '1' ) 30/11/2022 08:26:48 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 ( '58883' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 08:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58883' , '14021' , 'CINGOLO' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '14021' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14021' , '' , '1' ) 30/11/2022 08:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58883' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '30' , '24.590163934426' , '22' , '0' , '60.00' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '' , '1' ) 30/11/2022 08:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58883' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19397' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19397' , '' , '1' ) 30/11/2022 08:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58883' , '2266' , 'CLERGY GRIGIO CHIARO ML - COTONE 41 ' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2266' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2266' , '' , '1' ) 30/11/2022 08:26:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58883' , '2151' , 'CLERGY BLU MM - COTONE 41 ' , '1' , '-1' , '1' , '20.5' , '16.803278688525' , '22' , '0' , '20.50' ) 30/11/2022 08:26:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '2151' AND id_supplier = '' 30/11/2022 08:26:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2151' , '' , '1' ) 30/11/2022 08:28:12 am >> SELECT document_num FROM ps_document WHERE document_num = '2115' AND id_document != '58982' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/11/2022 08:28:12 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2115', document_date = '2022-06-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '410.00', price_tax_excluded = '336.07', date_upd = NOW() WHERE id_document = '58982' 30/11/2022 08:28: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 = '58982' 30/11/2022 08:28:12 am >> DELETE FROM ps_document_detail WHERE id_document = '58982' 30/11/2022 08:28: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 ( '58982' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 30/11/2022 08:28:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '' 30/11/2022 08:28:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' ) 30/11/2022 08:28: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 ( '58982' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '162' , '132.7868852459' , '22' , '0' , '162.00' ) 30/11/2022 08:28:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/11/2022 08:28:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/11/2022 08:28: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 ( '58982' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '108.00' ) 30/11/2022 08:28:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 30/11/2022 08:28:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 30/11/2022 08:28:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3540' AND id_document != '74268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-21') 30/11/2022 08:28:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3540', document_date = '2022-11-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '349.00', price_tax_excluded = '293.01', date_upd = NOW() WHERE id_document = '74268' 30/11/2022 08:28:48 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 = '74268' 30/11/2022 08:28:48 am >> DELETE FROM ps_document_detail WHERE id_document = '74268' 30/11/2022 08:28:48 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 ( '74268' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 30/11/2022 08:28:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 30/11/2022 08:28:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 30/11/2022 08:28:48 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 ( '74268' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/11/2022 08:28:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 08:28:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 08:28:48 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 ( '74268' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/11/2022 08:28:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/11/2022 08:28:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/11/2022 08:28:48 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 ( '74268' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 30/11/2022 08:28:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 30/11/2022 08:28:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 30/11/2022 08:28:48 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 ( '74268' , '20048' , 'AGENDA MISSIONARIA 2023' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 30/11/2022 08:28:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20048' AND id_supplier = '' 30/11/2022 08:28:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20048' , '' , '1' ) 30/11/2022 08:29:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3602' AND id_document != '41898' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2021-11-08') 30/11/2022 08:29:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3602', document_date = '2021-11-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '181.00', price_tax_excluded = '154.60', date_upd = NOW() WHERE id_document = '41898' 30/11/2022 08:29: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 = '41898' 30/11/2022 08:29:41 am >> DELETE FROM ps_document_detail WHERE id_document = '41898' 30/11/2022 08:29: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 ( '41898' , '18795' , 'VESTE CHIERICHETTO + COTTA' , '1' , '-1' , '1' , '87.0000' , '71.311475409836' , '22' , '0' , '87.00' ) 30/11/2022 08:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18795' AND id_supplier = '' 30/11/2022 08:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18795' , '' , '1' ) 30/11/2022 08:29: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 ( '41898' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '15.00' ) 30/11/2022 08:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/11/2022 08:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/11/2022 08:29: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 ( '41898' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 30/11/2022 08:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/11/2022 08:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/11/2022 08:29: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 ( '41898' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '39.00' ) 30/11/2022 08:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/11/2022 08:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/11/2022 08:29: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 ( '41898' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '2.9' , '2.7884615384615' , '4' , '0' , '29.00' ) 30/11/2022 08:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 08:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 08:30:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3544' AND id_document != '74276' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-22') 30/11/2022 08:30:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3544', document_date = '2022-11-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '251.90', price_tax_excluded = '216.19', date_upd = NOW() WHERE id_document = '74276' 30/11/2022 08:30:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '74276' 30/11/2022 08:30:35 am >> DELETE FROM ps_document_detail WHERE id_document = '74276' 30/11/2022 08:30:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '8197' , 'PORTATECA - 059' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 30/11/2022 08:30:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '8197' AND id_supplier = '' 30/11/2022 08:30:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8197' , '' , '1' ) 30/11/2022 08:30:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '28.0000' , '22.950819672131' , '22' , '' , '28.00' ) 30/11/2022 08:30:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '18045' AND id_supplier = '' 30/11/2022 08:30:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18045' , '' , '1' ) 30/11/2022 08:30:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '74276' , '11154' , 'VASETTO BASSO CON ANELLO - 820' , '1' , '-1' , '1' , '17.0000' , '13.934426229508' , '22' , '0' , '17.00' ) 30/11/2022 08:30:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '11154' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11154' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '17.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '5.70' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.0400' , '0.04' , '0' , '0' , '38.40' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '11858' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11858' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '17520' , 'LUMINO SMERALDO' , '30' , '-30' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '12.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '17520' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17520' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '2436' , 'COLORANTE PER CERA LIQUIDA - 1002' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '2436' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2436' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '13079' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13079' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '6011' , 'LUMINELLO VETRO - 474/25' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '6011' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6011' , '' , '1' ) 30/11/2022 08:30: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 ( '74276' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '90' , '-90' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '27.00' ) 30/11/2022 08:30:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '18620' AND id_supplier = '' 30/11/2022 08:30:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18620' , '' , '1' ) 30/11/2022 09:24:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3669' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 09:24: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 ( '11' , '3669' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.10' , '5.00' , NOW() , NOW() ) 30/11/2022 09:24: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 = '75464' 30/11/2022 09:24:17 am >> DELETE FROM ps_document_detail WHERE id_document = '75464' 30/11/2022 09:24: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 ( '75464' , '14835' , 'STELLA COMETA - P581' , '1' , '-1' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '2.40' ) 30/11/2022 09:24:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '14835' AND id_supplier = '' 30/11/2022 09:24:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14835' , '' , '1' ) 30/11/2022 09:24: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 ( '75464' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/11/2022 09:24:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '' 30/11/2022 09:24:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '' , '1' ) 30/11/2022 09:24: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 ( '75464' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.4' , '1.9672131147541' , '22' , '0' , '2.40' ) 30/11/2022 09:24:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/11/2022 09:24:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/11/2022 09:46:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 09:46: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' , '3670' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '17.21' , NOW() , NOW() ) 30/11/2022 09:46: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 = '75465' 30/11/2022 09:46:09 am >> DELETE FROM ps_document_detail WHERE id_document = '75465' 30/11/2022 09:46: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 ( '75465' , '6403' , 'MENSA BIANCA 80X150 ' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 30/11/2022 09:46:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '6403' AND id_supplier = '' 30/11/2022 09:46:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6403' , '' , '1' ) 30/11/2022 09:46:10 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 ( '75465' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 30/11/2022 09:46:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '1912' AND id_supplier = '' 30/11/2022 09:46:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1912' , '' , '1' ) 30/11/2022 10:14:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 10:14:42 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' , '3671' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.40' , '87.10' , NOW() , NOW() ) 30/11/2022 10:14:42 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 = '75466' 30/11/2022 10:14:42 am >> DELETE FROM ps_document_detail WHERE id_document = '75466' 30/11/2022 10:14:42 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 ( '75466' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/11/2022 10:14:42 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 ( '75466' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 30/11/2022 10:14:42 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 ( '75466' , '20199' , 'PAROLA DI DIO OGNI GIORNO 2023 - V. PAGLIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '20199' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20199' , '' , '1' ) 30/11/2022 10:14:42 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 ( '75466' , '14640' , 'ECCOMI TI ASCOLTO! - ANNO C - G. CALABRESE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '14640' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14640' , '' , '1' ) 30/11/2022 10:14:42 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 ( '75466' , '13002' , 'ECCOMI TI ASCOLTO! - ANNO B - G. CALABRESE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '13002' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13002' , '' , '1' ) 30/11/2022 10:14:42 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 ( '75466' , '4379' , 'GESÙ BAMBINO - 91 - OGGETTI' , '100' , '-100' , '1' , '0.11' , '0.09016393442623' , '22' , '0' , '11.00' ) 30/11/2022 10:14:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '4379' AND id_supplier = '' 30/11/2022 10:14:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4379' , '' , '1' ) 30/11/2022 10:23:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 10:23:07 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' , '3672' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 30/11/2022 10:23:07 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 = '75467' 30/11/2022 10:23:07 am >> DELETE FROM ps_document_detail WHERE id_document = '75467' 30/11/2022 10:23:07 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 ( '75467' , '20004' , 'GESU BAMBINO CM 20 - BJ142-20E' , '2' , '-2' , '1' , '20' , '16.393442622951' , '22' , '0' , '40.00' ) 30/11/2022 10:23:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '20004' AND id_supplier = '' 30/11/2022 10:23:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20004' , '' , '1' ) 30/11/2022 10:23:07 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 ( '75467' , '15002' , 'GESU BAMBINO CM 20 - 27598' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 30/11/2022 10:23:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '15002' AND id_supplier = '' 30/11/2022 10:23:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15002' , '' , '1' ) 30/11/2022 10:36:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 10:36:54 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' , '3673' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.82' , '18.82' , NOW() , NOW() ) 30/11/2022 10:36:54 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 = '75468' 30/11/2022 10:36:54 am >> DELETE FROM ps_document_detail WHERE id_document = '75468' 30/11/2022 10:36: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 ( '75468' , '1090' , 'BIBBIA' , '2' , '-2' , '4' , '9.90' , '9.9' , '0' , '5' , '18.82' ) 30/11/2022 10:36:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '1090' AND id_supplier = '' 30/11/2022 10:36:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1090' , '' , '1' ) 30/11/2022 10:51:54 am >> SELECT document_num FROM ps_document WHERE document_num = '3674' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 10:51:54 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' , '3674' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 30/11/2022 10:51:54 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 = '75469' 30/11/2022 10:51:54 am >> DELETE FROM ps_document_detail WHERE id_document = '75469' 30/11/2022 10:51: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 ( '75469' , '20400' , 'ANGELO CUSTODE DI SAN FRANCESCO - R. CANTALAMESSA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 30/11/2022 10:51:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '20400' AND id_supplier = '' 30/11/2022 10:51:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20400' , '' , '1' ) 30/11/2022 10:55:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 10:55:48 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' , '3675' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.70' , '121.51' , NOW() , NOW() ) 30/11/2022 10:55:48 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 = '75470' 30/11/2022 10:55:48 am >> DELETE FROM ps_document_detail WHERE id_document = '75470' 30/11/2022 10:55:48 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 ( '75470' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '5.70' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/11/2022 10:55:48 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 ( '75470' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '16.00' ) 30/11/2022 10:55:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/11/2022 10:55:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/11/2022 11:05:39 am >> SELECT document_num FROM ps_document WHERE document_num = '317' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:05:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '317' , '2022-11-30' , '' , '1083' , '0' , '4674059' , 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '199.33' , '199.33' , NOW() , NOW() ) 30/11/2022 11:05:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75471' 30/11/2022 11:05:39 am >> DELETE FROM ps_document_detail WHERE id_document = '75471' 30/11/2022 11:05: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 ( '75471' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 30/11/2022 11:05: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 ( '75471' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 30/11/2022 11:05: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 ( '75471' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 30/11/2022 11:05: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 ( '75471' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.50' , '3.5' , '0' , '15' , '50.58' ) 30/11/2022 11:05: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 ( '75471' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 30/11/2022 11:05: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 ( '75471' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 30/11/2022 11:08:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:08:19 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' , '3676' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.19' , '70.57' , NOW() , NOW() ) 30/11/2022 11:08: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 = '75472' 30/11/2022 11:08:19 am >> DELETE FROM ps_document_detail WHERE id_document = '75472' 30/11/2022 11:08: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 ( '75472' , '12819' , 'REGISTRO DEL CATECHISTA ' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '9.00' ) 30/11/2022 11:08:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 30/11/2022 11:08:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '6901' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 30/11/2022 11:08:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '6901' AND id_supplier = '' 30/11/2022 11:08:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6901' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '19760' , 'RAGAZZI CHE SQUADRA - 3' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 30/11/2022 11:08:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19760' AND id_supplier = '' 30/11/2022 11:08:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19760' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 30/11/2022 11:08:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17230' AND id_supplier = '' 30/11/2022 11:08:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17230' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 30/11/2022 11:08:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '17325' AND id_supplier = '' 30/11/2022 11:08:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17325' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '17242' , 'SCOPRIAMO INSIEME LA COMUNIONE' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '17242' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17242' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '4168' , 'FIGLI DEL VENTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '4168' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4168' , '' , '1' ) 30/11/2022 11:08: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 ( '75472' , '20308' , 'ATTENDERE E SPERARE - PAPA FRANCESCO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/11/2022 11:08:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20308' AND id_supplier = '' 30/11/2022 11:08:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20308' , '' , '1' ) 30/11/2022 11:09:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:09:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3677' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 30/11/2022 11:09:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75473' 30/11/2022 11:09:37 am >> DELETE FROM ps_document_detail WHERE id_document = '75473' 30/11/2022 11:09: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 ( '75473' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 30/11/2022 11:09:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 30/11/2022 11:09:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 30/11/2022 11:43:34 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:43: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 ( '24' , '105/A' , '2022-11-30' , 'A' , '2054' , '0' , '4671710' , 'VIA S. GIOVANNI, 51 27029 VIGEVANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.50' , '56.15' , NOW() , NOW() ) 30/11/2022 11:43: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 = '75474' 30/11/2022 11:43:34 am >> DELETE FROM ps_document_detail WHERE id_document = '75474' 30/11/2022 11:43: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 ( '75474' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '17.50' ) 30/11/2022 11:43: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 ( '75474' , '16314' , 'BAMBINO CM 6' , '30' , '-30' , '1' , '1.70' , '1.3934426229508' , '22' , '0' , '51.00' ) 30/11/2022 11:45:25 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75474' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:45:25 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-11-30', document_letter = 'A', id_customer = '2054', id_supplier = '', id_address = '4671710', address1 = 'VIA S. GIOVANNI, 51 27029 VIGEVANO', address2 = '', note = 'IT06V0834289640012010000844', 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 = '68.50', price_tax_excluded = '56.15', date_upd = NOW() WHERE id_document = '75474' 30/11/2022 11:45: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 = '75474' 30/11/2022 11:45:25 am >> DELETE FROM ps_document_detail WHERE id_document = '75474' 30/11/2022 11:45: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 ( '75474' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '17.50' ) 30/11/2022 11:45:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '' 30/11/2022 11:45:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '' , '1' ) 30/11/2022 11:45: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 ( '75474' , '16314' , 'BAMBINO CM 6' , '30' , '-30' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '51.00' ) 30/11/2022 11:45:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '16314' AND id_supplier = '' 30/11/2022 11:45:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16314' , '' , '1' ) 30/11/2022 11:46:05 am >> DELETE FROM ps_document WHERE id_document = '75474' 30/11/2022 11:46:05 am >> DELETE FROM ps_document_detail WHERE id_document = '75474' 30/11/2022 11:50:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 11:50:48 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' , '3678' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '20.50' , NOW() , NOW() ) 30/11/2022 11:50:48 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 = '75475' 30/11/2022 11:50:48 am >> DELETE FROM ps_document_detail WHERE id_document = '75475' 30/11/2022 11:50:48 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 ( '75475' , '20217' , 'ASCOLTARE 2023 KIKO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 30/11/2022 11:50:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20217' AND id_supplier = '' 30/11/2022 11:50:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20217' , '' , '1' ) 30/11/2022 11:50:48 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 ( '75475' , '20087' , 'CALENDARIO GESU CONFIDO IN TE 2023 - 8081' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 30/11/2022 11:50:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20087' AND id_supplier = '' 30/11/2022 11:50:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20087' , '' , '1' ) 30/11/2022 11:50:48 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 ( '75475' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 30/11/2022 11:50:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 30/11/2022 11:50:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 30/11/2022 12:29:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3651' AND id_document != '75441' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-28') 30/11/2022 12:29:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3651', document_date = '2022-11-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '75441' 30/11/2022 12:29: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 = '75441' 30/11/2022 12:29:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '75441' 30/11/2022 12:29: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 ( '75441' , '19998' , 'GESU BAMBINO CM 20 - BJ142-28E' , '1' , '-1' , '1' , '34.0000' , '27.868852459016' , '22' , '0' , '34.00' ) 30/11/2022 12:29:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19998' AND id_supplier = '' 30/11/2022 12:29:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19998' , '' , '1' ) 30/11/2022 12:29: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 ( '75441' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '15.00' ) 30/11/2022 12:29:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '' 30/11/2022 12:29:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '' , '1' ) 30/11/2022 12:41:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3658' AND id_document != '75450' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-29') 30/11/2022 12:41:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3658', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.90', price_tax_excluded = '35.73', date_upd = NOW() WHERE id_document = '75450' 30/11/2022 12:41: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 = '75450' 30/11/2022 12:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '75450' 30/11/2022 12:41: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 ( '75450' , '19452' , 'LIBERI NELLA VERITA - M. DE MAIO' , '1' , '-1' , '4' , '32.0000' , '32' , '0' , '5' , '30.40' ) 30/11/2022 12:41:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19452' AND id_supplier = '' 30/11/2022 12:41:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19452' , '' , '1' ) 30/11/2022 12:41: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 ( '75450' , '19129' , 'BRUCIAINCENSO ALADINO - ALA' , '1' , '-1' , '1' , '5.5000' , '4.5081967213115' , '22' , '0' , '5.50' ) 30/11/2022 12:41:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19129' AND id_supplier = '' 30/11/2022 12:41:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19129' , '' , '1' ) 30/11/2022 12:41: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 ( '75450' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 30/11/2022 12:41:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17052' AND id_supplier = '' 30/11/2022 12:41:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17052' , '' , '1' ) 30/11/2022 12:41: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 ( '75450' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '2' , '-2' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.30' ) 30/11/2022 12:41:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 30/11/2022 12:41:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 30/11/2022 12:41:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3652' AND id_document != '75442' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-28') 30/11/2022 12:41:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3652', document_date = '2022-11-28', 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.30', price_tax_excluded = '18.12', date_upd = NOW() WHERE id_document = '75442' 30/11/2022 12:41:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75442' 30/11/2022 12:41:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '75442' 30/11/2022 12:41:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75442' , '20261' , 'GIOIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 30/11/2022 12:41:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20261' AND id_supplier = '' 30/11/2022 12:41:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20261' , '' , '1' ) 30/11/2022 12:41:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75442' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 30/11/2022 12:41:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18460' AND id_supplier = '' 30/11/2022 12:41:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18460' , '' , '1' ) 30/11/2022 12:41:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75442' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 30/11/2022 12:41:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '' 30/11/2022 12:41:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '' , '1' ) 30/11/2022 12:41:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75442' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '5' , '-5' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.00' ) 30/11/2022 12:41:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18618' AND id_supplier = '' 30/11/2022 12:41:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18618' , '' , '1' ) 30/11/2022 12:43:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '82/A' AND id_document != '68029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-21') 30/11/2022 12:43:08 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '82/A', document_date = '2022-10-21', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'CATECHESI', 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 = '529.76', price_tax_excluded = '523.21', date_upd = NOW() WHERE id_document = '68029' 30/11/2022 12:43: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 = '68029' 30/11/2022 12:43:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '68029' 30/11/2022 12:43: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 ( '68029' , '16307' , 'BRACCIALE IN GOMMA DECINA' , '29' , '-29' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '20.30' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16307' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16307' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '14.00' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '13005' , 'PASSAPORTO DEL CATECHISTA' , '25' , '-25' , '4' , '1.2000' , '1.2' , '0' , '5' , '28.50' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13005' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13005' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '40' , '-40' , '4' , '1.6000' , '1.6' , '0' , '15' , '54.40' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 30/11/2022 12:43:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 30/11/2022 12:43:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '2679' , 'CONOSCERE GESU\'' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 30/11/2022 12:43:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2679' AND id_supplier = '' 30/11/2022 12:43:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2679' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '31' , '-31' , '4' , '3.5000' , '3.5' , '0' , '15' , '92.23' ) 30/11/2022 12:43:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 30/11/2022 12:43:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.5000' , '3.5' , '0' , '15' , '89.25' ) 30/11/2022 12:43:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 30/11/2022 12:43:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 30/11/2022 12:43: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 ( '68029' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '32' , '-32' , '4' , '3.5000' , '3.5' , '0' , '15' , '95.20' ) 30/11/2022 12:43:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 30/11/2022 12:43:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 30/11/2022 01:02:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 01:02:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3679' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 30/11/2022 01:02:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75476' 30/11/2022 01:02:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '75476' 30/11/2022 01:02:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75476' , '15351' , 'PORTATECA - 928' , '1' , '-1' , '1' , '57' , '46.72131147541' , '22' , '0' , '57.00' ) 30/11/2022 01:02:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15351' AND id_supplier = '' 30/11/2022 01:02:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15351' , '' , '1' ) 30/11/2022 01:07:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 01:07: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 ( '11' , '3680' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 30/11/2022 01:07: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 = '75477' 30/11/2022 01:07:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '75477' 30/11/2022 01:07: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 ( '75477' , '17464' , 'NOVENA DELLIMMACOLATA CON SANTINA CAMPANA' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 30/11/2022 01:07:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17464' AND id_supplier = '' 30/11/2022 01:07:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17464' , '' , '1' ) 30/11/2022 01:07: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 ( '75477' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 30/11/2022 01:07:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '' 30/11/2022 01:07:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '' , '1' ) 30/11/2022 02:49:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '75466' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 02:49:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3671', document_date = '2022-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '95.40', price_tax_excluded = '87.10', date_upd = NOW() WHERE id_document = '75466' 30/11/2022 02:49:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75466' 30/11/2022 02:49:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '75466' 30/11/2022 02:49: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 ( '75466' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 30/11/2022 02:49: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 ( '75466' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.0000' , '18.852459016393' , '22' , '0' , '23.00' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 30/11/2022 02:49: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 ( '75466' , '20199' , 'PAROLA DI DIO OGNI GIORNO 2023 - V. PAGLIA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20199' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20199' , '' , '1' ) 30/11/2022 02:49: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 ( '75466' , '14640' , 'ECCOMI TI ASCOLTO! - ANNO C - G. CALABRESE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14640' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14640' , '' , '1' ) 30/11/2022 02:49: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 ( '75466' , '13002' , 'ECCOMI TI ASCOLTO! - ANNO B - G. CALABRESE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13002' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13002' , '' , '1' ) 30/11/2022 02:49: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 ( '75466' , '4379' , 'ars' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 30/11/2022 02:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4379' AND id_supplier = '' 30/11/2022 02:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4379' , '' , '1' ) 30/11/2022 02:50:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'OGGETTI' AND id_product != '7202' AND ean13 != '' 30/11/2022 02:50:19 pm >> UPDATE ps_product SET id_supplier = '20', reference = '', ean13 = 'OGGETTI', date_upd = NOW() WHERE id_product = '7202' 30/11/2022 02:50:19 pm >> UPDATE ps_product_lang SET name = 'ARTICOLI RELIGIOSI', description = '' WHERE id_product = '7202' 30/11/2022 02:50:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '7202' 30/11/2022 02:50:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7202' 30/11/2022 02:50:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '7202' 30/11/2022 02:52:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571833' AND id_product != '18647' AND ean13 != '' 30/11/2022 02:52:26 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788867571833', date_upd = NOW() WHERE id_product = '18647' 30/11/2022 02:52:26 pm >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME AVVENTO e natale', description = '' WHERE id_product = '18647' 30/11/2022 02:52:26 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18647' 30/11/2022 02:52:26 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18647' 30/11/2022 02:52:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '18647' 30/11/2022 02:54:18 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '613076', document_date = '2022-10-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '18.44', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '601.85', price_tax_excluded = '601.85', date_upd = NOW() WHERE id_document = '69699' 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '69699' 30/11/2022 02:54:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '69699' 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '18667' , 'SCOPRIAMO LA CRESIMA' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '2' , '2' , '4' , '12.0000' , '12' , '0' , '35' , '15.60' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '20246' , 'EXSULTET' , '1' , '1' , '4' , '40.0000' , '40' , '0' , '30' , '28.00' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20246' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20246' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '3' , '3' , '4' , '12.0000' , '12' , '0' , '35+7' , '21.76' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '2' , '2' , '4' , '12.0000' , '12' , '0' , '35+7' , '14.51' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '3' , '3' , '4' , '13.0000' , '13' , '0' , '35' , '25.35' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2073' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2073' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '3' , '3' , '4' , '13.0000' , '13' , '0' , '35' , '25.35' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2072' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2072' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '17423' , 'CARLO ACUTIS' , '1' , '1' , '4' , '7.5000' , '7.5' , '0' , '30' , '5.25' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17423' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17423' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '33' , '10.05' ) 30/11/2022 02:54:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3977' AND id_supplier = '' 30/11/2022 02:54:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3977' , '' , '1' ) 30/11/2022 02:54:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '6302' , 'MATTEO' , '1' , '1' , '4' , '38.0000' , '38' , '0' , '33' , '25.46' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6302' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6302' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '9086' , 'ROSARIO CON I DEFUNTI' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '30' , '2.10' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9086' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9086' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '20043' , 'FOLLOWERS 2.0 - GUIDA' , '1' , '1' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20043' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20043' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '20137' , 'FOLLOWERS 2.0 - QUADERNO' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '33' , '5.36' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20137' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20137' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '19925' , 'AMEN - NOV. 2022' , '2' , '2' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '19926' , 'AMEN - DIC. 2022' , '2' , '2' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '3' , '3' , '4' , '12.0000' , '12' , '0' , '35+7' , '21.76' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '36' , '36' , '4' , '3.0000' , '3' , '0' , '35+7' , '65.29' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '12' , '12' , '4' , '3.0000' , '3' , '0' , '35+7' , '21.76' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/11/2022 02:54:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '' 30/11/2022 02:54:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '' , '1' ) 30/11/2022 02:54:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '35+7' , '7.25' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11188' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11188' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '36' , '36' , '4' , '3.0000' , '3' , '0' , '35+7' , '65.29' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '12' , '12' , '4' , '3.0000' , '3' , '0' , '35+7' , '21.76' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '36' , '36' , '4' , '3.0000' , '3' , '0' , '35+7' , '65.29' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '3' , '3' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8601' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8601' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '17244' , 'DIARIO DELLA MIA PRIMA CONFESSIONE' , '5' , '5' , '4' , '5.9000' , '5.9' , '0' , '30+7' , '19.20' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17244' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17244' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '16147' , 'SCOPRIAMO LA MESSA' , '2' , '2' , '4' , '4.9000' , '4.9' , '0' , '30+7' , '6.38' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16147' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16147' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '15386' , 'MESSA - LE PAROLE DI PAPA FRANCESCO' , '3' , '3' , '4' , '4.9000' , '4.9' , '0' , '30+7' , '9.57' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15386' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15386' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '18051' , 'MIA BIBBIA' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '30' , '2.45' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18051' AND id_supplier = '' 30/11/2022 02:54:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18051' , '' , '1' ) 30/11/2022 02:54: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 ( '69699' , '16392' , 'ALLA SCUOLA DEL VANGELO DI MATTEO - ANNO A - D. PETTI' , '1' , '1' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 30/11/2022 02:54:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16392' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16392' , '' , '1' ) 30/11/2022 02:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '6964' , 'NELLA CASA DEL PADRE - FEDELI' , '2' , '2' , '4' , '8.9000' , '8.9' , '0' , '35' , '11.57' ) 30/11/2022 02:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6964' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6964' , '' , '1' ) 30/11/2022 02:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '20110' , 'BRACE LEGNA SOFFIO - DOTTI/ALDEGANI' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '33' , '6.70' ) 30/11/2022 02:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20110' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20110' , '' , '1' ) 30/11/2022 02:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '18236' , 'SANTANTONIO DI PADOVA - G. SACINO' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '30' , '6.30' ) 30/11/2022 02:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18236' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18236' , '' , '1' ) 30/11/2022 02:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '12895' , 'PASSI VERSO LA CRESIMA' , '3' , '3' , '4' , '7.9000' , '7.9' , '0' , '35' , '15.41' ) 30/11/2022 02:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '' , '1' ) 30/11/2022 02:54:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '69699' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '2' , '2' , '4' , '16.0000' , '16' , '0' , '33' , '21.44' ) 30/11/2022 02:54:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20247' AND id_supplier = '' 30/11/2022 02:54:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20247' , '' , '1' ) 30/11/2022 02:54:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867571833' AND id_product != '18647' AND ean13 != '' 30/11/2022 02:54:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/4', ean13 = '9788867571833', date_upd = NOW() WHERE id_product = '18647' 30/11/2022 02:54:46 pm >> UPDATE ps_product_lang SET name = 'SCOPRIAMO INSIEME AVVENTO E NATALE', description = '' WHERE id_product = '18647' 30/11/2022 02:54:46 pm >> UPDATE ps_product SET wholesale_price = '3.43', on_sale = '0', price = '4.9000' WHERE id_product = '18647' 30/11/2022 02:54:46 pm >> UPDATE ps_product_shop SET wholesale_price = '3.43', price = '4.9000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18647' 30/11/2022 02:54:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '18647' 30/11/2022 03:56:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 03:56:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3681' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.70' , '6.31' , NOW() , NOW() ) 30/11/2022 03:56: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 = '75478' 30/11/2022 03:56:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '75478' 30/11/2022 03:56: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 ( '75478' , '13054' , 'ADDOBBI LASER' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 30/11/2022 03:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13054' AND id_supplier = '' 30/11/2022 03:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13054' , '' , '1' ) 30/11/2022 03:56: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 ( '75478' , '12919' , 'CONFEZIONE CARTONCINO CON BAMBINO - P422' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 30/11/2022 03:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12919' AND id_supplier = '' 30/11/2022 03:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12919' , '' , '1' ) 30/11/2022 03:56: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 ( '75478' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/11/2022 03:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20157' AND id_supplier = '' 30/11/2022 03:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20157' , '' , '1' ) 30/11/2022 03:56: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 ( '75478' , '20163' , 'QUADRETTO CAMPANA - 23/77C' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 30/11/2022 03:56:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20163' AND id_supplier = '' 30/11/2022 03:56:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20163' , '' , '1' ) 30/11/2022 04:08:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 04:08:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3682' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.00' , '101.84' , NOW() , NOW() ) 30/11/2022 04:08:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75479' 30/11/2022 04:08:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '75479' 30/11/2022 04:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75479' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 30/11/2022 04:08:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 30/11/2022 04:08:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 30/11/2022 04:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75479' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 30/11/2022 04:08:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/11/2022 04:08:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/11/2022 04:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75479' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/11/2022 04:08:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/11/2022 04:08:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/11/2022 04:08:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75479' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '20.00' ) 30/11/2022 04:08:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/11/2022 04:08:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/11/2022 04:12:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '317' AND id_document != '75471' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 04:12:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '317', document_date = '2022-11-30', document_letter = '', id_customer = '1083', id_supplier = '', id_address = '4674059', address1 = 'VIA CREMONA, 1 83020 S. MICHELE DI SERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '199.33', price_tax_excluded = '199.33', date_upd = NOW() WHERE id_document = '75471' 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75471' 30/11/2022 04:12:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '75471' 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 30/11/2022 04:12:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 30/11/2022 04:12:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8513' AND id_supplier = '' 30/11/2022 04:12:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8513' , '' , '1' ) 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '-17' , '4' , '3.5000' , '3.5' , '0' , '15' , '50.58' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8509' AND id_supplier = '' 30/11/2022 04:12:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8509' , '' , '1' ) 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '15' , '63.75' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 30/11/2022 04:12:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 30/11/2022 04:12:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75471' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2022 04:12:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 30/11/2022 04:12:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 30/11/2022 04:26:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 04:26:23 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' , '3683' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.60' , '116.96' , NOW() , NOW() ) 30/11/2022 04:26: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 = '75480' 30/11/2022 04:26:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '75480' 30/11/2022 04:26: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 ( '75480' , '16516' , 'SANT\'ANNA CM 30 - 626' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 30/11/2022 04:26:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16516' AND id_supplier = '' 30/11/2022 04:26:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16516' , '' , '1' ) 30/11/2022 04:26: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 ( '75480' , '8798' , 'RACCONTO DI MATTEO - B. MAGGIONI' , '1' , '-1' , '4' , '18.6' , '18.6' , '0' , '' , '18.60' ) 30/11/2022 04:26:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8798' AND id_supplier = '' 30/11/2022 04:26:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8798' , '' , '1' ) 30/11/2022 06:22:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 06:22:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3684' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 30/11/2022 06:22:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75481' 30/11/2022 06:22:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '75481' 30/11/2022 06:22:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75481' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '36.00' ) 30/11/2022 06:22:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 30/11/2022 06:22:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 30/11/2022 06:29:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 06:29:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3685' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.50' , '0.50' , NOW() , NOW() ) 30/11/2022 06:29:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75482' 30/11/2022 06:29:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '75482' 30/11/2022 06:29:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75482' , '19920' , 'CALENDARIO LITURGICO 2023 - 8078' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 30/11/2022 06:29:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19920' AND id_supplier = '' 30/11/2022 06:29:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19920' , '' , '1' ) 30/11/2022 06:36:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '318' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 06:36:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '318' , '2022-11-30' , '' , '2755' , '0' , '4670612' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '52.97' , '52.97' , NOW() , NOW() ) 30/11/2022 06:36: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 = '75483' 30/11/2022 06:36:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '75483' 30/11/2022 06:36: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 ( '75483' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '10' , '1.35' ) 30/11/2022 06:36: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 ( '75483' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '10' , '0.90' ) 30/11/2022 06:36: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 ( '75483' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '15' , '3.83' ) 30/11/2022 06:36: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 ( '75483' , '6629' , 'MIA PREGHIERA' , '2' , '-2' , '4' , '0.90' , '0.9' , '0' , '10' , '1.62' ) 30/11/2022 06:36: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 ( '75483' , '9996' , 'SIGNORE, TI PREGO' , '2' , '-2' , '4' , '6.00' , '6' , '0' , '15' , '10.20' ) 30/11/2022 06:36: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 ( '75483' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '15' , '5.95' ) 30/11/2022 06:36: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 ( '75483' , '20300' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '10' , '9.45' ) 30/11/2022 06:36: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 ( '75483' , '15276' , 'SCOLLINARE O SRADICARE - VIA CRUCIS' , '4' , '-4' , '4' , '2.00' , '2' , '0' , '5' , '7.60' ) 30/11/2022 06:36: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 ( '75483' , '20055' , 'NON TEMERE - AVVENTO 2022' , '3' , '-3' , '4' , '3.40' , '3.4' , '0' , '5' , '9.69' ) 30/11/2022 06:36: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 ( '75483' , '20032' , 'ALLA SCOPERTA DEL TESORO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/11/2022 06:43:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755' 30/11/2022 06:43:32 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 ( '2755' , '10' , '168' , '' , 'ALICANDRO' , 'FERNANDA ' , 'VIA PRINCIPE DI PIEMONTE' , 'C/O UFFICIO POSTALE' , '04026' , 'MINTURNO' , '' , 'UFF 0771658036' , '3405070675' , '' , '' , NOW() , NOW() ) 30/11/2022 06:43:32 pm >> UPDATE ps_customer SET email = 'FERNANDA.ALICANDRO@POSTEITALIANE.IT', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2755' 30/11/2022 06:47:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-11-30') 30/11/2022 06:47: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' , '3686' , '2022-11-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 30/11/2022 06:47: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 = '75484' 30/11/2022 06:47:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '75484' 30/11/2022 06:47: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 ( '75484' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/11/2022 06:47:24 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 30/11/2022 06:47:24 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 30/11/2022 07:00: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 ( '32' , '2022010002168' , '2022-11-30' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '38.24' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1235.55' , '1235.55' , NOW() , NOW() ) 30/11/2022 07:00: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 = '75485' 30/11/2022 07:00:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '75485' 30/11/2022 07:00: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 ( '75485' , '20400' , 'ANGELO CUSTODE DI SAN FRANCESCO - R. CANTALAMESSA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 30/11/2022 07:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20400' AND id_supplier = '107' 30/11/2022 07:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20400' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '13516' , 'SUL DISCERNIMENTO DEGLI SPIRITI - A. GAGLIARDI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13516' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13516' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '8798' , 'RACCONTO DI MATTEO - B. MAGGIONI' , '1' , '0' , '4' , '19.5000' , '19.5' , '0' , '35' , '12.68' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8798' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8798' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20395' , 'SANTA FAMIGLIA ' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '35' , '6.50' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20395' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20395' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20396' , 'MINISTERO DI GESù NEL VANGELO SECONDO MATTEO - N. DI BIANCO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20396' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20396' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20397' , 'FRATERNITà IMPOSSIBILE? - G. CUCCI' , '1' , '0' , '4' , '13.5000' , '13.5' , '0' , '35' , '8.78' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20397' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20397' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20394' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - EUCARISTIA - A. MIRALLES' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '22.75' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20394' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20394' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20399' , 'NATALE GRANDE GIOIA - M. BORRELLI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '35' , '11.70' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20399' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20399' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20398' , 'NATALE - BENEDETTO XVI' , '2' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '20.80' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20398' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20398' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '18808' , 'INTRODUZIONE AL PENTATEUCO - M. TABET' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18808' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18808' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '18183' , 'VANGELI SINOTTICI E ATTI DEGLI APOSTOLI - G. DE VIRGILIO' , '1' , '0' , '4' , '40.0000' , '40' , '0' , '35' , '26.00' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18183' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18183' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20401' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 1' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20401' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20401' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20402' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 2' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20402' AND id_supplier = '107' 30/11/2022 07:00:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20402' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20403' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 3' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20403' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20403' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20404' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 4' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20404' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20404' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20405' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 5' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20405' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20405' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20406' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 6' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20406' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20406' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20407' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 7' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20407' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20407' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20408' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 10' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20408' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20408' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20409' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 12' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20409' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20409' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20410' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 13' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20410' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20410' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20411' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 14' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20411' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20411' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20412' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 15' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20412' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20412' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20413' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 16 indici' , '1' , '0' , '4' , '136.0000' , '136' , '0' , '28.5' , '97.24' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20413' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20413' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20416' , 'GRANDE LESSICO DEL NUOVO TESTAMENTO 11' , '1' , '0' , '4' , '98.0000' , '98' , '0' , '28.5' , '70.07' ) 30/11/2022 07:00:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20416' AND id_supplier = '107' 30/11/2022 07:00:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20416' , '107' , '1' ) 30/11/2022 07:00: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 ( '75485' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 30/11/2022 07:00:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20190' AND id_supplier = '107' 30/11/2022 07:00:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20190' , '107' , '1' ) 30/11/2022 07:00:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75485' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '5' , '0' , '4' , '4.0000' , '4' , '0' , '35' , '13.00' ) 30/11/2022 07:00:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20012' AND id_supplier = '107' 30/11/2022 07:00:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20012' , '107' , '1' ) 30/11/2022 07:33:59 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '6345' 30/11/2022 07:33:59 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '6345' 30/11/2022 07:59:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '289' AND id_document != '73182' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-11-18') 30/11/2022 07:59:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '289', document_date = '2022-11-18', document_letter = '', id_customer = '3978', id_supplier = '', id_address = '4677190', address1 = 'VIA MALTA 3 83100 AVELLINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '279.66', price_tax_excluded = '279.66', date_upd = NOW() WHERE id_document = '73182' 30/11/2022 07:59: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 = '73182' 30/11/2022 07:59:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '73182' 30/11/2022 07:59: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 ( '73182' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 30/11/2022 07:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 30/11/2022 07:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '8408' , 'PRENDETE E MANGIATE' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '15' , '76.50' ) 30/11/2022 07:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 30/11/2022 07:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '15' , '42.50' ) 30/11/2022 07:59:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 30/11/2022 07:59:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '5' , '-5' , '4' , '5.0000' , '5' , '0' , '15' , '21.25' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8409' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8409' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4155' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4155' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 30/11/2022 07:59: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 ( '73182' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '20' , '-20' , '4' , '1.0000' , '1' , '0' , '15' , '17.00' ) 30/11/2022 07:59:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 30/11/2022 07:59:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' )