06/06/2022 08:38:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 08:38:29 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' , '1792' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.40' , '9.40' , NOW() , NOW() ) 06/06/2022 08:38:29 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 = '58611' 06/06/2022 08:38:29 am >> DELETE FROM ps_document_detail WHERE id_document = '58611' 06/06/2022 08:38:29 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 ( '58611' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 06/06/2022 08:38:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '18597' AND id_supplier = '' 06/06/2022 08:38:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18597' , '' , '1' ) 06/06/2022 08:38:29 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 ( '58611' , '19420' , 'PREGO ANCHE IO ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 06/06/2022 08:38:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19420' AND id_supplier = '' 06/06/2022 08:38:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19420' , '' , '1' ) 06/06/2022 08:38:30 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 ( '58611' , '12147' , 'ANGELO CUSTODE RACCONTATO AI BAMBINI - B. FERRERO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 06/06/2022 08:38:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '12147' AND id_supplier = '' 06/06/2022 08:38:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12147' , '' , '1' ) 06/06/2022 08:55:40 am >> SELECT document_num FROM ps_document WHERE document_num = '9/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 08:55:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '9/S' , '2022-06-06' , 'S' , '402' , '0' , '4670248' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '293.15' , '293.15' , NOW() , NOW() ) 06/06/2022 08:55: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 = '5365' 06/06/2022 08:55:40 am >> DELETE FROM ps_document_detail WHERE id_document = '5365' 06/06/2022 08:55: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 ( '5365' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '35' , '39.00' ) 06/06/2022 08:55: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 ( '5365' , '50' , 'PERDONAMI SIGNORE' , '70' , '-70' , '4' , '2.00' , '2' , '0' , '35' , '91.00' ) 06/06/2022 08:55: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 ( '5365' , '117' , 'La prehiera delle cinque dita n.e.' , '27' , '-27' , '4' , '1.50' , '1.5' , '0' , '35' , '26.32' ) 06/06/2022 08:55: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 ( '5365' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '35' , '6.83' ) 06/06/2022 08:55: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 ( '5365' , '110' , 'SE MI AMI NON PIANGERE' , '100' , '-100' , '4' , '1.50' , '1.5' , '0' , '35' , '97.50' ) 06/06/2022 08:55: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 ( '5365' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '35' , '32.50' ) 06/06/2022 09:15:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '58604' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 06/06/2022 09:15:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1785', document_date = '2022-06-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.20', price_tax_excluded = '26.39', date_upd = NOW() WHERE id_document = '58604' 06/06/2022 09:15: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 = '58604' 06/06/2022 09:15:59 am >> DELETE FROM ps_document_detail WHERE id_document = '58604' 06/06/2022 09:15: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 ( '58604' , '18274' , 'BRACCIALE A NODI - 2610' , '23' , '-23' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '32.20' ) 06/06/2022 09:15:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '18274' AND id_supplier = '' 06/06/2022 09:15:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18274' , '' , '1' ) 06/06/2022 09:16:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '58602' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-04') 06/06/2022 09:16:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1783', document_date = '2022-06-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '939.42', price_tax_excluded = '925.35', date_upd = NOW() WHERE id_document = '58602' 06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58602' 06/06/2022 09:16:31 am >> DELETE FROM ps_document_detail WHERE id_document = '58602' 06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58602' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58602' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '49' , '-49' , '4' , '18.5000' , '18.5' , '0' , '5' , '861.42' ) 06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '9253' AND id_supplier = '' 06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9253' , '' , '1' ) 06/06/2022 09:16:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58602' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '42.00' ) 06/06/2022 09:16:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 06/06/2022 09:16:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 06/06/2022 09:39:56 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 ( '32' , '6022259141' , '2022-05-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '5.10' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '127.31' , '127.31' , NOW() , NOW() ) 06/06/2022 09:39:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58612' 06/06/2022 09:39:56 am >> DELETE FROM ps_document_detail WHERE id_document = '58612' 06/06/2022 09:39:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58612' , '10915' , 'UNA COMUNITÀ LEGGE IL VANGELO DI LUCA' , '1' , '0' , '4' , '43.01' , '43.01' , '0' , '0' , '43.0100' ) 06/06/2022 09:39:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '10915' AND id_supplier = '109' 06/06/2022 09:39:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10915' , '109' , '1' ) 06/06/2022 09:39:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58612' , '822' , 'ATTI DEGLI APOSTOLI - S. FAUSTI' , '2' , '0' , '4' , '39.6' , '39.6' , '0' , '0' , '79.2000' ) 06/06/2022 09:39:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '822' AND id_supplier = '109' 06/06/2022 09:39:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '822' , '109' , '1' ) 06/06/2022 09:40:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 09:40:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1793' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 06/06/2022 09:40:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58613' 06/06/2022 09:40:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58613' 06/06/2022 09:40:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58613' , '9539' , 'SANTANTONIO DA PADOVA - 41' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 06/06/2022 09:40:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9539' AND id_supplier = '' 06/06/2022 09:40:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9539' , '' , '1' ) 06/06/2022 09:46:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 09:46: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' , '1794' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 06/06/2022 09:46: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 = '58614' 06/06/2022 09:46:54 am >> DELETE FROM ps_document_detail WHERE id_document = '58614' 06/06/2022 09:46: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 ( '58614' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/06/2022 09:46:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 06/06/2022 09:46:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 06/06/2022 09:46: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 ( '58614' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 06/06/2022 09:46:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 06/06/2022 09:46:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 06/06/2022 11:18:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 11:18:55 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' , '1795' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '143.00' , '117.21' , NOW() , NOW() ) 06/06/2022 11:18:55 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 = '58615' 06/06/2022 11:18:55 am >> DELETE FROM ps_document_detail WHERE id_document = '58615' 06/06/2022 11:18:55 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 ( '58615' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 06/06/2022 11:18:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '' 06/06/2022 11:18:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' ) 06/06/2022 11:42:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 11:42:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1796' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.20' , '87.50' , NOW() , NOW() ) 06/06/2022 11:42:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58616' 06/06/2022 11:42:03 am >> DELETE FROM ps_document_detail WHERE id_document = '58616' 06/06/2022 11:42:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58616' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58616' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '15.20' ) 06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58616' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '12.00' ) 06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 06/06/2022 11:42:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58616' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7' , '5.7377049180328' , '22' , '0' , '42.00' ) 06/06/2022 11:42:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 06/06/2022 11:42:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 06/06/2022 11:55:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 11:55:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1797' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 06/06/2022 11:55:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58617' 06/06/2022 11:55:38 am >> DELETE FROM ps_document_detail WHERE id_document = '58617' 06/06/2022 11:55: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 ( '58617' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 06/06/2022 11:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 06/06/2022 11:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 06/06/2022 11:55: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 ( '58617' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 06/06/2022 11:55:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '2164' AND id_supplier = '' 06/06/2022 11:55:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2164' , '' , '1' ) 06/06/2022 12:35:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 12:35:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1798' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.00' , '85.17' , NOW() , NOW() ) 06/06/2022 12:35:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58618' 06/06/2022 12:35:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58618' 06/06/2022 12:35: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 ( '58618' , '9688' , 'SCAPOLARE 10X15 CUORE DI GESÙ - 2202 ' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 06/06/2022 12:35:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9688' AND id_supplier = '' 06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9688' , '' , '1' ) 06/06/2022 12:35:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58618' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 06/06/2022 12:35:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58618' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = '' 06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '' , '1' ) 06/06/2022 12:35:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58618' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/06/2022 12:35:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 06/06/2022 12:35:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 06/06/2022 12:57:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1798' AND id_document != '58618' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 12:57:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1798', document_date = '2022-06-06', 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 = '102.00', price_tax_excluded = '85.17', date_upd = NOW() WHERE id_document = '58618' 06/06/2022 12:57:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58618' 06/06/2022 12:57:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58618' 06/06/2022 12:57: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 ( '58618' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 06/06/2022 12:57: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 ( '58618' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 06/06/2022 12:57: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 ( '58618' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = '' 06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '' , '1' ) 06/06/2022 12:57: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 ( '58618' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/06/2022 12:57:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 06/06/2022 12:57:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 06/06/2022 02:44:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 02:44:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '17' , '2022-06-06' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'CARTA D\'IDENTITA\' ARRIVERA\' DIRETTAMENTE DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1274.00' , '1274.00' , NOW() , NOW() ) 06/06/2022 02:44:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58619' 06/06/2022 02:44:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58619' 06/06/2022 02:44:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '320' , '-320' , '4' , '1.60' , '1.6' , '0' , '0' , '512.00' ) 06/06/2022 02:44:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '320' , '-320' , '4' , '1.60' , '1.6' , '0' , '0' , '512.00' ) 06/06/2022 02:44:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' , '2.50' , '2.5' , '0' , '0' , '250.00' ) 06/06/2022 02:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 02:46:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '17/E' , '2022-06-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '592.20' , '485.41' , NOW() , NOW() ) 06/06/2022 02:46:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58620' 06/06/2022 02:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58620' 06/06/2022 02:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58620' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 06/06/2022 02:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58620' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '38.00' , '31.147540983607' , '22' , '40' , '273.60' ) 06/06/2022 02:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58620' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '250' , '-250' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '45.00' ) 06/06/2022 02:48:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 02:48:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '6' , '2022-06-06' , '' , '6541' , '0' , '9339920' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3075.00' , '3075.00' , NOW() , NOW() ) 06/06/2022 02:48:06 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 = '5366' 06/06/2022 02:48:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '5366' 06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5366' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '270' , '-270' , '4' , '2.50' , '2.5' , '0' , '0' , '675.00' ) 06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5366' , '110' , 'SE MI AMI NON PIANGERE' , '500' , '-500' , '4' , '1.50' , '1.5' , '0' , '0' , '750.00' ) 06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5366' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '300' , '-300' , '4' , '1.50' , '1.5' , '0' , '0' , '450.00' ) 06/06/2022 02:48:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5366' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '480' , '-480' , '4' , '2.50' , '2.5' , '0' , '0' , '1200.00' ) 06/06/2022 03:16:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 03:16:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1799' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 06/06/2022 03:16:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58621' 06/06/2022 03:16:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58621' 06/06/2022 03:16:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58621' , '3074' , 'CROCE PRIMA COMUNIONE LEGNO CHIARO - 713/11' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/06/2022 03:16:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3074' AND id_supplier = '' 06/06/2022 03:16:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3074' , '' , '1' ) 06/06/2022 03:59:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 03:59:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1800' , '2022-06-06' , '' , '' , '' , '' , 'VIA SAN LEONARDO 239 84131 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.60' , '49.03' , NOW() , NOW() ) 06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58622' 06/06/2022 03:59:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58622' 06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58622' , '7912' , 'PERGAMENE - 1A COMUNIONE MOD. C' , '13' , '-13' , '1' , '0.7000' , '0.5738' , '22' , '0' , '9.10' ) 06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7912' AND id_supplier = '' 06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7912' , '' , '1' ) 06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58622' , '12044' , 'CONFEZIONE CARTONCINO CON CROCE - 2342/K126' , '13' , '-13' , '1' , '2.5000' , '2.0492' , '22' , '0' , '32.50' ) 06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12044' AND id_supplier = '' 06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12044' , '' , '1' ) 06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58622' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 06/06/2022 03:59:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58622' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 06/06/2022 03:59:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 06/06/2022 03:59:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 06/06/2022 03:59:46 pm >> DELETE FROM ps_document WHERE id_document = '58415' 06/06/2022 03:59:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '58415' 06/06/2022 04:24:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 04:24:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '18/E' , '2022-06-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MAGGIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '6426.71' , '6425.36' , NOW() , NOW() ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58623' 06/06/2022 04:24:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58623' 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '211' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '253.20' ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '5446' , 'IO SONO CON VOI - GUIDA' , '9' , '0' , '4' , '6.00' , '6' , '0' , '50' , '27.00' ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11183' , 'VENITE CON ME - GUIDA' , '7' , '0' , '4' , '6.00' , '6' , '0' , '50' , '21.00' ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '5548' , 'LAMPADA AI MIEI PASSI - ANNO C' , '1' , '0' , '4' , '10.33' , '10.33' , '0' , '50' , '5.17' ) 06/06/2022 04:24:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '3' , '0' , '4' , '6.20' , '6.2' , '0' , '50' , '9.30' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '2' , '0' , '4' , '5.16' , '5.16' , '0' , '50' , '5.16' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '9675' , 'SARETE MIEI TESTIMONI' , '59' , '0' , '4' , '3.00' , '3' , '0' , '50' , '88.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8254' , 'PREGHIAMO CON MARIA' , '11' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '3.58' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '5457' , 'IO SONO CON VOI 1 PARTE' , '697' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '871.25' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '5458' , 'IO SONO CON VOI 2 PARTE' , '510' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '637.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11191' , 'VENITE CON ME 1 PARTE' , '520' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '650.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11192' , 'VENITE CON ME 2 PARTE' , '272' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '340.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '1882' , 'CELEBRAZIONI PER LANNO CATECHISTICO' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '7' , '0' , '4' , '8.00' , '8' , '0' , '50' , '28.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8243' , 'PREGARE OGNI GIORNO' , '16' , '0' , '4' , '1.00' , '1' , '0' , '50' , '8.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '25' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '42.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '4' , '0' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '3' , '0' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11308' , 'VIA CRUCIS ' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '9' , '0' , '4' , '6.00' , '6' , '0' , '50' , '27.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '6629' , 'MIA PREGHIERA' , '10' , '0' , '4' , '0.65' , '0.65' , '0' , '50' , '3.25' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8408' , 'PRENDETE E MANGIATE' , '64' , '0' , '4' , '3.00' , '3' , '0' , '50' , '96.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '5' , '0' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '4' , '0' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '4154' , 'FESTA DEL PERDONO' , '39' , '0' , '4' , '3.00' , '3' , '0' , '50' , '58.50' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '2679' , 'CONOSCERE GESU' , '59' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '103.25' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '2680' , 'CONOSCERE GESU - GUIDA' , '5' , '0' , '4' , '6.00' , '6' , '0' , '50' , '15.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '3' , '0' , '4' , '8.50' , '8.5' , '0' , '50' , '12.75' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '15' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '12.00' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '821' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '656.80' ) 06/06/2022 04:24:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '1833' , 'CATECHISTA: VOCAZIONE E MISSIONE ' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2022 04:24: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 ( '58623' , '7543' , 'PARABOLE DI GESÙ' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2022 04:24: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 ( '58623' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2022 04:24: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 ( '58623' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '793' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '634.40' ) 06/06/2022 04:24: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 ( '58623' , '12819' , 'REGISTRO DEL CATECHISTA ' , '15' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '7.50' ) 06/06/2022 04:24: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 ( '58623' , '12253' , 'MIO LIBRO DI PREGHIERE' , '29' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '40.60' ) 06/06/2022 04:24: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 ( '58623' , '12255' , 'IN CAMMINO CON GESU' , '82' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '155.80' ) 06/06/2022 04:24: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 ( '58623' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '4' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '7.00' ) 06/06/2022 04:24: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 ( '58623' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '30' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '52.50' ) 06/06/2022 04:24: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 ( '58623' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '7' , '0' , '4' , '6.00' , '6' , '0' , '50' , '21.00' ) 06/06/2022 04:24: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 ( '58623' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 06/06/2022 04:24: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 ( '58623' , '13397' , 'MIO GESU' , '29' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '50.75' ) 06/06/2022 04:24: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 ( '58623' , '14031' , 'SEGNO DELLA CROCE' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2022 04:24: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 ( '58623' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '48' , '0' , '4' , '1.00' , '1' , '0' , '50' , '24.00' ) 06/06/2022 04:24: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 ( '58623' , '15019' , 'PREGHIAMO CON MARIA' , '31' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '12.40' ) 06/06/2022 04:24: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 ( '58623' , '15020' , 'PREGARE OGNI GIORNO' , '76' , '0' , '4' , '1.00' , '1' , '0' , '50' , '38.00' ) 06/06/2022 04:24: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 ( '58623' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '5' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '8.75' ) 06/06/2022 04:24: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 ( '58623' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '7' , '0' , '4' , '1.00' , '1' , '0' , '50' , '3.50' ) 06/06/2022 04:24: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 ( '58623' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '13' , '0' , '4' , '2.00' , '2' , '0' , '50' , '13.00' ) 06/06/2022 04:24: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 ( '58623' , '16667' , 'VIA CRUCIS' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 06/06/2022 04:24: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 ( '58623' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '9' , '0' , '4' , '15.00' , '15' , '0' , '50' , '67.50' ) 06/06/2022 04:24: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 ( '58623' , '17257' , 'IO TI BATTEZZO ' , '81' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '72.90' ) 06/06/2022 04:24: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 ( '58623' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '23' , '0' , '4' , '3.00' , '3' , '0' , '50' , '34.50' ) 06/06/2022 04:24: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 ( '58623' , '17582' , 'SAN CESARE DE BUS' , '9' , '0' , '4' , '5.00' , '5' , '0' , '50' , '22.50' ) 06/06/2022 04:24: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 ( '58623' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '7' , '0' , '4' , '20.00' , '20' , '0' , '50' , '70.00' ) 06/06/2022 04:24: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 ( '58623' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '5' , '0' , '4' , '3.80' , '3.8' , '0' , '50' , '9.50' ) 06/06/2022 04:24: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 ( '58623' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '16' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '20.00' ) 06/06/2022 04:24: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 ( '58623' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '0' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 06/06/2022 04:24: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 ( '58623' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '5' , '0' , '4' , '1.00' , '1' , '0' , '50' , '2.50' ) 06/06/2022 04:24: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 ( '58623' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '14' , '0' , '4' , '2.00' , '2' , '0' , '50' , '14.00' ) 06/06/2022 04:24: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 ( '58623' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 06/06/2022 04:24: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 ( '58623' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2022 04:24: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 ( '58623' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '47' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '44.65' ) 06/06/2022 04:24: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 ( '58623' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '26' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '32.50' ) 06/06/2022 04:24: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 ( '58623' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '6' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 06/06/2022 04:24: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 ( '58623' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '3' , '0' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 06/06/2022 04:24: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 ( '58623' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '3' , '0' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 06/06/2022 04:24: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 ( '58623' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '6' , '0' , '4' , '16.00' , '16' , '0' , '50' , '48.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '12' , '0' , '4' , '2.00' , '2' , '0' , '50' , '12.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '5' , '0' , '4' , '5.00' , '5' , '0' , '50' , '12.50' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '8' , '0' , '4' , '20.00' , '20' , '0' , '50' , '80.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '5' , '0' , '4' , '15.00' , '15' , '0' , '50' , '37.50' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '7' , '0' , '4' , '16.00' , '16' , '0' , '50' , '56.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.00' , '7' , '0' , '50' , '28.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '5' , '0' , '4' , '4.80' , '4.8' , '0' , '50' , '12.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '20' , '0' , '4' , '2.00' , '2' , '0' , '50' , '20.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '12' , '0' , '4' , '9.00' , '9' , '0' , '50' , '54.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '9' , '0' , '4' , '9.00' , '9' , '0' , '50' , '40.50' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '9' , '0' , '4' , '9.00' , '9' , '0' , '50' , '40.50' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '5' , '0' , '4' , '10.00' , '10' , '0' , '50' , '25.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '18950' , 'DOVE FINITO IL CONCILIO? - F. CERRI' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '13' , '0' , '4' , '2.00' , '2' , '0' , '50' , '13.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '15' , '0' , '4' , '20.00' , '20' , '0' , '50' , '150.00' ) 06/06/2022 04:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58623' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '30' , '0' , '4' , '12.00' , '12' , '0' , '50' , '180.00' ) 06/06/2022 04:40:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '19/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 04:40:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '19/E' , '2022-06-06' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MAGGIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '672.37' , '672.01' , NOW() , NOW() ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58624' 06/06/2022 04:40:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '58624' 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '8' , '8' , '4' , '2.40' , '2.4' , '0' , '50' , '9.60' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '2' , '2' , '4' , '6.20' , '6.2' , '0' , '50' , '6.20' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '5457' , 'IO SONO CON VOI 1 PARTE' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '15' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11191' , 'VENITE CON ME 1 PARTE' , '26' , '26' , '4' , '2.50' , '2.5' , '0' , '50' , '32.50' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '6' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '3' , '3' , '4' , '0.85' , '0.85' , '0' , '50' , '1.27' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '2' , '2' , '4' , '3.40' , '3.4' , '0' , '50' , '3.40' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '1' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '1' , '4' , '3.40' , '3.4' , '0' , '50' , '1.70' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '50' , '2.50' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '4' , '4' , '4' , '6.00' , '6' , '0' , '50' , '12.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8408' , 'PRENDETE E MANGIATE' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '2680' , 'CONOSCERE GESU - GUIDA' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '4' , '4' , '4' , '1.60' , '1.6' , '0' , '50' , '3.20' ) 06/06/2022 04:40:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '11' , '11' , '4' , '1.60' , '1.6' , '0' , '50' , '8.80' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '4' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '2.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '1' , '4' , '1.00' , '1' , '0' , '50' , '0.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '27' , '27' , '4' , '1.00' , '1' , '0' , '50' , '13.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '9' , '9' , '4' , '2.00' , '2' , '0' , '50' , '9.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '16667' , 'VIA CRUCIS' , '12' , '12' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18036' , 'FERITE FERITOIE ' , '2' , '2' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18175' , 'VIA DI SAN GIUSEPPE - G. POLIDORO' , '6' , '6' , '4' , '4.80' , '4.8' , '0' , '50' , '14.40' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '18' , '18' , '4' , '2.00' , '2' , '0' , '50' , '18.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '2' , '4' , '15.00' , '15' , '0' , '50' , '15.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '27' , '27' , '4' , '1.50' , '1.5' , '0' , '50' , '20.25' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '50' , '8.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18527' , 'SOGNI DI PACE - V. SAVOLDI' , '17' , '17' , '4' , '2.00' , '2' , '0' , '50' , '17.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '4' , '4' , '4' , '20.00' , '20' , '0' , '50' , '40.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18657' , 'HO DATO LORO LA TUA PAROLA - P. VALSECCHI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '2' , '2' , '4' , '4.80' , '4.8' , '0' , '50' , '4.80' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '12' , '12' , '4' , '9.00' , '9' , '0' , '50' , '54.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '11' , '11' , '4' , '9.00' , '9' , '0' , '50' , '49.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '3' , '3' , '4' , '9.00' , '9' , '0' , '50' , '13.50' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '20' , '20' , '4' , '10.00' , '10' , '0' , '50' , '100.00' ) 06/06/2022 04:40:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58624' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '23' , '23' , '4' , '2.00' , '2' , '0' , '50' , '23.00' ) 06/06/2022 04:56:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 04:56:38 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 ( '22' , '10/S' , '2022-06-06' , 'S' , '6541' , '0' , '9339920' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MAGGIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2156.75' , '2156.75' , NOW() , NOW() ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5367' 06/06/2022 04:56:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '5367' 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '17' , 'LA FEDE NELLO ZAINETTO' , '40' , '0' , '4' , '5.00' , '5' , '0' , '50' , '100.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '391' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '293.25' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '182' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '227.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '96' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '120.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '238' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '297.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '125' , 'MIE PREGHIERINE - N. E.' , '292' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '219.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '33' , '100 GIORNI CON LO SPIRITO' , '90' , '0' , '4' , '7.00' , '7' , '0' , '50' , '315.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '36' , 'IL CANTICO DEI CANTICI' , '2' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '8' , '0' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '50' , 'PERDONAMI SIGNORE' , '6' , '0' , '4' , '2.00' , '2' , '0' , '50' , '6.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '52' , 'Il Padre Nostro spiegato ai bambini' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '55' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '41.25' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '56' , 'MARIA LA MAMMA DI GESU' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '13' , '0' , '4' , '2.00' , '2' , '0' , '50' , '13.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '0' , '4' , '30.00' , '30' , '0' , '50' , '15.00' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '0' , '4' , '6.50' , '6.5' , '0' , '50' , '6.50' ) 06/06/2022 04:56:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '0' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '72' , 'FEDE, SPERANZA E CARITA\'' , '3' , '0' , '4' , '6.00' , '6' , '0' , '50' , '9.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '75' , 'IL SEGNO DELLA CROCE' , '5' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.75' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '92' , 'LA PREGHIERA DEL ROSARIO' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '15' , '0' , '4' , '16.00' , '16' , '0' , '50' , '120.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '94' , 'IL BATTESIMO' , '15' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '11.25' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '35' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '43.75' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '110' , 'SE MI AMI NON PIANGERE' , '8' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '6.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '5' , '0' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '25' , '0' , '4' , '4.00' , '4' , '0' , '50' , '50.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '117' , 'La prehiera delle cinque dita n.e.' , '55' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '41.25' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '14' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '17.50' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '40' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '50.00' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '0' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 06/06/2022 04:56:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5367' , '126' , 'SACRAMENTO DEL PERDONO' , '87' , '0' , '4' , '2.00' , '2' , '0' , '50' , '87.00' ) 06/06/2022 05:00:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 05:00: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 ( '25' , '11/S' , '2022-06-06' , 'S' , '6541' , '0' , '9339920' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MAGGIO 2022' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '326.50' , '326.50' , NOW() , NOW() ) 06/06/2022 05:00: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 = '5368' 06/06/2022 05:00:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '5368' 06/06/2022 05:00: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 ( '5368' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '1' , '4' , '7.00' , '7' , '0' , '50' , '3.50' ) 06/06/2022 05:00: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 ( '5368' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '11' , '11' , '4' , '2.50' , '2.5' , '0' , '50' , '13.75' ) 06/06/2022 05:00: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 ( '5368' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '30' , '30' , '4' , '2.00' , '2' , '0' , '50' , '30.00' ) 06/06/2022 05:00: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 ( '5368' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/06/2022 05:00: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 ( '5368' , '62' , 'GIOVANNI XXIII° SANTO .....IL PAPA BUONO' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2022 05:00: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 ( '5368' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 06/06/2022 05:00: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 ( '5368' , '72' , 'FEDE, SPERANZA E CARITA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 06/06/2022 05:00: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 ( '5368' , '90' , 'ATTO DI AFFIDAMENTO A MARIA' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/06/2022 05:00: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 ( '5368' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '18' , '18' , '4' , '16.00' , '16' , '0' , '50' , '144.00' ) 06/06/2022 05:00: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 ( '5368' , '119' , 'Rosario spiegato ai bambini ' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/06/2022 05:00: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 ( '5368' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '82' , '82' , '4' , '3.00' , '3' , '0' , '50' , '123.00' ) 06/06/2022 05:04:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571030' AND id_product != '131' AND ean13 != '' 06/06/2022 05:04:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571030', date_upd = NOW() WHERE id_product = '131' 06/06/2022 05:04:00 pm >> UPDATE ps_product_lang SET name = 'LIBRO AGENDA CATTOLICO 2022', description = '

Questa agenda risponde alle esigenze ecumeniche della società di oggi.

Nell’agenda potete trovare:

• le pagine riservate ai dati personali;

• i calendari del 2021 e 2022;

• il calendario annuale per appuntamenti;

• le solennità e le feste del rito romano e ambrosiano;

• la tabella delle principali celebrazioni dell’anno liturgico;

• le abbreviazioni dei libri biblici.

In più tante altre notizie per l\'anno liturgico.

' WHERE id_product = '131' 06/06/2022 05:04:00 pm >> UPDATE ps_product SET wholesale_price = '3.80', on_sale = '0', price = '16.00' WHERE id_product = '131' 06/06/2022 05:04:00 pm >> UPDATE ps_product_shop SET wholesale_price = '3.80', price = '16.00', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '448', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '131' 06/06/2022 05:04:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '131' 06/06/2022 05:04:00 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '131' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 06/06/2022 05:05:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571573' AND id_product != '133' AND ean13 != '' 06/06/2022 05:05:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571573', date_upd = NOW() WHERE id_product = '133' 06/06/2022 05:05:25 pm >> UPDATE ps_product_lang SET name = 'LIBRO AGENDA CATTOLICO 2023', description = '

Questa agenda risponde alle esigenze ecumeniche della società di oggi.

Nell’agenda potete trovare:

• le pagine riservate ai dati personali;

• i calendari del 2022 e 2023;

• il calendario annuale per appuntamenti;

• le solennità e le feste del rito romano e ambrosiano;

• la tabella delle principali celebrazioni dell’anno liturgico;

• le abbreviazioni dei libri biblici.

In più tante altre notizie per l\'anno liturgico.

' WHERE id_product = '133' 06/06/2022 05:05:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '133' 06/06/2022 05:05:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '448', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '133' 06/06/2022 05:05:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '133' 06/06/2022 05:05:47 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '131' 06/06/2022 05:05:48 pm >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '133' 06/06/2022 05:21:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1801' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 05:21:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1801' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 06/06/2022 05:21:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58625' 06/06/2022 05:21:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58625' 06/06/2022 05:21:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58625' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 06/06/2022 05:21:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = '' 06/06/2022 05:21:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '' , '1' ) 06/06/2022 05:21:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58625' , '19507' , 'MESSA MEDITAZIONE - LUG/AGO 2022' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 06/06/2022 05:21:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = '' 06/06/2022 05:21:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '' , '1' ) 06/06/2022 05:42:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1802' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 05:42:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1802' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.80' , '26.07' , NOW() , NOW() ) 06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58626' 06/06/2022 05:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58626' 06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '1' , '-1' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '3.30' ) 06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15403' AND id_supplier = '' 06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15403' , '' , '1' ) 06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '19.5' , '15.983606557377' , '22' , '0' , '19.50' ) 06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18213' AND id_supplier = '' 06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18213' , '' , '1' ) 06/06/2022 05:42:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58626' , '6075' , 'LOURDES BABY - 023 LDS/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 06/06/2022 05:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6075' AND id_supplier = '' 06/06/2022 05:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6075' , '' , '1' ) 06/06/2022 05:54:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1803' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 05:54: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' , '1803' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '14.10' , NOW() , NOW() ) 06/06/2022 05:54: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 = '58627' 06/06/2022 05:54:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58627' 06/06/2022 05:54: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 ( '58627' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 06/06/2022 05:54: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 ( '58627' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 06/06/2022 05:54: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 ( '58627' , '18353' , 'PORTA ROSARIO IN VELLUTO PICCOLO - 313-NT 4' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/06/2022 05:54:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18353' AND id_supplier = '' 06/06/2022 05:54:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18353' , '' , '1' ) 06/06/2022 05:57:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1751' AND id_document != '58565' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 06/06/2022 05:57:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1751', document_date = '2022-06-03', 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 = '22.55', price_tax_excluded = '20.91', date_upd = NOW() WHERE id_document = '58565' 06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58565' 06/06/2022 05:57:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '58565' 06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58565' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58565' , '5312' , 'INNO ALLO SPIRITO SANTO' , '3' , '-3' , '4' , '0.1500' , '0.15' , '0' , '0' , '0.45' ) 06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5312' AND id_supplier = '' 06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5312' , '' , '1' ) 06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58565' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '7.50' ) 06/06/2022 05:57:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = '' 06/06/2022 05:57:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' ) 06/06/2022 05:57:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58565' , '19507' , 'MESSA MEDITAZIONE - LUG/AGO 2022' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 06/06/2022 05:57:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19507' AND id_supplier = '' 06/06/2022 05:57:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19507' , '' , '1' ) 06/06/2022 05:58:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1727' AND id_document != '58533' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-31') 06/06/2022 05:58:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1727', document_date = '2022-05-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.87', price_tax_excluded = '18.52', date_upd = NOW() WHERE id_document = '58533' 06/06/2022 05:58:06 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 = '58533' 06/06/2022 05:58:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '58533' 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '9664' , 'SAPIENZA - 117' , '50' , '-50' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '7.50' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9664' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9664' , '' , '1' ) 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '12712' , 'CRESIMA UNA FESTA DA VIVERE' , '2' , '-2' , '4' , '1.9000' , '1.9' , '0' , '5' , '3.62' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12712' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12712' , '' , '1' ) 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5+' , '1.90' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2777' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2777' , '' , '1' ) 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '15125' , 'MESSA DI PRIMA COMUNIONE - 8338' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15125' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15125' , '' , '1' ) 06/06/2022 05:58:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58533' , '19506' , 'MESSA MEDITAZIONE - GIU 2022' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 06/06/2022 05:58:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19506' AND id_supplier = '' 06/06/2022 05:58:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19506' , '' , '1' ) 06/06/2022 06:27:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1804' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 06:27:10 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' , '1804' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.60' , NOW() , NOW() ) 06/06/2022 06:27:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58628' 06/06/2022 06:27:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '58628' 06/06/2022 06:27:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58628' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '1' , '-1' , '4' , '1.60' , '1.6' , '0' , '0' , '1.60' ) 06/06/2022 06:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 06/06/2022 06:27:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 06/06/2022 07:20:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1805' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 07:20: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' , '1805' , '2022-06-06' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.80' , '31.07' , NOW() , NOW() ) 06/06/2022 07:20: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 = '58629' 06/06/2022 07:20:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58629' 06/06/2022 07:20: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 ( '58629' , '18129' , 'TAU COLORATO - T56' , '25' , '-25' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '30.00' ) 06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '' 06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' ) 06/06/2022 07:20: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 ( '58629' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 06/06/2022 07:20: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 ( '58629' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17005' AND id_supplier = '' 06/06/2022 07:20:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17005' , '' , '1' ) 06/06/2022 07:20: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 ( '58629' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/06/2022 07:20:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17004' AND id_supplier = '' 06/06/2022 07:20:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17004' , '' , '1' ) 06/06/2022 07:41:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '17' AND id_document != '58619' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-06-06') 06/06/2022 07:41:26 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '17', document_date = '2022-06-06', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'CARTA D\'IDENTITA\' ARRIVERA\' DIRETTAMENTE DA VELAR', 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 = '2274.00', price_tax_excluded = '2274.00', date_upd = NOW() WHERE id_document = '58619' 06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58619' 06/06/2022 07:41:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '58619' 06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '320' , '-320' , '4' , '1.6000' , '1.6' , '0' , '0' , '512.00' ) 06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11104' AND id_supplier = '' 06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11104' , '' , '1' ) 06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '12355' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. CENA' , '320' , '-320' , '4' , '1.6000' , '1.6' , '0' , '0' , '512.00' ) 06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12355' AND id_supplier = '' 06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12355' , '' , '1' ) 06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '17861' , 'CARTA D\'IDENTITA\' DELLA CHIESA - R. LUPI' , '100' , '-100' , '4' , '2.5000' , '2.5' , '0' , '0' , '250.00' ) 06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17861' AND id_supplier = '' 06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17861' , '' , '1' ) 06/06/2022 07:41:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58619' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '50' , '-50' , '4' , '20.00' , '20' , '0' , '0' , '1000.00' ) 06/06/2022 07:41:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19562' AND id_supplier = '' 06/06/2022 07:41:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19562' , '' , '1' )