15/02/2023 08:39:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2598/00/2023' , '2023-02-13' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '150.00' , '150.00' , NOW() , NOW() ) 15/02/2023 08:39:32 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 = '81363' 15/02/2023 08:39:32 am >> DELETE FROM ps_document_detail WHERE id_document = '81363' 15/02/2023 08:39:32 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 ( '81363' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '50' , '50' , '4' , '5.00' , '5' , '0' , '40' , '150.0000' ) 15/02/2023 08:39:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '20592' AND id_supplier = '38' 15/02/2023 08:39:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20592' , '38' , '1' ) 15/02/2023 09:48:06 am >> SELECT document_num FROM ps_document WHERE document_num = '521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 09:48:06 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' , '521' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '139.40' , '118.53' , NOW() , NOW() ) 15/02/2023 09:48:06 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 = '81364' 15/02/2023 09:48:06 am >> DELETE FROM ps_document_detail WHERE id_document = '81364' 15/02/2023 09:48:06 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 ( '81364' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 15/02/2023 09:48:06 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 ( '81364' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 15/02/2023 09:48:06 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 ( '81364' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '54' , '44.262295081967' , '22' , '0' , '54.00' ) 15/02/2023 09:48:06 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 ( '81364' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 15/02/2023 09:48:06 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 ( '81364' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 15/02/2023 09:48:06 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 ( '81364' , '15228' , 'AMORE CROCIFISSO - V. LOPANO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 15/02/2023 09:48:06 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 ( '81364' , '20660' , 'QUARESIMA E PASQUA ' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 15/02/2023 09:48:06 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 ( '81364' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 15/02/2023 09:48:58 am >> SELECT document_num FROM ps_document WHERE document_num = '522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 09:48:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '522' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '270.00' , '221.31' , NOW() , NOW() ) 15/02/2023 09:48: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 = '81365' 15/02/2023 09:48:58 am >> DELETE FROM ps_document_detail WHERE id_document = '81365' 15/02/2023 09:48:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81365' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 15/02/2023 09:49:10 am >> DELETE FROM ps_document WHERE id_document = '77272' 15/02/2023 09:49:10 am >> DELETE FROM ps_document_detail WHERE id_document = '77272' 15/02/2023 09:59:24 am >> DELETE FROM ps_product WHERE id_product = '3948' 15/02/2023 09:59:24 am >> DELETE FROM ps_product_shop WHERE id_product = '3948' 15/02/2023 09:59:24 am >> DELETE FROM ps_product_lang WHERE id_product = '3948' 15/02/2023 09:59:24 am >> DELETE FROM ps_stock_available WHERE id_product = '3948' 15/02/2023 09:59:36 am >> DELETE FROM ps_product WHERE id_product = '8763' 15/02/2023 09:59:36 am >> DELETE FROM ps_product_shop WHERE id_product = '8763' 15/02/2023 09:59:36 am >> DELETE FROM ps_product_lang WHERE id_product = '8763' 15/02/2023 09:59:36 am >> DELETE FROM ps_stock_available WHERE id_product = '8763' 15/02/2023 10:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 10:12:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '523' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.50' , '38.93' , NOW() , NOW() ) 15/02/2023 10:12:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81366' 15/02/2023 10:12:37 am >> DELETE FROM ps_document_detail WHERE id_document = '81366' 15/02/2023 10:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81366' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 15/02/2023 10:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81366' , '20027' , 'CANDELA ALTARE 20X500' , '2' , '-2' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '4.00' ) 15/02/2023 10:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81366' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 15/02/2023 10:12:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81366' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/02/2023 11:00:33 am >> SELECT document_num FROM ps_document WHERE document_num = '524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:00:33 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' , '524' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.25' , '9.25' , NOW() , NOW() ) 15/02/2023 11:00:33 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 = '81367' 15/02/2023 11:00:33 am >> DELETE FROM ps_document_detail WHERE id_document = '81367' 15/02/2023 11:00:33 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 ( '81367' , '17034' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 15/02/2023 11:00:33 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 ( '81367' , '20683' , 'TI RACCONTO LA PASQUA' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/02/2023 11:00:33 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 ( '81367' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/02/2023 11:01:23 am >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:01:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '23/A' , '2023-02-15' , 'A' , '189' , '0' , '4677907' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '178.56' , '178.56' , NOW() , NOW() ) 15/02/2023 11:01:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81368' 15/02/2023 11:01:23 am >> DELETE FROM ps_document_detail WHERE id_document = '81368' 15/02/2023 11:01:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81368' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' , '2.40' , '2.4' , '0' , '38' , '178.56' ) 15/02/2023 11:04:47 am >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '81368' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:04:47 am >> UPDATE ps_document SET id_document_type = '24', document_num = '23/A', document_date = '2023-02-15', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4677907', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '10', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '188.56', price_tax_excluded = '188.56', date_upd = NOW() WHERE id_document = '81368' 15/02/2023 11:04:47 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 = '81368' 15/02/2023 11:04:47 am >> DELETE FROM ps_document_detail WHERE id_document = '81368' 15/02/2023 11:04:47 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 ( '81368' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' , '2.40' , '2.4' , '0' , '38' , '178.56' ) 15/02/2023 11:31:01 am >> SELECT document_num FROM ps_document WHERE document_num = '525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:31:01 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' , '525' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 15/02/2023 11:31:01 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 = '81369' 15/02/2023 11:31:01 am >> DELETE FROM ps_document_detail WHERE id_document = '81369' 15/02/2023 11:31:01 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 ( '81369' , '16408' , 'AMPOLLE DORATE CON BECCUCCIO - 1503' , '1' , '-1' , '1' , '78.00' , '63.934426229508' , '22' , '0' , '78.00' ) 15/02/2023 11:38:01 am >> SELECT document_num FROM ps_document WHERE document_num = '526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:38:01 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' , '526' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 15/02/2023 11:38:01 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 = '81370' 15/02/2023 11:38:01 am >> DELETE FROM ps_document_detail WHERE id_document = '81370' 15/02/2023 11:38:01 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 ( '81370' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/02/2023 11:55:42 am >> SELECT document_num FROM ps_document WHERE document_num = '527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 11:55:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '527' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 15/02/2023 11:55:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81371' 15/02/2023 11:55:42 am >> DELETE FROM ps_document_detail WHERE id_document = '81371' 15/02/2023 11:55:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81371' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/02/2023 12:09:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '81368' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 12:09:04 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '23/A', document_date = '2023-02-15', document_letter = 'A', id_customer = '189', id_supplier = '', id_address = '4677907', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = 'spedito', price_shipping = '10.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 = '188.56', price_tax_excluded = '188.56', date_upd = NOW() WHERE id_document = '81368' 15/02/2023 12:09:04 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 = '81368' 15/02/2023 12:09:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '81368' 15/02/2023 12:09:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81368' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '120' , '-120' , '4' , '2.4000' , '2.4' , '0' , '38' , '178.56' ) 15/02/2023 12:09:33 pm >> DELETE FROM ps_document WHERE id_document = '78246' 15/02/2023 12:09:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '78246' 15/02/2023 12:10:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '416' AND id_document != '81231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-04') 15/02/2023 12:10:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '416', document_date = '2023-02-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 = '590.00', price_tax_excluded = '510.30', date_upd = NOW() WHERE id_document = '81231' 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81231' 15/02/2023 12:10:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '81231' 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '14000' , 'GALATEO IN CHIESA' , '15' , '-15' , '4' , '1.0000' , '1' , '0' , '0' , '15.00' ) 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '1041' , 'BENEDIZIONI' , '200' , '-200' , '1' , '0.1800' , '0.14754098360656' , '22' , '0' , '36.00' ) 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '2722' , 'COPRI AMBONE FIGLIOL PRODIGO' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 15/02/2023 12:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '13928' , 'COPRILEGGIO - 315/TP' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 15/02/2023 12:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '14214' , 'CASULA IN POLIESTERE ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 15/02/2023 12:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 15/02/2023 12:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '19607' , 'CLERGY F/F COTONE ML ' , '1' , '-1' , '1' , '31.0000' , '25.409836065574' , '22' , '0' , '31.00' ) 15/02/2023 12:10:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81231' , '15210' , 'CERO PASQUALE API 80X120' , '1' , '-1' , '1' , '85.00' , '69.672131147541' , '22' , '0' , '85.00' ) 15/02/2023 12:35:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821597978' AND id_product != '4487' AND ean13 != '' 15/02/2023 12:35:58 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/6', ean13 = '9788821597978', date_upd = NOW() WHERE id_product = '4487' 15/02/2023 12:35:58 pm >> UPDATE ps_product_lang SET name = 'GESÙ NEL CUORE - ALBUM PRIMA COMUNIONE', description = '' WHERE id_product = '4487' 15/02/2023 12:35:58 pm >> UPDATE ps_product SET wholesale_price = '8.39', on_sale = '0', price = '12.9000' WHERE id_product = '4487' 15/02/2023 12:35:58 pm >> UPDATE ps_product_shop SET wholesale_price = '8.39', price = '12.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4487' 15/02/2023 12:35:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '4487' 15/02/2023 12:36:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892215603' AND id_product != '14452' AND ean13 != '' 15/02/2023 12:36:22 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/6', ean13 = '9788892215603', date_upd = NOW() WHERE id_product = '14452' 15/02/2023 12:36:22 pm >> UPDATE ps_product_lang SET name = 'COLORI STAGIONI E ANIMALI', description = '' WHERE id_product = '14452' 15/02/2023 12:36:22 pm >> UPDATE ps_product SET wholesale_price = '2.54', on_sale = '0', price = '3.9000' WHERE id_product = '14452' 15/02/2023 12:36:22 pm >> UPDATE ps_product_shop SET wholesale_price = '2.54', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14452' 15/02/2023 12:36:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '14452' 15/02/2023 12:57:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '24/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 12:57:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '24/A' , '2023-02-15' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , 'acconto € 550' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1060.00' , '868.85' , NOW() , NOW() ) 15/02/2023 12:57:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81372' 15/02/2023 12:57:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '81372' 15/02/2023 12:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81372' , '12296' , 'CASULA 100% POLIESTERE ' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 15/02/2023 12:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81372' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '2' , '-2' , '1' , '385' , '315.5737704918' , '22' , '0' , '770.00' ) 15/02/2023 12:57:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81372' , '20273' , 'CASULA IHS - 220' , '2' , '-2' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '140.00' ) 15/02/2023 12:59:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 12:59:51 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' , '528' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '535.00' , '438.52' , NOW() , NOW() ) 15/02/2023 12:59:51 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 = '81373' 15/02/2023 12:59:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '81373' 15/02/2023 12:59:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81373' , '12296' , 'CASULA 100% POLIESTERE ' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 15/02/2023 12:59:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81373' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '1' , '-1' , '1' , '385' , '315.5737704918' , '22' , '0' , '385.00' ) 15/02/2023 01:00:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '24/A' AND id_document != '81372' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 01:00:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '24/A', document_date = '2023-02-15', document_letter = 'A', id_customer = '3030', id_supplier = '', id_address = '4671709', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO', address2 = '', note = 'acconto € 15,00', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '910.00', price_tax_excluded = '745.90', date_upd = NOW() WHERE id_document = '81372' 15/02/2023 01:00: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 = '81372' 15/02/2023 01:00:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '81372' 15/02/2023 01:00: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 ( '81372' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '2' , '-2' , '1' , '385.0000' , '315.5737704918' , '22' , '0' , '770.00' ) 15/02/2023 01:00: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 ( '81372' , '20273' , 'CASULA IHS - 220' , '2' , '-2' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '140.00' ) 15/02/2023 01:02:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 01:02:31 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' , '529' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.50' , '40.57' , NOW() , NOW() ) 15/02/2023 01:02:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81374' 15/02/2023 01:02:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '81374' 15/02/2023 01:02: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 ( '81374' , '6811' , 'MOCCOLO 80X200' , '3' , '-3' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '27.00' ) 15/02/2023 01:02: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 ( '81374' , '19150' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 15/02/2023 03:24:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 03:24:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '530' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 15/02/2023 03:24:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81375' 15/02/2023 03:24:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '81375' 15/02/2023 03:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81375' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 15/02/2023 03:24:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81375' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 15/02/2023 03:24:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 03:24: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' , '531' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.42' , '26.42' , NOW() , NOW() ) 15/02/2023 03:24: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 = '81376' 15/02/2023 03:24:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '81376' 15/02/2023 03:24: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 ( '81376' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 15/02/2023 03:24:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81376' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 15/02/2023 03:24:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81376' , '20653' , 'INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 15/02/2023 03:41:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 03:41:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '532' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '33.05' , NOW() , NOW() ) 15/02/2023 03:41:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81377' 15/02/2023 03:41:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '81377' 15/02/2023 03:41:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81377' , '7503' , 'PAPA GIOVANNI' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '5' , '9.41' ) 15/02/2023 03:41:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81377' , '6579' , 'MESSIA - DVD' , '1' , '-1' , '1' , '14.90' , '12.213114754098' , '22' , '5' , '14.16' ) 15/02/2023 03:41:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81377' , '13687' , 'JESUS - THE BIBLE COLLECTION' , '1' , '-1' , '1' , '9.90' , '8.1147540983607' , '22' , '5' , '9.41' ) 15/02/2023 03:41:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81377' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '6.02' , '6.02' , '0' , '0' , '6.02' ) 15/02/2023 05:19:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 05:19:46 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' , '533' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 15/02/2023 05:19:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81378' 15/02/2023 05:19:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '81378' 15/02/2023 05:19:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81378' , '19309' , 'CROCE ULIVO PRIMA COMUNIONE - 1328' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 15/02/2023 05:39:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 05:39:00 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' , '534' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.41' , '9.41' , NOW() , NOW() ) 15/02/2023 05:39:00 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 = '81379' 15/02/2023 05:39:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81379' 15/02/2023 05:39:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81379' , '1090' , 'BIBBIA' , '1' , '-1' , '4' , '9.90' , '9.9' , '0' , '5' , '9.41' ) 15/02/2023 05:40:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 05:40:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '535' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 15/02/2023 05:40:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81380' 15/02/2023 05:40:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81380' 15/02/2023 05:40:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81380' , '15839' , 'PICCOLO PRINCIPE COMMENTATO PAPA FRANCESCO' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 15/02/2023 06:39:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 06:39:41 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' , '536' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 15/02/2023 06:39:41 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 = '81381' 15/02/2023 06:39:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '81381' 15/02/2023 06:39:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81381' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 15/02/2023 06:55:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-15') 15/02/2023 06:55:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '537' , '2023-02-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 15/02/2023 06:55:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81382' 15/02/2023 06:55:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '81382' 15/02/2023 06:55:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81382' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' )