22/06/2023 09:32:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2151' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 09:32:18 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' , '2151' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 22/06/2023 09:32:18 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 = '86460' 22/06/2023 09:32:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86460' 22/06/2023 09:32:18 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 ( '86460' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 22/06/2023 09:32:18 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 ( '86460' , '19881' , 'CROCE CM 47 VETRO/ARGENTO - 4977/837' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 22/06/2023 09:44:58 am >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '86402' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-17') 22/06/2023 09:44:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2023-06-17', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '129.90', price_tax_excluded = '107.82', date_upd = NOW() WHERE id_document = '86402' 22/06/2023 09:44: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 = '86402' 22/06/2023 09:44:58 am >> DELETE FROM ps_document_detail WHERE id_document = '86402' 22/06/2023 09:44: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 ( '86402' , '19311' , 'BRACCIALE MADREPERLA COMUNIONE - 1906/K126' , '17' , '-17' , '1' , '2.8000' , '2.2950819672131' , '22' , '0' , '47.60' ) 22/06/2023 09:44: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 ( '86402' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '20.80' ) 22/06/2023 09:44: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 ( '86402' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '14.5000' , '11.885245901639' , '22' , '0' , '14.50' ) 22/06/2023 09:44: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 ( '86402' , '15097' , 'CORONA MATRIMONIO - ORO' , '5' , '-5' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '37.50' ) 22/06/2023 09:44: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 ( '86402' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/06/2023 09:44: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 ( '86402' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 22/06/2023 09:45:45 am >> SELECT document_num FROM ps_document WHERE document_num = '2152' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 09:45:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2152' , '2023-06-22' , '' , '0' , '0' , '0' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '129.90' , '107.82' , NOW() , NOW() ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86461' 22/06/2023 09:45:45 am >> DELETE FROM ps_document_detail WHERE id_document = '86461' 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '19311' , 'BRACCIALE MADREPERLA COMUNIONE - 1906/K126' , '17' , '-17' , '1' , '2.8000' , '2.2951' , '22' , '0' , '47.60' ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.3000' , '1.0656' , '22' , '0' , '20.80' ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '15028' , 'ROSARIO CRISTALLO E ARGENTO - 17800' , '1' , '-1' , '1' , '14.5000' , '11.8852' , '22' , '0' , '14.50' ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '15097' , 'CORONA MATRIMONIO - ORO' , '5' , '-5' , '1' , '7.5000' , '6.1475' , '22' , '0' , '37.50' ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 22/06/2023 09:45:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86461' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9231' , '4' , '0' , '6.00' ) 22/06/2023 09:46:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2153' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 09:46: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' , '2153' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 22/06/2023 09:46: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 = '86462' 22/06/2023 09:46:44 am >> DELETE FROM ps_document_detail WHERE id_document = '86462' 22/06/2023 09:46: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 ( '86462' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 22/06/2023 09:51:43 am >> SELECT document_num FROM ps_document WHERE document_num = '2154' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 09:51:43 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' , '2154' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 22/06/2023 09:51:43 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 = '86463' 22/06/2023 09:51:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86463' 22/06/2023 09:51:43 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 ( '86463' , '18098' , 'CROCE IN RESINA CM 19 - 3830' , '6' , '-6' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '27.00' ) 22/06/2023 09:51:43 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 ( '86463' , '21184' , 'POLO FILO SCOZIA - M03' , '1' , '-1' , '1' , '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 22/06/2023 09:51:43 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 ( '86463' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 22/06/2023 10:39:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2155' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 10:39:27 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' , '2155' , '2023-06-22' , '' , '0' , '0' , '0' , 'VIA TAVERNA DELLE ROSE 84091 BATTIPAGLIA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '960.00' , '960.00' , NOW() , NOW() ) 22/06/2023 10:39:27 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 = '86464' 22/06/2023 10:39:27 am >> DELETE FROM ps_document_detail WHERE id_document = '86464' 22/06/2023 10:39:27 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 ( '86464' , '19656' , 'VIA CRUCIS 15 STAZIONI - 37X28' , '1' , '-1' , '0' , '960' , '960' , '' , '0' , '960.00' ) 22/06/2023 10:41:46 am >> DELETE FROM ps_document WHERE id_document = '82645' 22/06/2023 10:41:46 am >> DELETE FROM ps_document_detail WHERE id_document = '82645' 22/06/2023 10:48:23 am >> DELETE FROM ps_document WHERE id_document = '86402' 22/06/2023 10:48:23 am >> DELETE FROM ps_document_detail WHERE id_document = '86402' 22/06/2023 11:11:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2156' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 11:11:11 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' , '2156' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 22/06/2023 11:11:11 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 = '86465' 22/06/2023 11:11:11 am >> DELETE FROM ps_document_detail WHERE id_document = '86465' 22/06/2023 11:11:11 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 ( '86465' , '16107' , 'VERGINE MADRE, FIGLIA DEL TUO FIGLIO - L. EPICOCO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 22/06/2023 11:58:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1928' AND id_document != '85678' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-01') 22/06/2023 11:58:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1928', document_date = '2023-06-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '56.21', date_upd = NOW() WHERE id_document = '85678' 22/06/2023 11:58: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 = '85678' 22/06/2023 11:58:56 am >> DELETE FROM ps_document_detail WHERE id_document = '85678' 22/06/2023 11:58: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 ( '85678' , '19560' , 'PERGAMENA 17X25' , '30' , '-30' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '21.00' ) 22/06/2023 11:58: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 ( '85678' , '21035' , 'FILOCALIA - VOL.1' , '1' , '-1' , '4' , '39' , '39' , '0' , '0' , '39.00' ) 22/06/2023 12:08:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2157' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 12:08:43 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' , '2157' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.67' , '48.72' , NOW() , NOW() ) 22/06/2023 12:08:43 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 = '86466' 22/06/2023 12:08:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '86466' 22/06/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86466' , '16905' , 'GIOVANNI PAOLO II - J. RATZINGER' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/06/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86466' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/06/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86466' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/06/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86466' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 22/06/2023 12:08:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86466' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '33' , '27.049180327869' , '22' , '0' , '33.00' ) 22/06/2023 12:11:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '9/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 12:11:05 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' , '9/L' , '2023-06-22' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '67.90' , '57.29' , NOW() , NOW() ) 22/06/2023 12:11:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86467' 22/06/2023 12:11:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86467' 22/06/2023 12:11:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86467' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/06/2023 12:11:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86467' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/06/2023 12:11:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86467' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/06/2023 12:27:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2158' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 12:27:13 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' , '2158' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.10' , '9.10' , NOW() , NOW() ) 22/06/2023 12:27: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 = '86468' 22/06/2023 12:27:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86468' 22/06/2023 12:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86468' , '16772' , 'QUADRO DECORATO ' , '1' , '-1' , '1' , '7.30' , '5.983606557377' , '22' , '0' , '7.30' ) 22/06/2023 12:27:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86468' , '15103' , 'GIROCOLLO - 870/24' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 22/06/2023 12:29:41 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/06/2023 12:29:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21185' , '1' , '' , 'nuovo-prodotto' ) 22/06/2023 12:29:42 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21185' , '1' , '1' , '2' , NOW() , NOW() ) 22/06/2023 12:29:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21185' , '0' , '1' , '0' , '0' ) 22/06/2023 12:30:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851425609' AND id_product != '21185' AND ean13 != '' 22/06/2023 12:30:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/2', ean13 = '9788851425609', date_upd = NOW() WHERE id_product = '21185' 22/06/2023 12:30:30 pm >> UPDATE ps_product_lang SET name = 'RIPORTARE I GIOVANI A MESSA - A. MATTEO', description = '' WHERE id_product = '21185' 22/06/2023 12:30:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '21185' 22/06/2023 12:30:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21185' 22/06/2023 12:30:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21185' 22/06/2023 12:30:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21185' 22/06/2023 12:30:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21186' , '1' , '' , 'nuovo-prodotto' ) 22/06/2023 12:30:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21186' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21185' 22/06/2023 12:30:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21186' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21185' 22/06/2023 12:31:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240698' AND id_product != '21186' AND ean13 != '' 22/06/2023 12:31:21 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892240698', date_upd = NOW() WHERE id_product = '21186' 22/06/2023 12:31:22 pm >> UPDATE ps_product_lang SET name = 'OPZIONE FRANCESCO - A. MATTEO', description = '' WHERE id_product = '21186' 22/06/2023 12:31:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21186' 22/06/2023 12:31:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21186' 22/06/2023 12:31:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '21186' 22/06/2023 12:31:23 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21186' 22/06/2023 12:31:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21187' , '1' , '' , 'nuovo-prodotto' ) 22/06/2023 12:31:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21187' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21186' 22/06/2023 12:31:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21187' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21186' 22/06/2023 12:31: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 ( '33' , '634663' , '2023-06-21' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.47' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.88' , '84.88' , NOW() , NOW() ) 22/06/2023 12:31: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 = '86469' 22/06/2023 12:31:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86469' 22/06/2023 12:31: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 ( '86469' , '3604' , 'DOCUMENTI DEL CONCILIO VATICANO II' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '33' , '11.0550' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3604' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3604' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '15996' , 'TELEMACO NON SI SBAGLIAVA - L. EPICOCO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '33' , '21.4400' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15996' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15996' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '4594' , 'GIORNO IN CUI IO E GESÙ ... - ALBUM COMUNIONE' , '1' , '1' , '4' , '13.50' , '13.5' , '0' , '33' , '9.0450' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4594' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4594' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18261' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18261' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '12995' , 'SALE, NON MIELE - L. EPICOCO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12995' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12995' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '21185' , 'RIPORTARE I GIOVANI A MESSA - A. MATTEO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21185' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21185' , '7' , '1' ) 22/06/2023 12:31: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 ( '86469' , '21186' , 'OPZIONE FRANCESCO - A. MATTEO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/06/2023 12:31:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21186' AND id_supplier = '7' 22/06/2023 12:31:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21186' , '7' , '1' ) 22/06/2023 02:27:06 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '9hyfeCT5HJT9fkim' , NOW() , NOW() ) 22/06/2023 02:27:06 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7052' , '1' ) 22/06/2023 02:27:06 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7052' , '2' ) 22/06/2023 02:27:06 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7052' , '3' ) 22/06/2023 02:28:13 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7052' 22/06/2023 02:28:13 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7052' , '10' , '141' , '' , 'MASCIA' , 'STEFANIA' , 'VIA BENEDETTO CROCE 41' , '' , '09045' , 'QUARTU SANT\'ELENA' , '' , '' , '' , '' , '' , NOW() , NOW() ) 22/06/2023 02:28:13 pm >> UPDATE ps_customer SET email = 'stefaniamascia29@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7052' 22/06/2023 02:33:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 02:33:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '27' , '2023-06-22' , '' , '7052' , '0' , '135353950' , 'VIA BENEDETTO CROCE 41 09045 QUARTU SANT\\\'ELENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '12.00' , '12.00' , NOW() , NOW() ) 22/06/2023 02:33:59 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 = '11344' 22/06/2023 02:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '11344' 22/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11344' , '' , 'FIGURINE' , '30' , '-30' , '0' , '0.3' , '0.3' , '' , '0' , '9.00' ) 22/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11344' , '' , 'SPEDIZIONE' , '1' , '-1' , '0' , '3' , '3' , '' , '0' , '3.00' ) 22/06/2023 03:02:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '977' AND id_document != '82471' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 22/06/2023 03:02:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '977', document_date = '2023-03-25', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '82471' 22/06/2023 03:02:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82471' 22/06/2023 03:02:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82471' 22/06/2023 03:02:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '-1' , '1' , '36' , '29.508196721311' , '22' , '0' , '36.00' ) 22/06/2023 03:02:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/06/2023 03:02:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82471' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '2.8' , '2.2950819672131' , '22' , '0' , '14.00' ) 22/06/2023 03:04:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '973' AND id_document != '82465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-25') 22/06/2023 03:04:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '973', document_date = '2023-03-25', 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 = '58.00', price_tax_excluded = '47.54', date_upd = NOW() WHERE id_document = '82465' 22/06/2023 03:04:29 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 = '82465' 22/06/2023 03:04:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82465' 22/06/2023 03:04:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82465' , '19315' , 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/06/2023 03:04:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82465' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '37' , '-37' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '55.50' ) 22/06/2023 03:45:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2159' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 03:45:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2159' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '117.00' , '117.00' , NOW() , NOW() ) 22/06/2023 03:45:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86470' 22/06/2023 03:45:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '86470' 22/06/2023 03:45:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86470' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '26' , '-26' , '4' , '4.5' , '4.5' , '0' , '0' , '117.00' ) 22/06/2023 04:56:00 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7052' 22/06/2023 04:56:00 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7052' , '10' , '141' , '' , 'MASCIA' , 'STEFANIA' , 'VIA BENEDETTO CROCE 41' , '' , '09045' , 'QUARTU SANT\'ELENA' , '' , '' , '3489220415' , '' , '' , NOW() , NOW() ) 22/06/2023 04:56:00 pm >> UPDATE ps_customer SET email = 'stefaniamascia29@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7052' 22/06/2023 04:57:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2013' AND id_document != '85785' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 22/06/2023 04:57:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2013', document_date = '2023-06-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA ROMA 84020 RICIGLIANO', 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 = '195.00', price_tax_excluded = '195.00', date_upd = NOW() WHERE id_document = '85785' 22/06/2023 04:57:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85785' 22/06/2023 04:57:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '85785' 22/06/2023 04:57:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '140.0000' , '140' , '0' , '5' , '133.00' ) 22/06/2023 04:57:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '5' , '57.00' ) 22/06/2023 04:57:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85785' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 22/06/2023 04:57:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1975' AND id_document != '85736' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-07') 22/06/2023 04:57:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1975', document_date = '2023-06-07', 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 = '73.50', price_tax_excluded = '72.29', date_upd = NOW() WHERE id_document = '85736' 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85736' 22/06/2023 04:57:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '85736' 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '18748' , 'OSTIA MAGNA 125mm' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/06/2023 04:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '17581' , 'MESSALE QUOTIDIANO N.E. ' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '5' , '37.05' ) 22/06/2023 04:57:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85736' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '4.95' , '4.95' , '0' , '0' , '4.95' ) 22/06/2023 05:19:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2160' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 05:19:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2160' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '49.70' , NOW() , NOW() ) 22/06/2023 05:19:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86471' 22/06/2023 05:19:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '86471' 22/06/2023 05:19: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 ( '86471' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '10' , '36.00' ) 22/06/2023 05:19: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 ( '86471' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 22/06/2023 06:15:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2161' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 06:15: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 ( '11' , '2161' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '6.20' , NOW() , NOW() ) 22/06/2023 06:15: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 = '86472' 22/06/2023 06:15:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86472' 22/06/2023 06:15: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 ( '86472' , '2528' , 'COMPIETA' , '5' , '-5' , '4' , '1.30' , '1.3' , '0' , '5' , '6.20' ) 22/06/2023 06:18:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2162' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-22') 22/06/2023 06:18:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2162' , '2023-06-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 22/06/2023 06:18:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86473' 22/06/2023 06:18:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '86473' 22/06/2023 06:18:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86473' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' )