31/01/2026 09:04:56 am >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 09:04:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '337' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 31/01/2026 09:04:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101169' 31/01/2026 09:04:56 am >> DELETE FROM ps_document_detail WHERE id_document = '101169' 31/01/2026 09:04:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101169' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 31/01/2026 09:42:16 am >> SELECT document_num FROM ps_document WHERE document_num = '338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 09:42: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' , '338' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 31/01/2026 09:42: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 = '101170' 31/01/2026 09:42:16 am >> DELETE FROM ps_document_detail WHERE id_document = '101170' 31/01/2026 09:42: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 ( '101170' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2026 10:37:55 am >> SELECT document_num FROM ps_document WHERE document_num = '339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 10:37: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' , '339' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 31/01/2026 10:37: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 = '101171' 31/01/2026 10:37:55 am >> DELETE FROM ps_document_detail WHERE id_document = '101171' 31/01/2026 10:37: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 ( '101171' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 31/01/2026 10:37: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 ( '101171' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 31/01/2026 10:59:49 am >> SELECT document_num FROM ps_document WHERE document_num = '340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 10:59:49 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' , '340' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '3.00' , '2.88' , NOW() , NOW() ) 31/01/2026 10:59:49 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 = '101172' 31/01/2026 10:59:49 am >> DELETE FROM ps_document_detail WHERE id_document = '101172' 31/01/2026 10:59:49 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 ( '101172' , '11152' , 'VARIE - OSTIE - PARTICOLE' , '1' , '-1' , '3' , '3' , '2.8846153846154' , '4' , '0' , '3.00' ) 31/01/2026 11:05:20 am >> SELECT document_num FROM ps_document WHERE document_num = '341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 11:05:20 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' , '341' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '84.55' , '84.55' , NOW() , NOW() ) 31/01/2026 11:05:20 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 = '101173' 31/01/2026 11:05:20 am >> DELETE FROM ps_document_detail WHERE id_document = '101173' 31/01/2026 11:05:20 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 ( '101173' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 31/01/2026 11:05:20 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 ( '101173' , '7186' , 'NUOVO TESTAMENTO INTERLINEARE' , '1' , '-1' , '4' , '79.00' , '79' , '0' , '5' , '75.05' ) 31/01/2026 11:11:48 am >> SELECT document_num FROM ps_document WHERE document_num = '342' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 11:11:48 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' , '342' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '18.05' , '18.05' , NOW() , NOW() ) 31/01/2026 11:11:48 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 = '101174' 31/01/2026 11:11:48 am >> DELETE FROM ps_document_detail WHERE id_document = '101174' 31/01/2026 11:11:48 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 ( '101174' , '24487' , 'PRETI SPEZZATI - G. DAUCOURT' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 31/01/2026 11:11:48 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 ( '101174' , '24479' , 'DAL GREMBO FIORISCE LA SPERANZA - F. BRAMBILLA' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 31/01/2026 11:13:05 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '101068' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-23') 31/01/2026 11:13:05 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2026-01-23', document_letter = 'A', 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 = '17', id_causal = '0', price_tax_included = '277.20', price_tax_excluded = '277.20', date_upd = NOW() WHERE id_document = '101068' 31/01/2026 11:13: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 = '101068' 31/01/2026 11:13:05 am >> DELETE FROM ps_document_detail WHERE id_document = '101068' 31/01/2026 11:13: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 ( '101068' , '1090' , 'BIBBIA' , '28' , '-28' , '4' , '9.9000' , '9.9' , '0' , '0' , '277.20' ) 31/01/2026 11:15:39 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '101068' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-23') 31/01/2026 11:15:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2026-01-23', document_letter = 'A', id_customer = '3536', id_supplier = '0', id_address = '4673201', 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 = '17', id_causal = '0', price_tax_included = '188.70', price_tax_excluded = '188.70', date_upd = NOW() WHERE id_document = '101068' 31/01/2026 11:15: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 = '101068' 31/01/2026 11:15:39 am >> DELETE FROM ps_document_detail WHERE id_document = '101068' 31/01/2026 11:15: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 ( '101068' , '1090' , 'BIBBIA' , '17' , '-17' , '4' , '9' , '9' , '0' , '0' , '153.00' ) 31/01/2026 11:15: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 ( '101068' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 31/01/2026 11:16:35 am >> SELECT document_num FROM ps_document WHERE document_num = '23/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 11:16:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '23/A' , '2026-01-31' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '110.90' , '110.90' , NOW() , NOW() ) 31/01/2026 11:16:35 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 = '101175' 31/01/2026 11:16:35 am >> DELETE FROM ps_document_detail WHERE id_document = '101175' 31/01/2026 11:16:35 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 ( '101175' , '1090' , 'BIBBIA' , '11' , '-11' , '4' , '9' , '9' , '0' , '0' , '99.00' ) 31/01/2026 11:16:35 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 ( '101175' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '15' , '11.90' ) 31/01/2026 11:18:39 am >> SELECT document_num FROM ps_document WHERE document_num = '18/A' AND id_document != '101068' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2026-01-23') 31/01/2026 11:18:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '18/A', document_date = '2026-01-23', document_letter = 'A', id_customer = '3536', id_supplier = '', id_address = '4673201', 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 = '17', id_causal = '0', price_tax_included = '266.05', price_tax_excluded = '252.97', date_upd = NOW() WHERE id_document = '101068' 31/01/2026 11:18: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 = '101068' 31/01/2026 11:18:39 am >> DELETE FROM ps_document_detail WHERE id_document = '101068' 31/01/2026 11:18: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 ( '101068' , '1090' , 'BIBBIA' , '17' , '-17' , '4' , '9.0000' , '9' , '0' , '0' , '153.00' ) 31/01/2026 11:18: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 ( '101068' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 31/01/2026 11:18: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 ( '101068' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 31/01/2026 11:18: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 ( '101068' , '23807' , 'CALENDARIO LITURGICO 2026' , '6' , '-6' , '4' , '0.80' , '0.8' , '0' , '0' , '4.80' ) 31/01/2026 11:18: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 ( '101068' , '13319' , 'VIVI LA VITA - 30' , '17' , '-17' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '2.55' ) 31/01/2026 11:32:06 am >> SELECT document_num FROM ps_document WHERE document_num = '343' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 11:32:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '343' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '50.50' , '47.22' , NOW() , NOW() ) 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101176' 31/01/2026 11:32:06 am >> DELETE FROM ps_document_detail WHERE id_document = '101176' 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101176' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101176' , '9362' , 'SALMI LE PIÙ BELLE PREGHIERE - 8107' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101176' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '18.2' , '14.918032786885' , '22' , '0' , '18.20' ) 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101176' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2026 11:32:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101176' , '24467' , 'SULLA TUA PAROLA - MAR/APR 2026' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2026 11:36:53 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('2026-01-31') 31/01/2026 11:36:53 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' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 31/01/2026 11:36:53 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 = '101177' 31/01/2026 11:36:53 am >> DELETE FROM ps_document_detail WHERE id_document = '101177' 31/01/2026 11:36:53 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 ( '101177' , '19149' , 'CANDELE STEREATICHE E/10 TRIB' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 31/01/2026 11:51:32 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('2026-01-31') 31/01/2026 11:51:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '345' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '137.00' , '134.84' , NOW() , NOW() ) 31/01/2026 11:51: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 = '101178' 31/01/2026 11:51:32 am >> DELETE FROM ps_document_detail WHERE id_document = '101178' 31/01/2026 11:51:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101178' , '2766' , 'CORONA PLASTICA VARI COLORI - 07' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 31/01/2026 11:51:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101178' , '13506' , 'SANTO ROSARIO' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 31/01/2026 11:51:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101178' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '125' , '125' , '0' , '0' , '125.00' ) 31/01/2026 12:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '346' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 12:04:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '346' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '78.00' , '65.38' , NOW() , NOW() ) 31/01/2026 12:04:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101179' 31/01/2026 12:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '101179' 31/01/2026 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101179' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 31/01/2026 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101179' , '24460' , 'CRESIMA: IL SIGILLO DELLO SPIRITO SANTO - A. SORRENTINO' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 31/01/2026 12:08:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '135' AND id_document != '100914' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-14') 31/01/2026 12:08:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '135', document_date = '2026-01-14', 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 = '17', id_causal = '0', price_tax_included = '339.00', price_tax_excluded = '277.87', date_upd = NOW() WHERE id_document = '100914' 31/01/2026 12:08: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 = '100914' 31/01/2026 12:08:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '100914' 31/01/2026 12:08: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 ( '100914' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '210' , '172.13114754098' , '22' , '0' , '210.00' ) 31/01/2026 12:08: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 ( '100914' , '14389' , 'CAMICE MISTO COTONE - COLLO QUADRO - 446TCAQ' , '1' , '-1' , '1' , '129' , '105.73770491803' , '22' , '0' , '129.00' ) 31/01/2026 12:28:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '101100' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-26') 31/01/2026 12:28:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '283', document_date = '2026-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 = '1', id_causal = '0', price_tax_included = '18.35', price_tax_excluded = '18.35', date_upd = NOW() WHERE id_document = '101100' 31/01/2026 12:28:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101100' 31/01/2026 12:28:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '101100' 31/01/2026 12:28:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101100' , '24400' , 'MATER POPULI FIDELIS' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 31/01/2026 12:28:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101100' , '24449' , 'PRATICA DELLA PRESENZA DI DIO - FRA LORENZO' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 31/01/2026 12:28:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101100' , '24214' , 'SULLA TUA PAROLA GEN/FEB 2026 - 532' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 31/01/2026 12:29:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '266' AND id_document != '101075' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-23') 31/01/2026 12:29:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '266', document_date = '2026-01-23', 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 = '15', id_causal = '0', price_tax_included = '14.20', price_tax_excluded = '14.20', date_upd = NOW() WHERE id_document = '101075' 31/01/2026 12:29:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101075' 31/01/2026 12:29:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '101075' 31/01/2026 12:29:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101075' , '20872' , 'CON TE GESU ' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 31/01/2026 12:29:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101075' , '24503' , 'VIA CRUCIS PER I PIU PICCOLI' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 31/01/2026 12:29:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101075' , '24398' , 'AMEN - MAR 26' , '1' , '-1' , '4' , '3.7' , '3.7' , '0' , '0' , '3.70' ) 31/01/2026 12:29:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '100751' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-02') 31/01/2026 12:29:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4', document_date = '2026-01-02', 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 = '17', id_causal = '0', price_tax_included = '90.25', price_tax_excluded = '90.25', date_upd = NOW() WHERE id_document = '100751' 31/01/2026 12:29:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '100751' 31/01/2026 12:29:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '100751' 31/01/2026 12:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '15124' , 'SEGRETO MERAVIGLIOSO DEL SANTO ROSARIO - 8285' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 31/01/2026 12:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '16837' , 'PORTA IL TUO CUORE AL LARGO! - 8993' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2026 12:29:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '100751' , '17831' , '24 PASSI NEL QUOTIDIANO - SAN . F. SALES - 8299' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 31/01/2026 12:30: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 ( '100751' , '6317' , 'MEDAGLIA MIRACOLOSA - 8332' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2026 12:30: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 ( '100751' , '23964' , 'CONFESSIONE MEDICINA DEL CUORE - 8313' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 31/01/2026 12:30: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 ( '100751' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/01/2026 12:30: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 ( '100751' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/01/2026 12:30: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 ( '100751' , '24019' , 'PERCHE LA MADONNA APPARE - 8267' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2026 12:30: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 ( '100751' , '24187' , 'QUALE VITA DOPO LA MORTE? BILLON/RAMOND' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '5' , '21.85' ) 31/01/2026 12:30: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 ( '100751' , '23805' , 'COMANDAMENTI - G. RAVASI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 31/01/2026 12:30: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 ( '100751' , '24399' , 'AMEN - APR 26' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 31/01/2026 12:33:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616225' AND id_product != '9362' AND ean13 != '' 31/01/2026 12:33:07 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616225', date_upd = NOW() WHERE id_product = '9362' 31/01/2026 12:33:07 pm >> UPDATE ps_product_lang SET name = 'SALMI LE PIÙ BELLE PREGHIERE - 8107', description = '' WHERE id_product = '9362' 31/01/2026 12:33:07 pm >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '14' WHERE id_product = '9362' 31/01/2026 12:33:07 pm >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '14', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9362' 31/01/2026 12:33:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '9362' 31/01/2026 12:48:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '347' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2026-01-31') 31/01/2026 12:48:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '347' , '2026-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '2.10' , '1.72' , NOW() , NOW() ) 31/01/2026 12:48:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '101180' 31/01/2026 12:48:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '101180' 31/01/2026 12:48:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '101180' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '2.10' )