07/05/2025 08:32:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048523' AND id_product != '20895' AND ean13 != '' 07/05/2025 08:32:49 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048523', date_upd = NOW() WHERE id_product = '20895' 07/05/2025 08:32:49 am >> UPDATE ps_product_lang SET name = 'NOVE MARTEDI\' DELL\'ANGELO CUSTODE - 8458', description = '' WHERE id_product = '20895' 07/05/2025 08:32:49 am >> UPDATE ps_product SET wholesale_price = '1.80', on_sale = '0', price = '3.0000' WHERE id_product = '20895' 07/05/2025 08:32:49 am >> UPDATE ps_product_shop SET wholesale_price = '1.80', price = '3.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20895' 07/05/2025 08:32:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20895' 07/05/2025 09:13:57 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 07/05/2025 09:14:31 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 07/05/2025 09:15:08 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 07/05/2025 09:16:50 am >> SELECT document_num FROM ps_document WHERE document_num = '11/S' AND id_document != '14806' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-17') 07/05/2025 09:16:50 am >> UPDATE ps_document SET id_document_type = '23', document_num = '11/S', document_date = '2025-04-17', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '177359088', address1 = 'VIA RIGLA 44 24010 PONTERANICA', 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 = '18.75', price_tax_excluded = '18.75', date_upd = NOW() WHERE id_document = '14806' 07/05/2025 09:16:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14806' 07/05/2025 09:16:50 am >> DELETE FROM ps_document_detail WHERE id_document = '14806' 07/05/2025 09:16:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14806' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '50' , '18.75' ) 07/05/2025 09:17:09 am >> SELECT document_num FROM ps_document WHERE document_num = '8/S' AND id_document != '14809' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 07/05/2025 09:17:09 am >> UPDATE ps_document SET id_document_type = '22', document_num = '8/S', document_date = '2025-05-05', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO APRILE 2025', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '1147.70', price_tax_excluded = '1147.70', date_upd = NOW() WHERE id_document = '14809' 07/05/2025 09:17: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 = '14809' 07/05/2025 09:17:09 am >> DELETE FROM ps_document_detail WHERE id_document = '14809' 07/05/2025 09:17: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 ( '14809' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '12.00' ) 07/05/2025 09:17: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 ( '14809' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '0.90' ) 07/05/2025 09:17: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 ( '14809' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '30' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '22.50' ) 07/05/2025 09:17: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 ( '14809' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 07/05/2025 09:17: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 ( '14809' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '257' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '321.25' ) 07/05/2025 09:17: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 ( '14809' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '6' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '7.50' ) 07/05/2025 09:17: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 ( '14809' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '208' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '260.00' ) 07/05/2025 09:17: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 ( '14809' , '125' , 'MIE PREGHIERINE - N. E.' , '32' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '24.00' ) 07/05/2025 09:17: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 ( '14809' , '33' , '100 GIORNI CON LO SPIRITO' , '13' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '48.75' ) 07/05/2025 09:17: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 ( '14809' , '50' , 'PERDONAMI SIGNORE' , '104' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '130.00' ) 07/05/2025 09:17: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 ( '14809' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '4' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '3.00' ) 07/05/2025 09:17: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 ( '14809' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '11' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '11.00' ) 07/05/2025 09:17: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 ( '14809' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/05/2025 09:17: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 ( '14809' , '88' , 'GESÙ È RISORTO' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 07/05/2025 09:17: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 ( '14809' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '12' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '10.80' ) 07/05/2025 09:17: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 ( '14809' , '92' , 'LA PREGHIERA DEL ROSARIO' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 07/05/2025 09:17: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 ( '14809' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 07/05/2025 09:17: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 ( '14809' , '104' , 'TEMPO DI QUARESIMA' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/05/2025 09:17: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 ( '14809' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 07/05/2025 09:17: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 ( '14809' , '110' , 'SE MI AMI NON PIANGERE' , '212' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '190.80' ) 07/05/2025 09:17: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 ( '14809' , '111' , 'I NONNI SONO UN TESORO' , '14' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '12.60' ) 07/05/2025 09:17: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 ( '14809' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 07/05/2025 09:17: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 ( '14809' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '8' , '0' , '4' , '4.0000' , '4' , '0' , '50' , '16.00' ) 07/05/2025 09:17:10 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 ( '14809' , '117' , 'La preghiera delle cinque dita n.e.' , '2' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '1.80' ) 07/05/2025 09:17:10 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 ( '14809' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 07/05/2025 09:17:10 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 ( '14809' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 07/05/2025 09:17:10 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 ( '14809' , '138' , 'LA NASCITA DI GESU' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 07/05/2025 09:17:10 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 ( '14809' , '139' , 'E NATO - n.e.' , '2' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '2.00' ) 07/05/2025 09:17:10 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 ( '14809' , '136' , 'ANGELO DI DIO N.E.' , '2' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '1.80' ) 07/05/2025 09:17:10 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 ( '14809' , '137' , 'AVVENTO' , '2' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 07/05/2025 09:17:10 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 ( '14809' , '126' , 'SACRAMENTO DEL PERDONO' , '27' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '27.00' ) 07/05/2025 09:17:45 am >> SELECT document_num FROM ps_document WHERE document_num = '9/S' AND id_document != '14810' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-05') 07/05/2025 09:17:45 am >> UPDATE ps_document SET id_document_type = '25', document_num = '9/S', document_date = '2025-05-05', document_letter = 'S', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA APRILE 2025', 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 = '112.70', price_tax_excluded = '112.70', date_upd = NOW() WHERE id_document = '14810' 07/05/2025 09:17: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 = '14810' 07/05/2025 09:17:45 am >> DELETE FROM ps_document_detail WHERE id_document = '14810' 07/05/2025 09:17: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 ( '14810' , '11' , 'COME PREPARARSI ALLA CONFESSIONE' , '1' , '1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/05/2025 09:17: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 ( '14810' , '17' , 'LA FEDE NELLO ZAINETTO' , '10' , '10' , '4' , '6.0000' , '6' , '0' , '50' , '30.00' ) 07/05/2025 09:17: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 ( '14810' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '1' , '1' , '4' , '1.5000' , '1.5' , '0' , '50' , '0.75' ) 07/05/2025 09:17: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 ( '14810' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '8' , '8' , '4' , '2.5000' , '2.5' , '0' , '50' , '10.00' ) 07/05/2025 09:17: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 ( '14810' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '2' , '2' , '4' , '2.5000' , '2.5' , '0' , '50' , '2.50' ) 07/05/2025 09:17: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 ( '14810' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/05/2025 09:17: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 ( '14810' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '1' , '1' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 07/05/2025 09:17: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 ( '14810' , '33' , '100 GIORNI CON LO SPIRITO' , '2' , '2' , '4' , '7.5000' , '7.5' , '0' , '50' , '7.50' ) 07/05/2025 09:17: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 ( '14810' , '35' , 'ANGELI - I NOSTRI MIGLIORI AMICI' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/05/2025 09:17: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 ( '14810' , '50' , 'PERDONAMI SIGNORE' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 07/05/2025 09:17: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 ( '14810' , '72' , 'FEDE, SPERANZA E CARITA' , '2' , '2' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 07/05/2025 09:17: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 ( '14810' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '3' , '3' , '4' , '1.8000' , '1.8' , '0' , '50' , '2.70' ) 07/05/2025 09:17: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 ( '14810' , '96' , 'LA PREGHIERA - MEDICINA DELLANIMA' , '8' , '8' , '4' , '1.5000' , '1.5' , '0' , '50' , '6.00' ) 07/05/2025 09:17: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 ( '14810' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '2' , '2' , '4' , '1.5000' , '1.5' , '0' , '50' , '1.50' ) 07/05/2025 09:17: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 ( '14810' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '1' , '1' , '4' , '2.0000' , '2' , '0' , '50' , '1.00' ) 07/05/2025 09:17: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 ( '14810' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '8' , '8' , '4' , '1.5000' , '1.5' , '0' , '50' , '6.00' ) 07/05/2025 09:17: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 ( '14810' , '104' , 'TEMPO DI QUARESIMA' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/05/2025 09:17: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 ( '14810' , '111' , 'I NONNI SONO UN TESORO' , '20' , '20' , '4' , '1.8000' , '1.8' , '0' , '50' , '18.00' ) 07/05/2025 09:17: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 ( '14810' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '1' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 07/05/2025 09:17: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 ( '14810' , '139' , 'E NATO - n.e.' , '3' , '3' , '4' , '2.0000' , '2' , '0' , '50' , '3.00' ) 07/05/2025 09:17: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 ( '14810' , '137' , 'AVVENTO' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 07/05/2025 09:19:24 am >> DELETE FROM ps_document WHERE id_document = '14806' 07/05/2025 09:19:24 am >> DELETE FROM ps_document_detail WHERE id_document = '14806' 07/05/2025 09:19:44 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 09:19: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 ( '23' , '10/S' , '2025-05-07' , 'S' , '3487' , '0' , '177359088' , 'VIA RIGLA 44 24010 PONTERANICA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.75' , '18.75' , NOW() , NOW() ) 07/05/2025 09:19: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 = '14812' 07/05/2025 09:19:45 am >> DELETE FROM ps_document_detail WHERE id_document = '14812' 07/05/2025 09:19: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 ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '50' , '18.75' ) 07/05/2025 09:21:35 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '14812' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-04-28') 07/05/2025 09:21:35 am >> UPDATE ps_document SET id_document_type = '23', document_num = '10/S', document_date = '2025-04-28', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '177359088', address1 = 'VIA RIGLA 44 24010 PONTERANICA', 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 = '18.75', price_tax_excluded = '18.75', date_upd = NOW() WHERE id_document = '14812' 07/05/2025 09:21:35 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14812' 07/05/2025 09:21:35 am >> DELETE FROM ps_document_detail WHERE id_document = '14812' 07/05/2025 09:21:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '50' , '18.75' ) 07/05/2025 09:25:46 am >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '14807' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-04-24') 07/05/2025 09:25:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '13', document_date = '2025-04-24', document_letter = '', id_customer = '2173', id_supplier = '', id_address = '88682004', address1 = 'VIA ROMA 32 67030 BARREA', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '45.90', price_tax_excluded = '45.90', date_upd = NOW() WHERE id_document = '14807' 07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14807' 07/05/2025 09:25:46 am >> DELETE FROM ps_document_detail WHERE id_document = '14807' 07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14807' , '126' , 'SACRAMENTO DEL PERDONO' , '15' , '-15' , '4' , '2.0000' , '2' , '0' , '5' , '28.50' ) 07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14807' , '125' , 'MIE PREGHIERINE - N. E.' , '7' , '-7' , '4' , '1.5' , '1.5' , '0' , '5' , '9.97' ) 07/05/2025 09:25:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14807' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '-1' , '4' , '0.53' , '0.53' , '0' , '0' , '0.53' ) 07/05/2025 09:49:33 am >> SELECT document_num FROM ps_document WHERE document_num = '10/S' AND id_document != '14812' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-05-02') 07/05/2025 09:49:33 am >> UPDATE ps_document SET id_document_type = '23', document_num = '10/S', document_date = '2025-05-02', document_letter = 'S', id_customer = '3487', id_supplier = '', id_address = '177359088', address1 = 'VIA RIGLA 44 24010 PONTERANICA', 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 = '18.75', price_tax_excluded = '18.75', date_upd = NOW() WHERE id_document = '14812' 07/05/2025 09:49:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14812' 07/05/2025 09:49:33 am >> DELETE FROM ps_document_detail WHERE id_document = '14812' 07/05/2025 09:49:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14812' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '50' , '18.75' ) 07/05/2025 10:21:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '86/D16418' AND id_product != '23335' AND ean13 != '' 07/05/2025 10:21:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '86/D16418', date_upd = NOW() WHERE id_product = '23335' 07/05/2025 10:21:41 am >> UPDATE ps_product_lang SET name = 'DALMATICA - 86/D16418', description = '' WHERE id_product = '23335' 07/05/2025 10:21:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '229.5082' WHERE id_product = '23335' 07/05/2025 10:21:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '229.5082', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23335' 07/05/2025 10:21:41 am >> DELETE FROM ps_specific_price WHERE id_product = '23335' 07/05/2025 10:34:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 07/05/2025 10:34:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23716' , '1' , '' , 'nuovo-prodotto' ) 07/05/2025 10:34:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23716' , '1' , '1' , '2' , NOW() , NOW() ) 07/05/2025 10:34:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23716' , '0' , '1' , '0' , '0' ) 07/05/2025 10:40:20 am >> SELECT document_num FROM ps_document WHERE document_num = '1537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 10:40: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' , '1537' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '24.98' , NOW() , NOW() ) 07/05/2025 10:40: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 = '97031' 07/05/2025 10:40:20 am >> DELETE FROM ps_document_detail WHERE id_document = '97031' 07/05/2025 10:40: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 ( '97031' , '20516' , 'CROCE COMUNIONE - 42/08' , '10' , '-10' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '13.00' ) 07/05/2025 10:40: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 ( '97031' , '18357' , 'MIE PREGHIERINE N.E.' , '6' , '-6' , '4' , '1.50' , '1.5' , '0' , '0' , '9.00' ) 07/05/2025 10:40: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 ( '97031' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '13' , '-13' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '6.50' ) 07/05/2025 10:41:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002376' AND id_product != '23716' AND ean13 != '' 07/05/2025 10:41:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002376', date_upd = NOW() WHERE id_product = '23716' 07/05/2025 10:41:49 am >> UPDATE ps_product_lang SET name = 'DALMATICA MARIANA - 86/DAL15236', description = '' WHERE id_product = '23716' 07/05/2025 10:41:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '385.24590163934425' WHERE id_product = '23716' 07/05/2025 10:41:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '385.24590163934425', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23716' 07/05/2025 10:41:49 am >> DELETE FROM ps_specific_price WHERE id_product = '23716' 07/05/2025 10:42:36 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' , '153' , '2025-04-24' , '' , '0' , '143' , '4670947' , 'VIA DELLE SELVETTE 324 55018 SEGROMIGNO IN MONTE CAPANNORI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '231.95' , '190.12' , NOW() , NOW() ) 07/05/2025 10:42:36 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 = '97032' 07/05/2025 10:42:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97032' 07/05/2025 10:42:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97032' , '23716' , 'DALMATICA MARIANA - 86/DAL15236' , '1' , '1' , '1' , '196' , '160.65573770492' , '22' , '3' , '231.9464' ) 07/05/2025 10:42:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '23716' AND id_supplier = '143' 07/05/2025 10:42:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23716' , '143' , '1' ) 07/05/2025 10:43:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 10:43:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1538' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 07/05/2025 10:43:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97033' 07/05/2025 10:43:15 am >> DELETE FROM ps_document_detail WHERE id_document = '97033' 07/05/2025 10:43:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97033' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 07/05/2025 10:44:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 10:44: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' , '1539' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 07/05/2025 10:44: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 = '97034' 07/05/2025 10:44:14 am >> DELETE FROM ps_document_detail WHERE id_document = '97034' 07/05/2025 10:44: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 ( '97034' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 07/05/2025 10:45:20 am >> DELETE FROM ps_document WHERE id_document = '96866' 07/05/2025 10:45:20 am >> DELETE FROM ps_document_detail WHERE id_document = '96866' 07/05/2025 10:45:31 am >> DELETE FROM ps_document WHERE id_document = '96800' 07/05/2025 10:45:31 am >> DELETE FROM ps_document_detail WHERE id_document = '96800' 07/05/2025 10:47:04 am >> DELETE FROM ps_document WHERE id_document = '96966' 07/05/2025 10:47:04 am >> DELETE FROM ps_document_detail WHERE id_document = '96966' 07/05/2025 10:47:52 am >> SELECT document_num FROM ps_document WHERE document_num = '47/A' AND id_document != '96002' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-03-03') 07/05/2025 10:47:52 am >> UPDATE ps_document SET id_document_type = '24', document_num = '47/A', document_date = '2025-03-03', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', address2 = '', note = '9', 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 = '236.00', price_tax_excluded = '221.93', date_upd = NOW() WHERE id_document = '96002' 07/05/2025 10:47:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96002' 07/05/2025 10:47:52 am >> DELETE FROM ps_document_detail WHERE id_document = '96002' 07/05/2025 10:47:52 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 ( '96002' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '10' , '-10' , '4' , '8.0000' , '8' , '0' , '0' , '80.00' ) 07/05/2025 10:47:52 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 ( '96002' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '3' , '-3' , '4' , '16.0000' , '16' , '0' , '0' , '48.00' ) 07/05/2025 10:47:52 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 ( '96002' , '23095' , 'PORTACHIAVI GIUBILEO - G1878' , '15' , '-15' , '1' , '2.4000' , '1.9672131147541' , '22' , '0' , '36.00' ) 07/05/2025 10:47:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96002' , '23425' , 'ROSARIO GIUBILEO - 198/1-G25' , '12' , '-12' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '42.00' ) 07/05/2025 10:47:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96002' , '' , 'BUONO A RUSSO' , '1' , '-1' , '0' , '30' , '30' , '' , '0' , '30.00' ) 07/05/2025 10:48:25 am >> DELETE FROM ps_document WHERE id_document = '94924' 07/05/2025 10:48:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94924' 07/05/2025 10:52:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1408' AND id_document != '96877' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-28') 07/05/2025 10:52:05 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1408', document_date = '2025-04-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 = '3', id_causal = '0', price_tax_included = '160.00', price_tax_excluded = '131.15', date_upd = NOW() WHERE id_document = '96877' 07/05/2025 10:52:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96877' 07/05/2025 10:52:05 am >> DELETE FROM ps_document_detail WHERE id_document = '96877' 07/05/2025 10:52:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96877' , '18371' , 'CAMICE MISTO LANA - 70/000403' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 07/05/2025 10:53:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1302' AND id_document != '96753' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-04-17') 07/05/2025 10:53:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1302', document_date = '2025-04-17', 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 = '3', id_causal = '0', price_tax_included = '111.00', price_tax_excluded = '90.98', date_upd = NOW() WHERE id_document = '96753' 07/05/2025 10:53:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '96753' 07/05/2025 10:53:08 am >> DELETE FROM ps_document_detail WHERE id_document = '96753' 07/05/2025 10:53:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '96753' , '17991' , 'STOLA LINO/POL GIGLIUCCIO A MANO' , '1' , '-1' , '1' , '111' , '90.983606557377' , '22' , '0' , '111.00' ) 07/05/2025 11:12:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 11:12:36 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' , '1540' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.70' , '25.98' , NOW() , NOW() ) 07/05/2025 11:12:36 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 = '97035' 07/05/2025 11:12:36 am >> DELETE FROM ps_document_detail WHERE id_document = '97035' 07/05/2025 11:12:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97035' , '13799' , 'CROCETTA CONFESSIONE - 2370/J44' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' ) 07/05/2025 11:12:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97035' , '22502' , 'CONFEZIONE ROSARIO MISSIONARIO - 08/4MK' , '16' , '-16' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '28.80' ) 07/05/2025 12:04:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:04:37 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' , '1541' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.70' , '19.43' , NOW() , NOW() ) 07/05/2025 12:04:37 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 = '97036' 07/05/2025 12:04:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '97036' 07/05/2025 12:04:37 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 ( '97036' , '20515' , 'DECINA ULIVO - 04/7-D' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 07/05/2025 12:04:37 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 ( '97036' , '22500' , 'DECINA LEGNO' , '2' , '-2' , '1' , '1.60' , '1.3114754098361' , '22' , '0' , '3.20' ) 07/05/2025 12:04:37 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 ( '97036' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 07/05/2025 12:36:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:36:09 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' , '1542' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '207.90' , '179.99' , NOW() , NOW() ) 07/05/2025 12:36:09 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 = '97037' 07/05/2025 12:36:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97037' 07/05/2025 12:36:09 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 ( '97037' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 07/05/2025 12:36:09 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 ( '97037' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 07/05/2025 12:36:09 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 ( '97037' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 07/05/2025 12:36:09 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 ( '97037' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 07/05/2025 12:36:09 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 ( '97037' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 07/05/2025 12:36:09 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 ( '97037' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '22.50' ) 07/05/2025 12:37:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:37:10 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' , '1543' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 07/05/2025 12:37:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97038' 07/05/2025 12:37:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '97038' 07/05/2025 12:37:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97038' , '22199' , 'VINO LIQUOROSO ROSSO ' , '12' , '-12' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '90.00' ) 07/05/2025 12:49:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:49: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' , '1544' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.20' , '4.26' , NOW() , NOW() ) 07/05/2025 12:49: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 = '97039' 07/05/2025 12:49:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '97039' 07/05/2025 12:49: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 ( '97039' , '22501' , 'BRACCIALE COLORATO PRIMA COMUNIONE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 07/05/2025 12:49: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 ( '97039' , '22499' , 'BRACCIALE PRIMA COMUNIONE' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 07/05/2025 12:49: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 ( '97039' , '7922' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '5' , '-5' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.50' ) 07/05/2025 12:49:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:49:48 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' , '1545' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 07/05/2025 12:49:48 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 = '97040' 07/05/2025 12:49:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '97040' 07/05/2025 12:49:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '97040' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 07/05/2025 12:50:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:50:52 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' , '1546' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 07/05/2025 12:50:52 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 = '97041' 07/05/2025 12:50:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '97041' 07/05/2025 12:50:52 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 ( '97041' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 07/05/2025 12:55:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:55: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' , '1547' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 07/05/2025 12:55: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 = '97042' 07/05/2025 12:55:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '97042' 07/05/2025 12:55: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 ( '97042' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '11' , '-11' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.50' ) 07/05/2025 12:55: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 ( '97042' , '16311' , 'DECINA MISSIONARIA - FR17-2' , '11' , '-11' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.50' ) 07/05/2025 12:55:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1548' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 12:55:46 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' , '1548' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 07/05/2025 12:55:46 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 = '97043' 07/05/2025 12:55:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '97043' 07/05/2025 12:55:46 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 ( '97043' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 07/05/2025 03:28:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 03:28: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' , '1549' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 07/05/2025 03:28: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 = '97044' 07/05/2025 03:28:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '97044' 07/05/2025 03:28: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 ( '97044' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '12.5' , '10.245901639344' , '22' , '0' , '12.50' ) 07/05/2025 03:28: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 ( '97044' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 07/05/2025 03:28: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 ( '97044' , '20516' , 'CROCE COMUNIONE - 42/08' , '11' , '-11' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '13.20' ) 07/05/2025 03:28: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 ( '97044' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '11' , '-11' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '19.80' ) 07/05/2025 03:28: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 ( '97044' , '17617' , 'IMMAGINI ISONZO X 100' , '10' , '-10' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '34.00' ) 07/05/2025 03:41:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 03:41:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1550' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '249.00' , '204.10' , NOW() , NOW() ) 07/05/2025 03:41:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '97045' 07/05/2025 03:41:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '97045' 07/05/2025 03:41: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 ( '97045' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '88' , '72.131147540984' , '22' , '0' , '88.00' ) 07/05/2025 03:41: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 ( '97045' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '62' , '50.819672131148' , '22' , '0' , '62.00' ) 07/05/2025 03:41: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 ( '97045' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 07/05/2025 03:41: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 ( '97045' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 07/05/2025 03:43:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1550' AND id_document != '97045' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 03:43:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1550', document_date = '2025-05-07', 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 = '249.00', price_tax_excluded = '204.10', date_upd = NOW() WHERE id_document = '97045' 07/05/2025 03:43:05 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 = '97045' 07/05/2025 03:43:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '97045' 07/05/2025 03:43:05 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 ( '97045' , '14920' , 'CASULA AVE MARIA - PCA032' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 07/05/2025 03:43:05 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 ( '97045' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '1' , '-1' , '1' , '64' , '52.459016393443' , '22' , '0' , '64.00' ) 07/05/2025 03:43:05 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 ( '97045' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '50.00' ) 07/05/2025 03:43:05 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 ( '97045' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 07/05/2025 05:59:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1551' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 05:59: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' , '1551' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.30' , '2.25' , NOW() , NOW() ) 07/05/2025 05:59: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 = '97046' 07/05/2025 05:59:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '97046' 07/05/2025 05:59: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 ( '97046' , '16059' , 'MEDAGLIA S. PELLEGRINO - FM022' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 07/05/2025 05:59: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 ( '97046' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 07/05/2025 06:19:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1552' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 06:19:44 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' , '1552' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 07/05/2025 06:19:44 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 = '97047' 07/05/2025 06:19:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '97047' 07/05/2025 06:19:44 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 ( '97047' , '22198' , 'CORONCINA PRIMA COMUNIONE - 3313' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 07/05/2025 06:27:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1553' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 06:27: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' , '1553' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 07/05/2025 06:27: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 = '97048' 07/05/2025 06:27:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '97048' 07/05/2025 06:27: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 ( '97048' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 07/05/2025 06:28:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1554' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 06:28: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' , '1554' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 07/05/2025 06:28: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 = '97049' 07/05/2025 06:28:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '97049' 07/05/2025 06:28: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 ( '97049' , '23536' , 'SULLA TUA PAROLA - MAG/GIU 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/05/2025 06:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '1555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 06:58: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' , '1555' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.90' , '102.26' , NOW() , NOW() ) 07/05/2025 06:58: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 = '97050' 07/05/2025 06:58:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '97050' 07/05/2025 06:58: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 ( '97050' , '23225' , 'STOLA MARIANA - ST08' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 07/05/2025 06:58: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 ( '97050' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 07/05/2025 07:43:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-05-07') 07/05/2025 07:43:09 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' , '1556' , '2025-05-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 07/05/2025 07:43:09 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 = '97051' 07/05/2025 07:43:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '97051' 07/05/2025 07:43:09 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 ( '97051' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 07/05/2025 07:43:09 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 ( '97051' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' )