15/05/2025 08:37:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1453' AND id_document != '96925' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-30') 15/05/2025 08:37:54 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1453', document_date = '2025-04-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 = '18.50', price_tax_excluded = '18.50', date_upd = NOW() WHERE id_document = '96925' 15/05/2025 08:37:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96925' 15/05/2025 08:37:54 am >> DELETE FROM ps_document_detail WHERE id_document = '96925' 15/05/2025 08:37:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96925' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 15/05/2025 08:38:18 am >> SELECT document_num FROM ps_document WHERE document_num = '339' AND id_document != '95539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-31') 15/05/2025 08:38:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '339', document_date = '2025-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '17.58', price_tax_excluded = '17.58', date_upd = NOW() WHERE id_document = '95539' 15/05/2025 08:38:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95539' 15/05/2025 08:38:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95539' 15/05/2025 08:38:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95539' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 08:38:39 am >> SELECT document_num FROM ps_document WHERE document_num = '4057' AND id_document != '95004' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-23') 15/05/2025 08:38:39 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4057', document_date = '2024-12-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '16.00', price_tax_excluded = '16.00', date_upd = NOW() WHERE id_document = '95004' 15/05/2025 08:38:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95004' 15/05/2025 08:38:39 am >> DELETE FROM ps_document_detail WHERE id_document = '95004' 15/05/2025 08:38:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95004' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' ) 15/05/2025 08:39:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3831' AND id_document != '94728' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-06') 15/05/2025 08:39:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3831', 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 = '25.08', price_tax_excluded = '23.73', date_upd = NOW() WHERE id_document = '94728' 15/05/2025 08:39:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94728' 15/05/2025 08:39:02 am >> DELETE FROM ps_document_detail WHERE id_document = '94728' 15/05/2025 08:39:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94728' , '935' , 'BAMBINO CM 7,5 DIPINTO - P3' , '3' , '-3' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '7.50' ) 15/05/2025 08:39:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94728' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 08:39:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3416' AND id_document != '94175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-11') 15/05/2025 08:39:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3416', document_date = '2024-11-11', 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 = '17.58', price_tax_excluded = '17.58', date_upd = NOW() WHERE id_document = '94175' 15/05/2025 08:39: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 = '94175' 15/05/2025 08:39:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94175' 15/05/2025 08:39: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 ( '94175' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 08:39:56 am >> SELECT document_num FROM ps_document WHERE document_num = '2701' AND id_document != '93162' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 15/05/2025 08:39:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2701', document_date = '2024-09-16', 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 = '17.58', price_tax_excluded = '17.58', date_upd = NOW() WHERE id_document = '93162' 15/05/2025 08:39:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93162' 15/05/2025 08:39:56 am >> DELETE FROM ps_document_detail WHERE id_document = '93162' 15/05/2025 08:39:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93162' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 08:41:22 am >> SELECT document_num FROM ps_document WHERE document_num = '668' AND id_document != '90654' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 15/05/2025 08:41:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '668', document_date = '2024-03-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 = '18.58', price_tax_excluded = '18.58', date_upd = NOW() WHERE id_document = '90654' 15/05/2025 08:41:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90654' 15/05/2025 08:41:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90654' 15/05/2025 08:41:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90654' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 08:41:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90654' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 15/05/2025 09:28:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 09:28: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 ( '11' , '1674' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.00' , '33.00' , NOW() , NOW() ) 15/05/2025 09:28: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 = '97191' 15/05/2025 09:28:40 am >> DELETE FROM ps_document_detail WHERE id_document = '97191' 15/05/2025 09:28: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 ( '97191' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '0' , '33.00' ) 15/05/2025 09:30:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 09:30:28 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' , '1675' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.58' , '65.94' , NOW() , NOW() ) 15/05/2025 09:30: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 = '97192' 15/05/2025 09:30:28 am >> DELETE FROM ps_document_detail WHERE id_document = '97192' 15/05/2025 09:30: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 ( '97192' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 15/05/2025 09:30: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 ( '97192' , '21899' , 'SACRA BIBBIA cei/uelci ' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 15/05/2025 10:43:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 10:43:41 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' , '1676' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 15/05/2025 10:43:41 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 = '97193' 15/05/2025 10:43:41 am >> DELETE FROM ps_document_detail WHERE id_document = '97193' 15/05/2025 10:43: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 ( '97193' , '8643' , 'QUADRETTO PORTA FOTO I COM. - OGGETTI' , '1' , '-1' , '1' , '16.3' , '13.360655737705' , '22' , '0' , '16.30' ) 15/05/2025 10:43: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 ( '97193' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '1' , '-1' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '2.70' ) 15/05/2025 10:46:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 10:46:14 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' , '1677' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.66' , '4.66' , NOW() , NOW() ) 15/05/2025 10:46:14 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 = '97194' 15/05/2025 10:46:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97194' 15/05/2025 10:46:14 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 ( '97194' , '18057' , 'ROSARIO CON PAPA FRANCESCO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 15/05/2025 11:05:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 11:05:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1678' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '326.20' , '313.40' , NOW() , NOW() ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97195' 15/05/2025 11:05:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97195' 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '20' , '-20' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.00' ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '7907' , 'PERGAMENE' , '30' , '-30' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '15.00' ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '28.00' ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '1090' , 'BIBBIA' , '20' , '-20' , '4' , '9.90' , '9.9' , '0' , '5' , '188.20' ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '20516' , 'CROCE COMUNIONE - 42/08' , '30' , '-30' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '36.00' ) 15/05/2025 11:05:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97195' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '15' , '15' , '0' , '0' , '45.00' ) 15/05/2025 11:17:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '97016' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-06') 15/05/2025 11:17:14 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1523', document_date = '2025-05-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 = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '97016' 15/05/2025 11:17:14 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 = '97016' 15/05/2025 11:17:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97016' 15/05/2025 11:17:14 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 ( '97016' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 15/05/2025 11:17:14 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 ( '97016' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 15/05/2025 11:45:03 am >> SELECT document_num FROM ps_document WHERE document_num = '19/E' AND id_document != '97187' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-14') 15/05/2025 11:45:03 am >> UPDATE ps_document SET id_document_type = '23', document_num = '19/E', document_date = '2025-05-14', document_letter = 'E', id_customer = '2938', id_supplier = '', id_address = '4678844', address1 = 'VIA ARCIVESCOVATO 31 55100 LUCCA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '100.00', date_upd = NOW() WHERE id_document = '97187' 15/05/2025 11:45:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97187' 15/05/2025 11:45:03 am >> DELETE FROM ps_document_detail WHERE id_document = '97187' 15/05/2025 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97187' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '15' , '-15' , '4' , '10.0000' , '10' , '0' , '40' , '90.00' ) 15/05/2025 11:45:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97187' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/05/2025 11:55:01 am >> SELECT document_num FROM ps_document WHERE document_num = '1679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 11:55:01 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' , '1679' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.50' , '24.82' , NOW() , NOW() ) 15/05/2025 11:55:01 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 = '97196' 15/05/2025 11:55:01 am >> DELETE FROM ps_document_detail WHERE id_document = '97196' 15/05/2025 11:55:01 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 ( '97196' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 15/05/2025 11:55:01 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 ( '97196' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 15/05/2025 11:56:40 am >> SELECT document_num FROM ps_document WHERE document_num = '14/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 11:56: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 ( '23' , '14/L' , '2025-05-15' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '821.80' , '693.73' , NOW() , NOW() ) 15/05/2025 11:56: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 = '97197' 15/05/2025 11:56:40 am >> DELETE FROM ps_document_detail WHERE id_document = '97197' 15/05/2025 11:56: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 ( '97197' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 15/05/2025 11:56: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 ( '97197' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.0000' , '36.0656' , '22' , '0' , '44.00' ) 15/05/2025 11:56: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 ( '97197' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.0000' , '147.541' , '22' , '0' , '180.00' ) 15/05/2025 11:56: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 ( '97197' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '2' , '-2' , '1' , '46.0000' , '37.7049' , '22' , '0' , '92.00' ) 15/05/2025 11:56: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 ( '97197' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '328.0000' , '268.8525' , '22' , '0' , '328.00' ) 15/05/2025 11:56: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 ( '97197' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 15/05/2025 11:56: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 ( '97197' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3654' , '4' , '0' , '7.00' ) 15/05/2025 11:56: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 ( '97197' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 15/05/2025 11:56: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 ( '97197' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754' , '22' , '0' , '7.90' ) 15/05/2025 11:57:09 am >> SELECT document_num FROM ps_document WHERE document_num = '14/L' AND id_document != '97197' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 11:57:09 am >> UPDATE ps_document SET id_document_type = '23', document_num = '14/L', document_date = '2025-05-15', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'hospice solofra', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '821.80', price_tax_excluded = '693.73', date_upd = NOW() WHERE id_document = '97197' 15/05/2025 11:57:09 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 = '97197' 15/05/2025 11:57:09 am >> DELETE FROM ps_document_detail WHERE id_document = '97197' 15/05/2025 11:57:09 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 ( '97197' , '17330' , 'MESSALE ROMANO D\'ALTARE N. E. ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 15/05/2025 11:57:09 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 ( '97197' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.0000' , '36.065573770492' , '22' , '0' , '44.00' ) 15/05/2025 11:57:09 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 ( '97197' , '22216' , 'CALICE CLASSICO - 885' , '1' , '-1' , '1' , '180.0000' , '147.54098360656' , '22' , '0' , '180.00' ) 15/05/2025 11:57:09 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 ( '97197' , '16765' , 'MELOGRANO CON BASE OTTONE DORATO - 1021/B' , '2' , '-2' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '92.00' ) 15/05/2025 11:57:09 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 ( '97197' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '328.0000' , '268.85245901639' , '22' , '0' , '328.00' ) 15/05/2025 11:57:09 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 ( '97197' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 15/05/2025 11:57:09 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 ( '97197' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/05/2025 11:57:09 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 ( '97197' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 15/05/2025 11:57:09 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 ( '97197' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 15/05/2025 11:59:22 am >> DELETE FROM ps_document WHERE id_document = '96985' 15/05/2025 11:59:22 am >> DELETE FROM ps_document_detail WHERE id_document = '96985' 15/05/2025 12:10:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 12:10:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1680' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.00' , '34.43' , NOW() , NOW() ) 15/05/2025 12:10:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97198' 15/05/2025 12:10:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '97198' 15/05/2025 12:10:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97198' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '60' , '-60' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '42.00' ) 15/05/2025 12:57:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1681' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 12:57: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' , '1681' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '33.61' , NOW() , NOW() ) 15/05/2025 12:57: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 = '97199' 15/05/2025 12:57:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97199' 15/05/2025 12:57: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 ( '97199' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '41' , '33.606557377049' , '22' , '0' , '41.00' ) 15/05/2025 12:59:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 12:59: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' , '1682' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 15/05/2025 12:59: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 = '97200' 15/05/2025 12:59:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97200' 15/05/2025 12:59: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 ( '97200' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '41.00' , '33.606557377049' , '22' , '0' , '41.00' ) 15/05/2025 12:59: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 ( '97200' , '8082' , 'POLO LIMITED ' , '2' , '-2' , '1' , '27' , '22.131147540984' , '22' , '0' , '54.00' ) 15/05/2025 12:59:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 12:59: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' , '1683' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 15/05/2025 12:59: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 = '97201' 15/05/2025 12:59:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '97201' 15/05/2025 12:59: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 ( '97201' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '1' , '-1' , '1' , '44.00' , '36.065573770492' , '22' , '0' , '44.00' ) 15/05/2025 01:00:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1681' AND id_document != '97199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 01:00:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1681', document_date = '2025-05-15', 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 = '41.00', price_tax_excluded = '33.61', date_upd = NOW() WHERE id_document = '97199' 15/05/2025 01:00: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 = '97199' 15/05/2025 01:00:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97199' 15/05/2025 01:00: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 ( '97199' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 15/05/2025 01:00: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 ( '97199' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 15/05/2025 02:23:44 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/05/2025 02:23:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23754' , '1' , '' , 'nuovo-prodotto' ) 15/05/2025 02:23:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23754' , '1' , '1' , '2' , NOW() , NOW() ) 15/05/2025 02:23:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23754' , '0' , '1' , '0' , '0' ) 15/05/2025 02:24:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254713723' AND id_product != '23754' AND ean13 != '' 15/05/2025 02:24:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/5', ean13 = '9791254713723', date_upd = NOW() WHERE id_product = '23754' 15/05/2025 02:24:36 pm >> UPDATE ps_product_lang SET name = 'CANTO DELLA RANA - G. RAVASI', description = '' WHERE id_product = '23754' 15/05/2025 02:24:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23754' 15/05/2025 02:24:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23754' 15/05/2025 02:24:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '23754' 15/05/2025 02:24:36 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 = '23754' 15/05/2025 02:24:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23755' , '1' , '' , 'nuovo-prodotto' ) 15/05/2025 02:24:36 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 '23755' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23754' 15/05/2025 02:24:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23755' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23754' 15/05/2025 02:28:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810724057' AND id_product != '23755' AND ean13 != '' 15/05/2025 02:28:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788810724057', date_upd = NOW() WHERE id_product = '23755' 15/05/2025 02:28:46 pm >> UPDATE ps_product_lang SET name = 'VIAGGIO NEI MIRACOLI EUCARISTICI - M. BUIONI', description = '' WHERE id_product = '23755' 15/05/2025 02:28:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.5' WHERE id_product = '23755' 15/05/2025 02:28:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.5', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23755' 15/05/2025 02:28:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '23755' 15/05/2025 02:28:47 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 = '23755' 15/05/2025 02:28:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23756' , '1' , '' , 'nuovo-prodotto' ) 15/05/2025 02:28:47 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 '23756' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23755' 15/05/2025 02:28:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23756' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23755' 15/05/2025 02:29:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '00145268' , '2025-05-14' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '194.36' , '194.36' , NOW() , NOW() ) 15/05/2025 02:29: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 = '97202' 15/05/2025 02:29:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '97202' 15/05/2025 02:29: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 ( '97202' , '23754' , 'CANTO DELLA RANA - G. RAVASI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 15/05/2025 02:29:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23754' AND id_supplier = '109' 15/05/2025 02:29:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23754' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '23235' , 'DIO ESISTE? - ROBERT SARAH' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 15/05/2025 02:29:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23235' AND id_supplier = '109' 15/05/2025 02:29:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23235' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '23746' , 'DIO CRISTO LA CHIESA - A. CATTANEO' , '1' , '1' , '4' , '23.00' , '23' , '0' , '35' , '14.9500' ) 15/05/2025 02:29:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23746' AND id_supplier = '109' 15/05/2025 02:29:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23746' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '2640' , 'CONFESSIONI - S. AGOSTINO ' , '1' , '1' , '4' , '8.00' , '8' , '0' , '30' , '5.6000' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2640' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2640' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '23416' , 'CREDO COMPENDIO DELLA FEDE CATTOLICA - A. SCHNEIDER' , '1' , '1' , '4' , '25.90' , '25.9' , '0' , '30' , '18.1300' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23416' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23416' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '7182' , 'NUOVO TESTAMENTO - CAR. GRANDI' , '2' , '2' , '4' , '39.00' , '39' , '0' , '37' , '49.1400' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7182' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7182' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '37' , '12.6000' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '1' , '4' , '41.00' , '41' , '0' , '37' , '25.8300' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '23755' , 'VIAGGIO NEI MIRACOLI EUCARISTICI - M. BUIONI' , '2' , '2' , '4' , '17.50' , '17.5' , '0' , '37' , '22.0500' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23755' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23755' , '109' , '1' ) 15/05/2025 02:29: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 ( '97202' , '22283' , 'BIBBIA DI GERUSALEMME VERDE' , '1' , '1' , '4' , '32.00' , '32' , '0' , '37' , '20.1600' ) 15/05/2025 02:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22283' AND id_supplier = '109' 15/05/2025 02:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22283' , '109' , '1' ) 15/05/2025 02:36:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928085' AND id_product != '22978' AND ean13 != '' 15/05/2025 02:36:13 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/3', ean13 = '9788839928085', date_upd = NOW() WHERE id_product = '22978' 15/05/2025 02:36:13 pm >> UPDATE ps_product_lang SET name = 'MISTERO PASQUALE E LITURGIA DELLE ORE - A.J. LAMBERT', description = '' WHERE id_product = '22978' 15/05/2025 02:36:13 pm >> UPDATE ps_product SET wholesale_price = '12.60', on_sale = '0', price = '18.0000' WHERE id_product = '22978' 15/05/2025 02:36:13 pm >> UPDATE ps_product_shop SET wholesale_price = '12.60', price = '18.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22978' 15/05/2025 02:36:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22978' 15/05/2025 03:55:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/S' AND id_document != '14813' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 03:55:14 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '11/S', document_date = '2025-05-15', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '275.00', price_tax_excluded = '275.00', date_upd = NOW() WHERE id_document = '14813' 15/05/2025 03:55:14 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 = '14813' 15/05/2025 03:55:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '14813' 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '120' , 'Libro Agenda cattolico 2019' , '20' , '-20' , '4' , '16.0000' , '16' , '0' , '50' , '160.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '128' , 'LIBRO AGENDA CATTOLICO 2021' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '50' , '8.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '50' , '9.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '7' , '-7' , '4' , '18.0000' , '18' , '0' , '50' , '63.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '52' , 'Il Padre Nostro spiegato ai bambini' , '8' , '-8' , '4' , '2.0000' , '2' , '0' , '50' , '8.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '34' , 'LE MIE PREGHIERINE' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.00' ) 15/05/2025 03:55:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14813' , '114' , 'Le preghiere dei ragazzi' , '32' , '-32' , '4' , '1.5000' , '1.5' , '0' , '50' , '24.00' ) 15/05/2025 04:41:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 04:41:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1684' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.00' , '50.00' , NOW() , NOW() ) 15/05/2025 04:41:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97203' 15/05/2025 04:41:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97203' 15/05/2025 04:41:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97203' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 15/05/2025 04:41:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97203' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 15/05/2025 05:17:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 05:17: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' , '1685' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.90' , '14.67' , NOW() , NOW() ) 15/05/2025 05:17: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 = '97204' 15/05/2025 05:17:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97204' 15/05/2025 05:17: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 ( '97204' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 15/05/2025 05:17: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 ( '97204' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 15/05/2025 05:30:32 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1090' 15/05/2025 05:30:32 pm >> UPDATE ps_stock_available SET quantity = quantity + '-13' WHERE id_product = '1090' 15/05/2025 06:26:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-15') 15/05/2025 06:26:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1686' , '2025-05-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '406.00' , '332.79' , NOW() , NOW() ) 15/05/2025 06:26:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97205' 15/05/2025 06:26:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97205' 15/05/2025 06:26:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97205' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '406' , '332.7868852459' , '22' , '0' , '406.00' )