31/01/2024 08:19:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2974' AND id_document != '87500' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-30') 31/01/2024 08:19:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2974', document_date = '2023-09-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '130.00', price_tax_excluded = '110.33', date_upd = NOW() WHERE id_document = '87500' 31/01/2024 08:19: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 = '87500' 31/01/2024 08:19:23 am >> DELETE FROM ps_document_detail WHERE id_document = '87500' 31/01/2024 08:19: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 ( '87500' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '4.1' , '3.3606557377049' , '22' , '0' , '4.10' ) 31/01/2024 08:19: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 ( '87500' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 31/01/2024 08:19: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 ( '87500' , '21395' , 'CONVERTIRE LA CATECHESI - AAVV' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/01/2024 08:19: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 ( '87500' , '12849' , 'LIBRO DELLE SS. MESSE' , '7' , '-7' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '105.00' ) 31/01/2024 09:10:33 am >> SELECT document_num FROM ps_document WHERE document_num = '312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 09:10: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' , '312' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 31/01/2024 09:10: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 = '90164' 31/01/2024 09:10:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90164' 31/01/2024 09:10: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 ( '90164' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 31/01/2024 09:38:03 am >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 09:38:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '15/A' , '2024-01-31' , 'A' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '146.60' , '123.00' , NOW() , NOW() ) 31/01/2024 09:38:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90165' 31/01/2024 09:38:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90165' 31/01/2024 09:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90165' , '16796' , 'LUMINO 5F BIANCO' , '336' , '-336' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '100.80' ) 31/01/2024 09:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90165' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 31/01/2024 09:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90165' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/01/2024 09:38:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90165' , '3028' , 'CROCE MET. 3T.OX CM 4,5 - G299 ' , '32' , '-32' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '12.80' ) 31/01/2024 09:38:32 am >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '90165' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 09:38:32 am >> UPDATE ps_document SET id_document_type = '24', document_num = '15/A', document_date = '2024-01-31', document_letter = 'A', id_customer = '1203', id_supplier = '', id_address = '4669427', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', 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 = '316.60', price_tax_excluded = '262.35', date_upd = NOW() WHERE id_document = '90165' 31/01/2024 09:38: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 = '90165' 31/01/2024 09:38:33 am >> DELETE FROM ps_document_detail WHERE id_document = '90165' 31/01/2024 09:38: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 ( '90165' , '16796' , 'LUMINO 5F BIANCO' , '336' , '-336' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '100.80' ) 31/01/2024 09:38: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 ( '90165' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 31/01/2024 09:38: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 ( '90165' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/01/2024 09:38: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 ( '90165' , '3028' , 'CROCE MET. 3T.OX CM 4,5 - G299 ' , '32' , '-32' , '1' , '0.4000' , '0.32786885245902' , '22' , '0' , '12.80' ) 31/01/2024 09:38: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 ( '90165' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 31/01/2024 09:51:15 am >> SELECT document_num FROM ps_document WHERE document_num = '313' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 09:51:15 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' , '313' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.70' , '121.07' , NOW() , NOW() ) 31/01/2024 09:51:15 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 = '90166' 31/01/2024 09:51:15 am >> DELETE FROM ps_document_detail WHERE id_document = '90166' 31/01/2024 09:51:15 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 ( '90166' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2024 09:51:15 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 ( '90166' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 31/01/2024 09:51:15 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 ( '90166' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 31/01/2024 09:51:15 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 ( '90166' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 31/01/2024 10:01:46 am >> SELECT document_num FROM ps_document WHERE document_num = '314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 10:01:46 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' , '314' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '290.00' , '241.61' , NOW() , NOW() ) 31/01/2024 10:01:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90167' 31/01/2024 10:01:46 am >> DELETE FROM ps_document_detail WHERE id_document = '90167' 31/01/2024 10:01:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90167' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '9' , '-9' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '247.50' ) 31/01/2024 10:01:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90167' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '15.00' ) 31/01/2024 10:01:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90167' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 31/01/2024 10:01:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90167' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 31/01/2024 10:38:47 am >> SELECT document_num FROM ps_document WHERE document_num = '315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 10:38:47 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' , '315' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 31/01/2024 10:38: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 = '90168' 31/01/2024 10:38:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90168' 31/01/2024 10:38: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 ( '90168' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/01/2024 10:55:03 am >> SELECT document_num FROM ps_document WHERE document_num = '316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 10:55:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '316' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/01/2024 10:55:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90169' 31/01/2024 10:55:03 am >> DELETE FROM ps_document_detail WHERE id_document = '90169' 31/01/2024 10:55:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90169' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2024 12:03:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '90111' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-26') 31/01/2024 12:03:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '271', document_date = '2024-01-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.85', price_tax_excluded = '21.85', date_upd = NOW() WHERE id_document = '90111' 31/01/2024 12:03: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 = '90111' 31/01/2024 12:03:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90111' 31/01/2024 12:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90111' , '18580' , 'ORAZIONALE PER LA PREGHIERA UNIVERSALE - N.E.' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/01/2024 12:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90111' , '11183' , 'VENITE CON ME - GUIDA' , '1' , '-1' , '4' , '2.1' , '2.1' , '0' , '' , '2.10' ) 31/01/2024 12:03:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90111' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 31/01/2024 12:34:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 12:34:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '317' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 31/01/2024 12:34:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90170' 31/01/2024 12:34:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '90170' 31/01/2024 12:34:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90170' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2024 12:39:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 12:39:50 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' , '318' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '80.00' , NOW() , NOW() ) 31/01/2024 12:39:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90171' 31/01/2024 12:39:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '90171' 31/01/2024 12:39:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90171' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '80' , '80' , '0' , '0' , '80.00' ) 31/01/2024 12:44:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2024 12:44:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22115' , '1' , '' , 'nuovo-prodotto' ) 31/01/2024 12:44:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22115' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2024 12:44:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22115' , '0' , '1' , '0' , '0' ) 31/01/2024 12:45:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608792' AND id_product != '22115' AND ean13 != '' 31/01/2024 12:45:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608792', date_upd = NOW() WHERE id_product = '22115' 31/01/2024 12:45:07 pm >> UPDATE ps_product_lang SET name = 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024', description = '' WHERE id_product = '22115' 31/01/2024 12:45:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.819672131147541' WHERE id_product = '22115' 31/01/2024 12:45:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.819672131147541', id_tax_rules_group = '1', id_category_default = '104', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22115' 31/01/2024 12:45:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22115' 31/01/2024 12:45:08 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 = '22115' 31/01/2024 12:45:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22116' , '1' , '' , 'nuovo-prodotto' ) 31/01/2024 12:45:08 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 '22116' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22115' 31/01/2024 12:45:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22116' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22115' 31/01/2024 12:45:48 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' , '2024-DL000320' , '2024-01-30' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.71' , '5.50' , NOW() , NOW() ) 31/01/2024 12:45:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90172' 31/01/2024 12:45:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90172' 31/01/2024 12:45:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90172' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '10' , '10' , '1' , '1.00' , '0.81967213114754' , '22' , '45' , '6.7100' ) 31/01/2024 12:45:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22115' AND id_supplier = '79' 31/01/2024 12:45:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22115' , '79' , '1' ) 31/01/2024 12:48:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608792' AND id_product != '22115' AND ean13 != '' 31/01/2024 12:48:32 pm >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788826608792', date_upd = NOW() WHERE id_product = '22115' 31/01/2024 12:48:32 pm >> UPDATE ps_product_lang SET name = 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024', description = '' WHERE id_product = '22115' 31/01/2024 12:48:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1' WHERE id_product = '22115' 31/01/2024 12:48:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22115' 31/01/2024 12:48:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22115' 31/01/2024 12:49:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024FV000112' , '2024-01-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '21' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '587.13' , '587.13' , NOW() , NOW() ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90173' 31/01/2024 12:49:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90173' 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '5' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '21.00' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17526' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17526' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '18580' , 'ORAZIONALE PER LA PREGHIERA UNIVERSALE - N.E.' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18580' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18580' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '11193' , 'VENITE CON ME CAT.' , '50' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '192.50' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '50' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '192.50' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17862' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17862' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.5000' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '22111' , 'PREGARE OGGI' , '3' , '0' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 31/01/2024 12:49:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22111' AND id_supplier = '79' 31/01/2024 12:49:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22111' , '79' , '1' ) 31/01/2024 12:49:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '2' , '0' , '4' , '35.0000' , '35' , '0' , '35' , '45.50' ) 31/01/2024 12:49:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22112' AND id_supplier = '79' 31/01/2024 12:49:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22112' , '79' , '1' ) 31/01/2024 12:49:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 31/01/2024 12:49:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3544' AND id_supplier = '79' 31/01/2024 12:49:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3544' , '79' , '1' ) 31/01/2024 12:49:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90173' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '10' , '0' , '4' , '1.00' , '1' , '0' , '45' , '5.5000' ) 31/01/2024 12:49:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22115' AND id_supplier = '79' 31/01/2024 12:49:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22115' , '79' , '1' ) 31/01/2024 12:50:15 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2024-DL000320', document_date = '2024-01-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', 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 = '5.50', price_tax_excluded = '5.50', date_upd = NOW() WHERE id_document = '90172' 31/01/2024 12:50: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 = '90172' 31/01/2024 12:50:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90172' 31/01/2024 12:50: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 ( '90172' , '22115' , 'ATTRAVERSO IL DESERTO - MESSAGGIO QUARESIMA 2024' , '10' , '10' , '4' , '1.00' , '1' , '0' , '45' , '5.5000' ) 31/01/2024 12:50:40 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '2024-DL000250', document_date = '2024-01-25', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', 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 = '135.13', price_tax_excluded = '135.13', date_upd = NOW() WHERE id_document = '90115' 31/01/2024 12:50: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 = '90115' 31/01/2024 12:50:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '90115' 31/01/2024 12:50: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 ( '90115' , '17862' , 'DALLINFORMATICA AL CIELO C. ACUTIS - N. GORI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/01/2024 12:50: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 ( '90115' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '2' , '4' , '30.0000' , '30' , '0' , '35' , '39.00' ) 31/01/2024 12:50: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 ( '90115' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '30' , '24.5000' ) 31/01/2024 12:50: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 ( '90115' , '22111' , 'PREGARE OGGI' , '3' , '3' , '4' , '8.5000' , '8.5' , '0' , '45' , '14.03' ) 31/01/2024 12:50: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 ( '90115' , '22112' , 'LITURGIA DELLE ORE VOL. III - N.E.' , '2' , '2' , '4' , '35.0000' , '35' , '0' , '35' , '45.50' ) 31/01/2024 12:50: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 ( '90115' , '3544' , 'DIRETTORIO OMILETICO' , '1' , '1' , '4' , '10.0000' , '10' , '0' , '45' , '5.50' ) 31/01/2024 03:57:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 03:57: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' , '319' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 31/01/2024 03:57: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 = '90174' 31/01/2024 03:57:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90174' 31/01/2024 03:57: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 ( '90174' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/01/2024 04:01:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 04:01: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' , '320' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 31/01/2024 04:01: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 = '90175' 31/01/2024 04:01:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90175' 31/01/2024 04:01: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 ( '90175' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2024 04:29:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 04:29:26 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' , '321' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '115.57' , NOW() , NOW() ) 31/01/2024 04:29:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90176' 31/01/2024 04:29:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90176' 31/01/2024 04:29:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90176' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '10' , '10' , '0' , '0' , '100.00' ) 31/01/2024 04:29:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90176' , '9452' , 'SAN GIOVANNI BOSCO - 50' , '5' , '-5' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '19.00' ) 31/01/2024 04:30:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 04:30:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '322' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 31/01/2024 04:30:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90177' 31/01/2024 04:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '90177' 31/01/2024 04:30:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90177' , '3631' , 'DON BOSCO - T. BOSCO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2024 04:43:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 04:43: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' , '323' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.50' , '80.94' , NOW() , NOW() ) 31/01/2024 04:43: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 = '90178' 31/01/2024 04:43:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '90178' 31/01/2024 04:43: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 ( '90178' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/01/2024 04:43: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 ( '90178' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/01/2024 04:43: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 ( '90178' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 31/01/2024 04:43: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 ( '90178' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '1' , '-1' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '17.50' ) 31/01/2024 04:43: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 ( '90178' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 31/01/2024 04:43: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 ( '90178' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '12' , '-12' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '42.00' ) 31/01/2024 05:00:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2024010000134' , '2024-01-31' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '13.28' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '403.93' , '402.16' , NOW() , NOW() ) 31/01/2024 05:00: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 = '90179' 31/01/2024 05:00:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90179' 31/01/2024 05:00: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 ( '90179' , '21461' , 'PAROLA PER OGGI 2024' , '4' , '0' , '1' , '2.8689' , '2.3515573770492' , '22' , '30' , '9.8002' ) 31/01/2024 05:00:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21461' AND id_supplier = '107' 31/01/2024 05:00:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21461' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22043' , 'MATTEO - R. FABRIS' , '2' , '0' , '4' , '48.0000' , '48' , '0' , '35' , '62.40' ) 31/01/2024 05:00:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22043' AND id_supplier = '107' 31/01/2024 05:00:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22043' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22044' , 'GIOVANNI - R.E. BROWN' , '2' , '0' , '4' , '66.5000' , '66.5' , '0' , '35' , '86.45' ) 31/01/2024 05:00:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22044' AND id_supplier = '107' 31/01/2024 05:00:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22044' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '2' , '0' , '4' , '32.0000' , '32' , '0' , '30' , '44.80' ) 31/01/2024 05:00:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 31/01/2024 05:00:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '18312' , 'ANCORA NON AVETE FEDE? ANNO B - E. DELLA CORTE' , '1' , '0' , '4' , '27.0000' , '27' , '0' , '35' , '17.55' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18312' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18312' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '19.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21467' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21467' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '5.85' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22056' , 'E IO VI RISTORERO - M. ZUPPI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22056' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22056' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22057' , 'SEQUELA CHRISTI - C.M. MARTINI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22057' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22057' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '21760' , 'QUANDO LAMORE E PER SEMPRE - B. BAFFETTI' , '5' , '0' , '4' , '9.0000' , '9' , '0' , '35' , '29.25' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21760' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21760' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22042' , 'ARTE DI CELEBRARE LEUCARISTIA - AROCENA/PORTOLES' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '35' , '26.00' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22042' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22042' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22058' , 'TEOLOGIA LITURGICA DEI SACRAMENTI - A. MIRALLES' , '1' , '0' , '4' , '30.0000' , '30' , '0' , '35' , '19.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22058' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22058' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22059' , 'CREARE CASA - SUSSIDIO' , '3' , '0' , '4' , '4.0000' , '4' , '0' , '35' , '7.80' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22059' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22059' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22060' , 'CREARE CASA - IMMAGINETTE' , '100' , '0' , '4' , '0.1000' , '0.1' , '0' , '35' , '6.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22060' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22060' , '107' , '1' ) 31/01/2024 05:00: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 ( '90179' , '22061' , 'FEDE DI ABRAMO E FEDE CRISTIANA - F. MOSETTO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/01/2024 05:00:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22061' AND id_supplier = '107' 31/01/2024 05:00:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22061' , '107' , '1' ) 31/01/2024 05:00:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90179' , '22062' , 'SOSTENERE LE RAGIONI DELLA FEDE - S. GUSTAVSSON' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 31/01/2024 05:00:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22062' AND id_supplier = '107' 31/01/2024 05:00:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22062' , '107' , '1' ) 31/01/2024 05:06:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 05:06:18 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' , '324' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 31/01/2024 05:06:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90180' 31/01/2024 05:06:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '90180' 31/01/2024 05:06:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90180' , '9129' , 'ROSARIO LEGNO - T/2' , '5' , '-5' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '9.00' ) 31/01/2024 05:22:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002130' AND id_product != '20955' AND ean13 != '' 31/01/2024 05:22:26 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '002130', date_upd = NOW() WHERE id_product = '20955' 31/01/2024 05:22:26 pm >> UPDATE ps_product_lang SET name = 'CASULA LANA RICAMO ORNATO IHS - 6847L', description = '' WHERE id_product = '20955' 31/01/2024 05:22:26 pm >> UPDATE ps_product SET wholesale_price = '340.00', on_sale = '0', price = '696.7213114754098' WHERE id_product = '20955' 31/01/2024 05:22:26 pm >> UPDATE ps_product_shop SET wholesale_price = '340.00', price = '696.7213114754098', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20955' 31/01/2024 05:22:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '20955' 31/01/2024 06:11:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 06:11:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '325' , '2024-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 31/01/2024 06:11:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90181' 31/01/2024 06:11:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90181' 31/01/2024 06:11:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90181' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 31/01/2024 07:38:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '90153' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-30') 31/01/2024 07:38:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2024-01-30', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '65.00', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '90153' 31/01/2024 07:38: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 = '90153' 31/01/2024 07:38:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90153' 31/01/2024 07:38: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 ( '90153' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 31/01/2024 07:39:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '325' AND id_document != '90181' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-31') 31/01/2024 07:39:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '325', document_date = '2024-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.50', price_tax_excluded = '3.50', date_upd = NOW() WHERE id_document = '90181' 31/01/2024 07:39:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90181' 31/01/2024 07:39:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '90181' 31/01/2024 07:39: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 ( '90181' , '18051' , 'MIA BIBBIA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 31/01/2024 07:39: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 ( '90181' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 31/01/2024 07:42:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/E' AND id_document != '90119' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-26') 31/01/2024 07:42:33 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '2/E', document_date = '2024-01-26', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '816.00', price_tax_excluded = '668.85', date_upd = NOW() WHERE id_document = '90119' 31/01/2024 07:42:33 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 = '90119' 31/01/2024 07:42:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '90119' 31/01/2024 07:42:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 31/01/2024 07:42:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 31/01/2024 07:42:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '20' , '-20' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '240.00' ) 31/01/2024 07:44:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2/E' AND id_document != '90119' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-26') 31/01/2024 07:44:39 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '2/E', document_date = '2024-01-26', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '816.00', price_tax_excluded = '668.85', date_upd = NOW() WHERE id_document = '90119' 31/01/2024 07:44: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 = '90119' 31/01/2024 07:44:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90119' 31/01/2024 07:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 31/01/2024 07:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 31/01/2024 07:44:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90119' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '20' , '-20' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '240.00' )