04/04/2024 08:57:33 am >> SELECT document_num FROM ps_document WHERE document_num = '6/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 08:57:33 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 ( '22' , '6/S' , '2024-04-04' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO MARZO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '872.95' , '866.10' , NOW() , NOW() ) 04/04/2024 08:57: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 = '14207' 04/04/2024 08:57:33 am >> DELETE FROM ps_document_detail WHERE id_document = '14207' 04/04/2024 08:57:34 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 ( '14207' , '17' , 'LA FEDE NELLO ZAINETTO' , '43' , '0' , '4' , '6.00' , '6' , '0' , '50' , '129.00' ) 04/04/2024 08:57:34 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 ( '14207' , '20' , 'GIOVEDÌ SANTO' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2024 08:57:34 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 ( '14207' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '4' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '3.60' ) 04/04/2024 08:57:34 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 ( '14207' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '2' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 04/04/2024 08:57:34 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 ( '14207' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '6' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '7.50' ) 04/04/2024 08:57:34 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 ( '14207' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '163' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '203.75' ) 04/04/2024 08:57:34 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 ( '14207' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2024 08:57:34 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 ( '14207' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 04/04/2024 08:57:34 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 ( '14207' , '125' , 'MIE PREGHIERINE - N. E.' , '100' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '75.00' ) 04/04/2024 08:57:34 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 ( '14207' , '30' , 'LA BIBBIA: ANTICO TESTAMENTO' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2024 08:57:34 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 ( '14207' , '33' , '100 GIORNI CON LO SPIRITO' , '6' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '22.50' ) 04/04/2024 08:57:34 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 ( '14207' , '36' , 'IL CANTICO DEI CANTICI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2024 08:57:34 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 ( '14207' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 04/04/2024 08:57:34 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 ( '14207' , '50' , 'PERDONAMI SIGNORE' , '17' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '21.25' ) 04/04/2024 08:57:34 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 ( '14207' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '34' , '0' , '4' , '2.00' , '2' , '0' , '50' , '34.00' ) 04/04/2024 08:57:34 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 ( '14207' , '70' , 'La storia della salvezza raccontata ai bambini. 2 Caino e Abele' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2024 08:57:34 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 ( '14207' , '75' , 'IL SEGNO DELLA CROCE' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2024 08:57:34 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 ( '14207' , '88' , 'GESÙ È RISORTO' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 04/04/2024 08:57:34 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 ( '14207' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 04/04/2024 08:57:34 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 ( '14207' , '92' , 'LA PREGHIERA DEL ROSARIO' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2024 08:57:34 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 ( '14207' , '95' , 'LA PICCOLA MATITA' , '4' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 04/04/2024 08:57:34 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 ( '14207' , '99' , 'AVE MARIA PREGHIERE MARIANE' , '10' , '0' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 04/04/2024 08:57:34 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 ( '14207' , '101' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 04/04/2024 08:57:34 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 ( '14207' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/04/2024 08:57:34 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 ( '14207' , '110' , 'SE MI AMI NON PIANGERE' , '14' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '12.60' ) 04/04/2024 08:57:34 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 ( '14207' , '112' , 'SEMPRE CON TE -VANGELO TASCABILE' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2024 08:57:34 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 ( '14207' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/04/2024 08:57:34 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 ( '14207' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '1' , '0' , '4' , '4.00' , '4' , '0' , '50' , '2.00' ) 04/04/2024 08:57:34 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 ( '14207' , '117' , 'La preghiera delle cinque dita n.e.' , '5' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '4.50' ) 04/04/2024 08:57:34 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 ( '14207' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '8' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '10.00' ) 04/04/2024 08:57:34 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 ( '14207' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '60' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '75.00' ) 04/04/2024 08:57:34 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 ( '14207' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '7' , '0' , '4' , '18.00' , '18' , '0' , '50' , '63.00' ) 04/04/2024 08:57:34 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 ( '14207' , '138' , 'LA NASCITA DI GESU' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 04/04/2024 08:57:34 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 ( '14207' , '139' , 'E NATO - n.e.' , '38' , '0' , '1' , '2.00' , '1.6393442622951' , '22' , '50' , '38.00' ) 04/04/2024 08:57:34 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 ( '14207' , '136' , 'ANGELO DI DIO N.E.' , '27' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '24.30' ) 04/04/2024 08:57:34 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 ( '14207' , '137' , 'AVVENTO' , '25' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '31.25' ) 04/04/2024 08:57:34 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 ( '14207' , '126' , 'SACRAMENTO DEL PERDONO' , '8' , '0' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 04/04/2024 09:34:25 am >> SELECT document_num FROM ps_document WHERE document_num = '7/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:34:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '7/S' , '2024-04-04' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA MARZO 2024' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '544.35' , '538.22' , NOW() , NOW() ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14208' 04/04/2024 09:34:25 am >> DELETE FROM ps_document_detail WHERE id_document = '14208' 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '17' , 'LA FEDE NELLO ZAINETTO' , '7' , '7' , '4' , '6.00' , '6' , '0' , '50' , '21.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '20' , 'GIOVEDÌ SANTO' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '3' , '3' , '4' , '1.80' , '1.8' , '0' , '50' , '2.70' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '6' , '6' , '4' , '1.50' , '1.5' , '0' , '50' , '4.50' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '15' , '15' , '4' , '2.50' , '2.5' , '0' , '50' , '18.75' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '10' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '46' , 'LE LETTERE DI SAN PAOLO' , '1' , '1' , '4' , '3.50' , '3.5' , '0' , '50' , '1.75' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '50' , 'PERDONAMI SIGNORE' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '2' , '2' , '4' , '6.50' , '6.5' , '0' , '50' , '6.50' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '88' , 'GESÙ È RISORTO' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '90' , 'ATTO DI AFFIDAMENTO A MARIA' , '7' , '7' , '4' , '1.50' , '1.5' , '0' , '50' , '5.25' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '94' , 'IL BATTESIMO' , '12' , '12' , '4' , '1.50' , '1.5' , '0' , '50' , '9.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '4' , '4' , '4' , '1.50' , '1.5' , '0' , '50' , '3.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '104' , 'TEMPO DI QUARESIMA' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2024 09:34:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '1' , '1' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '117' , 'La preghiera delle cinque dita n.e.' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '50' , '0.90' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '50' , '2.50' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '18' , '18' , '4' , '3.00' , '3' , '0' , '50' , '27.00' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '29' , '29' , '4' , '18.00' , '18' , '0' , '50' , '261.00' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '138' , 'LA NASCITA DI GESU' , '38' , '38' , '4' , '2.50' , '2.5' , '0' , '50' , '47.50' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '139' , 'E NATO - n.e.' , '34' , '34' , '1' , '2.00' , '1.6393442622951' , '22' , '50' , '34.00' ) 04/04/2024 09:34:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14208' , '137' , 'AVVENTO' , '33' , '33' , '4' , '2.50' , '2.5' , '0' , '50' , '41.25' ) 04/04/2024 09:37:07 am >> SELECT document_num FROM ps_document WHERE document_num = '1010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:37:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1010' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 04/04/2024 09:37:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91078' 04/04/2024 09:37:07 am >> DELETE FROM ps_document_detail WHERE id_document = '91078' 04/04/2024 09:37:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91078' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 04/04/2024 09:45:59 am >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:45:59 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 ( '22' , '17/E' , '2024-04-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '177.50' , '177.50' , NOW() , NOW() ) 04/04/2024 09:45:59 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 = '91079' 04/04/2024 09:45:59 am >> DELETE FROM ps_document_detail WHERE id_document = '91079' 04/04/2024 09:45:59 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 ( '91079' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '48' , '0' , '4' , '2.40' , '2.4' , '0' , '50' , '57.60' ) 04/04/2024 09:45:59 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 ( '91079' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2024 09:45:59 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 ( '91079' , '5457' , 'IO SONO CON VOI 1 PARTE' , '26' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '36.40' ) 04/04/2024 09:45:59 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 ( '91079' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '8.40' ) 04/04/2024 09:45:59 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 ( '91079' , '11191' , 'VENITE CON ME 1 PARTE' , '21' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '29.40' ) 04/04/2024 09:45:59 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 ( '91079' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '26.60' ) 04/04/2024 09:45:59 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 ( '91079' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '42' , '0' , '4' , '0.85' , '0.85' , '0' , '50' , '17.85' ) 04/04/2024 09:46:04 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'JzNDSt6Ju9FIcbOy' , NOW() , NOW() ) 04/04/2024 09:46:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4095' , '1' ) 04/04/2024 09:46:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4095' , '2' ) 04/04/2024 09:46:04 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4095' , '3' ) 04/04/2024 09:48:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4095' 04/04/2024 09:48:18 am >> 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 ( '4095' , '10' , '202' , '' , 'CARMELA' , 'PIPITONE' , 'VIA G. B. CULTRONE 17' , '' , '97100' , 'RAGUSA' , '' , '' , '3209566107' , '' , '' , NOW() , NOW() ) 04/04/2024 09:48:18 am >> UPDATE ps_customer SET email = 'carmela.pipitone@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4095' 04/04/2024 09:49:21 am >> SELECT document_num FROM ps_document WHERE document_num = '59' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:49:21 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 ( '21' , '59' , '2024-04-04' , '' , '4095' , '0' , '4679294' , 'VIA G. B. CULTRONE 17 97100 RAGUSA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.65' , '31.65' , NOW() , NOW() ) 04/04/2024 09:49:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91080' 04/04/2024 09:49:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91080' 04/04/2024 09:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91080' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 04/04/2024 09:49:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91080' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 04/04/2024 09:50:21 am >> SELECT document_num FROM ps_document WHERE document_num = '59' AND id_document != '91080' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:50:21 am >> UPDATE ps_document SET id_document_type = '21', document_num = '59', document_date = '2024-04-04', document_letter = '', id_customer = '4095', id_supplier = '', id_address = '4679294', address1 = 'VIA G. B. CULTRONE 17 97100 RAGUSA', address2 = '', note = '', price_shipping = '5.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 = '31.65', price_tax_excluded = '31.65', date_upd = NOW() WHERE id_document = '91080' 04/04/2024 09:50:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91080' 04/04/2024 09:50:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91080' 04/04/2024 09:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91080' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '5' , '23.75' ) 04/04/2024 09:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91080' , '0' , 'contrassegno' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 04/04/2024 09:58:16 am >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 04/04/2024 09:58:16 am >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23 + 40,00 22/11 - 110,00 07/12- 200,00 11/01 - 50,00 04/04/2024', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '82607' 04/04/2024 09:58:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82607' 04/04/2024 09:58:16 am >> DELETE FROM ps_document_detail WHERE id_document = '82607' 04/04/2024 09:58:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 04/04/2024 09:58:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550.0000' , '450.81967213115' , '22' , '0' , '550.00' ) 04/04/2024 09:59:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 09:59:44 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' , '1011' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 04/04/2024 09:59:44 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 = '91081' 04/04/2024 09:59:44 am >> DELETE FROM ps_document_detail WHERE id_document = '91081' 04/04/2024 09:59:44 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 ( '91081' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/04/2024 10:09:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:09:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1012' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 04/04/2024 10:09:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91082' 04/04/2024 10:09:41 am >> DELETE FROM ps_document_detail WHERE id_document = '91082' 04/04/2024 10:09:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91082' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '5' , '-5' , '4' , '0.60' , '0.6' , '0' , '0' , '3.00' ) 04/04/2024 10:11:16 am >> SELECT document_num FROM ps_document WHERE document_num = '60' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:11:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '60' , '2024-04-04' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '65.45' , '65.45' , NOW() , NOW() ) 04/04/2024 10:11:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91083' 04/04/2024 10:11:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91083' 04/04/2024 10:11:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91083' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 04/04/2024 10:11:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91083' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 04/04/2024 10:11:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:11:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1013' , '2024-04-04' , '' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '67.62' , NOW() , NOW() ) 04/04/2024 10:11:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91084' 04/04/2024 10:11:55 am >> DELETE FROM ps_document_detail WHERE id_document = '91084' 04/04/2024 10:11:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91084' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '80' , '-80' , '1' , '1.0000' , '0.8197' , '22' , '0' , '80.00' ) 04/04/2024 10:11:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91084' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '2.5000' , '2.0492' , '22' , '0' , '2.50' ) 04/04/2024 10:14:47 am >> DELETE FROM ps_document WHERE id_document = '89396' 04/04/2024 10:14:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89396' 04/04/2024 10:15:36 am >> SELECT document_num FROM ps_document WHERE document_num = '1014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:15: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' , '1014' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 04/04/2024 10:15: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 = '91085' 04/04/2024 10:15:36 am >> DELETE FROM ps_document_detail WHERE id_document = '91085' 04/04/2024 10:15: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 ( '91085' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 04/04/2024 10:30:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1013' AND id_document != '91084' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:30:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1013', document_date = '2024-04-04', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '82.50', price_tax_excluded = '67.62', date_upd = NOW() WHERE id_document = '91084' 04/04/2024 10:30:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91084' 04/04/2024 10:30:03 am >> DELETE FROM ps_document_detail WHERE id_document = '91084' 04/04/2024 10:30:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91084' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '80' , '-80' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '80.00' ) 04/04/2024 10:30:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91084' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 04/04/2024 10:32:58 am >> SELECT document_num FROM ps_document WHERE document_num = '1015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:32:58 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' , '1015' , '2024-04-04' , '' , '0' , '0' , '0' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '329.95' , '277.65' , NOW() , NOW() ) 04/04/2024 10:32:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91086' 04/04/2024 10:32:58 am >> DELETE FROM ps_document_detail WHERE id_document = '91086' 04/04/2024 10:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '10' , '-10' , '1' , '22.0000' , '18.0328' , '22' , '0' , '220.00' ) 04/04/2024 10:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377' , '22' , '0' , '70.00' ) 04/04/2024 10:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '22281' , 'CARDIOLOGO VISITA GESU - F. SERAFINI' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '5' , '21.85' ) 04/04/2024 10:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '10' , '-10' , '4' , '1.9000' , '1.9' , '0' , '5' , '18.10' ) 04/04/2024 10:35:22 am >> DELETE FROM ps_document WHERE id_document = '90153' 04/04/2024 10:35:22 am >> DELETE FROM ps_document_detail WHERE id_document = '90153' 04/04/2024 10:36:01 am >> SELECT document_num FROM ps_document WHERE document_num = '590' AND id_document != '90540' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-28') 04/04/2024 10:36:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '590', document_date = '2024-02-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 = '67.00', price_tax_excluded = '55.91', date_upd = NOW() WHERE id_document = '90540' 04/04/2024 10:36:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90540' 04/04/2024 10:36:01 am >> DELETE FROM ps_document_detail WHERE id_document = '90540' 04/04/2024 10:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90540' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 04/04/2024 10:36:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90540' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 04/04/2024 10:36:49 am >> SELECT document_num FROM ps_document WHERE document_num = '478' AND id_document != '90391' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-17') 04/04/2024 10:36:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '478', document_date = '2024-02-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 = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '53.51', date_upd = NOW() WHERE id_document = '90391' 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90391' 04/04/2024 10:36:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90391' 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '14664' , 'DALL\'AURORA IO TI CERCO - A. CENCINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '18223' , 'CORONA MISSIONARIA - R102' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.3400' , '2.34' , '0' , '0' , '2.34' ) 04/04/2024 10:36:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90391' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 04/04/2024 10:39:46 am >> SELECT document_num FROM ps_document WHERE document_num = '845' AND id_document != '90876' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-21') 04/04/2024 10:39:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '845', document_date = '2024-03-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '90876' 04/04/2024 10:39: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 = '90876' 04/04/2024 10:39:46 am >> DELETE FROM ps_document_detail WHERE id_document = '90876' 04/04/2024 10:39: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 ( '90876' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 04/04/2024 10:40:13 am >> SELECT document_num FROM ps_document WHERE document_num = '537' AND id_document != '90470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-23') 04/04/2024 10:40:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '537', document_date = '2024-02-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '51.50', price_tax_excluded = '42.21', date_upd = NOW() WHERE id_document = '90470' 04/04/2024 10:40:13 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 = '90470' 04/04/2024 10:40:13 am >> DELETE FROM ps_document_detail WHERE id_document = '90470' 04/04/2024 10:40:13 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 ( '90470' , '1929' , 'CERCHIETTO CON FIORI LUSSO' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 04/04/2024 10:40:13 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 ( '90470' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '25' , '-25' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '45.00' ) 04/04/2024 10:40:36 am >> SELECT document_num FROM ps_document WHERE document_num = '972' AND id_document != '91029' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-30') 04/04/2024 10:40:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '972', document_date = '2024-03-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91029' 04/04/2024 10:40: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 = '91029' 04/04/2024 10:40:36 am >> DELETE FROM ps_document_detail WHERE id_document = '91029' 04/04/2024 10:40: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 ( '91029' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '25' , '-25' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '45.00' ) 04/04/2024 10:42:08 am >> SELECT document_num FROM ps_document WHERE document_num = '962' AND id_document != '91018' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-29') 04/04/2024 10:42:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '962', document_date = '2024-03-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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91018' 04/04/2024 10:42: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 = '91018' 04/04/2024 10:42:08 am >> DELETE FROM ps_document_detail WHERE id_document = '91018' 04/04/2024 10:42: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 ( '91018' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '4' , '-4' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '1.00' ) 04/04/2024 10:42: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 ( '91018' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '30' , '-30' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '54.00' ) 04/04/2024 10:42:29 am >> SELECT document_num FROM ps_document WHERE document_num = '952' AND id_document != '91007' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-28') 04/04/2024 10:42:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '952', document_date = '2024-03-28', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '316.70', price_tax_excluded = '260.16', date_upd = NOW() WHERE id_document = '91007' 04/04/2024 10:42:29 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 = '91007' 04/04/2024 10:42:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91007' 04/04/2024 10:42:29 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 ( '91007' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 04/04/2024 10:42:29 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 ( '91007' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 04/04/2024 10:42:29 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 ( '91007' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '35.80' ) 04/04/2024 10:42:29 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 ( '91007' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 04/04/2024 10:42:29 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 ( '91007' , '1041' , 'BENEDIZIONI' , '400' , '-400' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '40.00' ) 04/04/2024 10:42:29 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 ( '91007' , '19364' , 'CERO MINIATO 80X120' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 04/04/2024 10:42:29 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 ( '91007' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 04/04/2024 10:42:29 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 ( '91007' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 04/04/2024 10:42:47 am >> SELECT document_num FROM ps_document WHERE document_num = '885' AND id_document != '90933' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-25') 04/04/2024 10:42:47 am >> UPDATE ps_document SET id_document_type = '11', document_num = '885', document_date = '2024-03-25', 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 = '128.00', price_tax_excluded = '104.92', date_upd = NOW() WHERE id_document = '90933' 04/04/2024 10:42:47 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 = '90933' 04/04/2024 10:42:47 am >> DELETE FROM ps_document_detail WHERE id_document = '90933' 04/04/2024 10:42:47 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 ( '90933' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '110.00' ) 04/04/2024 10:42:47 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 ( '90933' , '3268' , 'CUSTODIA S. ROSARIO + DECINA' , '10' , '-10' , '1' , '1.80' , '1.4754098360656' , '22' , '0' , '18.00' ) 04/04/2024 10:57:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 10:57:50 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' , '1016' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 04/04/2024 10:57: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 = '91087' 04/04/2024 10:57:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91087' 04/04/2024 10:57: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 ( '91087' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.40' , '1.9672131147541' , '22' , '0' , '12.00' ) 04/04/2024 11:15:01 am >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '91079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 11:15:01 am >> UPDATE ps_document SET id_document_type = '22', document_num = '17/E', document_date = '2024-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'venduto marzo 2024', 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 = '3125.30', price_tax_excluded = '3124.40', date_upd = NOW() WHERE id_document = '91079' 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91079' 04/04/2024 11:15:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91079' 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '48' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '57.60' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '5457' , 'IO SONO CON VOI 1 PARTE' , '26' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '36.40' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '8.40' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11191' , 'VENITE CON ME 1 PARTE' , '21' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '29.40' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '26.60' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '42' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '17.85' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '0' , '4' , '8.00' , '8' , '0' , '50' , '4.00' ) 04/04/2024 11:15:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '0' , '4' , '3.40' , '3.4' , '0' , '50' , '39.10' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '0' , '4' , '8.00' , '8' , '0' , '50' , '40.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '6629' , 'MIA PREGHIERA' , '27' , '0' , '4' , '0.90' , '0.9' , '0' , '50' , '12.15' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8408' , 'PRENDETE E MANGIATE' , '105' , '0' , '4' , '3.00' , '3' , '0' , '50' , '157.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.00' , '5' , '0' , '50' , '10.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '7' , '0' , '4' , '5.00' , '5' , '0' , '50' , '17.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '4154' , 'FESTA DEL PERDONO' , '141' , '0' , '4' , '3.00' , '3' , '0' , '50' , '211.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2679' , 'CONOSCERE GESU' , '15' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '26.25' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '0' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '0' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '0' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '10' , '0' , '4' , '1.60' , '1.6' , '0' , '50' , '8.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '0' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '5.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '1.40' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '12' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '21.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '18' , '0' , '4' , '6.00' , '6' , '0' , '50' , '54.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '13956' , 'MIRACOLI DI GESU' , '1' , '0' , '4' , '3.00' , '3' , '0' , '50' , '1.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '9' , '0' , '4' , '1.00' , '1' , '0' , '50' , '4.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15019' , 'PREGHIAMO CON MARIA' , '20' , '0' , '4' , '0.80' , '0.8' , '0' , '50' , '8.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15020' , 'PREGARE OGNI GIORNO' , '22' , '0' , '4' , '1.00' , '1' , '0' , '50' , '11.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '8' , '0' , '4' , '6.00' , '6' , '0' , '50' , '24.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '217' , '0' , '4' , '1.00' , '1' , '0' , '50' , '108.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '73' , '0' , '4' , '2.00' , '2' , '0' , '50' , '73.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16667' , 'VIA CRUCIS' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '9' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '11.25' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '5' , '0' , '4' , '15.00' , '15' , '0' , '50' , '37.50' ) 04/04/2024 11:15:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17257' , 'IO TI BATTEZZO ' , '13' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '11.70' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '10' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '45' , '0' , '4' , '1.90' , '1.9' , '0' , '50' , '42.75' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '85' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '63.75' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '2' , '0' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.00' , '7' , '0' , '50' , '28.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '10' , '0' , '4' , '2.00' , '2' , '0' , '50' , '10.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.00' , '9' , '0' , '50' , '9.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '6' , '0' , '4' , '12.00' , '12' , '0' , '50' , '36.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '6' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '13.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.00' , '35' , '0' , '50' , '17.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '49' , '0' , '4' , '2.00' , '2' , '0' , '50' , '49.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '0' , '4' , '4.50' , '4.5' , '0' , '50' , '4.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20722' , 'SEMINATORI DI GIOIA' , '7' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '8.75' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '5' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '2' , '0' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '2' , '0' , '4' , '20.00' , '20' , '0' , '50' , '20.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '20' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '25.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '2' , '0' , '4' , '8.00' , '8' , '0' , '50' , '8.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '71' , '0' , '4' , '3.00' , '3' , '0' , '50' , '106.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '71' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '88.75' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '12' , '0' , '4' , '2.00' , '2' , '0' , '50' , '12.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '16' , '0' , '4' , '2.00' , '2' , '0' , '50' , '16.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '9' , '0' , '4' , '8.00' , '8' , '0' , '50' , '36.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '0' , '4' , '10.00' , '10' , '0' , '50' , '20.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '12' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '85' , '0' , '4' , '8.00' , '8' , '0' , '50' , '340.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20954' , 'TEMPO DELL’APOCALISSE ' , '4' , '0' , '4' , '15.00' , '15' , '0' , '50' , '30.00' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '82' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '114.80' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '84' , '0' , '4' , '2.80' , '2.8' , '0' , '50' , '117.60' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2024 11:15:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '27' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '33.75' ) 04/04/2024 11:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22151' , 'MA DIO LO HA RISUSCITATO' , '70' , '0' , '4' , '10.00' , '10' , '0' , '50' , '350.00' ) 04/04/2024 11:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '18' , '0' , '4' , '6.00' , '6' , '0' , '50' , '54.00' ) 04/04/2024 11:15:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22152' , 'A TE RICORRIAMO' , '193' , '0' , '4' , '3.00' , '3' , '0' , '50' , '289.50' ) 04/04/2024 11:56:14 am >> SELECT document_num FROM ps_document WHERE document_num = '18/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 11:56: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 ( '25' , '18/E' , '2024-04-04' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'resa marzo 2024' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '2571.95' , '2568.34' , NOW() , NOW() ) 04/04/2024 11:56: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 = '91088' 04/04/2024 11:56:14 am >> DELETE FROM ps_document_detail WHERE id_document = '91088' 04/04/2024 11:56: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 ( '91088' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '170' , '170' , '4' , '2.40' , '2.4' , '0' , '50' , '204.00' ) 04/04/2024 11:56: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 ( '91088' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 04/04/2024 11:56: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 ( '91088' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 04/04/2024 11:56: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 ( '91088' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '3' , '4' , '8.00' , '8' , '0' , '50' , '12.00' ) 04/04/2024 11:56: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 ( '91088' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '1' , '4' , '6.20' , '6.2' , '0' , '50' , '3.10' ) 04/04/2024 11:56: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 ( '91088' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '28' , '4' , '3.50' , '3.5' , '0' , '50' , '49.00' ) 04/04/2024 11:56: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 ( '91088' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '2' , '2' , '4' , '2.10' , '2.1' , '0' , '50' , '2.10' ) 04/04/2024 11:56: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 ( '91088' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '27' , '4' , '2.80' , '2.8' , '0' , '50' , '37.80' ) 04/04/2024 11:56: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 ( '91088' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '27' , '4' , '2.80' , '2.8' , '0' , '50' , '37.80' ) 04/04/2024 11:56: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 ( '91088' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '4' , '4' , '2.80' , '2.8' , '0' , '50' , '5.60' ) 04/04/2024 11:56: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 ( '91088' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '5' , '4' , '2.80' , '2.8' , '0' , '50' , '7.00' ) 04/04/2024 11:56: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 ( '91088' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '17' , '4' , '3.50' , '3.5' , '0' , '50' , '29.75' ) 04/04/2024 11:56: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 ( '91088' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '7' , '7' , '4' , '8.00' , '8' , '0' , '50' , '28.00' ) 04/04/2024 11:56: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 ( '91088' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '19' , '19' , '4' , '3.40' , '3.4' , '0' , '50' , '32.30' ) 04/04/2024 11:56: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 ( '91088' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '2' , '2' , '4' , '10.00' , '10' , '0' , '50' , '10.00' ) 04/04/2024 11:56: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 ( '91088' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '2' , '4' , '5.00' , '5' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '7' , '7' , '4' , '3.40' , '3.4' , '0' , '50' , '11.90' ) 04/04/2024 11:56: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 ( '91088' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '13' , '13' , '4' , '5.00' , '5' , '0' , '50' , '32.50' ) 04/04/2024 11:56: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 ( '91088' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '21' , '21' , '4' , '8.00' , '8' , '0' , '50' , '84.00' ) 04/04/2024 11:56: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 ( '91088' , '6629' , 'MIA PREGHIERA' , '19' , '19' , '4' , '0.90' , '0.9' , '0' , '50' , '8.55' ) 04/04/2024 11:56: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 ( '91088' , '8408' , 'PRENDETE E MANGIATE' , '48' , '48' , '4' , '3.00' , '3' , '0' , '50' , '72.00' ) 04/04/2024 11:56: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 ( '91088' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '11' , '11' , '4' , '5.00' , '5' , '0' , '50' , '27.50' ) 04/04/2024 11:56: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 ( '91088' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '3' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 04/04/2024 11:56: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 ( '91088' , '4154' , 'FESTA DEL PERDONO' , '35' , '35' , '4' , '3.00' , '3' , '0' , '50' , '52.50' ) 04/04/2024 11:56: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 ( '91088' , '2679' , 'CONOSCERE GESU' , '34' , '34' , '4' , '3.50' , '3.5' , '0' , '50' , '59.50' ) 04/04/2024 11:56: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 ( '91088' , '2680' , 'CONOSCERE GESU - GUIDA' , '8' , '8' , '4' , '6.00' , '6' , '0' , '50' , '24.00' ) 04/04/2024 11:56: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 ( '91088' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '3' , '4' , '5.00' , '5' , '0' , '50' , '7.50' ) 04/04/2024 11:56: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 ( '91088' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '50' , '7.00' ) 04/04/2024 11:56: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 ( '91088' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '1' , '4' , '1.60' , '1.6' , '0' , '50' , '0.80' ) 04/04/2024 11:56: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 ( '91088' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' , '2' , '4' , '12.00' , '12' , '0' , '50' , '12.00' ) 04/04/2024 11:56: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 ( '91088' , '7543' , 'PARABOLE DI GESÙ' , '5' , '5' , '4' , '3.00' , '3' , '0' , '50' , '7.50' ) 04/04/2024 11:56: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 ( '91088' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '3' , '4' , '3.50' , '3.5' , '0' , '50' , '5.25' ) 04/04/2024 11:56: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 ( '91088' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 04/04/2024 11:56: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 ( '91088' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '8' , '4' , '3.50' , '3.5' , '0' , '50' , '14.00' ) 04/04/2024 11:56: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 ( '91088' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '12819' , 'REGISTRO DEL CATECHISTA ' , '40' , '40' , '1' , '1.00' , '0.81967213114754' , '22' , '50' , '20.00' ) 04/04/2024 11:56: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 ( '91088' , '12813' , 'MARIA MADRE NOSTRA' , '12' , '12' , '4' , '3.00' , '3' , '0' , '50' , '18.00' ) 04/04/2024 11:56: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 ( '91088' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '50' , '3.50' ) 04/04/2024 11:56: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 ( '91088' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '6' , '6' , '4' , '3.50' , '3.5' , '0' , '50' , '10.50' ) 04/04/2024 11:56: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 ( '91088' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 04/04/2024 11:56: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 ( '91088' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2024 11:56: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 ( '91088' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '1' , '4' , '9.00' , '9' , '0' , '50' , '4.50' ) 04/04/2024 11:56: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 ( '91088' , '15019' , 'PREGHIAMO CON MARIA' , '8' , '8' , '4' , '0.80' , '0.8' , '0' , '50' , '3.20' ) 04/04/2024 11:56: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 ( '91088' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '1' , '4' , '6.00' , '6' , '0' , '50' , '3.00' ) 04/04/2024 11:56: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 ( '91088' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '8' , '8' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 04/04/2024 11:56: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 ( '91088' , '16667' , 'VIA CRUCIS' , '7' , '7' , '4' , '3.00' , '3' , '0' , '50' , '10.50' ) 04/04/2024 11:56: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 ( '91088' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2024 11:56: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 ( '91088' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '6' , '6' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 04/04/2024 11:56: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 ( '91088' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 04/04/2024 11:56: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 ( '91088' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '1' , '4' , '3.80' , '3.8' , '0' , '50' , '1.90' ) 04/04/2024 11:56: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 ( '91088' , '18036' , 'FERITE FERITOIE ' , '8' , '8' , '4' , '8.00' , '8' , '0' , '50' , '32.00' ) 04/04/2024 11:56: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 ( '91088' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '50' , '6.00' ) 04/04/2024 11:56: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 ( '91088' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '15' , '15' , '4' , '2.00' , '2' , '0' , '50' , '15.00' ) 04/04/2024 11:56: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 ( '91088' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '4' , '4' , '4' , '1.90' , '1.9' , '0' , '50' , '3.80' ) 04/04/2024 11:56: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 ( '91088' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '4' , '4' , '2.50' , '2.5' , '0' , '50' , '5.00' ) 04/04/2024 11:56: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 ( '91088' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '2' , '2' , '4' , '16.00' , '16' , '0' , '50' , '16.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '4' , '4' , '4' , '16.00' , '16' , '0' , '50' , '32.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '21' , '21' , '4' , '2.00' , '2' , '0' , '50' , '21.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '1' , '4' , '15.00' , '15' , '0' , '50' , '7.50' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '50' , '24.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '3' , '3' , '4' , '7.00' , '7' , '0' , '50' , '10.50' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '2' , '2' , '4' , '4.80' , '4.8' , '0' , '50' , '4.80' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '7' , '7' , '4' , '2.00' , '2' , '0' , '50' , '7.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '29' , '29' , '4' , '9.00' , '9' , '0' , '50' , '130.50' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '22' , '22' , '4' , '9.00' , '9' , '0' , '50' , '99.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '14' , '14' , '4' , '9.00' , '9' , '0' , '50' , '63.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '3' , '3' , '4' , '10.00' , '10' , '0' , '50' , '15.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '50' , '5.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '3' , '3' , '4' , '12.00' , '12' , '0' , '50' , '18.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '1' , '4' , '20.00' , '20' , '0' , '50' , '10.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '17' , '17' , '4' , '2.50' , '2.5' , '0' , '50' , '21.25' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '3' , '3' , '4' , '35.00' , '35' , '0' , '50' , '52.50' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '29' , '29' , '4' , '2.50' , '2.5' , '0' , '50' , '36.25' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '7' , '7' , '4' , '10.00' , '10' , '0' , '50' , '35.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '22' , '22' , '4' , '2.50' , '2.5' , '0' , '50' , '27.50' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '8' , '8' , '4' , '2.00' , '2' , '0' , '50' , '8.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20721' , 'AVE MARIA - L. CALABRETTA' , '7' , '7' , '4' , '4.50' , '4.5' , '0' , '50' , '15.75' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '4' , '4' , '4' , '4.50' , '4.5' , '0' , '50' , '9.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20722' , 'SEMINATORI DI GIOIA' , '12' , '12' , '4' , '2.50' , '2.5' , '0' , '50' , '15.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '13' , '13' , '4' , '2.50' , '2.5' , '0' , '50' , '16.25' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '7' , '7' , '4' , '10.00' , '10' , '0' , '50' , '35.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '4' , '4' , '4' , '20.00' , '20' , '0' , '50' , '40.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '97' , '97' , '4' , '2.50' , '2.5' , '0' , '50' , '121.25' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '48' , '48' , '4' , '8.00' , '8' , '0' , '50' , '192.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '2' , '2' , '4' , '25.00' , '25' , '0' , '50' , '25.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '4' , '4' , '4' , '2.00' , '2' , '0' , '50' , '4.00' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '101' , '101' , '4' , '2.50' , '2.5' , '0' , '50' , '126.25' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '32' , '32' , '4' , '2.80' , '2.8' , '0' , '50' , '44.80' ) 04/04/2024 11:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '4' , '4' , '4' , '15.00' , '15' , '0' , '50' , '30.00' ) 04/04/2024 11:56: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 ( '91088' , '20954' , 'TEMPO DELL’APOCALISSE ' , '11' , '11' , '4' , '15.00' , '15' , '0' , '50' , '82.50' ) 04/04/2024 11:56: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 ( '91088' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '11' , '11' , '4' , '4.50' , '4.5' , '0' , '50' , '24.75' ) 04/04/2024 01:00:05 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 ( '32' , '19' , '2024-03-29' , '' , '0' , '0' , '4673832' , 'VIA TIRABOSCHI 13 24017 SERINA ' , '' , '' , '14' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '1363.46' , '1117.59' , NOW() , NOW() ) 04/04/2024 01:00: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 = '91089' 04/04/2024 01:00:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91089' 04/04/2024 01:00: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 ( '91089' , '22248' , 'STOLA - STOM18' , '4' , '0' , '1' , '97.3600' , '79.8033' , '22' , '0' , '475.12' ) 04/04/2024 01:00: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 ( '91089' , '22250' , 'STOLA RICAMO ORO - STOM16' , '1' , '0' , '1' , '324.2200' , '265.7541' , '22' , '0' , '395.55' ) 04/04/2024 01:00: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 ( '91089' , '19435' , 'STOLA - STO0M05' , '1' , '0' , '1' , '138.15' , '113.23770491803' , '22' , '0' , '168.5430' ) 04/04/2024 01:00: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 ( '91089' , '22249' , 'CASULA MARIANA - CASOM77' , '1' , '0' , '1' , '251.78' , '206.37704918033' , '22' , '0' , '307.1716' ) 04/04/2024 03:50:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 04/04/2024 03:50:41 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '151.30', price_tax_excluded = '151.30', date_upd = NOW() WHERE id_document = '89846' 04/04/2024 03:50: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 = '89846' 04/04/2024 03:50:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 04/04/2024 03:50: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 04/04/2024 03:50: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 ( '89846' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 04/04/2024 03:50: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 ( '89846' , '10064' , 'SOLO L\'AMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 04/04/2024 03:50: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 ( '89846' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 04/04/2024 03:50: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 ( '89846' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 04/04/2024 03:50: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 ( '89846' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 04/04/2024 03:50: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 ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 04/04/2024 03:50: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 ( '89846' , '22348' , 'GESU QUESTO SCONOSCIUTO - D. CULOT' , '1' , '-1' , '4' , '28.00' , '28' , '0' , '0' , '28.00' ) 04/04/2024 03:50: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 ( '89846' , '22333' , 'NARRAZIONI DELLA PASSIONE DI GESU CRISTO - G. BETORI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 04/04/2024 04:21:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '90934' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-25') 04/04/2024 04:21:17 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2024-03-25', document_letter = 'A', id_customer = '3712', id_supplier = '', id_address = '4671443', address1 = 'VIA DALMAZIA 6 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '161.40', price_tax_excluded = '133.56', date_upd = NOW() WHERE id_document = '90934' 04/04/2024 04:21: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 = '90934' 04/04/2024 04:21:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '90934' 04/04/2024 04:21: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 ( '90934' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 04/04/2024 04:21: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 ( '90934' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 04/04/2024 04:21: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 ( '90934' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 04/04/2024 04:21: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 ( '90934' , '6019' , 'LUMINO ROSSO - 10B' , '27' , '-27' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '13.50' ) 04/04/2024 04:21: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 ( '90934' , '6014' , 'LUMINO BIANCO - 10B' , '18' , '-18' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '9.00' ) 04/04/2024 04:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '20437' , 'LUMINO BIANCO 10BTS000' , '9' , '-9' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '4.50' ) 04/04/2024 04:21:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90934' , '17710' , 'OSTIA MAGNA 140 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 04/04/2024 04:32:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1017' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 04:32:56 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' , '1017' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '14.50' , NOW() , NOW() ) 04/04/2024 04:32:56 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 = '91090' 04/04/2024 04:32:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '91090' 04/04/2024 04:32:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91090' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 04/04/2024 04:52:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '47/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 04:52: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 ( '24' , '47/A' , '2024-04-04' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '300.00' , NOW() , NOW() ) 04/04/2024 04:52: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 = '91091' 04/04/2024 04:52:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '91091' 04/04/2024 04:52: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 ( '91091' , '' , 'COPRILEGGIO' , '1' , '-1' , '0' , '300' , '300' , '' , '0' , '300.00' ) 04/04/2024 04:58:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1018' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 04:58:36 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' , '1018' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 04/04/2024 04:58: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 = '91092' 04/04/2024 04:58:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '91092' 04/04/2024 04:58: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 ( '91092' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45' , '45' , '0' , '0' , '45.00' ) 04/04/2024 05:06:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1015' AND id_document != '91086' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 05:06:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1015', document_date = '2024-04-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '329.95', price_tax_excluded = '277.65', date_upd = NOW() WHERE id_document = '91086' 04/04/2024 05:06:24 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 = '91086' 04/04/2024 05:06:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91086' 04/04/2024 05:06:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '22281' , 'CARDIOLOGO VISITA GESU - F. SERAFINI' , '1' , '-1' , '4' , '23.0000' , '23' , '0' , '5' , '21.85' ) 04/04/2024 05:06:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '10' , '-10' , '4' , '1.9000' , '1.9' , '0' , '5' , '18.10' ) 04/04/2024 05:06:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91086' , '22234' , 'CAMICE MISTO LANA - 70/002020' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 04/04/2024 05:06:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '638' AND id_document != '90611' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-04') 04/04/2024 05:06:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '638', document_date = '2024-03-04', 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 = '90611' 04/04/2024 05:06: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 = '90611' 04/04/2024 05:06:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '90611' 04/04/2024 05:06: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 ( '90611' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '20' , '16.393442622951' , '22' , '0' , '100.00' ) 04/04/2024 05:07:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '556' AND id_document != '90497' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-26') 04/04/2024 05:07:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '556', document_date = '2024-02-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '89.00', price_tax_excluded = '72.95', date_upd = NOW() WHERE id_document = '90497' 04/04/2024 05:07:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90497' 04/04/2024 05:07:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '90497' 04/04/2024 05:07:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90497' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '4' , '-4' , '1' , '20' , '16.393442622951' , '22' , '0' , '80.00' ) 04/04/2024 05:07:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90497' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '' , '9.00' ) 04/04/2024 05:08:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '963' AND id_document != '91019' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-29') 04/04/2024 05:08:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '963', document_date = '2024-03-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 = '57.00', price_tax_excluded = '46.72', date_upd = NOW() WHERE id_document = '91019' 04/04/2024 05:08:28 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 = '91019' 04/04/2024 05:08:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '91019' 04/04/2024 05:08:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91019' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 04/04/2024 05:08:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91019' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '50.00' ) 04/04/2024 05:08:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '898' AND id_document != '90948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-26') 04/04/2024 05:08:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '898', document_date = '2024-03-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.50', price_tax_excluded = '83.87', date_upd = NOW() WHERE id_document = '90948' 04/04/2024 05:08: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 = '90948' 04/04/2024 05:08:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90948' 04/04/2024 05:08: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 ( '90948' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 04/04/2024 05:08: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 ( '90948' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 04/04/2024 05:08: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 ( '90948' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 04/04/2024 05:22:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002238' AND id_product != '22249' AND ean13 != '' 04/04/2024 05:22:03 pm >> UPDATE ps_product SET id_supplier = '160', reference = '', ean13 = '002238', date_upd = NOW() WHERE id_product = '22249' 04/04/2024 05:22:03 pm >> UPDATE ps_product_lang SET name = 'CASULA MARIANA - CASOM77', description = '' WHERE id_product = '22249' 04/04/2024 05:22:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '487.7049180327869' WHERE id_product = '22249' 04/04/2024 05:22:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '487.7049180327869', id_tax_rules_group = '1', id_category_default = '494', 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 = '22249' 04/04/2024 05:22:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '22249' 04/04/2024 05:47:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1019' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 05:47:27 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' , '1019' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.25' , '8.44' , NOW() , NOW() ) 04/04/2024 05:47:27 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 = '91093' 04/04/2024 05:47:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91093' 04/04/2024 05:47:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91093' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 04/04/2024 05:47:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91093' , '18134' , 'CROCE SAN BENEDETTO CM 7 - CSB3' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 04/04/2024 06:12:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1020' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 06:12: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' , '1020' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 04/04/2024 06:12: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 = '91094' 04/04/2024 06:12:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '91094' 04/04/2024 06:12:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91094' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 04/04/2024 06:34:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1021' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 06:34:33 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' , '1021' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.10' , '15.66' , NOW() , NOW() ) 04/04/2024 06:34:33 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 = '91095' 04/04/2024 06:34:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91095' 04/04/2024 06:34:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91095' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 04/04/2024 06:34:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91095' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 04/04/2024 06:34:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91095' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 04/04/2024 06:34:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91095' , '18214' , 'BRACCIALE DECINA LEGNO CORDA - BC566' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 04/04/2024 06:34:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91095' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 04/04/2024 07:01:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 07:01:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1022' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 04/04/2024 07:01:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91096' 04/04/2024 07:01:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91096' 04/04/2024 07:01:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91096' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 04/04/2024 07:37:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 07:37:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1023' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 04/04/2024 07:37:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91097' 04/04/2024 07:37:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91097' 04/04/2024 07:37:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91097' , '21005' , 'ARCA DI NOE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 04/04/2024 07:53:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1024' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 07:53:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1024' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 04/04/2024 07:53:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91098' 04/04/2024 07:53:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91098' 04/04/2024 07:53: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 ( '91098' , '5764' , 'LEZIONARIO FERIALE ANNO PARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 04/04/2024 07:55:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1025' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-04') 04/04/2024 07:55:50 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' , '1025' , '2024-04-04' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 04/04/2024 07:55:50 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 = '91099' 04/04/2024 07:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91099' 04/04/2024 07:55:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91099' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' )