18/12/2023 08:44:07 am >> SELECT document_num FROM ps_document WHERE document_num = '5/PA' AND id_document != '89496' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-15') 18/12/2023 08:44:07 am >> UPDATE ps_document SET id_document_type = '23', document_num = '5/PA', document_date = '2023-12-15', document_letter = 'PA', id_customer = '4073', id_supplier = '', id_address = '4679226', address1 = 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1079.10', price_tax_excluded = '1079.10', date_upd = NOW() WHERE id_document = '89496' 18/12/2023 08:44: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 = '89496' 18/12/2023 08:44:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89496' 18/12/2023 08:44: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 ( '89496' , '0' , 'DETERMINA N. 118 DEL 21/11/2023 CODICE CIG: Z903D5E745' , '0' , '0' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 18/12/2023 08:44: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 ( '89496' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 18/12/2023 08:44: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 ( '89496' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 18/12/2023 08:44: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 ( '89496' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 08:44: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 ( '89496' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 18/12/2023 08:44: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 ( '89496' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 18/12/2023 08:44: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 ( '89496' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 08:44: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 ( '89496' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:44: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 ( '89496' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:44: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 ( '89496' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:44: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 ( '89496' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 08:44: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 ( '89496' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 18/12/2023 08:44: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 ( '89496' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:44: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 ( '89496' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:44: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 ( '89496' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:44: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 ( '89496' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:44: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 ( '89496' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:44: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 ( '89496' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:44: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 ( '89496' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:44: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 ( '89496' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 18/12/2023 08:44: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 ( '89496' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:44: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 ( '89496' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:44: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 ( '89496' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/12/2023 08:44: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 ( '89496' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 18/12/2023 08:44: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 ( '89496' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 18/12/2023 08:44: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 ( '89496' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:44: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 ( '89496' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 18/12/2023 08:44: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 ( '89496' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:44: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 ( '89496' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:44: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 ( '89496' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:44: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 ( '89496' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 08:44: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 ( '89496' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 08:44: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 ( '89496' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:44: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 ( '89496' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:44: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 ( '89496' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:44: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 ( '89496' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 18/12/2023 08:44: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 ( '89496' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 18/12/2023 08:44: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 ( '89496' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 18/12/2023 08:44: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 ( '89496' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:44: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 ( '89496' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 18/12/2023 08:44: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 ( '89496' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:44: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 ( '89496' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 18/12/2023 08:44: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 ( '89496' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:44: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 ( '89496' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:44: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 ( '89496' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:44: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 ( '89496' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:44: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 ( '89496' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 18/12/2023 08:44: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 ( '89496' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 08:44: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 ( '89496' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:44: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 ( '89496' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 18/12/2023 08:44: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 ( '89496' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:44: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 ( '89496' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:44: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 ( '89496' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 18/12/2023 08:59:51 am >> SELECT document_num FROM ps_document WHERE document_num = '5/PA' AND id_document != '89496' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 08:59:51 am >> UPDATE ps_document SET id_document_type = '23', document_num = '5/PA', document_date = '2023-12-18', document_letter = 'PA', id_customer = '4073', id_supplier = '', id_address = '4679226', address1 = 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1079.10', price_tax_excluded = '1079.10', date_upd = NOW() WHERE id_document = '89496' 18/12/2023 08:59:51 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 = '89496' 18/12/2023 08:59:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89496' 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'DETERMINA N. 118 DEL 21/11/2023 CODICE CIG: Z903D5E745' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:59:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:59: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 ( '89496' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 18/12/2023 08:59: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 ( '89496' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:59: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 ( '89496' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:59: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 ( '89496' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 18/12/2023 08:59: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 ( '89496' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 18/12/2023 08:59: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 ( '89496' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 18/12/2023 08:59: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 ( '89496' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59: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 ( '89496' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 08:59: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 ( '89496' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59: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 ( '89496' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 18/12/2023 08:59: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 ( '89496' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59: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 ( '89496' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:59: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 ( '89496' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:59: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 ( '89496' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:59: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 ( '89496' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 08:59: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 ( '89496' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 08:59: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 ( '89496' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 18/12/2023 08:59: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 ( '89496' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:59: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 ( '89496' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59: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 ( '89496' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59: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 ( '89496' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:59: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 ( '89496' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 18/12/2023 08:59: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 ( '89496' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 18/12/2023 08:59: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 ( '89496' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 18/12/2023 08:59: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 ( '89496' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 08:59: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 ( '89496' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 18/12/2023 08:59: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 ( '89496' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:59: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 ( '89496' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 18/12/2023 08:59: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 ( '89496' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:59: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 ( '89496' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:59: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 ( '89496' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 08:59: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 ( '89496' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 18/12/2023 08:59: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 ( '89496' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 18/12/2023 08:59: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 ( '89496' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 08:59: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 ( '89496' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 08:59: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 ( '89496' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 18/12/2023 08:59: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 ( '89496' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 08:59: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 ( '89496' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 18/12/2023 08:59: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 ( '89496' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 18/12/2023 09:07:47 am >> SELECT document_num FROM ps_document WHERE document_num = '4027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 09:07:47 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' , '4027' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '132.00' , '108.20' , NOW() , NOW() ) 18/12/2023 09:07: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 = '89537' 18/12/2023 09:07:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89537' 18/12/2023 09:07:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89537' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '132' , '108.19672131148' , '22' , '0' , '132.00' ) 18/12/2023 09:31:44 am >> SELECT document_num FROM ps_document WHERE document_num = '4028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 09:31: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' , '4028' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 18/12/2023 09:31: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 = '89538' 18/12/2023 09:31:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89538' 18/12/2023 09:31: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 ( '89538' , '20561' , 'CONFEZIONE CARTONCINO CON BAMBINO- P762' , '80' , '-80' , '1' , '0.7' , '0.57377049180328' , '22' , '0' , '56.00' ) 18/12/2023 09:34:12 am >> SELECT document_num FROM ps_document WHERE document_num = '4029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 09:34:12 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' , '4029' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '32.91' , NOW() , NOW() ) 18/12/2023 09:34:12 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 = '89539' 18/12/2023 09:34:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89539' 18/12/2023 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89539' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 18/12/2023 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89539' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/12/2023 09:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89539' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 18/12/2023 09:43:04 am >> SELECT document_num FROM ps_document WHERE document_num = '53' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 09:43:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '53' , '2023-12-18' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1304.00' , '1304.00' , NOW() , NOW() ) 18/12/2023 09:43:04 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 = '89540' 18/12/2023 09:43:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89540' 18/12/2023 09:43: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 ( '89540' , '7543' , 'PARABOLE DI GESÙ' , '160' , '-160' , '4' , '3.00' , '3' , '0' , '0' , '480.00' ) 18/12/2023 09:43: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 ( '89540' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '320' , '-320' , '4' , '1.90' , '1.9' , '0' , '0' , '608.00' ) 18/12/2023 09:43: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 ( '89540' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '216' , '-216' , '4' , '1.00' , '1' , '0' , '0' , '216.00' ) 18/12/2023 09:46:03 am >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 09:46:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '20' , '2023-12-18' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1912.00' , '1912.00' , NOW() , NOW() ) 18/12/2023 09:46: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 = '14023' 18/12/2023 09:46:03 am >> DELETE FROM ps_document_detail WHERE id_document = '14023' 18/12/2023 09:46: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 ( '14023' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '44' , '-44' , '4' , '18.00' , '18' , '0' , '0' , '792.00' ) 18/12/2023 09:46: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 ( '14023' , '126' , 'SACRAMENTO DEL PERDONO' , '560' , '-560' , '4' , '2.00' , '2' , '0' , '0' , '1120.00' ) 18/12/2023 09:48:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400330038' AND id_product != '20561' AND ean13 != '' 18/12/2023 09:48:03 am >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400330038', date_upd = NOW() WHERE id_product = '20561' 18/12/2023 09:48:03 am >> UPDATE ps_product_lang SET name = 'CONFEZIONE CARTONCINO CON BAMBINO - P762', description = '' WHERE id_product = '20561' 18/12/2023 09:48:03 am >> UPDATE ps_product SET wholesale_price = '0.25', on_sale = '0', price = '0.4918' WHERE id_product = '20561' 18/12/2023 09:48:03 am >> UPDATE ps_product_shop SET wholesale_price = '0.25', price = '0.4918', id_tax_rules_group = '1', id_category_default = '95', 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 = '20561' 18/12/2023 09:48:03 am >> DELETE FROM ps_specific_price WHERE id_product = '20561' 18/12/2023 09:52:45 am >> SELECT document_num FROM ps_document WHERE document_num = '4016' AND id_document != '89523' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 18/12/2023 09:52:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4016', document_date = '2023-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.50', price_tax_excluded = '20.08', date_upd = NOW() WHERE id_document = '89523' 18/12/2023 09:52:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89523' 18/12/2023 09:52:45 am >> DELETE FROM ps_document_detail WHERE id_document = '89523' 18/12/2023 09:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89523' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '6' , '-6' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '21.00' ) 18/12/2023 09:52:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89523' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 18/12/2023 10:01:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 10:01:02 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' , '4030' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 18/12/2023 10:01:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89541' 18/12/2023 10:01:02 am >> DELETE FROM ps_document_detail WHERE id_document = '89541' 18/12/2023 10:01: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 ( '89541' , '14790' , 'NATIVITA STELLATA 13,5 CM' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2023 10:38:19 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '5MSsXOeI2JTT1Zq7' , NOW() , NOW() ) 18/12/2023 10:38:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4074' , '1' ) 18/12/2023 10:38:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4074' , '2' ) 18/12/2023 10:38:19 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4074' , '3' ) 18/12/2023 10:41:40 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3892' 18/12/2023 10:41:40 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 ( '3892' , '10' , '210' , 'PARR. SANTA MARIA E SAN NICOLA' , 'ZOLFERINO' , 'DON ANTONIO' , 'VIA DI OGLIARA 198' , '' , '84100' , 'OGLIARA' , '' , '' , '3661264160' , '' , '' , NOW() , NOW() ) 18/12/2023 10:41:40 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3892' 18/12/2023 10:41:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3892' 18/12/2023 10:41:49 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 ( '3892' , '10' , '210' , 'PARR. SANTA MARIA E SAN NICOLA' , 'ZOLFERINO' , 'DON ANTONIO' , 'VIA DI OGLIARA 198' , '' , '84100' , 'SALERNO' , '' , '' , '3661264160' , '' , '' , NOW() , NOW() ) 18/12/2023 10:41:49 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3892' 18/12/2023 10:41:56 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4074' 18/12/2023 10:41:56 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 ( '4074' , '10' , '210' , '' , 'ZOLFERINO' , 'DON ANTONIO' , 'VIA DI OGLIARA 198' , '' , '84135' , 'SALERNO' , '' , '' , '3661264160' , '' , 'ZLFNTN78H08H703X' , NOW() , NOW() ) 18/12/2023 10:41:56 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4074' 18/12/2023 10:50:44 am >> SELECT document_num FROM ps_document WHERE document_num = '4031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 10:50: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' , '4031' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '291.07' , NOW() , NOW() ) 18/12/2023 10:50: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 = '89542' 18/12/2023 10:50:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89542' 18/12/2023 10:50: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 ( '89542' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 18/12/2023 10:50: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 ( '89542' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 18/12/2023 10:50: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 ( '89542' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 18/12/2023 10:50: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 ( '89542' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '300.5' , '246.31147540984' , '22' , '0' , '300.50' ) 18/12/2023 11:00:29 am >> SELECT document_num FROM ps_document WHERE document_num = '4032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:00: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' , '4032' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.00' , '18.85' , NOW() , NOW() ) 18/12/2023 11:00: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 = '89543' 18/12/2023 11:00:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89543' 18/12/2023 11:00: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 ( '89543' , '17570' , 'BAMBINELLO IN RESINA - PB5452' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 18/12/2023 11:13:51 am >> SELECT document_num FROM ps_document WHERE document_num = '4033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:13:51 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' , '4033' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 18/12/2023 11:13:51 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 = '89544' 18/12/2023 11:13:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89544' 18/12/2023 11:13:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89544' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 18/12/2023 11:13:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89544' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/12/2023 11:22:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2789' AND id_document != '87251' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-11') 18/12/2023 11:22:28 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2789', document_date = '2023-09-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '245.00', price_tax_excluded = '200.82', date_upd = NOW() WHERE id_document = '87251' 18/12/2023 11:22: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 = '87251' 18/12/2023 11:22:28 am >> DELETE FROM ps_document_detail WHERE id_document = '87251' 18/12/2023 11:22: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 ( '87251' , '16514' , 'CROCIFISSO 105X60 - 1015' , '1' , '-1' , '1' , '245' , '200.81967213115' , '22' , '0' , '245.00' ) 18/12/2023 11:26:53 am >> SELECT document_num FROM ps_document WHERE document_num = '4034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:26:53 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' , '4034' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.60' , '31.64' , NOW() , NOW() ) 18/12/2023 11:26:53 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 = '89545' 18/12/2023 11:26:53 am >> DELETE FROM ps_document_detail WHERE id_document = '89545' 18/12/2023 11:26:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89545' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '11' , '-11' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '38.50' ) 18/12/2023 11:26:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89545' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 18/12/2023 11:37:34 am >> SELECT document_num FROM ps_document WHERE document_num = '4035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:37:34 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' , '4035' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 18/12/2023 11:37:34 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 = '89546' 18/12/2023 11:37:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89546' 18/12/2023 11:37: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 ( '89546' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 18/12/2023 11:37: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 ( '89546' , '20522' , 'CROCE BASE NIK - 105 ALV' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/12/2023 11:37: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 ( '89546' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '4' , '-4' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '10.00' ) 18/12/2023 11:37:56 am >> SELECT document_num FROM ps_document WHERE document_num = '4036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:37: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 ( '11' , '4036' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 18/12/2023 11:37: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 = '89547' 18/12/2023 11:37:56 am >> DELETE FROM ps_document_detail WHERE id_document = '89547' 18/12/2023 11:37: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 ( '89547' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 18/12/2023 11:53:18 am >> SELECT document_num FROM ps_document WHERE document_num = '4037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:53: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' , '4037' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 18/12/2023 11:53: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 = '89548' 18/12/2023 11:53:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89548' 18/12/2023 11:53: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 ( '89548' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 18/12/2023 11:54:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:54: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' , '4038' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '409.84' , NOW() , NOW() ) 18/12/2023 11:54: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 = '89549' 18/12/2023 11:54:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89549' 18/12/2023 11:54: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 ( '89549' , '21903' , 'BAMBINO BETLEMME CM 50 - 50/B' , '1' , '-1' , '1' , '500' , '409.83606557377' , '22' , '0' , '500.00' ) 18/12/2023 11:55:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:55:19 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' , '4039' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 18/12/2023 11:55:19 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 = '89550' 18/12/2023 11:55:19 am >> DELETE FROM ps_document_detail WHERE id_document = '89550' 18/12/2023 11:55:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89550' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 18/12/2023 11:55:48 am >> SELECT document_num FROM ps_document WHERE document_num = '4040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 11:55:48 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' , '4040' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 18/12/2023 11:55:48 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 = '89551' 18/12/2023 11:55:48 am >> DELETE FROM ps_document_detail WHERE id_document = '89551' 18/12/2023 11:55:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89551' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 18/12/2023 12:00:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4040' AND id_document != '89551' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 12:00:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4040', document_date = '2023-12-18', 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 = '27.00', price_tax_excluded = '22.13', date_upd = NOW() WHERE id_document = '89551' 18/12/2023 12:00: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 = '89551' 18/12/2023 12:00:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89551' 18/12/2023 12:00: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 ( '89551' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '1' , '-1' , '1' , '27' , '22.131147540984' , '22' , '0' , '27.00' ) 18/12/2023 12:12:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2048' AND id_document != '85826' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 18/12/2023 12:12:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2048', document_date = '2023-06-13', 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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '85826' 18/12/2023 12:12: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 = '85826' 18/12/2023 12:12:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '85826' 18/12/2023 12:12: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 ( '85826' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '20' , '-20' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '10.00' ) 18/12/2023 12:12: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 ( '85826' , '13342' , 'PRESEPE CON LED - 8575/01' , '3' , '-3' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '45.00' ) 18/12/2023 12:12: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 ( '85826' , '20704' , 'QUADRO 63X35' , '1' , '-1' , '1' , '85' , '69.672131147541' , '22' , '0' , '85.00' ) 18/12/2023 12:14:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2787' AND id_document != '87249' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-11') 18/12/2023 12:14:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2787', document_date = '2023-09-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '145.00', price_tax_excluded = '127.21', date_upd = NOW() WHERE id_document = '87249' 18/12/2023 12:14: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 = '87249' 18/12/2023 12:14:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87249' 18/12/2023 12:14: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 ( '87249' , '17257' , 'IO TI BATTEZZO ' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '0' , '3.60' ) 18/12/2023 12:14: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 ( '87249' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.0000' , '45' , '0' , '5' , '42.75' ) 18/12/2023 12:14: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 ( '87249' , '20171' , 'ANGELO CM 18 - AR105' , '1' , '-1' , '1' , '13.6500' , '11.188524590164' , '22' , '0' , '13.65' ) 18/12/2023 12:14: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 ( '87249' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 18/12/2023 12:14: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 ( '87249' , '21178' , 'GEMELLO ARGENTO - GEM53' , '1' , '-1' , '1' , '73' , '59.83606557377' , '22' , '0' , '73.00' ) 18/12/2023 12:14: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 ( '87249' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '4' , '-4' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '8.00' ) 18/12/2023 12:15:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2866' AND id_document != '87354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-20') 18/12/2023 12:15:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2866', document_date = '2023-09-20', 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 = '39.00', price_tax_excluded = '31.97', date_upd = NOW() WHERE id_document = '87354' 18/12/2023 12:15:06 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 = '87354' 18/12/2023 12:15:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '87354' 18/12/2023 12:15:06 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 ( '87354' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 18/12/2023 12:15:06 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 ( '87354' , '21179' , 'ORECCHINI ARGENTO/CRISTALLO - 5447' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 18/12/2023 12:16:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '4/L' AND id_document != '82494' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-28') 18/12/2023 12:16:50 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '4/L', document_date = '2023-03-28', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA BATTIPAGLIA', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '223.50', price_tax_excluded = '190.01', date_upd = NOW() WHERE id_document = '82494' 18/12/2023 12:16: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 = '82494' 18/12/2023 12:16:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82494' 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.5600' , '0.56' , '0' , '0' , '14.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '300' , '-300' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '75.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 18/12/2023 12:16:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82494' , '11654' , 'SET ADESIVO CERO PASQUALE' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 18/12/2023 12:18:51 pm >> DELETE FROM ps_document WHERE id_document = '82684' 18/12/2023 12:18:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82684' 18/12/2023 12:24:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '56617' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-05') 18/12/2023 12:24:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '34/A', document_date = '2022-05-05', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'acconto € 100,00 5/4/23 - 200 04/05 18/12 € 660', 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 = '1460.00', price_tax_excluded = '1196.72', date_upd = NOW() WHERE id_document = '56617' 18/12/2023 12:24:00 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 = '56617' 18/12/2023 12:24:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 18/12/2023 12:24:00 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 ( '56617' , '0' , 'COTTA ' , '1' , '0' , '1' , '680.0000' , '557.37704918033' , '22' , '0' , '680.00' ) 18/12/2023 12:24:00 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 ( '56617' , '19802' , 'CASULA CON PALLIO L-LAME\' - NUOVA PRIMAVERA - 8254C****' , '1' , '0' , '1' , '780.0000' , '639.34426229508' , '22' , '0' , '780.00' ) 18/12/2023 12:24:00 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 ( '56617' , '' , 'RESTA A SALDO € 500' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 18/12/2023 12:26:53 pm >> DELETE FROM ps_document WHERE id_document = '56617' 18/12/2023 12:26:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '56617' 18/12/2023 12:28:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '4041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 12:28: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' , '4041' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '18.50' , NOW() , NOW() ) 18/12/2023 12:28: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 = '89552' 18/12/2023 12:28:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89552' 18/12/2023 12:28: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 ( '89552' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 12:31:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '27/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 12:31:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '27/L' , '2023-12-18' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '187.70' , '162.72' , NOW() , NOW() ) 18/12/2023 12:31: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 = '89553' 18/12/2023 12:31:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89553' 18/12/2023 12:31: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 ( '89553' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3654' , '4' , '0' , '17.50' ) 18/12/2023 12:31: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 ( '89553' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.9000' , '7.2951' , '22' , '0' , '17.80' ) 18/12/2023 12:31: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 ( '89553' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672' , '22' , '0' , '51.00' ) 18/12/2023 12:31: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 ( '89553' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3654' , '4' , '0' , '35.00' ) 18/12/2023 12:31: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 ( '89553' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 18/12/2023 12:31: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 ( '89553' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 18/12/2023 12:37:11 pm >> DELETE FROM ps_document WHERE id_document = '89028' 18/12/2023 12:37:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89028' 18/12/2023 12:47:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '4042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 12:47:07 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' , '4042' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '18.44' , NOW() , NOW() ) 18/12/2023 12:47:07 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 = '89554' 18/12/2023 12:47:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '89554' 18/12/2023 12:47:07 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 ( '89554' , '6403' , 'MENSA BIANCA 80X150 ' , '3' , '-3' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '22.50' ) 18/12/2023 12:52:47 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 18/12/2023 12:52:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22014' , '1' , '' , 'nuovo-prodotto' ) 18/12/2023 12:52:47 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22014' , '1' , '1' , '2' , NOW() , NOW() ) 18/12/2023 12:52:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22014' , '0' , '1' , '0' , '0' ) 18/12/2023 12:55:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002215' AND id_product != '22014' AND ean13 != '' 18/12/2023 12:55:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002215', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 12:55:07 pm >> UPDATE ps_product_lang SET name = 'festa della santa famiglia - pieghevole', description = '' WHERE id_product = '22014' 18/12/2023 12:55:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '22014' 18/12/2023 12:55:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 12:55:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22014' 18/12/2023 12:55:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002215' AND id_product != '22014' AND ean13 != '' 18/12/2023 12:55:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002215', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 12:55:29 pm >> UPDATE ps_product_lang SET name = 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE', description = '' WHERE id_product = '22014' 18/12/2023 12:55:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22014' 18/12/2023 12:55:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 12:55:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '22014' 18/12/2023 12: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 ( '33' , '3161' , '2023-12-11' , '' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.29' , '24.29' , NOW() , NOW() ) 18/12/2023 12: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 = '89555' 18/12/2023 12:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89555' 18/12/2023 12: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 ( '89555' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '2' , '2' , '4' , '7' , '7' , '0' , '0' , '14.0000' ) 18/12/2023 12:55:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20689' AND id_supplier = '174' 18/12/2023 12:55:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20689' , '174' , '1' ) 18/12/2023 12: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 ( '89555' , '20696' , 'NOSTRE NOZZE ' , '3' , '3' , '4' , '3.43' , '3.43' , '0' , '0' , '10.2900' ) 18/12/2023 12:55:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20696' AND id_supplier = '174' 18/12/2023 12:55:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20696' , '174' , '1' ) 18/12/2023 12: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 ( '89555' , '22014' , 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE' , '200' , '200' , '4' , '0.00' , '0' , '0' , '0' , '0.0000' ) 18/12/2023 12:55:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22014' AND id_supplier = '174' 18/12/2023 12:55:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22014' , '174' , '1' ) 18/12/2023 02:29:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002215' AND id_product != '22014' AND ean13 != '' 18/12/2023 02:29:32 pm >> UPDATE ps_product SET id_supplier = '174', reference = '', ean13 = '002215', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:29:32 pm >> UPDATE ps_product_lang SET name = 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE', description = '' WHERE id_product = '22014' 18/12/2023 02:29:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.35' WHERE id_product = '22014' 18/12/2023 02:29:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.35', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:29:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22014' 18/12/2023 02:30:01 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '3161', document_date = '2023-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4678466', address1 = 'VIA ADRIANA 18 84012 ANGRI', 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 = '69.29', price_tax_excluded = '69.29', date_upd = NOW() WHERE id_document = '89555' 18/12/2023 02:30: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 = '89555' 18/12/2023 02:30:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89555' 18/12/2023 02:30: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 ( '89555' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '2' , '2' , '4' , '7.0000' , '7' , '0' , '0' , '14.00' ) 18/12/2023 02:30: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 ( '89555' , '20696' , 'NOSTRE NOZZE ' , '3' , '3' , '4' , '3.4300' , '3.43' , '0' , '0' , '10.29' ) 18/12/2023 02:30: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 ( '89555' , '22014' , 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE' , '20' , '20' , '4' , '2.25' , '2.25' , '0' , '0' , '45.0000' ) 18/12/2023 02:31:49 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' , '00000' , '2023-12-18' , '' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '3' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '241.48' , '241.48' , NOW() , NOW() ) 18/12/2023 02:31:49 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 = '89556' 18/12/2023 02:31:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89556' 18/12/2023 02:31:49 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 ( '89556' , '20687' , 'NON HO CHE LOGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI' , '3' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '33.60' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20687' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20687' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20688' , 'LEONIA MARTIN - D. MENVIELLE' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '100' , '0.00' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20688' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20688' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20689' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20689' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20691' , 'LUIGI E ZELIA MARTIN - J. CLAPIER' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20691' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20691' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20692' , 'COME ACCOMPAGNARE I FIDANZATI - S. LONGOBARDI' , '2' , '0' , '4' , '19.0000' , '19' , '0' , '30' , '26.60' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20692' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20692' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20695' , 'VENITE ALLE NOZZE - S. LONGOBARDI' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20695' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20695' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20690' , 'CARLO ACUTIS APOSTOLO DEI MILLENNIALS - V. RIZZO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20690' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20690' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20697' , 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '14.00' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20697' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20697' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20700' , 'AMORE, SESSO E VERGINITA - C. GALATOLO' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20700' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20700' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20693' , 'TROVA LA PERLA PREZIOSA - G. ABBAGNARA' , '2' , '0' , '4' , '7.0000' , '7' , '0' , '30' , '9.80' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20693' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20693' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20699' , 'VOI SIETE LADESSO DI DIO - IPPOLITO/ABBAGNARA' , '2' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '21.00' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20699' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20699' , '174' , '1' ) 18/12/2023 02:31:49 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 ( '89556' , '20696' , 'NOSTRE NOZZE ' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 18/12/2023 02:31:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20696' AND id_supplier = '174' 18/12/2023 02:31:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20696' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20694' , 'COSTRUIRE LA CASA SULLA ROCCIA - K. WOJTYLA' , '2' , '0' , '4' , '7.0000' , '7' , '0' , '30' , '9.80' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20694' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20694' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20701' , 'CI SPOSIAMO COMPRENDERE LA POTENZA' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '30' , '6.30' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20701' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20701' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20698' , 'DIARIO DI BORDO - S. LONGOBARDI' , '1' , '0' , '4' , '5.9000' , '5.9' , '0' , '30' , '4.13' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20698' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20698' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20702' , 'CHI CERCATE - CALENDARIO QUARESIMA' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20702' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20702' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '2' , '0' , '4' , '7.0000' , '7' , '0' , '0' , '14.00' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20689' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20689' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '20696' , 'NOSTRE NOZZE ' , '3' , '0' , '4' , '3.4300' , '3.43' , '0' , '0' , '10.29' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20696' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20696' , '174' , '1' ) 18/12/2023 02:31: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 ( '89556' , '22014' , 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE' , '20' , '0' , '4' , '2.2500' , '2.25' , '0' , '0' , '45.00' ) 18/12/2023 02:31:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22014' AND id_supplier = '174' 18/12/2023 02:31:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22014' , '174' , '1' ) 18/12/2023 02:33:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002215' AND id_product != '22014' AND ean13 != '' 18/12/2023 02:33:18 pm >> UPDATE ps_product SET id_supplier = '174', reference = '', ean13 = '002215', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:33:18 pm >> UPDATE ps_product_lang SET name = 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE', description = '' WHERE id_product = '22014' 18/12/2023 02:33:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '22014' 18/12/2023 02:33:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:33:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '22014' 18/12/2023 02:36:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002215' AND id_product != '22014' AND ean13 != '' 18/12/2023 02:36:54 pm >> UPDATE ps_product SET id_supplier = '174', reference = '', ean13 = '002215', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:36:54 pm >> UPDATE ps_product_lang SET name = 'FESTA DELLA SANTA FAMIGLIA - PIEGHEVOLE 10 pz', description = '' WHERE id_product = '22014' 18/12/2023 02:36:54 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5000' WHERE id_product = '22014' 18/12/2023 02:36:54 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5000', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22014' 18/12/2023 02:36:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '22014' 18/12/2023 02:46:01 pm >> DELETE FROM ps_document WHERE id_document = '89079' 18/12/2023 02:46:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89079' 18/12/2023 02:47:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3927' AND id_document != '89413' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-09') 18/12/2023 02:47:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3927', document_date = '2023-12-09', 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 = '21.00', price_tax_excluded = '17.21', date_upd = NOW() WHERE id_document = '89413' 18/12/2023 02:47:12 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 = '89413' 18/12/2023 02:47:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89413' 18/12/2023 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89413' , '4381' , 'GESÙ BAMBINO - CM 15 DORATO' , '1' , '-1' , '1' , '10.5' , '8.6065573770492' , '22' , '0' , '10.50' ) 18/12/2023 02:47:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89413' , '20001' , 'GESU BAMBINO CM 15 - BJ143-15' , '1' , '-1' , '1' , '10.5' , '8.6065573770492' , '22' , '0' , '10.50' ) 18/12/2023 02:47:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3843' AND id_document != '89291' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-02') 18/12/2023 02:47:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3843', document_date = '2023-12-02', 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 = '36.00', price_tax_excluded = '29.51', date_upd = NOW() WHERE id_document = '89291' 18/12/2023 02:47: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 = '89291' 18/12/2023 02:47:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89291' 18/12/2023 02:47: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 ( '89291' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '1' , '-1' , '1' , '11.9' , '9.7540983606557' , '22' , '0' , '11.90' ) 18/12/2023 02:47: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 ( '89291' , '21689' , 'ANGELO PIEGHEVOLE CM 12' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2023 02:47: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 ( '89291' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '3' , '-3' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '14.10' ) 18/12/2023 02:48:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2866' AND id_document != '87354' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-20') 18/12/2023 02:48:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2866', document_date = '2023-09-20', 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 = '39.00', price_tax_excluded = '31.97', date_upd = NOW() WHERE id_document = '87354' 18/12/2023 02:48: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 = '87354' 18/12/2023 02:48:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '87354' 18/12/2023 02:48:21 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 ( '87354' , '21179' , 'ORECCHINI ARGENTO/CRISTALLO - 5447' , '1' , '-1' , '1' , '21.0000' , '17.213114754098' , '22' , '0' , '21.00' ) 18/12/2023 02:48:21 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 ( '87354' , '19601' , 'ANGELO ALI TORTORA - 4231' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:48:21 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 ( '87354' , '21559' , 'SAN GIUSEPPE DORMIENTE CM 14 - 4043' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:48:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '87532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 18/12/2023 02:48:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2996', document_date = '2023-10-03', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '87532' 18/12/2023 02:48: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 = '87532' 18/12/2023 02:48:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '87532' 18/12/2023 02:48: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 ( '87532' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 18/12/2023 02:48: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 ( '87532' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 18/12/2023 02:48: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 ( '87532' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 18/12/2023 02:48: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 ( '87532' , '15589' , 'ANGELO CON STELLA ARG. - 4215' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 18/12/2023 02:49:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3961' AND id_document != '89456' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-13') 18/12/2023 02:49:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3961', document_date = '2023-12-13', 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 = '12.00', price_tax_excluded = '9.84', date_upd = NOW() WHERE id_document = '89456' 18/12/2023 02:49:16 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 = '89456' 18/12/2023 02:49:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '89456' 18/12/2023 02:49:16 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 ( '89456' , '9948' , 'SFERA DIAMETRO MM 100' , '1' , '-1' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '6.50' ) 18/12/2023 02:49:16 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 ( '89456' , '20520' , 'QUADRETTO ANGELO DI DIO - 5024-AD' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 18/12/2023 02:51:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2902' AND id_document != '87401' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-23') 18/12/2023 02:51:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2902', document_date = '2023-09-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 = '63.00', price_tax_excluded = '51.64', date_upd = NOW() WHERE id_document = '87401' 18/12/2023 02:51: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 = '87401' 18/12/2023 02:51:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87401' 18/12/2023 02:51: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 ( '87401' , '5976' , 'LUCERNA VETRO - 1493' , '1' , '-1' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 18/12/2023 02:51: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 ( '87401' , '20122' , 'FATIMA CM 21 - 1033' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 18/12/2023 02:51: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 ( '87401' , '20120' , 'FATIMA CM 27 -1025' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 18/12/2023 02:51: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 ( '87401' , '4954' , 'MIRACOLOSA BABY - 023 MIR/9BB' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 18/12/2023 02:53:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3123' AND id_document != '88231' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-11') 18/12/2023 02:53:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3123', document_date = '2023-10-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.00', price_tax_excluded = '82.31', date_upd = NOW() WHERE id_document = '88231' 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88231' 18/12/2023 02:53:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '88231' 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '-1' , '1' , '49.1000' , '40.245901639344' , '22' , '0' , '49.10' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '4400' , 'GESÙ CONFIDO BABY - 023 JC/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '13114' , 'MADONNA DEL CARMELO BABY - 023 CAR 9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '9464' , 'S. GIUSEPPE BABY - SJ/9BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 18/12/2023 02:53:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88231' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 18/12/2023 02:55:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '3891' AND id_document != '89366' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-06') 18/12/2023 02:55:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3891', document_date = '2023-12-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '33.50', price_tax_excluded = '27.46', date_upd = NOW() WHERE id_document = '89366' 18/12/2023 02:55:12 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 = '89366' 18/12/2023 02:55:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89366' 18/12/2023 02:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89366' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '17.80' ) 18/12/2023 02:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89366' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 18/12/2023 02:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89366' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '1' , '-1' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '3.30' ) 18/12/2023 02:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89366' , '18223' , 'CORONA MISSIONARIA - R102' , '2' , '-2' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '1.80' ) 18/12/2023 02:55:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89366' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '0.8' , '0.65573770491803' , '22' , '0' , '0.80' ) 18/12/2023 02:55:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '89116' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 18/12/2023 02:55:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3709', document_date = '2023-11-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 = '29.00', price_tax_excluded = '23.77', date_upd = NOW() WHERE id_document = '89116' 18/12/2023 02: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 = '89116' 18/12/2023 02:55:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '89116' 18/12/2023 02: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 ( '89116' , '18223' , 'CORONA MISSIONARIA - R102' , '29' , '-29' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '29.00' ) 18/12/2023 02:57:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3921' AND id_document != '89407' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-09') 18/12/2023 02:57:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3921', document_date = '2023-12-09', 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 = '58.60', price_tax_excluded = '48.03', date_upd = NOW() WHERE id_document = '89407' 18/12/2023 02:57:00 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 = '89407' 18/12/2023 02:57:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89407' 18/12/2023 02:57:00 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 ( '89407' , '5536' , 'LACCIO' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 18/12/2023 02:57:00 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 ( '89407' , '20523' , 'CROCE - 094 ALV' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 18/12/2023 02:57:00 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 ( '89407' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '2' , '-2' , '1' , '10' , '8.1967213114754' , '22' , '0' , '20.00' ) 18/12/2023 02:57:00 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 ( '89407' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '5' , '-5' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '30.00' ) 18/12/2023 02:58:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '3457' AND id_document != '88729' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 18/12/2023 02:58:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3457', document_date = '2023-11-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 = '120.95', price_tax_excluded = '103.76', date_upd = NOW() WHERE id_document = '88729' 18/12/2023 02:58: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 = '88729' 18/12/2023 02:58:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '88729' 18/12/2023 02:58: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 ( '88729' , '19607' , 'CLERGY F/F ML - C03' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 18/12/2023 02:58: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 ( '88729' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35.5000' , '29.098360655738' , '22' , '0' , '35.50' ) 18/12/2023 02:58: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 ( '88729' , '21173' , 'CARLO ACUTIS E IL SUO AMICO GESU - C. GALATOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 18/12/2023 02:58: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 ( '88729' , '3977' , 'EUCARISTIA: LA MIA AUTOSTRADA...' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 18/12/2023 02:58: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 ( '88729' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 18/12/2023 02:58: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 ( '88729' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '8.00' ) 18/12/2023 02:58: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 ( '88729' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 18/12/2023 02:58: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 ( '88729' , '18223' , 'CORONA MISSIONARIA - R102' , '1' , '-1' , '1' , '0.9' , '0.73770491803279' , '22' , '0' , '0.90' ) 18/12/2023 02:58:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3931' AND id_document != '89418' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-11') 18/12/2023 02:58:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3931', document_date = '2023-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '89418' 18/12/2023 02:59:00 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 = '89418' 18/12/2023 02:59:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89418' 18/12/2023 02:59:00 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 ( '89418' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '30.00' ) 18/12/2023 02:59:00 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 ( '89418' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/12/2023 02:59:00 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 ( '89418' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 18/12/2023 02:59:00 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 ( '89418' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2023 02:59:00 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 ( '89418' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/12/2023 02:59:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3780' AND id_document != '89205' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-28') 18/12/2023 02:59:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3780', document_date = '2023-11-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 = '110.00', price_tax_excluded = '93.85', date_upd = NOW() WHERE id_document = '89205' 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89205' 18/12/2023 02:59:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '89205' 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '3' , '-3' , '1' , '2.9000' , '2.3770491803279' , '22' , '0' , '8.70' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '14145' , 'CREDO SPIEGATO AI RAGAZZI' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '5' , '7.14' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '20072' , 'BRACCIALE - BC1759N' , '5' , '-5' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '10.00' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '18223' , 'CORONA MISSIONARIA - R102' , '25' , '-25' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '25.00' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '5' , '13.30' ) 18/12/2023 02:59:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89205' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '1' , '35.86' , '29.393442622951' , '22' , '0' , '35.86' ) 18/12/2023 03:01:11 pm >> DELETE FROM ps_document WHERE id_document = '89080' 18/12/2023 03:01:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89080' 18/12/2023 03:07:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '51' AND id_document != '89370' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 18/12/2023 03:07:28 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '51', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca prof. Giuseppe Lazzaro in Santa Maria ad Martyres\r\nv. Adriano Falvo - 84127 Salerno\r\n', 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 = '2596.00', price_tax_excluded = '2596.00', date_upd = NOW() WHERE id_document = '89370' 18/12/2023 03:07: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 = '89370' 18/12/2023 03:07:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '89370' 18/12/2023 03:07: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 ( '89370' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/12/2023 03:07: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 ( '89370' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 18/12/2023 03:07: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 ( '89370' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 18/12/2023 03:07: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 ( '89370' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07: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 ( '89370' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 03:07: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 ( '89370' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07: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 ( '89370' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07: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 ( '89370' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07: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 ( '89370' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 18/12/2023 03:07: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 ( '89370' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07: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 ( '89370' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/12/2023 03:07: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 ( '89370' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/12/2023 03:07: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 ( '89370' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/12/2023 03:07: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 ( '89370' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 18/12/2023 03:07: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 ( '89370' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/12/2023 03:07: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 ( '89370' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 18/12/2023 03:07: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 ( '89370' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 18/12/2023 03:07: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 ( '89370' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07: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 ( '89370' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07: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 ( '89370' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07: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 ( '89370' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07: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 ( '89370' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07: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 ( '89370' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 03:07: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 ( '89370' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 03:07: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 ( '89370' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 18/12/2023 03:07:30 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 ( '89370' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07:30 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 ( '89370' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 18/12/2023 03:07:30 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 ( '89370' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 18/12/2023 03:07:30 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 ( '89370' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 18/12/2023 03:07:30 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 ( '89370' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 18/12/2023 03:07:30 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 ( '89370' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 18/12/2023 03:07:30 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 ( '89370' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 18/12/2023 03:07:30 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 ( '89370' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 18/12/2023 03:07:30 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 ( '89370' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 18/12/2023 03:07:30 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 ( '89370' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 18/12/2023 03:07:30 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 ( '89370' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 18/12/2023 03:07:30 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 ( '89370' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 18/12/2023 03:07:30 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 ( '89370' , '8562' , 'PROMESSE DEL SACRO CUORE DI GESÙ' , '1' , '-1' , '4' , '6.5000' , '6.5' , '0' , '0' , '6.50' ) 18/12/2023 03:07:30 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 ( '89370' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '10060' , 'SOLO I MALATI GUARISCONO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '4001' , 'EVANGELO DI PAOLO - A. PITTA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:07:30 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 ( '89370' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 18/12/2023 03:07:30 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 ( '89370' , '22004' , 'PREGHIERA DEL CRISTIANO - C.M. MARTINI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07:30 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 ( '89370' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07:30 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 ( '89370' , '21116' , 'LIBERTA\' DI ANTONIO - L. EPICOCO' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 18/12/2023 03:07:30 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 ( '89370' , '17001' , 'SPERANZA NON E\' MORTA - L. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07:30 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 ( '89370' , '18261' , 'PIETRA SCARTATA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 18/12/2023 03:07:30 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 ( '89370' , '21466' , 'UNA LUCE DI NOME CHIARA - B. BAFFETTI' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 18/12/2023 03:07:30 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 ( '89370' , '15723' , 'TUTTI INSIEME SULLARCA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 18/12/2023 03:07:30 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 ( '89370' , '19513' , 'CARLO ACUTIS -DALLA PISTA .... - M. MUSOLINO' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '0' , '12.90' ) 18/12/2023 03:07: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 ( '89370' , '14728' , 'LIBRO DELLA GIUNGLA - R. KIPLING' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 18/12/2023 03:07: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 ( '89370' , '14830' , 'PICCOLA RENNA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 18/12/2023 03:07: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 ( '89370' , '16442' , 'CARLO ACUTIS L\'AMICO DI GESU\' - 8865' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 18/12/2023 03:07: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 ( '89370' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1609.2' , '1609.2' , '0' , '0' , '1609.20' ) 18/12/2023 03:10:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3975' AND id_document != '89475' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 18/12/2023 03:10:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3975', document_date = '2023-12-14', 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 = '80.00', price_tax_excluded = '65.57', date_upd = NOW() WHERE id_document = '89475' 18/12/2023 03:10: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 = '89475' 18/12/2023 03:10:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89475' 18/12/2023 03:10: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 ( '89475' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 18/12/2023 03:10: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 ( '89475' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 18/12/2023 03:12:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3757' AND id_document != '89175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-27') 18/12/2023 03:12:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3757', document_date = '2023-11-27', 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 = '187.00', price_tax_excluded = '156.89', date_upd = NOW() WHERE id_document = '89175' 18/12/2023 03:12:21 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 = '89175' 18/12/2023 03:12:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89175' 18/12/2023 03:12:21 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 ( '89175' , '21463' , 'CALENDARIO DELLAVVENTO 2023' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 18/12/2023 03:12:21 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 ( '89175' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 18/12/2023 03:12:21 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 ( '89175' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 18/12/2023 03:12:21 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 ( '89175' , '12663' , 'CAMICE BIANCO - MISTO COT. 160' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 18/12/2023 03:12:21 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 ( '89175' , '12660' , 'CAMICE BIANCO - MISTO COT. 145' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 18/12/2023 03:12:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89175' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 18/12/2023 03:13:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '88774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 18/12/2023 03:13:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3484', document_date = '2023-11-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '302.00', price_tax_excluded = '260.96', date_upd = NOW() WHERE id_document = '88774' 18/12/2023 03:13:06 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 = '88774' 18/12/2023 03:13:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88774' 18/12/2023 03:13:06 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 ( '88774' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '9.8' , '9.8' , '0' , '0' , '9.80' ) 18/12/2023 03:13:06 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 ( '88774' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 18/12/2023 03:13:06 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 ( '88774' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 18/12/2023 03:13:06 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 ( '88774' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 18/12/2023 03:13:06 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 ( '88774' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 18/12/2023 03:13:06 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 ( '88774' , '21439' , 'NATUZZA EVOLO COME BIBBIA - R.I. ZANINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 18/12/2023 03:13:06 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 ( '88774' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 18/12/2023 03:50:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '54' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 03:50: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 ( '24' , '54' , '2023-12-18' , '' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '224.00' , '183.61' , NOW() , NOW() ) 18/12/2023 03:50: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 = '89557' 18/12/2023 03:50:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89557' 18/12/2023 03:50: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 ( '89557' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 18/12/2023 03:50: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 ( '89557' , '21859' , 'NATIVITA - ST333-NT' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 18/12/2023 03:50: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 ( '89557' , '6915' , 'NATIVITÀ DECORO LEGNO C/LUCE CM 15,5' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 18/12/2023 03:50: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 ( '89557' , '16331' , 'GRUPPO NATIVITA PORCELLANA CM 14' , '12' , '-12' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '60.00' ) 18/12/2023 03:50: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 ( '89557' , '16329' , 'GRUPPO NATIVITA CM 11' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 18/12/2023 03:50: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 ( '89557' , '8449' , 'PRESEPE IN RESINA DIPINTO A MANO 8X12 - P359' , '5' , '-5' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '35.00' ) 18/12/2023 03:54:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 03:54:15 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' , '4043' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.50' , '17.62' , NOW() , NOW() ) 18/12/2023 03:54:15 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 = '89558' 18/12/2023 03:54:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89558' 18/12/2023 03:54:15 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 ( '89558' , '5975' , 'LUCERNA COLORATA - 1491' , '1' , '-1' , '1' , '21.50' , '17.622950819672' , '22' , '0' , '21.50' ) 18/12/2023 03:58:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 03:58: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' , '4044' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 18/12/2023 03:58: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 = '89559' 18/12/2023 03:58:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89559' 18/12/2023 03:58: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 ( '89559' , '17734' , 'VANGELO E ATTI BAMBINI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 18/12/2023 04:04:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 04:04:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4045' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 18/12/2023 04:04: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 = '89560' 18/12/2023 04:04:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89560' 18/12/2023 04:04: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 ( '89560' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 18/12/2023 04:27:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 04:27:15 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' , '4046' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 18/12/2023 04:27:15 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 = '89561' 18/12/2023 04:27:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89561' 18/12/2023 04:27:15 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 ( '89561' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 18/12/2023 04:28:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4046' AND id_document != '89561' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 04:28:39 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4046', document_date = '2023-12-18', 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 = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '89561' 18/12/2023 04:28:39 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 = '89561' 18/12/2023 04:28:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89561' 18/12/2023 04:28:39 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 ( '89561' , '17841' , 'QUADRO DECORATO 42X32' , '5' , '-5' , '1' , '50' , '40.983606557377' , '22' , '0' , '250.00' ) 18/12/2023 04:41:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '55' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 04:41: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 ( '24' , '55' , '2023-12-18' , '' , '0' , '180' , '4679124' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , 'reso' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '9' , '1100.00' , '1100.00' , NOW() , NOW() ) 18/12/2023 04:41: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 = '89562' 18/12/2023 04:41:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '89562' 18/12/2023 04:41:56 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 ( '89562' , '21675' , 'ITALIANI IN GUERRA - UTET' , '1' , '-1' , '4' , '800.00' , '800' , '0' , '0' , '800.00' ) 18/12/2023 04:41:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21675' AND id_supplier = '180' 18/12/2023 04:41:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21675' , '180' , '1' ) 18/12/2023 04:41:56 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 ( '89562' , '21676' , 'CRISTIANESIMO 5 VOL. - UTET' , '1' , '-1' , '4' , '300.00' , '300' , '0' , '0' , '300.00' ) 18/12/2023 04:41:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21676' AND id_supplier = '180' 18/12/2023 04:41:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21676' , '180' , '1' ) 18/12/2023 05:31:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3931' AND id_document != '89418' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-11') 18/12/2023 05:31:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3931', document_date = '2023-12-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '61.48', date_upd = NOW() WHERE id_document = '89418' 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89418' 18/12/2023 05:31:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89418' 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89418' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '30.00' ) 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89418' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89418' , '18135' , 'CROCE SAN BENEDETTO PICCOLA - CSB4' , '2' , '-2' , '1' , '2.25' , '1.844262295082' , '22' , '0' , '4.50' ) 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89418' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2023 05:31:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89418' , '1351' , 'BRACCIALETTO CON TAU - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 18/12/2023 05:33:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2926' AND id_document != '87431' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 18/12/2023 05:33:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2926', document_date = '2023-09-27', 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 = '15.20', price_tax_excluded = '15.20', date_upd = NOW() WHERE id_document = '87431' 18/12/2023 05:33:57 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 = '87431' 18/12/2023 05:33:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '87431' 18/12/2023 05:33: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 ( '87431' , '21415' , 'MESSA MEDITAZIONE - NOV/DIC 2023' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 18/12/2023 05:33: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 ( '87431' , '21485' , 'MIO GRANDE LIBRO DA COLORARE' , '1' , '-1' , '4' , '7.6' , '7.6' , '0' , '0' , '7.60' ) 18/12/2023 05:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3485' AND id_document != '88775' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 18/12/2023 05:34:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3485', document_date = '2023-11-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '80.20', price_tax_excluded = '80.20', date_upd = NOW() WHERE id_document = '88775' 18/12/2023 05:34:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88775' 18/12/2023 05:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '88775' 18/12/2023 05:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88775' , '21818' , 'GIOCHIAMO CON IL PRESEPE' , '1' , '-1' , '4' , '4.1' , '4.1' , '0' , '0' , '4.10' ) 18/12/2023 05:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88775' , '11644' , 'PICCOLA GUIDA ALLA CONFESSIONE' , '20' , '-20' , '4' , '1.9000' , '1.9' , '0' , '5' , '36.20' ) 18/12/2023 05:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88775' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '7' , '-7' , '4' , '6.0000' , '6' , '0' , '5' , '39.90' ) 18/12/2023 05:35:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3452' AND id_document != '88723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 18/12/2023 05:35:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3452', document_date = '2023-11-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 = '48.81', price_tax_excluded = '48.54', date_upd = NOW() WHERE id_document = '88723' 18/12/2023 05:35:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88723' 18/12/2023 05:35:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '88723' 18/12/2023 05:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88723' , '21661' , 'MIO NATALE DA SCOPRIRE' , '1' , '-1' , '4' , '14.25' , '14.25' , '0' , '0' , '14.25' ) 18/12/2023 05:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88723' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 18/12/2023 05:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88723' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '5' , '11.88' ) 18/12/2023 05:35:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88723' , '17523' , 'OSTIA PER CELIACI 25 PZ' , '1' , '-1' , '3' , '7.0000' , '6.7307692307692' , '4' , '0' , '7.00' ) 18/12/2023 05:37:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '3800' AND id_document != '89230' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 18/12/2023 05:37:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3800', document_date = '2023-11-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 = '34.00', price_tax_excluded = '30.75', date_upd = NOW() WHERE id_document = '89230' 18/12/2023 05:37:30 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 = '89230' 18/12/2023 05:37:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '89230' 18/12/2023 05:37:30 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 ( '89230' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '18.00' ) 18/12/2023 05:37:30 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 ( '89230' , '18732' , 'CREA IL TUO POPUP CON BABBO NATALE' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 18/12/2023 05:37:30 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 ( '89230' , '18733' , 'CREA IL TUO POPUP CON LA STORIA DI NATALE' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 18/12/2023 05:40:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '3822' AND id_document != '89262' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-01') 18/12/2023 05:40:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3822', document_date = '2023-12-01', 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 = '35.00', price_tax_excluded = '35.00', date_upd = NOW() WHERE id_document = '89262' 18/12/2023 05:40:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89262' 18/12/2023 05:40:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89262' 18/12/2023 05:40:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89262' , '21877' , 'CALENDARIO DAVVENTO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 18/12/2023 05:40:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89262' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.90' , '10.9' , '0' , '5' , '10.36' ) 18/12/2023 05:40:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89262' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/12/2023 05:40:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89262' , '18783' , 'MIA BIBBIA PREFERITA ' , '1' , '-1' , '4' , '10.48' , '10.48' , '0' , '0' , '10.48' ) 18/12/2023 05:41:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3819' AND id_document != '89259' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-01') 18/12/2023 05:41:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3819', document_date = '2023-12-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '41.00', price_tax_excluded = '37.21', date_upd = NOW() WHERE id_document = '89259' 18/12/2023 05:41: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 = '89259' 18/12/2023 05:41:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89259' 18/12/2023 05:41: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 ( '89259' , '20002' , 'GESU\' BAMBINO DORATO CM 20 - BJ146-20D' , '1' , '-1' , '1' , '21.0000' , '17.213114754098' , '22' , '0' , '21.00' ) 18/12/2023 05:41: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 ( '89259' , '17511' , 'BIBBIA DEI RAGAZZI' , '1' , '-1' , '4' , '20' , '20' , '0' , '0' , '20.00' ) 18/12/2023 06:00:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 06:00:04 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' , '4047' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.70' , '2.21' , NOW() , NOW() ) 18/12/2023 06:00:04 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 = '89563' 18/12/2023 06:00:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89563' 18/12/2023 06:00:04 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 ( '89563' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '2' , '-2' , '1' , '1.35' , '1.1065573770492' , '22' , '0' , '2.70' ) 18/12/2023 06:28:18 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'KlxizzScv3ygL9cf' , NOW() , NOW() ) 18/12/2023 06:28:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4075' , '1' ) 18/12/2023 06:28:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4075' , '2' ) 18/12/2023 06:28:18 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4075' , '3' ) 18/12/2023 06:34:39 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4075' 18/12/2023 06:34:39 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4075' , '10' , '138' , '' , 'RITSCH' , 'LUIGIA' , 'VIA PARROCO PALI' , '' , '39020' , 'SLUDERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 18/12/2023 06:34:39 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4075' 18/12/2023 06:35:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '320' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 06:35:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '320' , '2023-12-18' , '' , '4075' , '0' , '4679230' , 'VIA PARROCO PALI 39020 SLUDERNO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '17.40' , '17.40' , NOW() , NOW() ) 18/12/2023 06:35:25 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 = '89564' 18/12/2023 06:35:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '89564' 18/12/2023 06:35:25 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 ( '89564' , '1872' , 'CELEBRARE LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 18/12/2023 06:35:25 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 ( '89564' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 18/12/2023 06:39:04 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4075' 18/12/2023 06:39:04 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4075' , '10' , '138' , '' , 'RITSCH' , 'LUIGIA' , 'VIA PARROCO PALI' , '' , '39020' , 'SLUDERNO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 18/12/2023 06:39:04 pm >> UPDATE ps_customer SET email = 'luigia.ritsch60@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4075' 18/12/2023 06:42:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 06:42:15 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' , '4048' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.90' , '24.51' , NOW() , NOW() ) 18/12/2023 06:42:15 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 = '89565' 18/12/2023 06:42:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89565' 18/12/2023 06:42:15 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 ( '89565' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '29.90' ) 18/12/2023 06:54:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '54' AND id_document != '89557' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 06:54:33 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '54', document_date = '2023-12-18', document_letter = '', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '89557' 18/12/2023 06:54: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 = '89557' 18/12/2023 06:54:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '89557' 18/12/2023 06:54: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 ( '89557' , '15020' , 'PREGARE OGNI GIORNO' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 18/12/2023 06:55:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3973' AND id_document != '89472' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 18/12/2023 06:55:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3973', document_date = '2023-12-14', 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 = '95.00', price_tax_excluded = '80.57', date_upd = NOW() WHERE id_document = '89472' 18/12/2023 06:55:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89472' 18/12/2023 06:55:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89472' 18/12/2023 06:55:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89472' , '11328' , 'VIA DELLA FIDUCIA E DELLAMORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '' , '15.00' ) 18/12/2023 06:55:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89472' , '21561' , 'QUADRO PIASTRELLA 20X20 - 2189' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 18/12/2023 06:55:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89472' , '21859' , 'NATIVITA - ST333-NT' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 18/12/2023 06:57:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3757' AND id_document != '89175' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-27') 18/12/2023 06:57:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3757', document_date = '2023-11-27', 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 = '187.00', price_tax_excluded = '156.89', date_upd = NOW() WHERE id_document = '89175' 18/12/2023 06:57:04 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 = '89175' 18/12/2023 06:57:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89175' 18/12/2023 06:57:04 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 ( '89175' , '21463' , 'CALENDARIO DELLAVVENTO 2023' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '5' , '9.50' ) 18/12/2023 06:57:04 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 ( '89175' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 18/12/2023 06:57:04 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 ( '89175' , '21571' , 'BETLEHEM' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 18/12/2023 06:57:04 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 ( '89175' , '12663' , 'CAMICE BIANCO - MISTO COT. 160' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 18/12/2023 06:57:04 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 ( '89175' , '12660' , 'CAMICE BIANCO - MISTO COT. 145' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 18/12/2023 06:57:04 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 ( '89175' , '6915' , 'NATIVITÀ DECORO LEGNO C/LUCE CM 15,5' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 18/12/2023 06:57:04 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 ( '89175' , '16329' , 'GRUPPO NATIVITA CM 11' , '2' , '-2' , '1' , '4.95' , '4.0573770491803' , '22' , '0' , '9.90' ) 18/12/2023 06:58:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '88774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 18/12/2023 06:58:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3484', document_date = '2023-11-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '302.00', price_tax_excluded = '260.96', date_upd = NOW() WHERE id_document = '88774' 18/12/2023 06:58: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 = '88774' 18/12/2023 06:58:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88774' 18/12/2023 06:58: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 ( '88774' , '16393' , 'GIOCA ANCORA CON GESU ' , '1' , '-1' , '4' , '9.8000' , '9.8' , '0' , '0' , '9.80' ) 18/12/2023 06:58: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 ( '88774' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 18/12/2023 06:58: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 ( '88774' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 18/12/2023 06:58: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 ( '88774' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 18/12/2023 06:58: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 ( '88774' , '21439' , 'NATUZZA EVOLO COME BIBBIA - R.I. ZANINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 18/12/2023 06:58: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 ( '88774' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 18/12/2023 06:58: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 ( '88774' , '8449' , 'PRESEPE IN RESINA DIPINTO A MANO 8X12 - P359' , '5' , '-5' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '35.00' ) 18/12/2023 06:58:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3580' AND id_document != '88918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-13') 18/12/2023 06:58:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3580', document_date = '2023-11-13', 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 = '172.65', price_tax_excluded = '145.89', date_upd = NOW() WHERE id_document = '88918' 18/12/2023 06:58: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 = '88918' 18/12/2023 06:58:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '88918' 18/12/2023 06:58: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 ( '88918' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 18/12/2023 06:58: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 ( '88918' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2.95' , '2.4180327868852' , '22' , '0' , '5.90' ) 18/12/2023 06:58: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 ( '88918' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 18/12/2023 06:58: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 ( '88918' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 18/12/2023 06:58: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 ( '88918' , '16243' , 'QUADRO 10X10' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 18/12/2023 06:58: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 ( '88918' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 18/12/2023 06:58: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 ( '88918' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 18/12/2023 06:58: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 ( '88918' , '16331' , 'GRUPPO NATIVITA PORCELLANA CM 14' , '12' , '-12' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '60.00' ) 18/12/2023 07:19:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '4049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 07:19:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4049' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.30' , '33.98' , NOW() , NOW() ) 18/12/2023 07:19: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 = '89566' 18/12/2023 07:19:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '89566' 18/12/2023 07:19: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 ( '89566' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 18/12/2023 07:19: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 ( '89566' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 18/12/2023 07:19: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 ( '89566' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 18/12/2023 07:19: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 ( '89566' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 18/12/2023 07:26:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '4050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 07:26: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' , '4050' , '2023-12-18' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '6.90' , NOW() , NOW() ) 18/12/2023 07:26: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 = '89567' 18/12/2023 07:26:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '89567' 18/12/2023 07:26: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 ( '89567' , '21515' , 'CINQUE PANI DORZO 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '' , '6.90' ) 18/12/2023 07:29:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '4048' AND id_document != '89565' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-18') 18/12/2023 07:29:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4048', document_date = '2023-12-18', 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 = '29.90', price_tax_excluded = '24.51', date_upd = NOW() WHERE id_document = '89565' 18/12/2023 07:29: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 = '89565' 18/12/2023 07:29:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '89565' 18/12/2023 07:29: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 ( '89565' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29.9' , '24.508196721311' , '22' , '0' , '29.90' )