12/12/2024 09:43:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3906' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 09:43:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3906' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 12/12/2024 09:43:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94811' 12/12/2024 09:43:43 am >> DELETE FROM ps_document_detail WHERE id_document = '94811' 12/12/2024 09:43:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94811' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 12/12/2024 09:45:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3907' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 09:45: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' , '3907' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.50' , '48.77' , NOW() , NOW() ) 12/12/2024 09:45: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 = '94812' 12/12/2024 09:45:48 am >> DELETE FROM ps_document_detail WHERE id_document = '94812' 12/12/2024 09:45: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 ( '94812' , '23187' , 'SET NATIVITA CM 10 - PB20513' , '7' , '-7' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '59.50' ) 12/12/2024 09:54:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3908' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 09:54: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' , '3908' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.50' , '32.26' , NOW() , NOW() ) 12/12/2024 09:54: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 = '94813' 12/12/2024 09:54:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94813' 12/12/2024 09:54: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 ( '94813' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 12/12/2024 09:54: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 ( '94813' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 12/12/2024 09:54: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 ( '94813' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 12/12/2024 10:06:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3909' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 10:06: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' , '3909' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '19.50' , NOW() , NOW() ) 12/12/2024 10:06: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 = '94814' 12/12/2024 10:06:55 am >> DELETE FROM ps_document_detail WHERE id_document = '94814' 12/12/2024 10:06: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 ( '94814' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 12/12/2024 10:16:35 am >> SELECT document_num FROM ps_document WHERE document_num = '101/A' AND id_document != '93254' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-23') 12/12/2024 10:16:35 am >> UPDATE ps_document SET id_document_type = '24', document_num = '101/A', document_date = '2024-09-23', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', 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 = '636.00', price_tax_excluded = '521.31', date_upd = NOW() WHERE id_document = '93254' 12/12/2024 10: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 = '93254' 12/12/2024 10:16:35 am >> DELETE FROM ps_document_detail WHERE id_document = '93254' 12/12/2024 10:16:36 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 ( '93254' , '12816' , 'LIBRO DEI DEFUNTI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 12/12/2024 10:16:36 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 ( '93254' , '12814' , 'LIBRO DEI BATTEZZATI' , '6' , '-6' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '144.00' ) 12/12/2024 10:16:36 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 ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 12/12/2024 10:16:36 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 ( '93254' , '0' , '06/11/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 12/12/2024 10:16:36 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 ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 12/12/2024 10:16:36 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 ( '93254' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 12/12/2024 10:16:36 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 ( '93254' , '0' , '11/12' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 12/12/2024 10:16:36 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 ( '93254' , '12849' , 'LIBRO DELLE SS. MESSE' , '9' , '-9' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '108.00' ) 12/12/2024 10:19:30 am >> DELETE FROM ps_document WHERE id_document = '89628' 12/12/2024 10:19:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89628' 12/12/2024 10:19:33 am >> DELETE FROM ps_document WHERE id_document = '84356' 12/12/2024 10:19:33 am >> DELETE FROM ps_document_detail WHERE id_document = '84356' 12/12/2024 10:20:54 am >> DELETE FROM ps_document WHERE id_document = '92727' 12/12/2024 10:20:54 am >> DELETE FROM ps_document_detail WHERE id_document = '92727' 12/12/2024 10:21:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3826' AND id_document != '94723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-06') 12/12/2024 10:21:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3826', document_date = '2024-12-06', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '94723' 12/12/2024 10:21:50 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 = '94723' 12/12/2024 10:21:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94723' 12/12/2024 10:21:50 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 ( '94723' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 12/12/2024 10:21:51 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 ( '94723' , '19077' , 'GRUPPO NATIVITA\' STOFFA CM 30 - PB18552' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 12/12/2024 10:27:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3696' AND id_document != '94555' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-28') 12/12/2024 10:27:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3696', document_date = '2024-11-28', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '94555' 12/12/2024 10:27:52 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 = '94555' 12/12/2024 10:27:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94555' 12/12/2024 10:27: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 ( '94555' , '23191' , 'GRUPPO NATIVITA CM 20 - PB17025' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 12/12/2024 10:27: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 ( '94555' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 12/12/2024 10:27: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 ( '94555' , '20118' , 'FATIMA CM 44 - 1035' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/12/2024 10:28:28 am >> SELECT document_num FROM ps_document WHERE document_num = '21/L' AND id_document != '94798' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-10') 12/12/2024 10:28:28 am >> UPDATE ps_document SET id_document_type = '23', document_num = '21/L', document_date = '2024-12-10', document_letter = 'L', id_customer = '4148', id_supplier = '', id_address = '4679447', address1 = 'VIA TANAGRO 12 84135 salerno', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '94798' 12/12/2024 10:28:28 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 = '94798' 12/12/2024 10:28:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94798' 12/12/2024 10:28:28 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 ( '94798' , '23191' , 'GRUPPO NATIVITA CM 20 - PB17025' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 12/12/2024 10:47:35 am >> SELECT document_num FROM ps_document WHERE document_num = '3910' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 10:47: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 ( '11' , '3910' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 12/12/2024 10:47: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 = '94815' 12/12/2024 10:47:35 am >> DELETE FROM ps_document_detail WHERE id_document = '94815' 12/12/2024 10:47: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 ( '94815' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '10' , '-10' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '8.00' ) 12/12/2024 10:51:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3911' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 10: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' , '3911' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 12/12/2024 10: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 = '94816' 12/12/2024 10:51:32 am >> DELETE FROM ps_document_detail WHERE id_document = '94816' 12/12/2024 10: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 ( '94816' , '20073' , 'ROSARIO CRISTALLO - 01M46' , '2' , '-2' , '1' , '9' , '7.3770491803279' , '22' , '0' , '18.00' ) 12/12/2024 10:53:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3912' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 10:53:25 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' , '3912' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.52' , '42.71' , NOW() , NOW() ) 12/12/2024 10:53: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 = '94817' 12/12/2024 10:53:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94817' 12/12/2024 10:53: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 ( '94817' , '23068' , 'PAROLA E PREGHIERA - GEN 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 12/12/2024 10:53: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 ( '94817' , '23245' , 'PAROLA E PREGHIERA - FEB 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 12/12/2024 10:53: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 ( '94817' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 12/12/2024 10:53: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 ( '94817' , '23138' , 'VIZI E VIRTU - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 12/12/2024 10:53: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 ( '94817' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 12/12/2024 10:53: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 ( '94817' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 12/12/2024 10:53: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 ( '94817' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 12/12/2024 10:53: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 ( '94817' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.2' , '1.2' , '0' , '0' , '1.20' ) 12/12/2024 10:59:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3913' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 10:59:07 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' , '3913' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.80' , '28.41' , NOW() , NOW() ) 12/12/2024 10:59:07 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 = '94818' 12/12/2024 10:59:07 am >> DELETE FROM ps_document_detail WHERE id_document = '94818' 12/12/2024 10:59:07 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 ( '94818' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '4' , '-4' , '1' , '4.70' , '3.8524590163934' , '22' , '0' , '18.80' ) 12/12/2024 10:59:07 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 ( '94818' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 12/12/2024 10:59:07 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 ( '94818' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '0' , '6.00' ) 12/12/2024 11:03:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3601' AND id_document != '94428' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 12/12/2024 11:03:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3601', document_date = '2024-11-22', 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 = '18.40', price_tax_excluded = '15.71', date_upd = NOW() WHERE id_document = '94428' 12/12/2024 11:03: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 = '94428' 12/12/2024 11:03:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94428' 12/12/2024 11:03: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 ( '94428' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 12/12/2024 11:03: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 ( '94428' , '20123' , 'FATIMA CM 17 - 1012' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 12/12/2024 11:03: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 ( '94428' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '6.90' ) 12/12/2024 11:03: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 ( '94428' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1' , '0.81967213114754' , '22' , '0' , '1.00' ) 12/12/2024 11:05:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '94509' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 12/12/2024 11:05:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3661', document_date = '2024-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '94509' 12/12/2024 11:05: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 = '94509' 12/12/2024 11:05:21 am >> DELETE FROM ps_document_detail WHERE id_document = '94509' 12/12/2024 11:05: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 ( '94509' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '34.00' ) 12/12/2024 11:05: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 ( '94509' , '20124' , 'FATIMA CM 11 - 1011' , '2' , '-2' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '6.60' ) 12/12/2024 11:05: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 ( '94509' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 12/12/2024 11:06:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3914' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 11:06: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' , '3914' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 12/12/2024 11:06: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 = '94819' 12/12/2024 11:06:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94819' 12/12/2024 11:06: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 ( '94819' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 12/12/2024 11:06:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3660' AND id_document != '94508' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 12/12/2024 11:06:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3660', document_date = '2024-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '94508' 12/12/2024 11:06:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94508' 12/12/2024 11:06:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94508' 12/12/2024 11:06:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94508' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 12/12/2024 11:06:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94508' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 12/12/2024 11:07:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3743' AND id_document != '94607' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-30') 12/12/2024 11:07:24 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3743', document_date = '2024-11-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '94607' 12/12/2024 11:07: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 = '94607' 12/12/2024 11:07:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94607' 12/12/2024 11:07: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 ( '94607' , '20124' , 'FATIMA CM 11 - 1011' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 12/12/2024 11:07:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3759' AND id_document != '94631' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-02') 12/12/2024 11:07:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3759', document_date = '2024-12-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 = '0', id_causal = '0', price_tax_included = '36.50', price_tax_excluded = '29.92', date_upd = NOW() WHERE id_document = '94631' 12/12/2024 11:07: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 = '94631' 12/12/2024 11:07:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94631' 12/12/2024 11:07: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 ( '94631' , '20219' , 'MEDAGLIA SAN BENEDETTO CM 4 - 400/N0216' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 12/12/2024 11:07: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 ( '94631' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 12/12/2024 11:07: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 ( '94631' , '18619' , 'MEDAGLIA MIRACOLOSA BLU GRANDE - OV40M/SM' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 12/12/2024 11:07: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 ( '94631' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 12/12/2024 11:07: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 ( '94631' , '18130' , 'TAU GRANDE CM 4 - T9' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 12/12/2024 11:07: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 ( '94631' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 12/12/2024 11:07: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 ( '94631' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 12/12/2024 11:08:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3773' AND id_document != '94654' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-03') 12/12/2024 11:08:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3773', document_date = '2024-12-03', 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 = '87.00', price_tax_excluded = '71.49', date_upd = NOW() WHERE id_document = '94654' 12/12/2024 11:08:04 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 = '94654' 12/12/2024 11:08:04 am >> DELETE FROM ps_document_detail WHERE id_document = '94654' 12/12/2024 11:08:04 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 ( '94654' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 12/12/2024 11:08:04 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 ( '94654' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 12/12/2024 11:08:04 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 ( '94654' , '20124' , 'FATIMA CM 11 - 1011' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 12/12/2024 11:08:04 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 ( '94654' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '25' , '-25' , '4' , '0.0400' , '0.04' , '0' , '0' , '1.00' ) 12/12/2024 11:08:19 am >> SELECT document_num FROM ps_document WHERE document_num = '129/A' AND id_document != '94684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-12-04') 12/12/2024 11:08:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '129/A', document_date = '2024-12-04', document_letter = 'A', id_customer = '178', id_supplier = '', id_address = '4679446', address1 = 'VIA S. MARGHERITA 1 84129 SALERNO', 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 = '676.40', price_tax_excluded = '555.04', date_upd = NOW() WHERE id_document = '94684' 12/12/2024 11:08:19 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 = '94684' 12/12/2024 11:08:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94684' 12/12/2024 11:08:19 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 ( '94684' , '17617' , 'IMMAGINI ISONZO X 100' , '17' , '-17' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '56.10' ) 12/12/2024 11:08:19 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 ( '94684' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 12/12/2024 11:08:19 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 ( '94684' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 12/12/2024 11:08: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 ( '94684' , '20124' , 'FATIMA CM 11 - 1011' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 12/12/2024 11:08: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 ( '94684' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '11.00' ) 12/12/2024 11:08: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 ( '94684' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 12/12/2024 11:08: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 ( '94684' , '8054' , 'PISSIDE DUE SPECIE - 873' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 12/12/2024 11:08: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 ( '94684' , '22215' , 'CALICE MALTA - 341' , '1' , '-1' , '1' , '280.0000' , '229.50819672131' , '22' , '0' , '280.00' ) 12/12/2024 11:08: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 ( '94684' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 12/12/2024 11:08:33 am >> DELETE FROM ps_document WHERE id_document = '94684' 12/12/2024 11:08:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94684' 12/12/2024 11:10:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '94510' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-26') 12/12/2024 11:10:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3662', document_date = '2024-11-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94510' 12/12/2024 11:10:17 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 = '94510' 12/12/2024 11:10:17 am >> DELETE FROM ps_document_detail WHERE id_document = '94510' 12/12/2024 11:10:17 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 ( '94510' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 12/12/2024 11:10:17 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 ( '94510' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 12/12/2024 11:10:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3684' AND id_document != '94540' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-27') 12/12/2024 11:10:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3684', document_date = '2024-11-27', 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 = '177.97', price_tax_excluded = '167.58', date_upd = NOW() WHERE id_document = '94540' 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94540' 12/12/2024 11:10:42 am >> DELETE FROM ps_document_detail WHERE id_document = '94540' 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '23134' , 'AVVENTO E NATALE 2024/25' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '15515' , 'ORIGINALI, NON FOTOCOPIE - D. SORRENTINO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 12/12/2024 11:10:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '2' , '-2' , '4' , '42.0000' , '42' , '0' , '5' , '79.80' ) 12/12/2024 11:10:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.4000' , '2.7868852459016' , '22' , '0' , '13.60' ) 12/12/2024 11:10:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '9948' , 'SFERA DIAMETRO MM 100' , '4' , '-4' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '26.00' ) 12/12/2024 11:10:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 12/12/2024 11:10:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '18742' , 'VIAGGIO DEI TRE RE - B. MASINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 12/12/2024 11:10:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94540' , '23169' , 'DILEXIT NOS ' , '4' , '-4' , '4' , '2.2000' , '2.2' , '0' , '0' , '8.80' ) 12/12/2024 11:18:13 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/12/2024 11:18:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23300' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:18:13 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23300' , '1' , '1' , '2' , NOW() , NOW() ) 12/12/2024 11:18:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23300' , '0' , '1' , '0' , '0' ) 12/12/2024 11:18:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246270' AND id_product != '23300' AND ean13 != '' 12/12/2024 11:18:57 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892246270', date_upd = NOW() WHERE id_product = '23300' 12/12/2024 11:18:57 am >> UPDATE ps_product_lang SET name = 'DOMENICA DELLA PAROLA 2025', description = '' WHERE id_product = '23300' 12/12/2024 11:18:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23300' 12/12/2024 11:18:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23300' 12/12/2024 11:18:57 am >> DELETE FROM ps_specific_price WHERE id_product = '23300' 12/12/2024 11:19:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 12/12/2024 11:19:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23301' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:19:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23301' , '1' , '1' , '2' , NOW() , NOW() ) 12/12/2024 11:19:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23301' , '0' , '1' , '0' , '0' ) 12/12/2024 11:20:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228658' AND id_product != '23301' AND ean13 != '' 12/12/2024 11:20:20 am >> UPDATE ps_product SET id_supplier = '', reference = 'gondola 1', ean13 = '9788892228658', date_upd = NOW() WHERE id_product = '23301' 12/12/2024 11:20:20 am >> UPDATE ps_product_lang SET name = 'sacramenti - benedetto xvi', description = '' WHERE id_product = '23301' 12/12/2024 11:20:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23301' 12/12/2024 11:20:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23301' 12/12/2024 11:20:20 am >> DELETE FROM ps_specific_price WHERE id_product = '23301' 12/12/2024 11:20:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23301' 12/12/2024 11:20:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23302' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:20:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23302' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23301' 12/12/2024 11:20:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23302' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23301' 12/12/2024 11:20:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228665' AND id_product != '23302' AND ean13 != '' 12/12/2024 11:20:56 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892228665', date_upd = NOW() WHERE id_product = '23302' 12/12/2024 11:20:56 am >> UPDATE ps_product_lang SET name = 'COMANDAMENTI - BENEDETTO XVI', description = '' WHERE id_product = '23302' 12/12/2024 11:20:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '23302' 12/12/2024 11:20:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23302' 12/12/2024 11:20:56 am >> DELETE FROM ps_specific_price WHERE id_product = '23302' 12/12/2024 11:20:57 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23302' 12/12/2024 11:20:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23303' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:20:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23303' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23302' 12/12/2024 11:20:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23303' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23302' 12/12/2024 11:21:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246171' AND id_product != '23303' AND ean13 != '' 12/12/2024 11:21:32 am >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788892246171', date_upd = NOW() WHERE id_product = '23303' 12/12/2024 11:21:32 am >> UPDATE ps_product_lang SET name = 'PINO DANIELE - P. PERONA', description = '' WHERE id_product = '23303' 12/12/2024 11:21:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23303' 12/12/2024 11:21:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23303' 12/12/2024 11:21:32 am >> DELETE FROM ps_specific_price WHERE id_product = '23303' 12/12/2024 11:21:34 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23303' 12/12/2024 11:21:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23304' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:21:34 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23304' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23303' 12/12/2024 11:21:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23304' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23303' 12/12/2024 11:22:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825059434' AND id_product != '23304' AND ean13 != '' 12/12/2024 11:22:19 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788825059434', date_upd = NOW() WHERE id_product = '23304' 12/12/2024 11:22:19 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DI GUARIGIONE - M. LA GRUA', description = '' WHERE id_product = '23304' 12/12/2024 11:22:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '23304' 12/12/2024 11:22:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '17', 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 = '23304' 12/12/2024 11:22:19 am >> DELETE FROM ps_specific_price WHERE id_product = '23304' 12/12/2024 11:22:20 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23304' 12/12/2024 11:22:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23305' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:22:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23305' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23304' 12/12/2024 11:22:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23305' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23304' 12/12/2024 11:22:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572519' AND id_product != '23305' AND ean13 != '' 12/12/2024 11:22:56 am >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788867572519', date_upd = NOW() WHERE id_product = '23305' 12/12/2024 11:22:56 am >> UPDATE ps_product_lang SET name = 'STORIE DELLA BIBBIA', description = '' WHERE id_product = '23305' 12/12/2024 11:22:56 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '23305' 12/12/2024 11:22:56 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23305' 12/12/2024 11:22:56 am >> DELETE FROM ps_specific_price WHERE id_product = '23305' 12/12/2024 11:22:57 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23305' 12/12/2024 11:22:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23306' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:22:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23306' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23305' 12/12/2024 11:22:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23306' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23305' 12/12/2024 11:23:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572526' AND id_product != '23306' AND ean13 != '' 12/12/2024 11:23:21 am >> UPDATE ps_product SET id_supplier = '', reference = '5/2', ean13 = '9788867572526', date_upd = NOW() WHERE id_product = '23306' 12/12/2024 11:23:21 am >> UPDATE ps_product_lang SET name = 'STORIE DELLA BIBBIA', description = '' WHERE id_product = '23306' 12/12/2024 11:23:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '23306' 12/12/2024 11:23:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23306' 12/12/2024 11:23:21 am >> DELETE FROM ps_specific_price WHERE id_product = '23306' 12/12/2024 11:23:22 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23306' 12/12/2024 11:23:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23307' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:23:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23307' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23306' 12/12/2024 11:23:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23307' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23306' 12/12/2024 11:28:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281465176' AND id_product != '23307' AND ean13 != '' 12/12/2024 11:28:08 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791281465176', date_upd = NOW() WHERE id_product = '23307' 12/12/2024 11:28:08 am >> UPDATE ps_product_lang SET name = 'AVETE FATTO A ME - E. BOLIS', description = '' WHERE id_product = '23307' 12/12/2024 11:28:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '23307' 12/12/2024 11:28:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23307' 12/12/2024 11:28:08 am >> DELETE FROM ps_specific_price WHERE id_product = '23307' 12/12/2024 11:28:09 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23307' 12/12/2024 11:28:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23308' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 11:28:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23308' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23307' 12/12/2024 11:28:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23308' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23307' 12/12/2024 11:29:40 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 ( '33' , '684791' , '2024-12-06' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '2.65' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.05' , '93.05' , NOW() , NOW() ) 12/12/2024 11:29:40 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 = '94820' 12/12/2024 11:29:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94820' 12/12/2024 11:29:40 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 ( '94820' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '12' , '12' , '4' , '2.90' , '2.9' , '0' , '33' , '23.3160' ) 12/12/2024 11:29:40 am >> DELETE FROM ps_product_supplier WHERE id_product = '23300' AND id_supplier = '7' 12/12/2024 11:29:40 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23300' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '1' , '4' , '2.90' , '2.9' , '0' , '100' , '0.0000' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23300' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23300' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23307' , 'AVETE FATTO A ME - E. BOLIS' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23307' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23307' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23306' , 'STORIE DELLA BIBBIA' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23306' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23306' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23305' , 'STORIE DELLA BIBBIA' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23305' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23305' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23302' , 'COMANDAMENTI - BENEDETTO XVI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23302' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23302' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23301' , 'sacramenti - benedetto xvi' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23301' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23301' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23303' , 'PINO DANIELE - P. PERONA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23303' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23303' , '7' , '1' ) 12/12/2024 11:29:41 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 ( '94820' , '23304' , 'PREGHIERA DI GUARIGIONE - M. LA GRUA' , '1' , '1' , '4' , '19.00' , '19' , '0' , '30' , '13.3000' ) 12/12/2024 11:29:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23304' AND id_supplier = '7' 12/12/2024 11:29:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23304' , '7' , '1' ) 12/12/2024 12:02:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3915' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:02:47 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' , '3915' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.66' , '43.66' , NOW() , NOW() ) 12/12/2024 12:02:47 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 = '94821' 12/12/2024 12:02:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94821' 12/12/2024 12:02:47 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 ( '94821' , '22432' , 'IN SINU JESU' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 12/12/2024 12:02:47 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 ( '94821' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 12/12/2024 12:02:47 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 ( '94821' , '22334' , 'DIO LA SCIENZA DELLE PROVE' , '1' , '-1' , '4' , '24.90' , '24.9' , '0' , '5' , '23.66' ) 12/12/2024 12:08:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3916' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:08:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3916' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.86' , '55.72' , NOW() , NOW() ) 12/12/2024 12:08: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 = '94822' 12/12/2024 12:08:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '94822' 12/12/2024 12:08: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 ( '94822' , '5823' , 'LIBRO DORO' , '30' , '-30' , '4' , '0.60' , '0.6' , '0' , '0' , '18.00' ) 12/12/2024 12:09: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 ( '94822' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 12/12/2024 12:09: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 ( '94822' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 12/12/2024 12:09: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 ( '94822' , '23300' , 'DOMENICA DELLA PAROLA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 12/12/2024 12:09: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 ( '94822' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 12/12/2024 12:09: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 ( '94822' , '14957' , 'QUADRETTO NATIVITA 16X12 - P577' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 12/12/2024 12:09: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 ( '94822' , '23189' , 'GRUPPO NATIVITA\' STILIZZATA - PB18073' , '12' , '-12' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '24.00' ) 12/12/2024 12:11:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3764' 12/12/2024 12:11:04 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3764' , '10' , '210' , 'PARR. S. MARIA DELLA FOCE' , 'ESPOSITO MOCERINO' , 'LEONE' , 'VIALE SANTA MARIA DELLA FOCE 9' , '' , '84087' , 'SARNO' , '' , '' , '' , '' , '80009370653' , NOW() , NOW() ) 12/12/2024 12:11:04 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3764' 12/12/2024 12:11:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:11:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '264' , '2024-12-12' , '' , '3764' , '0' , '4679448' , 'VIALE SANTA MARIA DELLA FOCE 9 84087 SARNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '51.00' , NOW() , NOW() ) 12/12/2024 12:11:40 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 = '94823' 12/12/2024 12:11:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94823' 12/12/2024 12:11:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94823' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.40' , '2.4' , '0' , '15' , '51.00' ) 12/12/2024 12:17:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3917' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:17:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3917' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.80' , '26.89' , NOW() , NOW() ) 12/12/2024 12:17:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94824' 12/12/2024 12:17:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '94824' 12/12/2024 12:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94824' , '23187' , 'SET NATIVITA CM 10 - PB20513' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 12/12/2024 12:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94824' , '16329' , 'GRUPPO NATIVITA CM 11' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 12/12/2024 12:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94824' , '23182' , 'GRUPPO NATIVITA ALBERO CM 10 - PB16997' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 12/12/2024 12:17:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94824' , '16772' , 'QUADRO DECORATO ' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 12/12/2024 12:17:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94824' , '9506' , 'SAN PIO- 781-5 TMD ' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 12/12/2024 12:20:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '265' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:20:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '265' , '2024-12-12' , '' , '3826' , '0' , '4672780' , 'P. ZZA UMBERTO I 35 - PREPEZZANO 84090 GIFFONI SEI CASALI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '68.68' , '68.68' , NOW() , NOW() ) 12/12/2024 12:20:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94825' 12/12/2024 12:20:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94825' 12/12/2024 12:20:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94825' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 12/12/2024 12:20:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94825' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 12/12/2024 12:20:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94825' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 12/12/2024 12:20:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94825' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '12' , '-12' , '4' , '3.40' , '3.4' , '0' , '15' , '34.68' ) 12/12/2024 12:27:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3918' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:27:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3918' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '246.30' , '206.61' , NOW() , NOW() ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94826' 12/12/2024 12:27:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '94826' 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 12/12/2024 12:27:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94826' , '4374' , 'GESÙ BAMBINO - 273' , '200' , '-200' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '26.00' ) 12/12/2024 12:32:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3919' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 12:32:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3919' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.90' , '60.59' , NOW() , NOW() ) 12/12/2024 12:32:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94827' 12/12/2024 12:32:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '94827' 12/12/2024 12:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94827' , '4374' , 'GESÙ BAMBINO - 273' , '168' , '-168' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '21.84' ) 12/12/2024 12:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94827' , '17938' , 'SAN GIUSEPPE - ARS 119' , '62' , '-62' , '1' , '0.13' , '0.10655737704918' , '22' , '0' , '8.06' ) 12/12/2024 12:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94827' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 12/12/2024 12:32:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94827' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 12/12/2024 12:32:27 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 ( '94827' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 12/12/2024 12:46:16 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14120' 12/12/2024 12:46:16 pm >> UPDATE ps_stock_available SET quantity = quantity + '-81' WHERE id_product = '14120' 12/12/2024 12:47:10 pm >> DELETE FROM ps_product WHERE id_product = '4856' 12/12/2024 12:47:10 pm >> DELETE FROM ps_product_shop WHERE id_product = '4856' 12/12/2024 12:47:10 pm >> DELETE FROM ps_product_lang WHERE id_product = '4856' 12/12/2024 12:47:10 pm >> DELETE FROM ps_stock_available WHERE id_product = '4856' 12/12/2024 02:17:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '264' AND id_document != '94823' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 02:17:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '264', document_date = '2024-12-12', document_letter = '', id_customer = '3764', id_supplier = '', id_address = '4679448', address1 = 'VIALE SANTA MARIA DELLA FOCE 9 84087 SARNO', 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 = '51.00', price_tax_excluded = '51.00', date_upd = NOW() WHERE id_document = '94823' 12/12/2024 02:17:22 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 = '94823' 12/12/2024 02:17:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94823' 12/12/2024 02:17:22 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 ( '94823' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '25' , '-25' , '4' , '2.4000' , '2.4' , '0' , '15' , '51.00' ) 12/12/2024 02:37:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000392' AND id_product != '8053' AND ean13 != '' 12/12/2024 02:37:17 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000392', date_upd = NOW() WHERE id_product = '8053' 12/12/2024 02:37:17 pm >> UPDATE ps_product_lang SET name = 'PISSIDE DIAM 14 C/COPERCHIO - 864', description = '' WHERE id_product = '8053' 12/12/2024 02:37:17 pm >> UPDATE ps_product SET wholesale_price = '39.43', on_sale = '0', price = '81.14754098360656' WHERE id_product = '8053' 12/12/2024 02:37:17 pm >> UPDATE ps_product_shop SET wholesale_price = '39.43', price = '81.14754098360656', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8053' 12/12/2024 02:37:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '8053' 12/12/2024 02:39:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002333' AND id_product != '23308' AND ean13 != '' 12/12/2024 02:39:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002333', date_upd = NOW() WHERE id_product = '23308' 12/12/2024 02:39:21 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA CON CARTUCCIA 3,2X30 - 1132', description = '' WHERE id_product = '23308' 12/12/2024 02:39:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.672131147540984' WHERE id_product = '23308' 12/12/2024 02:39:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.672131147540984', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23308' 12/12/2024 02:39:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23308' 12/12/2024 02:39:22 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23308' 12/12/2024 02:39:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23309' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 02:39:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23309' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23308' 12/12/2024 02:39:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23309' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23308' 12/12/2024 02:40:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000054' AND id_product != '9715' AND ean13 != '' 12/12/2024 02:40:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000054', date_upd = NOW() WHERE id_product = '9715' 12/12/2024 02:40:41 pm >> UPDATE ps_product_lang SET name = 'SCATOLA PORTA OSTIE - CM 17 - OGGETTI', description = '' WHERE id_product = '9715' 12/12/2024 02:40:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '9715' 12/12/2024 02:40:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9715' 12/12/2024 02:40:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '9715' 12/12/2024 02:42:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002106' AND id_product != '20559' AND ean13 != '' 12/12/2024 02:42:02 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '002106', date_upd = NOW() WHERE id_product = '20559' 12/12/2024 02:42:02 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 3,2 X 30 - 132', description = '' WHERE id_product = '20559' 12/12/2024 02:42:02 pm >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '9.836065573770492' WHERE id_product = '20559' 12/12/2024 02:42:02 pm >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20559' 12/12/2024 02:42:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20559' 12/12/2024 02:42:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001743' AND id_product != '18271' AND ean13 != '' 12/12/2024 02:42:57 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001743', date_upd = NOW() WHERE id_product = '18271' 12/12/2024 02:42:57 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 3,2 X 25 - 131', description = '' WHERE id_product = '18271' 12/12/2024 02:42:57 pm >> UPDATE ps_product SET wholesale_price = '4.18', on_sale = '0', price = '9.01639344262295' WHERE id_product = '18271' 12/12/2024 02:42:57 pm >> UPDATE ps_product_shop SET wholesale_price = '4.18', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18271' 12/12/2024 02:42:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '18271' 12/12/2024 02:43:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002334' AND id_product != '23309' AND ean13 != '' 12/12/2024 02:43:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002334', date_upd = NOW() WHERE id_product = '23309' 12/12/2024 02:43:53 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X30 - 140', description = '' WHERE id_product = '23309' 12/12/2024 02:43:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '23309' 12/12/2024 02:43:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23309' 12/12/2024 02:43:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '23309' 12/12/2024 02:43:54 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23309' 12/12/2024 02:43:54 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23310' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 02:43:54 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23310' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23309' 12/12/2024 02:43:54 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23310' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23309' 12/12/2024 02:44:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001931' AND id_product != '19213' AND ean13 != '' 12/12/2024 02:44:22 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001931', date_upd = NOW() WHERE id_product = '19213' 12/12/2024 02:44:22 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X25 - 114', description = '' WHERE id_product = '19213' 12/12/2024 02:44:22 pm >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '9.01639344262295' WHERE id_product = '19213' 12/12/2024 02:44:22 pm >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '9.01639344262295', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19213' 12/12/2024 02:44:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '19213' 12/12/2024 02:44:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001931' AND id_product != '19213' AND ean13 != '' 12/12/2024 02:44:46 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001931', date_upd = NOW() WHERE id_product = '19213' 12/12/2024 02:44:46 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X25 - 114', description = '' WHERE id_product = '19213' 12/12/2024 02:44:46 pm >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '9.836065573770492' WHERE id_product = '19213' 12/12/2024 02:44:46 pm >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19213' 12/12/2024 02:44:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '19213' 12/12/2024 02:45:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000258' AND id_product != '5998' AND ean13 != '' 12/12/2024 02:45:18 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000258', date_upd = NOW() WHERE id_product = '5998' 12/12/2024 02:45:18 pm >> UPDATE ps_product_lang SET name = 'LUME VETRO SOFFIATO - CM 20 - 1023', description = '' WHERE id_product = '5998' 12/12/2024 02:45:18 pm >> UPDATE ps_product SET wholesale_price = '15.68', on_sale = '0', price = '34.42622950819672' WHERE id_product = '5998' 12/12/2024 02:45:18 pm >> UPDATE ps_product_shop SET wholesale_price = '15.68', price = '34.42622950819672', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5998' 12/12/2024 02:45:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '5998' 12/12/2024 02:46:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000506' AND id_product != '4525' AND ean13 != '' 12/12/2024 02:46:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000506', date_upd = NOW() WHERE id_product = '4525' 12/12/2024 02:46:18 pm >> UPDATE ps_product_lang SET name = 'GIGLER COMPLETO - 248 ', description = '' WHERE id_product = '4525' 12/12/2024 02:46:18 pm >> UPDATE ps_product SET wholesale_price = '1.45', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '4525' 12/12/2024 02:46:19 pm >> UPDATE ps_product_shop SET wholesale_price = '1.45', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4525' 12/12/2024 02:46:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '4525' 12/12/2024 02:46:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000507' AND id_product != '564' AND ean13 != '' 12/12/2024 02:46:39 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000507', date_upd = NOW() WHERE id_product = '564' 12/12/2024 02:46:39 pm >> UPDATE ps_product_lang SET name = 'GIGLER COMPLETO PER ART. 534/536/537 - 249', description = '' WHERE id_product = '564' 12/12/2024 02:46:39 pm >> UPDATE ps_product SET wholesale_price = '1.81', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '564' 12/12/2024 02:46:39 pm >> UPDATE ps_product_shop SET wholesale_price = '1.81', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '564' 12/12/2024 02:46:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '564' 12/12/2024 02:48:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000018394' AND id_product != '23310' AND ean13 != '' 12/12/2024 02:48:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000018394', date_upd = NOW() WHERE id_product = '23310' 12/12/2024 02:48:17 pm >> UPDATE ps_product_lang SET name = 'PISSIDE DUE SPECIE - 873/1', description = '' WHERE id_product = '23310' 12/12/2024 02:48:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '209.01639344262296' WHERE id_product = '23310' 12/12/2024 02:48:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '209.01639344262296', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23310' 12/12/2024 02:48:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '23310' 12/12/2024 02:48:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23310' 12/12/2024 02:48:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23311' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 02:48:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23311' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23310' 12/12/2024 02:48:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23311' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23310' 12/12/2024 02:48:54 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 ( '31' , '3855' , '2024-12-06' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '14.01' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '645.62' , '529.20' , NOW() , NOW() ) 12/12/2024 02:48:54 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 = '94828' 12/12/2024 02:48:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94828' 12/12/2024 02:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4' , '3.2786885245902' , '22' , '5' , '9.2720' ) 12/12/2024 02:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23215' AND id_supplier = '12' 12/12/2024 02:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23215' , '12' , '1' ) 12/12/2024 02:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '1' , '1' , '1' , '3' , '2.4590163934426' , '22' , '5' , '3.4770' ) 12/12/2024 02:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '539' AND id_supplier = '12' 12/12/2024 02:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '539' , '12' , '1' ) 12/12/2024 02:48:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '1' , '1' , '42' , '34.426229508197' , '22' , '5' , '48.6780' ) 12/12/2024 02:48:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15357' AND id_supplier = '12' 12/12/2024 02:48:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15357' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '42.5' , '34.83606557377' , '22' , '5' , '49.2575' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '8053' , 'PISSIDE DIAM 14 C/COPERCHIO - 864' , '1' , '1' , '1' , '41.5' , '34.016393442623' , '22' , '5' , '48.0985' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8053' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8053' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '2' , '1' , '6' , '4.9180327868852' , '22' , '5' , '13.9080' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '2' , '2' , '1' , '7' , '5.7377049180328' , '22' , '5' , '16.2260' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12578' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12578' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '23308' , 'FINTA CANDELA CON CARTUCCIA 3,2X30 - 1132' , '4' , '4' , '1' , '10' , '8.1967213114754' , '22' , '5' , '46.3600' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23308' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23308' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '9715' , 'SCATOLA PORTA OSTIE - CM 17 - OGGETTI' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '5' , '23.1800' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9715' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9715' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '3' , '3' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '46.9395' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21583' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21583' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '6' , '4.9180327868852' , '22' , '5' , '69.5400' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '20559' , 'FINTA CANDELA 3,2 X 30 - 132' , '2' , '2' , '1' , '5' , '4.0983606557377' , '22' , '5' , '11.5900' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20559' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20559' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '2' , '2' , '1' , '4.4' , '3.6065573770492' , '22' , '5' , '10.1992' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18271' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18271' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '23309' , 'FINTA CANDELA 4X30 - 140' , '2' , '2' , '1' , '5.5' , '4.5081967213115' , '22' , '5' , '12.7490' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23309' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23309' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '19213' , 'FINTA CANDELA 4X25 - 114' , '2' , '2' , '1' , '5' , '4.0983606557377' , '22' , '5' , '11.5900' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19213' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19213' , '12' , '1' ) 12/12/2024 02:48:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '5998' , 'LUME VETRO SOFFIATO - CM 20 - 1023' , '2' , '2' , '1' , '17.5' , '14.344262295082' , '22' , '5' , '40.5650' ) 12/12/2024 02:48:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5998' AND id_supplier = '12' 12/12/2024 02:48:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5998' , '12' , '1' ) 12/12/2024 02:48:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '10' , '10' , '1' , '1.9' , '1.5573770491803' , '22' , '5' , '22.0210' ) 12/12/2024 02:48:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '12' 12/12/2024 02:48:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '12' , '1' ) 12/12/2024 02:48:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '4525' , 'GIGLER COMPLETO - 248 ' , '10' , '10' , '1' , '1.9' , '1.5573770491803' , '22' , '5' , '22.0210' ) 12/12/2024 02:48:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4525' AND id_supplier = '12' 12/12/2024 02:48:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4525' , '12' , '1' ) 12/12/2024 02:48:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94828' , '23310' , 'PISSIDE DUE SPECIE - 873/1' , '1' , '1' , '1' , '106' , '86.885245901639' , '22' , '5' , '122.8540' ) 12/12/2024 02:48:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23310' AND id_supplier = '12' 12/12/2024 02:48:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23310' , '12' , '1' ) 12/12/2024 03:09:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3920' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 03:09: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' , '3920' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '16.35' , NOW() , NOW() ) 12/12/2024 03:09: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 = '94829' 12/12/2024 03:09:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '94829' 12/12/2024 03:09: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 ( '94829' , '16244' , 'QUADRO 10X10' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 12/12/2024 03:09: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 ( '94829' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 12/12/2024 03:09: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 ( '94829' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/12/2024 03:34:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002335' AND id_product != '23311' AND ean13 != '' 12/12/2024 03:34:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002335', date_upd = NOW() WHERE id_product = '23311' 12/12/2024 03:34:21 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X60 - 142', description = '' WHERE id_product = '23311' 12/12/2024 03:34:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.21311475409836' WHERE id_product = '23311' 12/12/2024 03:34:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.21311475409836', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23311' 12/12/2024 03:34:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23311' 12/12/2024 03:35:06 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '3515', document_date = '2024-11-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '15.01', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '615.43', price_tax_excluded = '504.45', date_upd = NOW() WHERE id_document = '94247' 12/12/2024 03:35:06 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 = '94247' 12/12/2024 03:35:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94247' 12/12/2024 03:35:06 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 ( '94247' , '23215' , 'AMPOLLA RICAMBIO ART. 1509 - 70/M' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 12/12/2024 03:35:07 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 ( '94247' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '15' , '15' , '1' , '6.0000' , '4.9180327868852' , '22' , '5' , '104.31' ) 12/12/2024 03:35:07 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 ( '94247' , '12065' , 'COPPIA BOTTIGLIE A/V CORAZZATE - 847' , '1' , '1' , '1' , '19.5000' , '15.983606557377' , '22' , '5' , '22.60' ) 12/12/2024 03:35:07 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 ( '94247' , '803' , 'ASTUCCIO VIATICO - GRANDE - 1933' , '1' , '1' , '1' , '48.0000' , '39.344262295082' , '22' , '5' , '55.63' ) 12/12/2024 03:35:07 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 ( '94247' , '18271' , 'FINTA CANDELA 3,2 X 25 - 131' , '3' , '3' , '1' , '4.4000' , '3.6065573770492' , '22' , '5' , '15.30' ) 12/12/2024 03:35:07 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 ( '94247' , '23216' , 'CANDELA ELETTRICA - 326' , '2' , '2' , '1' , '4.0000' , '3.2786885245902' , '22' , '5' , '9.27' ) 12/12/2024 03:35:07 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 ( '94247' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '5' , '5' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '46.36' ) 12/12/2024 03:35:07 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 ( '94247' , '781' , 'ASPERGES MIGNON - 807' , '1' , '1' , '1' , '10.5000' , '8.6065573770492' , '22' , '5' , '12.17' ) 12/12/2024 03:35:07 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 ( '94247' , '23217' , 'SCATOLA PORTA OSTIA CON LUNETTA - 1355' , '1' , '1' , '1' , '64.0000' , '52.459016393443' , '22' , '5' , '74.18' ) 12/12/2024 03:35:07 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 ( '94247' , '797' , 'ASTUCCIO CON 3 VASETTI - 1759/3' , '1' , '1' , '1' , '160.0000' , '131.14754098361' , '22' , '5' , '185.44' ) 12/12/2024 03:35:07 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 ( '94247' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '4' , '4' , '1' , '7.0000' , '5.7377049180328' , '22' , '5' , '32.45' ) 12/12/2024 03:35:07 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 ( '94247' , '23311' , 'FINTA CANDELA 4X60 - 142' , '2' , '2' , '1' , '13' , '10.655737704918' , '22' , '5' , '30.1340' ) 12/12/2024 03:36:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002335' AND id_product != '23311' AND ean13 != '' 12/12/2024 03:36:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002335', date_upd = NOW() WHERE id_product = '23311' 12/12/2024 03:36:34 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X60 - 142', description = '' WHERE id_product = '23311' 12/12/2024 03:36:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.2131' WHERE id_product = '23311' 12/12/2024 03:36:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.2131', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23311' 12/12/2024 03:36:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23311' 12/12/2024 03:36:35 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23311' 12/12/2024 03:36:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23312' , '1' , '' , 'nuovo-prodotto' ) 12/12/2024 03:36:35 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23312' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23311' 12/12/2024 03:36:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23312' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23311' 12/12/2024 03:51:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3921' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 03:51:01 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' , '3921' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.40' , '2.40' , NOW() , NOW() ) 12/12/2024 03:51:01 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 = '94830' 12/12/2024 03:51:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94830' 12/12/2024 03:51:01 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 ( '94830' , '22698' , 'CALENDARIO LITURGICO 2025' , '3' , '-3' , '4' , '0.80' , '0.8' , '0' , '0' , '2.40' ) 12/12/2024 04:22:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 04:22: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 ( '24' , '35' , '2024-12-12' , '' , '0' , '0' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '5426.52' , '4447.97' , NOW() , NOW() ) 12/12/2024 04:22: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 = '94831' 12/12/2024 04:22:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94831' 12/12/2024 04:22: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 ( '94831' , '22829' , 'CASULA CON CROCE - 70/145-1' , '1' , '-1' , '1' , '367.0000' , '300.8197' , '22' , '0' , '447.74' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22830' , 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439' , '1' , '-1' , '1' , '1415.0000' , '1159.8361' , '22' , '0' , '1726.30' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22831' , 'COTTA MISTO LANA RICAMO A MANO - 70/423-1' , '1' , '-1' , '1' , '247.0000' , '202.459' , '22' , '0' , '301.34' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22832' , 'CASULA PURA SETA GREGGIA - 60/2035' , '1' , '-1' , '1' , '793.0000' , '650' , '22' , '0' , '967.46' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22833' , ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504' , '1' , '-1' , '1' , '615.0000' , '504.0984' , '22' , '0' , '750.30' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22834' , 'PALLA - 50/393' , '1' , '-1' , '1' , '118.0000' , '96.7213' , '22' , '0' , '143.96' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22835' , 'PALLA - 50/361.' , '3' , '-3' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '204.00' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22842' , 'PALLA SETA CON RICAMO ARG mf - 50/331' , '1' , '-1' , '1' , '131.0000' , '107.377' , '22' , '0' , '159.82' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22836' , 'PALLA - 75/1634' , '2' , '-2' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '79.00' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22839' , 'STOLA SETA - 70/506-1' , '1' , '-1' , '1' , '197.0000' , '161.4754' , '22' , '0' , '240.34' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '-1' , '1' , '224.0000' , '183.6066' , '22' , '0' , '273.28' ) 12/12/2024 04:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94831' , '22841' , 'STOLA CANAPA/LINO - 60/3098' , '1' , '-1' , '1' , '109.0000' , '89.3443' , '22' , '0' , '132.98' ) 12/12/2024 04:25:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '94831' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 04:25:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '35', document_date = '2024-12-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670237', address1 = 'VIA ROMA, 10 54035 FOSDINOVO', address2 = '', note = 'RESO DA CONTO DEPOSITO', 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 = '5426.52', price_tax_excluded = '4447.97', date_upd = NOW() WHERE id_document = '94831' 12/12/2024 04:25:10 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 = '94831' 12/12/2024 04:25:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94831' 12/12/2024 04:25:10 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 ( '94831' , '22829' , 'CASULA CON CROCE - 70/145-1' , '1' , '-1' , '1' , '367.0000' , '300.81967213115' , '22' , '0' , '447.74' ) 12/12/2024 04:25:10 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 ( '94831' , '22830' , 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439' , '1' , '-1' , '1' , '1415.0000' , '1159.8360655738' , '22' , '0' , '1726.30' ) 12/12/2024 04:25:10 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 ( '94831' , '22831' , 'COTTA MISTO LANA RICAMO A MANO - 70/423-1' , '1' , '-1' , '1' , '247.0000' , '202.45901639344' , '22' , '0' , '301.34' ) 12/12/2024 04:25:10 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 ( '94831' , '22832' , 'CASULA PURA SETA GREGGIA - 60/2035' , '1' , '-1' , '1' , '793.0000' , '650' , '22' , '0' , '967.46' ) 12/12/2024 04:25:10 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 ( '94831' , '22833' , ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504' , '1' , '-1' , '1' , '615.0000' , '504.09836065574' , '22' , '0' , '750.30' ) 12/12/2024 04:25:10 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 ( '94831' , '22834' , 'PALLA - 50/393' , '1' , '-1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '143.96' ) 12/12/2024 04:25:10 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 ( '94831' , '22835' , 'PALLA - 50/361.' , '3' , '-3' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '204.00' ) 12/12/2024 04:25:10 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 ( '94831' , '22842' , 'PALLA SETA CON RICAMO ARG mf - 50/331' , '1' , '-1' , '1' , '131.0000' , '107.37704918033' , '22' , '0' , '159.82' ) 12/12/2024 04:25:10 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 ( '94831' , '22836' , 'PALLA - 75/1634' , '2' , '-2' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '79.00' ) 12/12/2024 04:25:10 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 ( '94831' , '22839' , 'STOLA SETA - 70/506-1' , '1' , '-1' , '1' , '197.0000' , '161.47540983607' , '22' , '0' , '240.34' ) 12/12/2024 04:25:10 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 ( '94831' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '-1' , '1' , '224.0000' , '183.60655737705' , '22' , '0' , '273.28' ) 12/12/2024 04:25:10 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 ( '94831' , '22841' , 'STOLA CANAPA/LINO - 60/3098' , '1' , '-1' , '1' , '109.0000' , '89.344262295082' , '22' , '0' , '132.98' ) 12/12/2024 04:26:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '35' AND id_document != '94831' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 04:26:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '35', document_date = '2024-12-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670237', address1 = 'VIA ROMA, 10 54035 FOSDINOVO', address2 = '', note = 'RESO DA CONTO DEPOSITO', 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 = '5426.52', price_tax_excluded = '4447.97', date_upd = NOW() WHERE id_document = '94831' 12/12/2024 04:26:22 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 = '94831' 12/12/2024 04:26:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94831' 12/12/2024 04:26:22 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 ( '94831' , '22829' , 'CASULA CON CROCE - 70/145-1' , '1' , '-1' , '1' , '367.0000' , '300.81967213115' , '22' , '0' , '447.74' ) 12/12/2024 04:26:22 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 ( '94831' , '22830' , 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439' , '1' , '-1' , '1' , '1415.0000' , '1159.8360655738' , '22' , '0' , '1726.30' ) 12/12/2024 04:26:22 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 ( '94831' , '22831' , 'COTTA MISTO LANA RICAMO A MANO - 70/423-1' , '1' , '-1' , '1' , '247.0000' , '202.45901639344' , '22' , '0' , '301.34' ) 12/12/2024 04:26:22 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 ( '94831' , '22832' , 'CASULA PURA SETA GREGGIA - 60/2035' , '1' , '-1' , '1' , '793.0000' , '650' , '22' , '0' , '967.46' ) 12/12/2024 04:26:22 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 ( '94831' , '22833' , ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504' , '1' , '-1' , '1' , '615.0000' , '504.09836065574' , '22' , '0' , '750.30' ) 12/12/2024 04:26:22 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 ( '94831' , '22834' , 'PALLA - 50/393' , '1' , '-1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '143.96' ) 12/12/2024 04:26:22 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 ( '94831' , '22835' , 'PALLA - 50/361.' , '3' , '-3' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '204.00' ) 12/12/2024 04:26:22 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 ( '94831' , '22842' , 'PALLA SETA CON RICAMO ARG mf - 50/331' , '1' , '-1' , '1' , '131.0000' , '107.37704918033' , '22' , '0' , '159.82' ) 12/12/2024 04:26:22 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 ( '94831' , '22836' , 'PALLA - 75/1634' , '2' , '-2' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '79.00' ) 12/12/2024 04:26:22 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 ( '94831' , '22839' , 'STOLA SETA - 70/506-1' , '1' , '-1' , '1' , '197.0000' , '161.47540983607' , '22' , '0' , '240.34' ) 12/12/2024 04:26:22 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 ( '94831' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '-1' , '1' , '224.0000' , '183.60655737705' , '22' , '0' , '273.28' ) 12/12/2024 04:26:22 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 ( '94831' , '22841' , 'STOLA CANAPA/LINO - 60/3098' , '1' , '-1' , '1' , '109.0000' , '89.344262295082' , '22' , '0' , '132.98' ) 12/12/2024 05:21:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3922' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 05:21:45 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' , '3922' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/12/2024 05:21:45 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 = '94832' 12/12/2024 05:21:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94832' 12/12/2024 05:21:45 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 ( '94832' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 12/12/2024 07:03:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '179' AND id_document != '93804' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-24') 12/12/2024 07:03:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '179', document_date = '2024-10-24', document_letter = '', id_customer = '1207', id_supplier = '', id_address = '4672082', address1 = 'VIA SS. SALVATORE, 2 84080 CALVANICO', address2 = '', note = '', price_shipping = '0.26', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '322.58', price_tax_excluded = '322.58', date_upd = NOW() WHERE id_document = '93804' 12/12/2024 07:03: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 = '93804' 12/12/2024 07:03:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93804' 12/12/2024 07:03: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 ( '93804' , '2679' , 'CONOSCERE GESU\'' , '26' , '-26' , '4' , '3.5000' , '3.5' , '0' , '15' , '77.35' ) 12/12/2024 07:03: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 ( '93804' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '17' , '-17' , '4' , '3.4000' , '3.4' , '0' , '15' , '49.13' ) 12/12/2024 07:03: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 ( '93804' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 12/12/2024 07:03: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 ( '93804' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '14' , '-14' , '4' , '3.8000' , '3.8' , '0' , '15' , '45.22' ) 12/12/2024 07:03: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 ( '93804' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '18' , '-18' , '4' , '3.8000' , '3.8' , '0' , '15' , '58.14' ) 12/12/2024 07:03: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 ( '93804' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '16' , '-16' , '4' , '3.8000' , '3.8' , '0' , '15' , '51.68' ) 12/12/2024 07:05:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3923' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 07:05:20 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' , '3923' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '61.22' , NOW() , NOW() ) 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94833' 12/12/2024 07:05:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94833' 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94833' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94833' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94833' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94833' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '20' , '-20' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '40.00' ) 12/12/2024 07:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94833' , '23199' , 'VERBUM CARO FACTUM EST' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 12/12/2024 07:06:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3924' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 07:06:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3924' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 12/12/2024 07:06:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94834' 12/12/2024 07:06:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94834' 12/12/2024 07:06:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94834' , '19351' , 'SERVIZIO MESSA COTONE - 7050' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 12/12/2024 07:09:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3925' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 07:09:47 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' , '3925' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.90' , '64.49' , NOW() , NOW() ) 12/12/2024 07:09:47 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 = '94835' 12/12/2024 07:09:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '94835' 12/12/2024 07:09:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94835' , '6402' , 'MENSA BIANCA 60X200 ' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 12/12/2024 07:09:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94835' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 12/12/2024 07:37:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 07:37:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '47' , '2024-12-12' , '' , '6332' , '0' , '4682801' , 'piazza san Francesco n. 1 14036 Moncalvo' , '' , '' , '5.65' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '64.31' , '64.31' , NOW() , NOW() ) 12/12/2024 07:37:47 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 = '14778' 12/12/2024 07:37:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '14778' 12/12/2024 07:37:47 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 ( '14778' , '13' , 'BUSSATE E VI SARÀ APERTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '33' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '67' , 'CON GESU\' SULLA VIA DELLA CROCE - VIA CRUCIS ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '117' , 'La preghiera delle cinque dita n.e.' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '123' , 'DIO E\' IN DIECI PAROLE - COMANDAMENTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU\'' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '139' , 'E\' NATO - n.e.' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '137' , 'AVVENTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 12/12/2024 07:37:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14778' , '136' , 'ANGELO DI DIO N.E.' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 12/12/2024 07:47:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-12') 12/12/2024 07:47:02 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' , '3926' , '2024-12-12' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 12/12/2024 07:47:02 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 = '94836' 12/12/2024 07:47:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94836' 12/12/2024 07:47:02 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 ( '94836' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )