17/04/2024 09:12:07 am >> SELECT document_num FROM ps_document WHERE document_num = '52' AND id_document != '89371' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-12-06') 17/04/2024 09:12:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '52', document_date = '2023-12-06', document_letter = '', id_customer = '4068', id_supplier = '', id_address = '4679214', address1 = 'VIA DEI TRIBUNALI 316 80138 NAPOLI', address2 = 'Biblioteca del Convento dei Padri minimi di Santa Maria della Stella\r\nv. Stella 25 - 80137 Napoli \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 = '2500.00', price_tax_excluded = '2500.00', date_upd = NOW() WHERE id_document = '89371' 17/04/2024 09:12: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 = '89371' 17/04/2024 09:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89371' 17/04/2024 09:12: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 ( '89371' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 17/04/2024 09:12: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 ( '89371' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 17/04/2024 09:12: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 ( '89371' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 17/04/2024 09:12: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 ( '89371' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 17/04/2024 09:12: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 ( '89371' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 17/04/2024 09:12: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 ( '89371' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 17/04/2024 09:12: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 ( '89371' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 17/04/2024 09:12: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 ( '89371' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 17/04/2024 09:12: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 ( '89371' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 17/04/2024 09:12: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 ( '89371' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 17/04/2024 09:12: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 ( '89371' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/04/2024 09:12: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 ( '89371' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/04/2024 09:12: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 ( '89371' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/04/2024 09:12: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 ( '89371' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 17/04/2024 09:12: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 ( '89371' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/04/2024 09:12: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 ( '89371' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 17/04/2024 09:12: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 ( '89371' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 17/04/2024 09:12: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 ( '89371' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 17/04/2024 09:12: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 ( '89371' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 17/04/2024 09:12: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 ( '89371' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 17/04/2024 09:12: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 ( '89371' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 17/04/2024 09:12: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 ( '89371' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 17/04/2024 09:12: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 ( '89371' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 17/04/2024 09:12: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 ( '89371' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 17/04/2024 09:12: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 ( '89371' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 17/04/2024 09:12: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 ( '89371' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 17/04/2024 09:12: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 ( '89371' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 17/04/2024 09:12: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 ( '89371' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 17/04/2024 09:12: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 ( '89371' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 17/04/2024 09:12: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 ( '89371' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 17/04/2024 09:12: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 ( '89371' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 17/04/2024 09:12: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 ( '89371' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 17/04/2024 09:12: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 ( '89371' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 17/04/2024 09:12: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 ( '89371' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 17/04/2024 09:12: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 ( '89371' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' , '69.5000' , '69.5' , '0' , '0' , '69.50' ) 17/04/2024 09:12: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 ( '89371' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 17/04/2024 09:12: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 ( '89371' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' , '66.5000' , '66.5' , '0' , '0' , '66.50' ) 17/04/2024 09:12: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 ( '89371' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 17/04/2024 09:12: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 ( '89371' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 17/04/2024 09:12: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 ( '89371' , '3596' , 'DIZIONARIO DI OMILETICA - SODI/TRICCA' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 17/04/2024 09:12: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 ( '89371' , '20985' , 'BIBBIA E LITURGIA - O. VEZZOLI' , '1' , '-1' , '4' , '33.00' , '33' , '0' , '0' , '33.00' ) 17/04/2024 09:12: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 ( '89371' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1358.5' , '1358.5' , '0' , '0' , '1358.50' ) 17/04/2024 09:37:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 09:37:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1179' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 17/04/2024 09:37:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91304' 17/04/2024 09:37:25 am >> DELETE FROM ps_document_detail WHERE id_document = '91304' 17/04/2024 09:37:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91304' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 17/04/2024 09:44:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 09:44: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' , '1180' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '25.96' , NOW() , NOW() ) 17/04/2024 09:44: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 = '91305' 17/04/2024 09:44:02 am >> DELETE FROM ps_document_detail WHERE id_document = '91305' 17/04/2024 09:44: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 ( '91305' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 17/04/2024 09:44: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 ( '91305' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 17/04/2024 10:02:01 am >> SELECT document_num FROM ps_document WHERE document_num = '980' AND id_document != '91037' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-30') 17/04/2024 10:02:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '980', document_date = '2024-03-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91037' 17/04/2024 10:02:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91037' 17/04/2024 10:02:01 am >> DELETE FROM ps_document_detail WHERE id_document = '91037' 17/04/2024 10:02: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 ( '91037' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 17/04/2024 10:21:27 am >> SELECT document_num FROM ps_document WHERE document_num = '1181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 10:21:27 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' , '1181' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '45.00' , NOW() , NOW() ) 17/04/2024 10:21:27 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 = '91306' 17/04/2024 10:21:27 am >> DELETE FROM ps_document_detail WHERE id_document = '91306' 17/04/2024 10:21:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91306' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '15' , '15' , '0' , '0' , '45.00' ) 17/04/2024 10:47:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 10:47:00 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' , '1182' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.46' , '47.95' , NOW() , NOW() ) 17/04/2024 10:47:00 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 = '91307' 17/04/2024 10:47:00 am >> DELETE FROM ps_document_detail WHERE id_document = '91307' 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6138' , 'MAGNETE LAMICIZIA- 792/1' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '8.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6134' , 'MAGNETE GESÙ CONFIDO IN TE - 792/50' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6151' , 'MAGNETE SCOPRI L\'AMORE - 792/7' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6147' , 'MAGNETE PREGHIERA SEMPLICE - 792/6' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6137' , 'MAGNETE IL MEGLIO DI TE - 792/5' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6139' , 'MAGNETE L\'AMORE- 792/4' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6140' , 'MAGNETE O DIO ONNIPOTENTE - 792/35' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6142' , 'MAGNETE PADRE PIO - 792/44' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '6153' , 'MAGNETE VIVI LA VITA - 792/10' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 17/04/2024 10:47:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '22407' , 'CAMMINO DI SANTITA DI DON M. SOLOCKO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 17/04/2024 10:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '22322' , 'PAROLA E PREGHIERA - GIU 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 17/04/2024 10:47:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91307' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 17/04/2024 11:06:23 am >> SELECT document_num FROM ps_document WHERE document_num = '1183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 11:06:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1183' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.00' , '111.55' , NOW() , NOW() ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91308' 17/04/2024 11:06:23 am >> DELETE FROM ps_document_detail WHERE id_document = '91308' 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '11151' , 'LIBRI' , '3' , '-3' , '4' , '15' , '15' , '0' , '0' , '45.00' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '7907' , 'PERGAMENE' , '36' , '-36' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '18.00' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '7907' , 'PERGAMENE' , '50' , '-50' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '25.00' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '5461' , 'IO SONO IL PANE DELLA VITA - 8391' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '22152' , 'A TE RICORRIAMO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '19478' , 'MARIA CANTO DI SPERANZA - FRANCESCO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '21560' , 'ROSARIO LEGNO CORDA CON G. - 3539' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 17/04/2024 11:06:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91308' , '9181' , 'ROSARIO S. BENEDETTO LEGNO - 0341870BR' , '1' , '-1' , '1' , '3.22' , '2.6393442622951' , '22' , '0' , '3.22' ) 17/04/2024 11:19:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 11:19:13 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' , '1184' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 17/04/2024 11:19:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91309' 17/04/2024 11:19:13 am >> DELETE FROM ps_document_detail WHERE id_document = '91309' 17/04/2024 11:19:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91309' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '20.00' ) 17/04/2024 11:35:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 11:35:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1185' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 17/04/2024 11:35:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91310' 17/04/2024 11:35:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91310' 17/04/2024 11:35:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91310' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 17/04/2024 12:28:28 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1231' 17/04/2024 12:28:28 pm >> UPDATE ps_stock_available SET quantity = quantity + '-8' WHERE id_product = '1231' 17/04/2024 12:29:06 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7905' 17/04/2024 12:29:06 pm >> UPDATE ps_stock_available SET quantity = quantity + '-5' WHERE id_product = '7905' 17/04/2024 02:21:33 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '235', document_date = '2022-01-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = '', price_shipping = '5.51', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '108.41', price_tax_excluded = '108.41', date_upd = NOW() WHERE id_document = '50992' 17/04/2024 02:21: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 = '50992' 17/04/2024 02:21:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '50992' 17/04/2024 02:21: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 ( '50992' , '117' , 'A SARA E ALLE ALTRE DONNE - TONINO BELLO' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 17/04/2024 02:21: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 ( '50992' , '19161' , 'CAREZZA DI DIO - TONINO BELLO' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '30' , '5.60' ) 17/04/2024 02:21: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 ( '50992' , '19162' , 'IN CONFIDENZA DI PADRE - TONINO BELLO' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 17/04/2024 02:21: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 ( '50992' , '17280' , 'GESU, PENSACI TU - RUOTOLO' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 17/04/2024 02:21: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 ( '50992' , '17558' , 'IN SINU JESU' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 17/04/2024 02:21: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 ( '50992' , '19163' , 'VITA DI BRUNO CORNACCHIOLA - A.M. TURI' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 17/04/2024 02:21: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 ( '50992' , '19164' , 'SULLE ORME DI DON TONINO BELLO - E. TOLVE' , '1' , '1' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 17/04/2024 02:21: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 ( '50992' , '19165' , 'MESSAGGIO TEOLOGICO DI GUADALUPE - S. ALDAY' , '1' , '1' , '4' , '6.0000' , '6' , '0' , '30' , '4.20' ) 17/04/2024 02:21: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 ( '50992' , '19166' , 'SANTO ANGELO CUSTODE - B. DENTE' , '1' , '1' , '4' , '7.0000' , '7' , '0' , '30' , '4.90' ) 17/04/2024 02:21: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 ( '50992' , '18722' , 'SEGRETO DI MIO FIGLIO - A.S. ACUTIS' , '3' , '3' , '4' , '17.9000' , '17.9' , '0' , '27' , '39.20' ) 17/04/2024 03:42:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '370' AND id_document != '81169' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-02') 17/04/2024 03:42:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '370', document_date = '2023-02-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 = '2.85', price_tax_excluded = '2.85', date_upd = NOW() WHERE id_document = '81169' 17/04/2024 03:42: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 = '81169' 17/04/2024 03:42:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '81169' 17/04/2024 03:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81169' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 17/04/2024 03:42:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81169' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.85' , '0.85' , '0' , '0' , '0.85' ) 17/04/2024 03:47:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1186' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 03:47:02 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' , '1186' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.90' , '40.90' , NOW() , NOW() ) 17/04/2024 03:47:02 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 = '91311' 17/04/2024 03:47:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '91311' 17/04/2024 03:47:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91311' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 17/04/2024 03:47:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91311' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 17/04/2024 03:47:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '1187' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 03:47:21 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' , '1187' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 17/04/2024 03:47: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 = '91312' 17/04/2024 03:47:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '91312' 17/04/2024 03:47: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 ( '91312' , '22131' , 'SAN FRANCESCO DI PAOLA - A. DE LORENZI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 17/04/2024 03:57:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '89794' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-03') 17/04/2024 03:57:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '22', document_date = '2024-01-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', 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 = '131.05', price_tax_excluded = '117.81', date_upd = NOW() WHERE id_document = '89794' 17/04/2024 03:57:03 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 = '89794' 17/04/2024 03:57:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89794' 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '21627' , 'AVVENTO E NATALE 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '18284' , 'SEI NATO ORIGINALE - C. ACUTIS' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '8855' , 'REGISTRO DEL CATECHISTA' , '7' , '-7' , '1' , '0.7500' , '0.61475409836066' , '22' , '0' , '5.25' ) 17/04/2024 03:57:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89794' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '12' , '-12' , '4' , '1.00' , '1' , '0' , '5' , '11.40' ) 17/04/2024 03:58:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '1060' AND id_document != '91145' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-06') 17/04/2024 03:58:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1060', document_date = '2024-04-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 = '12.20', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '91145' 17/04/2024 03:58:08 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 = '91145' 17/04/2024 03:58:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '91145' 17/04/2024 03:58:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91145' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '24' , '-24' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.00' ) 17/04/2024 03:58:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91145' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.2' , '0.16393442622951' , '22' , '0' , '0.20' ) 17/04/2024 04:26:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1188' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 04:26:42 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' , '1188' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 17/04/2024 04:26:42 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 = '91313' 17/04/2024 04:26:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '91313' 17/04/2024 04:26:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91313' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/04/2024 04:28:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1094' AND id_document != '91195' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-10') 17/04/2024 04:28:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1094', document_date = '2024-04-10', 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.00', price_tax_excluded = '12.30', date_upd = NOW() WHERE id_document = '91195' 17/04/2024 04: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 = '91195' 17/04/2024 04:28:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91195' 17/04/2024 04: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 ( '91195' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '21' , '-21' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '14.70' ) 17/04/2024 04: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 ( '91195' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 17/04/2024 04:31:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1103' AND id_document != '91209' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-11') 17/04/2024 04:31:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1103', document_date = '2024-04-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 = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '91209' 17/04/2024 04: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 = '91209' 17/04/2024 04:31:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '91209' 17/04/2024 04: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 ( '91209' , '22337' , 'CROCE IN POLIMERO - 2748' , '21' , '-21' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '52.50' ) 17/04/2024 04: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 ( '91209' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/04/2024 04:32:41 pm >> DELETE FROM ps_document WHERE id_document = '91157' 17/04/2024 04:32:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91157' 17/04/2024 05:26:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '20/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 05:26:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '20/E' , '2024-04-17' , 'E' , '2938' , '0' , '4678844' , 'VIA ARCIVESCOVATO 31 55100 LUCCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '167.80' , '167.80' , NOW() , NOW() ) 17/04/2024 05:26:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91314' 17/04/2024 05:26:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91314' 17/04/2024 05:26:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91314' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '20' , '-20' , '4' , '10.00' , '10' , '0' , '40' , '120.00' ) 17/04/2024 05:26:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91314' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '40' , '10.80' ) 17/04/2024 05:26:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91314' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '3' , '-3' , '4' , '15.00' , '15' , '0' , '40' , '27.00' ) 17/04/2024 05:26:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91314' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 17/04/2024 05:27:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/E' AND id_document != '91063' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-03') 17/04/2024 05:27:35 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '16/E', document_date = '2024-04-03', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '396.00', price_tax_excluded = '324.59', date_upd = NOW() WHERE id_document = '91063' 17/04/2024 05:27: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 = '91063' 17/04/2024 05:27:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '91063' 17/04/2024 05:27: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 ( '91063' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 17/04/2024 05:27: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 ( '91063' , '15293' , 'BENEDIZIONI - RISURREZIONE A' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 17/04/2024 05:27: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 ( '91063' , '1041' , 'BENEDIZIONI - buon pastore' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 17/04/2024 05:49:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1189' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 05:49:16 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' , '1189' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.90' , '4.02' , NOW() , NOW() ) 17/04/2024 05: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 = '91315' 17/04/2024 05:49:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91315' 17/04/2024 05: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 ( '91315' , '20516' , 'CROCE COMUNIONE - 42/08' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 17/04/2024 05: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 ( '91315' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 17/04/2024 06:07:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1190' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 06:07:39 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' , '1190' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.40' , '40.49' , NOW() , NOW() ) 17/04/2024 06:07: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 = '91316' 17/04/2024 06:07:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91316' 17/04/2024 06:07: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 ( '91316' , '13334' , 'CROCE IN ULIVO CON LACCIO' , '20' , '-20' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '24.00' ) 17/04/2024 06:07: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 ( '91316' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 17/04/2024 06:07: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 ( '91316' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 17/04/2024 06:07: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 ( '91316' , '11683' , 'CROCE CON COLOMBA E LACCIO - 0872/09' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 17/04/2024 06:07: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 ( '91316' , '16308' , 'PORTACHIAVI SAN BENEDETTO' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 17/04/2024 06:14:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '90071' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-24') 17/04/2024 06:14:40 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2024-01-24', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', 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 = '1514.40', price_tax_excluded = '1317.05', date_upd = NOW() WHERE id_document = '90071' 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90071' 17/04/2024 06:14:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90071' 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '0' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '0' , 'spedito il 05/04/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '200' , '-200' , '4' , '3.5000' , '3.5' , '0' , '40' , '420.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '0' , 'spedito 1/6/23' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '0' , 'spedito 2/11/23' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 17/04/2024 06:14: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 ( '90071' , '12817' , 'LIBRO DEI MATRIMONI' , '3' , '-3' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '72.00' ) 17/04/2024 06:14: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 ( '90071' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '40' , '14.40' ) 17/04/2024 06:14: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 ( '90071' , '0' , 'spediti 24/01/2024' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14: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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 17/04/2024 06:14: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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 17/04/2024 06:14: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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 17/04/2024 06:14: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 ( '90071' , '0' , '08/02/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 17/04/2024 06:14: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 ( '90071' , '0' , '12/04/24' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 17/04/2024 06:14: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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 17/04/2024 06:14: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 ( '90071' , '' , '18/04/2024' , '0' , '0' , '1' , '0' , '0' , '22' , '0' , '0.00' ) 17/04/2024 06:14: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 ( '90071' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '18.00' ) 17/04/2024 07:18:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1191' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 07:18: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' , '1191' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 17/04/2024 07:18: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 = '91317' 17/04/2024 07:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91317' 17/04/2024 07:18: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 ( '91317' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 17/04/2024 07:26:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839938237' AND id_product != '22146' AND ean13 != '' 17/04/2024 07:26:56 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788839938237', date_upd = NOW() WHERE id_product = '22146' 17/04/2024 07:26:56 pm >> UPDATE ps_product_lang SET name = 'DALLA MORTE ALLA VITA - KOCH', description = '' WHERE id_product = '22146' 17/04/2024 07:26:56 pm >> UPDATE ps_product SET wholesale_price = '16.10', on_sale = '0', price = '23.0000' WHERE id_product = '22146' 17/04/2024 07:26:56 pm >> UPDATE ps_product_shop SET wholesale_price = '16.10', price = '23.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22146' 17/04/2024 07:26:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '22146' 17/04/2024 07:27:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839931375' AND id_product != '22142' AND ean13 != '' 17/04/2024 07:27:47 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788839931375', date_upd = NOW() WHERE id_product = '22142' 17/04/2024 07:27:47 pm >> UPDATE ps_product_lang SET name = 'PAROLE CHIAVE PER LA QUARESIMA', description = '' WHERE id_product = '22142' 17/04/2024 07:27:47 pm >> UPDATE ps_product SET wholesale_price = '3.50', on_sale = '0', price = '5.0000' WHERE id_product = '22142' 17/04/2024 07:27:47 pm >> UPDATE ps_product_shop SET wholesale_price = '3.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22142' 17/04/2024 07:27:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22142' 17/04/2024 07:28:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946678' AND id_product != '22088' AND ean13 != '' 17/04/2024 07:28:04 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788868946678', date_upd = NOW() WHERE id_product = '22088' 17/04/2024 07:28:04 pm >> UPDATE ps_product_lang SET name = 'SULLA SOGLIA DEL GIARDINO', description = '' WHERE id_product = '22088' 17/04/2024 07:28:04 pm >> UPDATE ps_product SET wholesale_price = '5.95', on_sale = '0', price = '8.5000' WHERE id_product = '22088' 17/04/2024 07:28:04 pm >> UPDATE ps_product_shop SET wholesale_price = '5.95', price = '8.5000', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22088' 17/04/2024 07:28:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '22088' 17/04/2024 07:28:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259752185' AND id_product != '20672' AND ean13 != '' 17/04/2024 07:28:21 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9791259752185', date_upd = NOW() WHERE id_product = '20672' 17/04/2024 07:28:21 pm >> UPDATE ps_product_lang SET name = 'VOLGERANNO LO SGUARDO A COLUI ... - P. MONTINI', description = '' WHERE id_product = '20672' 17/04/2024 07:28:21 pm >> UPDATE ps_product SET wholesale_price = '8.40', on_sale = '0', price = '12.0000' WHERE id_product = '20672' 17/04/2024 07:28:21 pm >> UPDATE ps_product_shop SET wholesale_price = '8.40', price = '12.0000', id_tax_rules_group = '4', id_category_default = '267', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20672' 17/04/2024 07:28:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '20672' 17/04/2024 07:29:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555791' AND id_product != '20871' AND ean13 != '' 17/04/2024 07:29:37 pm >> UPDATE ps_product SET id_supplier = '7', reference = '6/6', ean13 = '9788831555791', date_upd = NOW() WHERE id_product = '20871' 17/04/2024 07:29:37 pm >> UPDATE ps_product_lang SET name = 'NELLA STORIA ACCOMPAGNATI DA MARIA', description = '' WHERE id_product = '20871' 17/04/2024 07:29:37 pm >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20871' 17/04/2024 07:29:37 pm >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20871' 17/04/2024 07:29:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '20871' 17/04/2024 07:36:00 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 ( '31' , '84' , '2024-04-10' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '166.40' , '136.39' , NOW() , NOW() ) 17/04/2024 07:36: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 = '91318' 17/04/2024 07:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91318' 17/04/2024 07:36: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 ( '91318' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '4' , '4' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '78.5680' ) 17/04/2024 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 17/04/2024 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 17/04/2024 07:36: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 ( '91318' , '18947' , 'CLERGY COMODA MISTO - ML' , '2' , '2' , '1' , '19.25' , '15.77868852459' , '22' , '0' , '46.9700' ) 17/04/2024 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18947' AND id_supplier = '137' 17/04/2024 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18947' , '137' , '1' ) 17/04/2024 07:36: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 ( '91318' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '1' , '1' , '1' , '17.2' , '14.098360655738' , '22' , '8' , '19.3053' ) 17/04/2024 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '137' 17/04/2024 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '137' , '1' ) 17/04/2024 07:36: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 ( '91318' , '19607' , 'CLERGY F/F ML - C03' , '1' , '1' , '1' , '18.6' , '15.245901639344' , '22' , '5' , '21.5574' ) 17/04/2024 07:36:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19607' AND id_supplier = '137' 17/04/2024 07:36:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19607' , '137' , '1' ) 17/04/2024 07:49:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1192' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-17') 17/04/2024 07:49:47 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' , '1192' , '2024-04-17' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 17/04/2024 07:49: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 = '91319' 17/04/2024 07:49:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '91319' 17/04/2024 07:49: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 ( '91319' , '20487' , 'STELLARIO CM 14 - ART. 70' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' )