06/05/2023 08:59:26 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('2023-05-06') 06/05/2023 08:59:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '22' , '7/S' , '2023-05-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'VENDUTO APRILE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1190.55' , '1190.55' , NOW() , NOW() ) 06/05/2023 08:59:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11068' 06/05/2023 08:59:26 am >> DELETE FROM ps_document_detail WHERE id_document = '11068' 06/05/2023 08:59: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 ( '11068' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '0' , '4' , '10.50' , '10.5' , '0' , '50' , '5.25' ) 06/05/2023 08:59: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 ( '11068' , '13' , 'BUSSATE E VI SARÀ APERTO' , '20' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '15.00' ) 06/05/2023 08:59: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 ( '11068' , '17' , 'LA FEDE NELLO ZAINETTO' , '7' , '0' , '4' , '6.00' , '6' , '0' , '50' , '21.00' ) 06/05/2023 08:59: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 ( '11068' , '19' , 'CHIERICHETTI IERI OGGI DOMANI' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/05/2023 08:59: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 ( '11068' , '20' , 'GIOVEDÌ SANTO' , '3' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '2.25' ) 06/05/2023 08:59: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 ( '11068' , '21' , 'LA COMUNIONE' , '1' , '0' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/05/2023 08:59: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 ( '11068' , '124' , 'PREGHIERE DEI RAGAZZI N. E. ' , '178' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '133.50' ) 06/05/2023 08:59: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 ( '11068' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '35' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '43.75' ) 06/05/2023 08:59: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 ( '11068' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '54' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '67.50' ) 06/05/2023 08:59: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 ( '11068' , '130' , 'ROSARIO SPIEGATO AI BAMBINI - N.E.' , '136' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '170.00' ) 06/05/2023 08:59: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 ( '11068' , '125' , 'MIE PREGHIERINE - N. E.' , '74' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '55.50' ) 06/05/2023 08:59: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 ( '11068' , '33' , '100 GIORNI CON LO SPIRITO' , '19' , '0' , '4' , '7.50' , '7.5' , '0' , '50' , '71.25' ) 06/05/2023 08:59: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 ( '11068' , '42' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 06/05/2023 08:59: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 ( '11068' , '43' , 'LA BENEDIZIONE DELLA FAMIGLIA' , '1' , '0' , '4' , '1.30' , '1.3' , '0' , '50' , '0.65' ) 06/05/2023 08:59: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 ( '11068' , '44' , 'GUARDALIBRI: DVD IL CREDO' , '1' , '0' , '4' , '9.90' , '9.9' , '0' , '50' , '4.95' ) 06/05/2023 08:59: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 ( '11068' , '50' , 'PERDONAMI SIGNORE' , '58' , '0' , '4' , '2' , '2' , '0' , '50' , '58.00' ) 06/05/2023 08:59: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 ( '11068' , '52' , 'Il Padre Nostro spiegato ai bambini' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 06/05/2023 08:59: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 ( '11068' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '1' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/05/2023 08:59: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 ( '11068' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '2' , '0' , '4' , '2.00' , '2' , '0' , '50' , '2.00' ) 06/05/2023 08:59: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 ( '11068' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '0' , '4' , '30.00' , '30' , '0' , '50' , '15.00' ) 06/05/2023 08:59: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 ( '11068' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '27' , '0' , '4' , '2.00' , '2' , '0' , '50' , '27.00' ) 06/05/2023 08:59: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 ( '11068' , '88' , 'GESÙ È RISORTO' , '3' , '0' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 06/05/2023 08:59: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 ( '11068' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '38' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '34.20' ) 06/05/2023 08:59: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 ( '11068' , '92' , 'LA PREGHIERA DEL ROSARIO' , '3' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/05/2023 08:59: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 ( '11068' , '94' , 'IL BATTESIMO' , '10' , '0' , '4' , '1.50' , '1.5' , '0' , '50' , '7.50' ) 06/05/2023 08:59: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 ( '11068' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '30' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '37.50' ) 06/05/2023 08:59: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 ( '11068' , '110' , 'SE MI AMI NON PIANGERE' , '18' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '16.20' ) 06/05/2023 08:59: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 ( '11068' , '111' , 'I NONNI SONO UN TESORO' , '2' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '1.80' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '2' , '0' , '4' , '3.00' , '3' , '0' , '50' , '3.00' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '42' , '0' , '4' , '4.00' , '4' , '0' , '50' , '84.00' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '117' , 'La preghiera delle cinque dita n.e.' , '40' , '0' , '4' , '1.80' , '1.8' , '0' , '50' , '36.00' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '1' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '23' , '0' , '4' , '2.50' , '2.5' , '0' , '50' , '28.75' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '6' , '0' , '4' , '3.00' , '3' , '0' , '50' , '9.00' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '0' , '4' , '18.00' , '18' , '0' , '50' , '9.00' ) 06/05/2023 08:59:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11068' , '126' , 'SACRAMENTO DEL PERDONO' , '214' , '0' , '4' , '2.00' , '2' , '0' , '50' , '214.00' ) 06/05/2023 09:06:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 09:06:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1537' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 06/05/2023 09:06:31 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 = '84183' 06/05/2023 09:06:31 am >> DELETE FROM ps_document_detail WHERE id_document = '84183' 06/05/2023 09:06:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84183' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 06/05/2023 09:12:56 am >> SELECT document_num FROM ps_document WHERE document_num = '8/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 09:12:56 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' , '8/S' , '2023-05-06' , 'S' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'RESA APRILE 2023' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '319.00' , '319.00' , NOW() , NOW() ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '11069' 06/05/2023 09:12:56 am >> DELETE FROM ps_document_detail WHERE id_document = '11069' 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '6' , 'I miracoli da colorare. Il figlio della vedova' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '17' , 'LA FEDE NELLO ZAINETTO' , '2' , '2' , '4' , '6.00' , '6' , '0' , '50' , '6.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '20' , 'GIOVEDÌ SANTO' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '50' , '1.50' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '50' , '6.25' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '33' , '100 GIORNI CON LO SPIRITO' , '3' , '3' , '4' , '7.50' , '7.5' , '0' , '50' , '11.25' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '52' , 'Il Padre Nostro spiegato ai bambini' , '3' , '3' , '4' , '2.00' , '2' , '0' , '50' , '3.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '54' , 'BENEDETTO XVI ° ..... UNA PAGINA DI STORIA' , '1' , '1' , '4' , '2.50' , '2.5' , '0' , '50' , '1.25' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '1' , '1' , '4' , '2.00' , '2' , '0' , '50' , '1.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '5' , '5' , '4' , '2.00' , '2' , '0' , '50' , '5.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '97' , '\"IL NATALE \"\"CHE MERAVIGLIA\"\"\"' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '104' , 'TEMPO DI QUARESIMA' , '10' , '10' , '4' , '2.50' , '2.5' , '0' , '50' , '12.50' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '106' , 'RICORDO DI UNA GIORNATA SPECIALE' , '1' , '1' , '4' , '1.50' , '1.5' , '0' , '50' , '0.75' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '111' , 'I NONNI SONO UN TESORO' , '20' , '20' , '4' , '1.80' , '1.8' , '0' , '50' , '18.00' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '3' , '3' , '4' , '3.00' , '3' , '0' , '50' , '4.50' ) 06/05/2023 09:12:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '114' , 'Le preghiere dei ragazzi' , '9' , '9' , '4' , '1.50' , '1.5' , '0' , '50' , '6.75' ) 06/05/2023 09:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '115' , 'SAN FRANCESCO DASSISI RACCONTATO AI RAGAZZI N.E.' , '2' , '2' , '4' , '4.00' , '4' , '0' , '50' , '4.00' ) 06/05/2023 09:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '3' , '3' , '4' , '2.50' , '2.5' , '0' , '50' , '3.75' ) 06/05/2023 09:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '8' , '8' , '4' , '3.00' , '3' , '0' , '50' , '12.00' ) 06/05/2023 09:12:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11069' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '24' , '24' , '4' , '18.00' , '18' , '0' , '50' , '216.00' ) 06/05/2023 09:30:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 09:30:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1538' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 06/05/2023 09:30: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 = '84184' 06/05/2023 09:30:46 am >> DELETE FROM ps_document_detail WHERE id_document = '84184' 06/05/2023 09:30: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 ( '84184' , '2655' , 'CONFEZIONE CARTONCINO CONFESSIONE- 2331-J44' , '9' , '-9' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '22.50' ) 06/05/2023 09:45:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 09:45:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1539' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 06/05/2023 09:45:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84185' 06/05/2023 09:45:52 am >> DELETE FROM ps_document_detail WHERE id_document = '84185' 06/05/2023 09:45:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84185' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 06/05/2023 10:00:18 am >> SELECT document_num FROM ps_document WHERE document_num = '1540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:00:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1540' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.40' , '65.08' , NOW() , NOW() ) 06/05/2023 10:00:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84186' 06/05/2023 10:00:18 am >> DELETE FROM ps_document_detail WHERE id_document = '84186' 06/05/2023 10:00:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84186' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 06/05/2023 10:00:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84186' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 06/05/2023 10:32:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:32:05 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' , '1541' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 06/05/2023 10:32:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84187' 06/05/2023 10:32:05 am >> DELETE FROM ps_document_detail WHERE id_document = '84187' 06/05/2023 10:32:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84187' , '18716' , 'SAN MICHELE CM 33 - ST214-SM' , '1' , '-1' , '1' , '53' , '43.44262295082' , '22' , '0' , '53.00' ) 06/05/2023 10:34:30 am >> SELECT document_num FROM ps_document WHERE document_num = '1542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:34:30 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' , '1542' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 06/05/2023 10:34:30 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 = '84188' 06/05/2023 10:34:30 am >> DELETE FROM ps_document_detail WHERE id_document = '84188' 06/05/2023 10:34:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84188' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 06/05/2023 10:47:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:47:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1543' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.40' , '33.93' , NOW() , NOW() ) 06/05/2023 10:47:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84189' 06/05/2023 10:47:15 am >> DELETE FROM ps_document_detail WHERE id_document = '84189' 06/05/2023 10:47: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 ( '84189' , '7202' , 'ARTICOLI RELIGIOSI' , '23' , '-23' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '41.40' ) 06/05/2023 10:47:28 am >> SELECT document_num FROM ps_document WHERE document_num = '1544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:47:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1544' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 06/05/2023 10:47:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84190' 06/05/2023 10:47:28 am >> DELETE FROM ps_document_detail WHERE id_document = '84190' 06/05/2023 10:47:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84190' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/05/2023 10:49:10 am >> SELECT document_num FROM ps_document WHERE document_num = '1545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 10:49:10 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' , '1545' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '12.54' , NOW() , NOW() ) 06/05/2023 10:49:10 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 = '84191' 06/05/2023 10:49:10 am >> DELETE FROM ps_document_detail WHERE id_document = '84191' 06/05/2023 10:49:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84191' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/05/2023 10:49:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84191' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 06/05/2023 10:49:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84191' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 06/05/2023 11:02:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:02:29 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' , '1546' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '13.77' , NOW() , NOW() ) 06/05/2023 11:02: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 = '84192' 06/05/2023 11:02:29 am >> DELETE FROM ps_document_detail WHERE id_document = '84192' 06/05/2023 11:02: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 ( '84192' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 06/05/2023 11:02: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 ( '84192' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/05/2023 11:13:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1547' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:13:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1547' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 06/05/2023 11:13:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84193' 06/05/2023 11:13:40 am >> DELETE FROM ps_document_detail WHERE id_document = '84193' 06/05/2023 11:13:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84193' , '19867' , 'CINGOLO NODO BIANCO - F9756' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 06/05/2023 11:31:43 am >> SELECT document_num FROM ps_document WHERE document_num = '1548' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:31:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1548' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 06/05/2023 11:31:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84194' 06/05/2023 11:31:43 am >> DELETE FROM ps_document_detail WHERE id_document = '84194' 06/05/2023 11:31:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84194' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 06/05/2023 11:33:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1548' AND id_document != '84194' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:33:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1548', document_date = '2023-05-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '24.59', date_upd = NOW() WHERE id_document = '84194' 06/05/2023 11:33:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84194' 06/05/2023 11:33:07 am >> DELETE FROM ps_document_detail WHERE id_document = '84194' 06/05/2023 11:33: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 ( '84194' , '14209' , 'PARAFIAMMA PLEXIGLASS CM 3.2' , '2' , '-2' , '1' , '15' , '12.295081967213' , '22' , '0' , '30.00' ) 06/05/2023 11:42:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1549' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:42:31 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' , '1549' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 06/05/2023 11:42:31 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 = '84195' 06/05/2023 11:42:31 am >> DELETE FROM ps_document_detail WHERE id_document = '84195' 06/05/2023 11:42:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84195' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 06/05/2023 11:47:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1550' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 11:47:09 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' , '1550' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 06/05/2023 11:47:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84196' 06/05/2023 11:47:09 am >> DELETE FROM ps_document_detail WHERE id_document = '84196' 06/05/2023 11:47:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84196' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 06/05/2023 12:09:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1551' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:09:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1551' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.20' , '8.31' , NOW() , NOW() ) 06/05/2023 12:09:55 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 = '84197' 06/05/2023 12:09:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '84197' 06/05/2023 12:09:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84197' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 06/05/2023 12:09:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84197' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 06/05/2023 12:09:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84197' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 06/05/2023 12:17:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1552' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:17:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1552' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 06/05/2023 12:17:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84198' 06/05/2023 12:17:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '84198' 06/05/2023 12:17:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84198' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 06/05/2023 12:19:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1553' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:19: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 ( '11' , '1553' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 06/05/2023 12:19: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 = '84199' 06/05/2023 12:19:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '84199' 06/05/2023 12:19: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 ( '84199' , '19560' , 'PERGAMENA 17X25' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 06/05/2023 12:19: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 ( '84199' , '18223' , 'CORONA MISSIONARIA - R102' , '12' , '-12' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '12.00' ) 06/05/2023 12:35:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '58/A' AND id_document != '84077' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-02') 06/05/2023 12:35:53 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '58/A', document_date = '2023-05-02', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'cappellania SAN LEONARDO', 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 = '90.56', price_tax_excluded = '87.86', date_upd = NOW() WHERE id_document = '84077' 06/05/2023 12:35:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84077' 06/05/2023 12:35:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '84077' 06/05/2023 12:35: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 ( '84077' , '20766' , 'AMEN - GIU 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 06/05/2023 12:35: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 ( '84077' , '20765' , 'AMEN - MAG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 06/05/2023 12:35: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 ( '84077' , '20999' , 'AMEN - LUG 23' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 06/05/2023 12:35: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 ( '84077' , '0' , 'SUPPLICA' , '2' , '-2' , '0' , '10.0000' , '10' , '0' , '0' , '20.00' ) 06/05/2023 12:35: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 ( '84077' , '13103' , 'BRACCIALE BAMBOO - CY B 774' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' ) 06/05/2023 12:39:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1554' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:39:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1554' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.15' , NOW() , NOW() ) 06/05/2023 12:39:29 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 = '84200' 06/05/2023 12:39:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '84200' 06/05/2023 12:39:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84200' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '1' , '-1' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '1.40' ) 06/05/2023 12:54:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1555' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:54:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1555' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.50' , '55.95' , NOW() , NOW() ) 06/05/2023 12:54: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 = '84201' 06/05/2023 12:54:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '84201' 06/05/2023 12:54: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 ( '84201' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '50' , '-50' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '30.00' ) 06/05/2023 12:54: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 ( '84201' , '13506' , 'SANTO ROSARIO' , '50' , '-50' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '15.00' ) 06/05/2023 12:54: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 ( '84201' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 06/05/2023 12:54: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 ( '84201' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '5' , '17.10' ) 06/05/2023 12:58:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1556' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-06') 06/05/2023 12:58:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1556' , '2023-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.81' , '60.81' , NOW() , NOW() ) 06/05/2023 12:58:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84202' 06/05/2023 12:58:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '84202' 06/05/2023 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84202' , '1136' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '-1' , '4' , '34.50' , '34.5' , '0' , '5' , '32.78' ) 06/05/2023 12:58:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84202' , '1142' , 'BIBBIA DI GERUSALEMME - TASC.' , '1' , '-1' , '4' , '29.50' , '29.5' , '0' , '5' , '28.03' )