01/02/2025 08:03:53 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'gixcJtSmWseNzTV7' , NOW() , NOW() ) 01/02/2025 08:03:53 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4161' , '1' ) 01/02/2025 08:03:53 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4161' , '2' ) 01/02/2025 08:03:53 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4161' , '3' ) 01/02/2025 08:06:02 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4161' 01/02/2025 08:06:02 am >> 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 ( '4161' , '10' , '192' , '' , 'RAMELLA' , 'CARLO GIUSEPPE MARIA' , 'VIA G. OBERDAN 35' , '' , '27029' , 'VIGEVANO' , '' , '' , '3396833573' , '' , '' , NOW() , NOW() ) 01/02/2025 08:06:02 am >> UPDATE ps_customer SET email = 'carlo_acquisti@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4161' 01/02/2025 08:07:05 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 08:07:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '22' , '2025-02-01' , '' , '4161' , '0' , '4679461' , 'VIA G. OBERDAN 35 27029 VIGEVANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.75' , '80.75' , NOW() , NOW() ) 01/02/2025 08:07:05 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 = '95544' 01/02/2025 08:07:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95544' 01/02/2025 08:07:05 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 ( '95544' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:05 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 ( '95544' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:05 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 ( '95544' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:05 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 ( '95544' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 01/02/2025 08:07:37 am >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '95544' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 08:07:38 am >> UPDATE ps_document SET id_document_type = '21', document_num = '22', document_date = '2025-02-01', document_letter = '', id_customer = '4161', id_supplier = '', id_address = '4679461', address1 = 'VIA G. OBERDAN 35 27029 VIGEVANO', 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 = '80.75', price_tax_excluded = '80.75', date_upd = NOW() WHERE id_document = '95544' 01/02/2025 08:07:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95544' 01/02/2025 08:07:38 am >> DELETE FROM ps_document_detail WHERE id_document = '95544' 01/02/2025 08:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 01/02/2025 08:07:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95544' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 01/02/2025 09:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '344' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 09:08:08 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' , '344' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.90' , '17.95' , NOW() , NOW() ) 01/02/2025 09:08:08 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 = '95545' 01/02/2025 09:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '95545' 01/02/2025 09:08:08 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 ( '95545' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 01/02/2025 09:08:08 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 ( '95545' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 01/02/2025 09:34:25 am >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '95483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 01/02/2025 09:34:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '296', document_date = '2025-01-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '95483' 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95483' 01/02/2025 09:34:25 am >> DELETE FROM ps_document_detail WHERE id_document = '95483' 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.8000' , '16.229508196721' , '22' , '0' , '19.80' ) 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/02/2025 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.8' , '4.7540983606557' , '22' , '0' , '5.80' ) 01/02/2025 09:44:22 am >> SELECT document_num FROM ps_document WHERE document_num = '345' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 09:44:22 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' , '345' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.20' , '14.10' , NOW() , NOW() ) 01/02/2025 09:44:22 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 = '95546' 01/02/2025 09:44:22 am >> DELETE FROM ps_document_detail WHERE id_document = '95546' 01/02/2025 09:44:22 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 ( '95546' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 01/02/2025 09:44: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 ( '95546' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 01/02/2025 10:14:05 am >> SELECT document_num FROM ps_document WHERE document_num = '346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:14:05 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' , '346' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '7.15' , NOW() , NOW() ) 01/02/2025 10:14:05 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 = '95547' 01/02/2025 10:14:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95547' 01/02/2025 10:14:05 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 ( '95547' , '20028' , 'CANDELA ALTARE 26X350' , '3' , '-3' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '7.50' ) 01/02/2025 10:14:05 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 ( '95547' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 01/02/2025 10:27:26 am >> SELECT document_num FROM ps_document WHERE document_num = '347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:27:26 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' , '347' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 01/02/2025 10:27:26 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 = '95548' 01/02/2025 10:27:26 am >> DELETE FROM ps_document_detail WHERE id_document = '95548' 01/02/2025 10:27:26 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 ( '95548' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 01/02/2025 10:34:21 am >> SELECT document_num FROM ps_document WHERE document_num = '348' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:34:21 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' , '348' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 01/02/2025 10:34:21 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 = '95549' 01/02/2025 10:34:21 am >> DELETE FROM ps_document_detail WHERE id_document = '95549' 01/02/2025 10:34:21 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 ( '95549' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 01/02/2025 10:35:57 am >> SELECT document_num FROM ps_document WHERE document_num = '349' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:35:57 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' , '349' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '152.00' , '124.59' , NOW() , NOW() ) 01/02/2025 10:35:57 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 = '95550' 01/02/2025 10:35:57 am >> DELETE FROM ps_document_detail WHERE id_document = '95550' 01/02/2025 10:35:57 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 ( '95550' , '14021' , 'CINGOLO - CING08' , '2' , '-2' , '1' , '26' , '21.311475409836' , '22' , '0' , '52.00' ) 01/02/2025 10:35:57 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 ( '95550' , '23336' , 'DALMATICA - PDA004' , '1' , '-1' , '1' , '100.00' , '81.967213114754' , '22' , '0' , '100.00' ) 01/02/2025 10:38:15 am >> SELECT document_num FROM ps_document WHERE document_num = '350' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:38: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' , '350' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.60' , NOW() , NOW() ) 01/02/2025 10:38: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 = '95551' 01/02/2025 10:38:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95551' 01/02/2025 10:38: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 ( '95551' , '22698' , 'CALENDARIO LITURGICO 2025' , '2' , '-2' , '4' , '0.80' , '0.8' , '0' , '0' , '1.60' ) 01/02/2025 10:43:39 am >> SELECT document_num FROM ps_document WHERE document_num = '351' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:43:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '351' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 01/02/2025 10:43:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95552' 01/02/2025 10:43:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95552' 01/02/2025 10:43:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95552' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '2' , '-2' , '4' , '16.00' , '16' , '0' , '5' , '30.40' ) 01/02/2025 10:44:33 am >> SELECT document_num FROM ps_document WHERE document_num = '352' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 10:44: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' , '352' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 01/02/2025 10:44: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 = '95553' 01/02/2025 10:44:33 am >> DELETE FROM ps_document_detail WHERE id_document = '95553' 01/02/2025 10:44: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 ( '95553' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 01/02/2025 11:12:16 am >> SELECT document_num FROM ps_document WHERE document_num = '353' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:12:16 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' , '353' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.92' , NOW() , NOW() ) 01/02/2025 11:12:16 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 = '95554' 01/02/2025 11:12:16 am >> DELETE FROM ps_document_detail WHERE id_document = '95554' 01/02/2025 11:12:16 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 ( '95554' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 01/02/2025 11:12:16 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 ( '95554' , '21069' , 'MARIA ROSA MISTICA - 8093' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 01/02/2025 11:19:05 am >> SELECT document_num FROM ps_document WHERE document_num = '354' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:19:05 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' , '354' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.56' , '38.31' , NOW() , NOW() ) 01/02/2025 11:19:05 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 = '95555' 01/02/2025 11:19:05 am >> DELETE FROM ps_document_detail WHERE id_document = '95555' 01/02/2025 11:19:05 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 ( '95555' , '18853' , 'BIBBIA IN TASCA' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 01/02/2025 11:19:05 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 ( '95555' , '23355' , 'INSIEME NELLA MESSA - MAR 25' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 01/02/2025 11:19:05 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 ( '95555' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 01/02/2025 11:19:41 am >> DELETE FROM ps_document WHERE id_document = '95431' 01/02/2025 11:19:41 am >> DELETE FROM ps_document_detail WHERE id_document = '95431' 01/02/2025 11:24:46 am >> SELECT document_num FROM ps_document WHERE document_num = '355' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:24: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' , '355' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 01/02/2025 11:24: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 = '95556' 01/02/2025 11:24:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95556' 01/02/2025 11:24: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 ( '95556' , '23344' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2025' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 01/02/2025 11:27:59 am >> SELECT document_num FROM ps_document WHERE document_num = '33/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:27:59 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' , '33/A' , '2025-02-01' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '70.00' , NOW() , NOW() ) 01/02/2025 11:27:59 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 = '95557' 01/02/2025 11:27:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95557' 01/02/2025 11:27: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 ( '95557' , '' , 'CANDELE' , '1' , '-1' , '0' , '70' , '70' , '' , '0' , '70.00' ) 01/02/2025 11:29:39 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:29:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '23' , '2025-02-01' , '' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.56' , '28.56' , NOW() , NOW() ) 01/02/2025 11:29:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95558' 01/02/2025 11:29:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95558' 01/02/2025 11:29:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95558' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '15' , '28.56' ) 01/02/2025 11:32:55 am >> SELECT document_num FROM ps_document WHERE document_num = '356' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:32:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '356' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 01/02/2025 11:32:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95559' 01/02/2025 11:32:55 am >> DELETE FROM ps_document_detail WHERE id_document = '95559' 01/02/2025 11:32:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95559' , '20033' , 'CAMMINO DEL DESIDERIO - G. PICCOLO' , '2' , '-2' , '4' , '16.00' , '16' , '0' , '5' , '30.40' ) 01/02/2025 11:37:11 am >> SELECT document_num FROM ps_document WHERE document_num = '357' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:37: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' , '357' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 01/02/2025 11:37: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 = '95560' 01/02/2025 11:37:11 am >> DELETE FROM ps_document_detail WHERE id_document = '95560' 01/02/2025 11:37: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 ( '95560' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 01/02/2025 11:40:54 am >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '95483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 01/02/2025 11:40:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '296', document_date = '2025-01-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '95483' 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95483' 01/02/2025 11:40:54 am >> DELETE FROM ps_document_detail WHERE id_document = '95483' 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.8000' , '16.229508196721' , '22' , '0' , '19.80' ) 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '17052' , 'CROCETTA S. BENEDETTO METALLO OX CM5X3,3 - PG382' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 01/02/2025 11:40:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95483' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 01/02/2025 11:56:21 am >> SELECT document_num FROM ps_document WHERE document_num = '358' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:56:21 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' , '358' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.50' , '21.72' , NOW() , NOW() ) 01/02/2025 11:56:21 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 = '95561' 01/02/2025 11:56:21 am >> DELETE FROM ps_document_detail WHERE id_document = '95561' 01/02/2025 11:56:21 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 ( '95561' , '20026' , 'CANDELA VOTIVA 20X40' , '53' , '-53' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '26.50' ) 01/02/2025 11:57:02 am >> SELECT document_num FROM ps_document WHERE document_num = '359' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:57:02 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' , '359' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.80' , '41.80' , NOW() , NOW() ) 01/02/2025 11:57:02 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 = '95562' 01/02/2025 11:57:02 am >> DELETE FROM ps_document_detail WHERE id_document = '95562' 01/02/2025 11:57:02 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 ( '95562' , '22865' , 'CATECHISMO MAGGIORE - SAN PIO X' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '5' , '18.05' ) 01/02/2025 11:57:02 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 ( '95562' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 01/02/2025 11:58:24 am >> SELECT document_num FROM ps_document WHERE document_num = '360' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 11:58:24 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' , '360' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 01/02/2025 11:58:24 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 = '95563' 01/02/2025 11:58:24 am >> DELETE FROM ps_document_detail WHERE id_document = '95563' 01/02/2025 11:58:24 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 ( '95563' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 01/02/2025 12:23:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '361' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 12:23: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' , '361' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.65' , '118.57' , NOW() , NOW() ) 01/02/2025 12:23: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 = '95564' 01/02/2025 12:23:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '95564' 01/02/2025 12:23: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 ( '95564' , '22551' , 'VOTIVE 16X300 - ART. 500 - 1630' , '263' , '-263' , '1' , '0.55' , '0.45081967213115' , '22' , '0' , '144.65' ) 01/02/2025 12:25:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '362' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 12:25:49 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' , '362' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 01/02/2025 12:25:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95565' 01/02/2025 12:25:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '95565' 01/02/2025 12:25:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95565' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 01/02/2025 12:33:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '363' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 12:33:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '363' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.50' , '47.13' , NOW() , NOW() ) 01/02/2025 12:33:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95566' 01/02/2025 12:33:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95566' 01/02/2025 12:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95566' , '20026' , 'CANDELA VOTIVA 20X40' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 01/02/2025 12:33:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95566' , '1935' , 'CERETTI DIAM 20X600 ART. 200' , '15' , '-15' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '43.50' ) 01/02/2025 12:36:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '364' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 12:36:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '364' , '2025-02-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '24.04' , NOW() , NOW() ) 01/02/2025 12:36:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95567' 01/02/2025 12:36:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95567' 01/02/2025 12:36:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95567' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 01/02/2025 12:36:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95567' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 01/02/2025 12:37:27 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '22551' 01/02/2025 12:37:27 pm >> UPDATE ps_stock_available SET quantity = quantity + '-27' WHERE id_product = '22551' 01/02/2025 12:39:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '95558' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-02-01') 01/02/2025 12:39:15 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '23', document_date = '2025-02-01', document_letter = '', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '28.56', price_tax_excluded = '28.56', date_upd = NOW() WHERE id_document = '95558' 01/02/2025 12:39: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 = '95558' 01/02/2025 12:39:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '95558' 01/02/2025 12:39: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 ( '95558' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.8000' , '2.8' , '0' , '15' , '28.56' )