20/04/2023 08:08:08 am >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 20/04/2023 08:08:08 am >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '633.40', price_tax_excluded = '633.40', date_upd = NOW() WHERE id_document = '82843' 20/04/2023 08:08:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82843' 20/04/2023 08:08:08 am >> DELETE FROM ps_document_detail WHERE id_document = '82843' 20/04/2023 08:08: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 ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:08: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 ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 20/04/2023 08:08: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 ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 20/04/2023 08:08: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 ( '82843' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 20/04/2023 08:08: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 ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 20/04/2023 08:08: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 ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:08: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 ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '4' , '-4' , '4' , '12.0000' , '12' , '0' , '0' , '48.00' ) 20/04/2023 08:08: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 ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:08: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 ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 20/04/2023 08:08: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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 20/04/2023 08:08: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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 20/04/2023 08:08: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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 20/04/2023 08:08: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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '0' , '32.00' ) 20/04/2023 08:08: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 ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 20/04/2023 08:08: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 ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 20/04/2023 08:08: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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 20/04/2023 08:08: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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:08: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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '19381' , 'SINODALITA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:08: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 ( '82843' , '20110' , 'BRACE LEGNA SOFFIO - DOTTI/ALDEGANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:08: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 ( '82843' , '20215' , 'GRANDE AVVENTURA DELLA SINODALITA - V. SPICACCI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 20/04/2023 08:08: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 ( '82843' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:08: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 ( '82843' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '10' , '-10' , '4' , '15.00' , '15' , '0' , '0' , '150.00' ) 20/04/2023 08:49:22 am >> SELECT document_num FROM ps_document WHERE document_num = '/A' AND id_document != '82843' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-17') 20/04/2023 08:49:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '/A', document_date = '2023-04-17', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '558.40', price_tax_excluded = '558.40', date_upd = NOW() WHERE id_document = '82843' 20/04/2023 08:49:22 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 = '82843' 20/04/2023 08:49:22 am >> DELETE FROM ps_document_detail WHERE id_document = '82843' 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '19941' , 'SEMINATORI DI SPERANZA - AAVV' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '3' , '-3' , '4' , '15.0000' , '15' , '0' , '0' , '45.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '2' , '-2' , '4' , '12.0000' , '12' , '0' , '0' , '24.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '16019' , 'MARTA, MARIA E LAZZARO - L. EPICOCO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '4' , '-4' , '4' , '12.0000' , '12' , '0' , '0' , '48.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:49:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82843' , '20816' , 'FRANCESCANESIMO DI UN PAPA GESUITA - M. SEMERARO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 20/04/2023 08:49: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 ( '82843' , '20878' , 'PROCESSO A FRANCESCO - E. FORTUNATO' , '1' , '-1' , '4' , '17.5000' , '17.5' , '0' , '0' , '17.50' ) 20/04/2023 08:49: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 ( '82843' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49: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 ( '82843' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 20/04/2023 08:49: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 ( '82843' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 20/04/2023 08:49: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 ( '82843' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '4' , '-4' , '4' , '8.0000' , '8' , '0' , '0' , '32.00' ) 20/04/2023 08:49: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 ( '82843' , '20801' , 'PREGHIERA RESPIRO DELLANIMA - PAPA FRANCESCO' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 20/04/2023 08:49: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 ( '82843' , '20856' , 'LASCIA CHE DIO TI ACCAREZZI - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49: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 ( '82843' , '20794' , 'CERCA IL TUO ORIZZONTE ' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 20/04/2023 08:49: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 ( '82843' , '20654' , 'CONQUISTA LA PACE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 20/04/2023 08:49: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 ( '82843' , '15816' , 'CI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:49: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 ( '82843' , '20250' , 'PREGA MANGIA AMA - L. EPICOCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49: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 ( '82843' , '19381' , 'SINODALITA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 20/04/2023 08:49: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 ( '82843' , '20110' , 'BRACE LEGNA SOFFIO - DOTTI/ALDEGANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 20/04/2023 08:49: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 ( '82843' , '20215' , 'GRANDE AVVENTURA DELLA SINODALITA - V. SPICACCI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 20/04/2023 08:49: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 ( '82843' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 20/04/2023 08:49: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 ( '82843' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '5' , '-5' , '4' , '15.0000' , '15' , '0' , '0' , '75.00' ) 20/04/2023 09:10:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '362' , '2023-04-19' , '' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 20/04/2023 09:10:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82888' 20/04/2023 09:10:14 am >> DELETE FROM ps_document_detail WHERE id_document = '82888' 20/04/2023 09:10:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82888' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '200' , '200' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/04/2023 09:10:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '20951' AND id_supplier = '159' 20/04/2023 09:10:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20951' , '159' , '1' ) 20/04/2023 09:36:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '22/151' AND id_product != '12463' AND ean13 != '' 20/04/2023 09:36:48 am >> UPDATE ps_product SET id_supplier = '60', reference = '', ean13 = '22/151', date_upd = NOW() WHERE id_product = '12463' 20/04/2023 09:36:48 am >> UPDATE ps_product_lang SET name = 'QUADRO CON MAGNETE FATIMA - 22/151', description = '' WHERE id_product = '12463' 20/04/2023 09:36:48 am >> UPDATE ps_product SET wholesale_price = '0.70', on_sale = '0', price = '1.4754' WHERE id_product = '12463' 20/04/2023 09:36:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.70', price = '1.4754', id_tax_rules_group = '1', id_category_default = '154', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12463' 20/04/2023 09:36:48 am >> DELETE FROM ps_specific_price WHERE id_product = '12463' 20/04/2023 10:00:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 10:00:42 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' , '1310' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.40' , '46.77' , NOW() , NOW() ) 20/04/2023 10:00:42 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 = '82889' 20/04/2023 10:00:42 am >> DELETE FROM ps_document_detail WHERE id_document = '82889' 20/04/2023 10:00:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82889' , '11389' , 'VINO ROSSO DOLCE - 103' , '3' , '-3' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '25.50' ) 20/04/2023 10:00:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82889' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 20/04/2023 10:00:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82889' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 20/04/2023 10:00:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82889' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 20/04/2023 11:03:25 am >> SELECT document_num FROM ps_document WHERE document_num = '1311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 11:03: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' , '1311' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 20/04/2023 11:03: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 = '82890' 20/04/2023 11:03:25 am >> DELETE FROM ps_document_detail WHERE id_document = '82890' 20/04/2023 11:03: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 ( '82890' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 20/04/2023 11:22:54 am >> SELECT document_num FROM ps_document WHERE document_num = '1312' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 11:22:54 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' , '1312' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 20/04/2023 11:22:54 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 = '82891' 20/04/2023 11:22:54 am >> DELETE FROM ps_document_detail WHERE id_document = '82891' 20/04/2023 11:22:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82891' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '57' , '46.72131147541' , '22' , '0' , '57.00' ) 20/04/2023 11:22:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82891' , '19607' , 'CLERGY F/F ML ' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 20/04/2023 11:22:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82891' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '39' , '31.967213114754' , '22' , '0' , '39.00' ) 20/04/2023 01:09:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1313' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 01:09:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1313' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.00' , '143.44' , NOW() , NOW() ) 20/04/2023 01:09: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 = '82892' 20/04/2023 01:09:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82892' 20/04/2023 01:09: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 ( '82892' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '175' , '143.44262295082' , '22' , '0' , '175.00' ) 20/04/2023 01:11:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1314' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 01:11:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1314' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.56' , NOW() , NOW() ) 20/04/2023 01:11: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 = '82893' 20/04/2023 01:11:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '82893' 20/04/2023 01:11: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 ( '82893' , '9011' , 'RITO DEL MATRIMONIO - RP29' , '8' , '-8' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '2.40' ) 20/04/2023 01:11: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 ( '82893' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 20/04/2023 01:11: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 ( '82893' , '18222' , 'ROSARIO COLORATO - R316' , '8' , '-8' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '5.60' ) 20/04/2023 02:32:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1314' AND id_document != '82893' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 02:32:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1314', document_date = '2023-04-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.56', date_upd = NOW() WHERE id_document = '82893' 20/04/2023 02:32:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82893' 20/04/2023 02:32:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '82893' 20/04/2023 02:32:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82893' , '9011' , 'RITO DEL MATRIMONIO - RP29' , '8' , '-8' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '2.40' ) 20/04/2023 02:32:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82893' , '18222' , 'ROSARIO COLORATO - R316' , '8' , '-8' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '5.60' ) 20/04/2023 02:32:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82893' , '20785' , 'CARTA D\'IDENTITA\' DEL CREATO - R. LUPI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 20/04/2023 02:33:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1229' AND id_document != '82779' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-13') 20/04/2023 02:33:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1229', document_date = '2023-04-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.60', price_tax_excluded = '21.37', date_upd = NOW() WHERE id_document = '82779' 20/04/2023 02:33:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82779' 20/04/2023 02:33:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82779' 20/04/2023 02:33:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82779' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 20/04/2023 02:33:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82779' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 20/04/2023 02:33:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82779' , '15604' , 'LUIGI MARIA DA MONTFORT' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 20/04/2023 02:33:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82779' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 20/04/2023 02:34:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1301' AND id_document != '82876' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-19') 20/04/2023 02:34:35 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1301', document_date = '2023-04-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '30.00', price_tax_excluded = '30.00', date_upd = NOW() WHERE id_document = '82876' 20/04/2023 02:34: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 = '82876' 20/04/2023 02:34:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '82876' 20/04/2023 02:34: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 ( '82876' , '16884' , 'ARTE DI GUARIRE - F. ROSINI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 20/04/2023 02:34: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 ( '82876' , '20740' , 'MIA VITA AUTOBIOGRAFIA BENEDETTO XVI - J. RATZINGER' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 20/04/2023 02:34:50 pm >> DELETE FROM ps_document WHERE id_document = '82843' 20/04/2023 02:34:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '82843' 20/04/2023 02:41:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '1315' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 02:41:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1315' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '342.00' , '342.00' , NOW() , NOW() ) 20/04/2023 02:41:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82894' 20/04/2023 02:41:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '82894' 20/04/2023 02:41:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82894' , '20910' , 'sud il capitale che serve - c. borgomeo' , '24' , '-24' , '4' , '15.00' , '15' , '0' , '5' , '342.00' ) 20/04/2023 02:45:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1233' AND id_document != '82784' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-13') 20/04/2023 02:45:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1233', document_date = '2023-04-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '200.05', price_tax_excluded = '167.59', date_upd = NOW() WHERE id_document = '82784' 20/04/2023 02:45:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82784' 20/04/2023 02:45:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82784' 20/04/2023 02:45:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '1041' , 'BENEDIZIONI' , '1200' , '-1200' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '180.00' ) 20/04/2023 02:45:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '20918' , 'TOTUM AMORIS EST' , '3' , '-3' , '4' , '3' , '3' , '0' , '0' , '9.00' ) 20/04/2023 02:45:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82784' , '20417' , 'NON SARA SUBITO LA FINE - G. ZANCHI' , '1' , '-1' , '4' , '11.05' , '11.05' , '0' , '0' , '11.05' ) 20/04/2023 02:46:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1248' AND id_document != '82802' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-14') 20/04/2023 02:46:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1248', document_date = '2023-04-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '13.42', price_tax_excluded = '13.42', date_upd = NOW() WHERE id_document = '82802' 20/04/2023 02:46: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 = '82802' 20/04/2023 02:46:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '82802' 20/04/2023 02:46: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 ( '82802' , '20767' , 'INSIEME NELLA MESSA - MAG 2023' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 20/04/2023 02:46: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 ( '82802' , '20868' , 'INSIEME NELLA MESSA - GIU 23' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 20/04/2023 02:46: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 ( '82802' , '20923' , 'LETTERA ALLA COSTITUZIONE - M. ZUPPI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 20/04/2023 02:59:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '1316' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 02:59: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' , '1316' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '704.00' , '704.00' , NOW() , NOW() ) 20/04/2023 02:59: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 = '82895' 20/04/2023 02:59:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '82895' 20/04/2023 02:59: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 ( '82895' , '20911' , 'SOGNO DA VIVERE INSIEME' , '6' , '-6' , '4' , '9.00' , '9' , '0' , '5' , '51.30' ) 20/04/2023 02:59: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 ( '82895' , '20912' , 'FALSI MITI' , '5' , '-5' , '4' , '9' , '9' , '0' , '0' , '45.00' ) 20/04/2023 02:59: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 ( '82895' , '20913' , 'RIFARSI UNA VITA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '5' , '47.50' ) 20/04/2023 02:59: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 ( '82895' , '13152' , 'RAGAZZI IN PANCHINA' , '9' , '-9' , '4' , '9' , '9' , '0' , '0' , '81.00' ) 20/04/2023 02:59: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 ( '82895' , '20914' , 'CI VUOLE UN FIORE' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '5' , '28.50' ) 20/04/2023 02:59: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 ( '82895' , '20915' , 'PER PICCINA CHE TU SIA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '5' , '28.50' ) 20/04/2023 02:59: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 ( '82895' , '20916' , 'ZAINO DA RIEMPIRE' , '8' , '-8' , '4' , '9' , '9' , '0' , '0' , '72.00' ) 20/04/2023 02:59: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 ( '82895' , '20903' , 'CARITAS SPES FIDES - BENEDETTO XVI' , '4' , '-4' , '4' , '17.1' , '17.1' , '0' , '0' , '68.40' ) 20/04/2023 02:59: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 ( '82895' , '20917' , 'GESU E IL CREATO' , '4' , '-4' , '4' , '15.3' , '15.3' , '0' , '0' , '61.20' ) 20/04/2023 02:59: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 ( '82895' , '19382' , 'REGNO DEI CIELI E PIENO COMPIMENTO - E. MANICARDI' , '4' , '-4' , '4' , '18.9' , '18.9' , '0' , '0' , '75.60' ) 20/04/2023 02:59: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 ( '82895' , '20919' , 'GESU DI NAZARET NELLE CULTURE DEL SUO TEMPO' , '2' , '-2' , '4' , '20' , '20' , '0' , '0' , '40.00' ) 20/04/2023 02:59: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 ( '82895' , '20920' , 'INTRODUZIONE ALLA SACRA SCRITTURA - G. PULCINELLI' , '1' , '-1' , '4' , '22' , '22' , '0' , '0' , '22.00' ) 20/04/2023 02:59: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 ( '82895' , '20923' , 'LETTERA ALLA COSTITUZIONE - M. ZUPPI' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 20/04/2023 02:59: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 ( '82895' , '20922' , 'TRASMETTERE UN VANGELO DI LIBERTA - C. THEOBALD' , '3' , '-3' , '4' , '15' , '15' , '0' , '0' , '45.00' ) 20/04/2023 03:01:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1315' AND id_document != '82894' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 03:01:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1315', document_date = '2023-04-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '342.00', price_tax_excluded = '342.00', date_upd = NOW() WHERE id_document = '82894' 20/04/2023 03:01:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82894' 20/04/2023 03:01:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '82894' 20/04/2023 03:01:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82894' , '20910' , 'sud il capitale che serve - c. borgomeo' , '23' , '-23' , '4' , '15.0000' , '15' , '0' , '5' , '327.75' ) 20/04/2023 03:01:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82894' , '20922' , 'TRASMETTERE UN VANGELO DI LIBERTA - C. THEOBALD' , '1' , '-1' , '4' , '14.25' , '14.25' , '0' , '' , '14.25' ) 20/04/2023 03:40:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1317' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 03:40:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1317' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 20/04/2023 03:40:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82896' 20/04/2023 03:40:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '82896' 20/04/2023 03:40:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82896' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 20/04/2023 04:09:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 04:09:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '20' , '2023-04-20' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2928.00' , '2928.00' , NOW() , NOW() ) 20/04/2023 04:09:19 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 = '82897' 20/04/2023 04:09:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '82897' 20/04/2023 04:09:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82897' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '80' , '-80' , '4' , '15.00' , '15' , '0' , '0' , '1200.00' ) 20/04/2023 04:09:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82897' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '720' , '-720' , '4' , '2.40' , '2.4' , '0' , '0' , '1728.00' ) 20/04/2023 04:30:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 04:30:44 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '16/E' , '2023-04-20' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '708.00' , '605.86' , NOW() , NOW() ) 20/04/2023 04:30: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 = '82898' 20/04/2023 04:30:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82898' 20/04/2023 04:30: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 ( '82898' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 20/04/2023 04:30: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 ( '82898' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '500' , '-500' , '1' , '0.50' , '0.40983606557377' , '22' , '40' , '150.00' ) 20/04/2023 04:30: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 ( '82898' , '14499' , 'COMUNIONE AI MALATI' , '500' , '-500' , '1' , '0.30' , '0.24590163934426' , '22' , '40' , '90.00' ) 20/04/2023 04:30: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 ( '82898' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '30' , '-30' , '3' , '10.00' , '9.6153846153846' , '4' , '40' , '180.00' ) 20/04/2023 04:31:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/E' AND id_document != '82898' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 04:31:03 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '16/E', document_date = '2023-04-20', 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 = '3', id_causal = '0', price_tax_included = '708.00', price_tax_excluded = '605.86', date_upd = NOW() WHERE id_document = '82898' 20/04/2023 04:31: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 = '82898' 20/04/2023 04:31:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '82898' 20/04/2023 04:31: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 ( '82898' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 20/04/2023 04:31: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 ( '82898' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '500' , '-500' , '1' , '0.5000' , '0.40983606557377' , '22' , '40' , '150.00' ) 20/04/2023 04:31: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 ( '82898' , '14499' , 'COMUNIONE AI MALATI' , '500' , '-500' , '1' , '0.3000' , '0.24590163934426' , '22' , '40' , '90.00' ) 20/04/2023 04:31: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 ( '82898' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '30' , '-30' , '3' , '10.0000' , '9.6153846153846' , '4' , '40' , '180.00' ) 20/04/2023 04:32:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '8' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 04:32:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '8' , '2023-04-20' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.00' , '750.00' , NOW() , NOW() ) 20/04/2023 04:32: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 = '11063' 20/04/2023 04:32:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '11063' 20/04/2023 04:32: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 ( '11063' , '33' , '100 GIORNI CON LO SPIRITO' , '100' , '-100' , '4' , '7.50' , '7.5' , '0' , '0' , '750.00' ) 20/04/2023 05:05:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '16/E' AND id_document != '82898' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 05:05:41 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '16/E', document_date = '2023-04-20', 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 = '3', id_causal = '0', price_tax_included = '888.00', price_tax_excluded = '778.94', date_upd = NOW() WHERE id_document = '82898' 20/04/2023 05:05:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82898' 20/04/2023 05:05:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '82898' 20/04/2023 05:05: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 ( '82898' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 20/04/2023 05:05: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 ( '82898' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '500' , '-500' , '1' , '0.5000' , '0.40983606557377' , '22' , '40' , '150.00' ) 20/04/2023 05:05: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 ( '82898' , '14499' , 'COMUNIONE AI MALATI' , '500' , '-500' , '1' , '0.3000' , '0.24590163934426' , '22' , '40' , '90.00' ) 20/04/2023 05:05: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 ( '82898' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '30' , '-30' , '3' , '20' , '19.230769230769' , '4' , '40' , '360.00' ) 20/04/2023 05:08:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1318' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 05:08:36 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1318' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.70' , '29.74' , NOW() , NOW() ) 20/04/2023 05:08:36 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82899' 20/04/2023 05:08:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '82899' 20/04/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82899' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 20/04/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82899' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 20/04/2023 05:08:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82899' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 20/04/2023 06:02:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '1319' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 06:02:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1319' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.90' , '54.02' , NOW() , NOW() ) 20/04/2023 06:02:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82900' 20/04/2023 06:02:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '82900' 20/04/2023 06:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82900' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '36.90' , '30.245901639344' , '22' , '0' , '36.90' ) 20/04/2023 06:02:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82900' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 20/04/2023 06:13:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 06:13:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1320' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/04/2023 06:13: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 = '82901' 20/04/2023 06:13:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '82901' 20/04/2023 06:13: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 ( '82901' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/04/2023 06:22:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 06:22: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' , '1321' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.90' , '12.16' , NOW() , NOW() ) 20/04/2023 06:22: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 = '82902' 20/04/2023 06:22:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '82902' 20/04/2023 06:22: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 ( '82902' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '8.50' ) 20/04/2023 06:22: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 ( '82902' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 20/04/2023 06:22: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 ( '82902' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 20/04/2023 06:59:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 06:59: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' , '1322' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 20/04/2023 06:59: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 = '82903' 20/04/2023 06:59:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '82903' 20/04/2023 06:59: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 ( '82903' , '15428' , 'TUNICA SVASATA COLLO RISVOLTATO - AETA08B00' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 20/04/2023 07:33:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 07:33:57 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' , '1323' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 20/04/2023 07:33:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82904' 20/04/2023 07:33:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '82904' 20/04/2023 07:33:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82904' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '0' , '6.00' ) 20/04/2023 07:36:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1323' AND id_document != '82904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 07:36:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1323', document_date = '2023-04-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '6.00', price_tax_excluded = '6.00', date_upd = NOW() WHERE id_document = '82904' 20/04/2023 07:36: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 = '82904' 20/04/2023 07:36:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '82904' 20/04/2023 07:36: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 ( '82904' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 20/04/2023 07:36: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 ( '82904' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3' , '3' , '0' , '0' , '3.00' ) 20/04/2023 07:36:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1212' AND id_document != '82756' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-12') 20/04/2023 07:36:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1212', document_date = '2023-04-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '43.74', date_upd = NOW() WHERE id_document = '82756' 20/04/2023 07:36: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 = '82756' 20/04/2023 07:36:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '82756' 20/04/2023 07:36: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 ( '82756' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 20/04/2023 07:36: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 ( '82756' , '14686' , 'QUADRETTO SMUSSATO 7X10 MISERICORDIOSO' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 20/04/2023 07:36: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 ( '82756' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '8' , '-8' , '4' , '5.0000' , '5' , '0' , '5' , '38.00' ) 20/04/2023 07:36:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1208' AND id_document != '82752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-11') 20/04/2023 07:36:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1208', document_date = '2023-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 = '9.00', price_tax_excluded = '7.38', date_upd = NOW() WHERE id_document = '82752' 20/04/2023 07:36:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82752' 20/04/2023 07:36:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '82752' 20/04/2023 07:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 20/04/2023 07:36:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '14686' , 'QUADRETTO SMUSSATO 7X10 MISERICORDIOSO' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 20/04/2023 07:36:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82752' , '16989' , 'QUADRETTO SMUSSATO 7X10 MIRACOLOSA' , '1' , '-1' , '1' , '2.1000' , '1.7213114754098' , '22' , '0' , '2.10' ) 20/04/2023 07:45:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 07:45:22 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' , '1324' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/04/2023 07:45:22 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 = '82905' 20/04/2023 07:45:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '82905' 20/04/2023 07:45:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82905' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 20/04/2023 07:55:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-20') 20/04/2023 07:55:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1325' , '2023-04-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 20/04/2023 07:55:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82906' 20/04/2023 07:55:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '82906' 20/04/2023 07:55:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82906' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )