29/01/2025 08:54:52 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/01/2025 08:54:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23393' , '1' , '' , 'nuovo-prodotto' ) 29/01/2025 08:54:52 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23393' , '1' , '1' , '2' , NOW() , NOW() ) 29/01/2025 08:54:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23393' , '0' , '1' , '0' , '0' ) 29/01/2025 08:56:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391318' AND id_product != '23393' AND ean13 != '' 29/01/2025 08:56:05 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9791256391318', date_upd = NOW() WHERE id_product = '23393' 29/01/2025 08:56:05 am >> UPDATE ps_product_lang SET name = 'SULLA TUA PAROLA - GEN/FEB 25', description = '' WHERE id_product = '23393' 29/01/2025 08:56:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '23393' 29/01/2025 08:56:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '106', 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 = '23393' 29/01/2025 08:56:05 am >> DELETE FROM ps_specific_price WHERE id_product = '23393' 29/01/2025 08:57:42 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 ( '31' , '1345/00/2025' , '2025-01-27' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , 'PAGATO € 175,20 - SCALATO N. C.' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '390.00' , '390.00' , NOW() , NOW() ) 29/01/2025 08:57: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 = '95472' 29/01/2025 08:57:42 am >> DELETE FROM ps_document_detail WHERE id_document = '95472' 29/01/2025 08:57: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 ( '95472' , '23393' , 'SULLA TUA PAROLA - GEN/FEB 25' , '130' , '130' , '4' , '5.00' , '5' , '0' , '40' , '390.0000' ) 29/01/2025 08:57:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '23393' AND id_supplier = '38' 29/01/2025 08:57:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23393' , '38' , '1' ) 29/01/2025 08:59:18 am >> SELECT document_num FROM ps_document WHERE document_num = '281' AND id_document != '95465' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-28') 29/01/2025 08:59:18 am >> UPDATE ps_document SET id_document_type = '11', document_num = '281', document_date = '2025-01-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 = '10.40', price_tax_excluded = '8.52', date_upd = NOW() WHERE id_document = '95465' 29/01/2025 08:59: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 = '95465' 29/01/2025 08:59:18 am >> DELETE FROM ps_document_detail WHERE id_document = '95465' 29/01/2025 08:59: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 ( '95465' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.9' , '6.4754098360656' , '22' , '0' , '7.90' ) 29/01/2025 08:59: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 ( '95465' , '7202' , 'ARTICOLI RELIGIOSI' , '10' , '-10' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.50' ) 29/01/2025 09:14:45 am >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 09:14:45 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' , '287' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '299.13' , '264.59' , NOW() , NOW() ) 29/01/2025 09:14:45 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 = '95473' 29/01/2025 09:14:45 am >> DELETE FROM ps_document_detail WHERE id_document = '95473' 29/01/2025 09:14:45 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 ( '95473' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 29/01/2025 09:14:45 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 ( '95473' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/01/2025 09:14:45 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 ( '95473' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/01/2025 09:14:45 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 ( '95473' , '23360' , 'QUARESIMA E PASQUA 2025' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 29/01/2025 09:14:45 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 ( '95473' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 29/01/2025 09:14:45 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 ( '95473' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 29/01/2025 09:14:45 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 ( '95473' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '12.90' ) 29/01/2025 09:14:45 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 ( '95473' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '12' , '-12' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '42.00' ) 29/01/2025 09:14:45 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 ( '95473' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '8' , '-8' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '16.00' ) 29/01/2025 09:44:23 am >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 09:44:23 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' , '288' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 29/01/2025 09:44:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95474' 29/01/2025 09:44:23 am >> DELETE FROM ps_document_detail WHERE id_document = '95474' 29/01/2025 09:44:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95474' , '23340' , 'PER UNA CHIESA SINODALE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 29/01/2025 10:24:46 am >> DELETE FROM ps_document WHERE id_document = '95381' 29/01/2025 10:24:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95381' 29/01/2025 10:25:14 am >> SELECT document_num FROM ps_document WHERE document_num = '289' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 10:25: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' , '289' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '186.50' , '156.20' , NOW() , NOW() ) 29/01/2025 10:25: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 = '95475' 29/01/2025 10:25:14 am >> DELETE FROM ps_document_detail WHERE id_document = '95475' 29/01/2025 10:25: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 ( '95475' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 29/01/2025 10:25: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 ( '95475' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/01/2025 10:25: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 ( '95475' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 29/01/2025 10:25: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 ( '95475' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 29/01/2025 10:25: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 ( '95475' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '63' , '51.639344262295' , '22' , '0' , '63.00' ) 29/01/2025 11:16:43 am >> SELECT document_num FROM ps_document WHERE document_num = '30/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 11:16: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 ( '24' , '30/A' , '2025-01-29' , 'A' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 29/01/2025 11:16: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 = '95476' 29/01/2025 11:16:43 am >> DELETE FROM ps_document_detail WHERE id_document = '95476' 29/01/2025 11:16: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 ( '95476' , '15210' , 'CERO PASQUALE API 80X120' , '4' , '-4' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 29/01/2025 11:28:17 am >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 11:28:17 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' , '290' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.80' , '7.03' , NOW() , NOW() ) 29/01/2025 11:28: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 = '95477' 29/01/2025 11:28:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95477' 29/01/2025 11:28: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 ( '95477' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 29/01/2025 11:28: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 ( '95477' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 29/01/2025 12:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 12:04:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '291' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.30' , '79.88' , NOW() , NOW() ) 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95478' 29/01/2025 12:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '95478' 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 29/01/2025 12:04:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95478' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 29/01/2025 12:05:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '292' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 12:05:58 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' , '292' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '99.00' , NOW() , NOW() ) 29/01/2025 12:05:58 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 = '95479' 29/01/2025 12:05:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '95479' 29/01/2025 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95479' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/01/2025 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95479' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '12.75' , '10.450819672131' , '22' , '0' , '25.50' ) 29/01/2025 12:05:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95479' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 29/01/2025 03:25:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '293' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 03:25: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' , '293' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.70' , '44.02' , NOW() , NOW() ) 29/01/2025 03:25: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 = '95480' 29/01/2025 03:25:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '95480' 29/01/2025 03:25: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 ( '95480' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '3' , '-3' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '53.70' ) 29/01/2025 04:30:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1' AND id_document != '95180' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-07') 29/01/2025 04:30:11 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '1', document_date = '2025-01-07', document_letter = '', id_customer = '2173', id_supplier = '', id_address = '4679183', address1 = 'VIA ROMA 32 67030 BARREA', address2 = '', note = '', price_shipping = '3.9', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '35.40', price_tax_excluded = '35.40', date_upd = NOW() WHERE id_document = '95180' 29/01/2025 04:30:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95180' 29/01/2025 04:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '95180' 29/01/2025 04:30:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95180' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '10' , '31.50' ) 29/01/2025 04:31:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4' AND id_document != '95270' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-14') 29/01/2025 04:31:34 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '4', document_date = '2025-01-14', document_letter = '', id_customer = '3266', id_supplier = '', id_address = '4679047', address1 = 'VIA DANTE 35 07010 MARA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '83.51', price_tax_excluded = '83.51', date_upd = NOW() WHERE id_document = '95270' 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95270' 29/01/2025 04:31:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '95270' 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '7' , '-7' , '4' , '5.5000' , '5.5' , '0' , '5' , '36.57' ) 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '5444' , 'IO SONO CON VOI - CAT.' , '4' , '-4' , '4' , '5.5000' , '5.5' , '0' , '5' , '20.90' ) 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '5458' , 'IO SONO CON VOI 2 PARTE' , '4' , '-4' , '4' , '2.8000' , '2.8' , '0' , '5' , '10.64' ) 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '3' , '-3' , '4' , '2.0000' , '2' , '0' , '5' , '5.70' ) 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '0' , 'spese di contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 29/01/2025 04:31:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95270' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '-2' , '4' , '3.4' , '3.4' , '0' , '0' , '6.80' ) 29/01/2025 04:32:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '95289' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-15') 29/01/2025 04:32:17 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '6', document_date = '2025-01-15', document_letter = '', id_customer = '3983', id_supplier = '', id_address = '4679455', address1 = 'P. ZZA ANNUNZIATA 03037 PONTECORVO', 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 = '286.87', price_tax_excluded = '286.87', date_upd = NOW() WHERE id_document = '95289' 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95289' 29/01/2025 04:32:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '95289' 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95289' , '5458' , 'IO SONO CON VOI 2 PARTE' , '9' , '-9' , '4' , '2.8000' , '2.8' , '0' , '15' , '21.42' ) 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95289' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '17' , '-17' , '4' , '3.4000' , '3.4' , '0' , '15' , '49.13' ) 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95289' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '14' , '-14' , '4' , '5.5000' , '5.5' , '0' , '15' , '65.45' ) 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95289' , '11193' , 'VENITE CON ME CAT.' , '31' , '-31' , '4' , '5.5000' , '5.5' , '0' , '15' , '144.92' ) 29/01/2025 04:32:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95289' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '7' , '-7' , '4' , '1.00' , '1' , '0' , '15' , '5.95' ) 29/01/2025 04:35:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '95294' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-15') 29/01/2025 04:35:36 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '150', document_date = '2025-01-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 = '100.00', price_tax_excluded = '81.97', date_upd = NOW() WHERE id_document = '95294' 29/01/2025 04:35:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95294' 29/01/2025 04:35:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '95294' 29/01/2025 04:35:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95294' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 29/01/2025 04:35:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95294' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/01/2025 04:35:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '95303' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-16') 29/01/2025 04:35:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '157', document_date = '2025-01-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', 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 = '94.90', price_tax_excluded = '77.79', date_upd = NOW() WHERE id_document = '95303' 29/01/2025 04:35: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 = '95303' 29/01/2025 04:35:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '95303' 29/01/2025 04:35: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 ( '95303' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 29/01/2025 04:35: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 ( '95303' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 29/01/2025 04:35: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 ( '95303' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '2' , '-2' , '1' , '9' , '7.3770491803279' , '22' , '0' , '18.00' ) 29/01/2025 04:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 04:45:51 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' , '294' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.53' , '25.91' , NOW() , NOW() ) 29/01/2025 04:45:51 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 = '95481' 29/01/2025 04:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '95481' 29/01/2025 04:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95481' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 29/01/2025 04:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95481' , '8288' , 'PREGHIERA DEL MATTINO E DELLA SERA - GR - PER LAICI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 29/01/2025 04:47:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '295' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 04:47: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' , '295' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 29/01/2025 04:47: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 = '95482' 29/01/2025 04:47:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '95482' 29/01/2025 04:47: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 ( '95482' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/01/2025 04:47: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 ( '95482' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/01/2025 05:44:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 05:44: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' , '296' , '2025-01-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.00' , '26.23' , NOW() , NOW() ) 29/01/2025 05:44: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 = '95483' 29/01/2025 05:44:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95483' 29/01/2025 05:44: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 ( '95483' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 29/01/2025 05:44: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 ( '95483' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.8' , '16.229508196721' , '22' , '0' , '19.80' ) 29/01/2025 05:45:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '296' AND id_document != '95483' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 05:45:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '296', document_date = '2025-01-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '95483' 29/01/2025 05:45: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 = '95483' 29/01/2025 05:45:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '95483' 29/01/2025 05:45: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 ( '95483' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.2' , '10' , '22' , '0' , '12.20' ) 29/01/2025 05:45: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 ( '95483' , '16248' , 'APPENDICHIAVI 16X11' , '1' , '-1' , '1' , '19.8000' , '16.229508196721' , '22' , '0' , '19.80' ) 29/01/2025 07:53:07 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'VArQuxfz2giVRx9C' , NOW() , NOW() ) 29/01/2025 07:53:07 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4160' , '1' ) 29/01/2025 07:53:07 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4160' , '2' ) 29/01/2025 07:53:07 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4160' , '3' ) 29/01/2025 07:54:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4160' 29/01/2025 07:54:52 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 ( '4160' , '10' , '134' , 'PARROCCHIA SANTA MARIA DEI GRECI' , 'CARETTI' , 'DON DONATO ' , 'VIA VALFORTORE' , '' , '82020' , 'MOLINARA' , '' , '' , '3348388342' , '' , '' , NOW() , NOW() ) 29/01/2025 07:54:52 pm >> UPDATE ps_customer SET email = 'donatocaretti@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4160' 29/01/2025 07:55:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-01-29') 29/01/2025 07:55:41 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' , '16' , '2025-01-29' , '' , '4160' , '0' , '4679459' , 'VIA VALFORTORE 82020 MOLINARA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '36.92' , '36.92' , NOW() , NOW() ) 29/01/2025 07:55:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95484' 29/01/2025 07:55:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '95484' 29/01/2025 07:55:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95484' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '5' , '13.30' ) 29/01/2025 07:55:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95484' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '5' , '18.62' )