14/10/2024 09:36:45 am >> SELECT document_num FROM ps_document WHERE document_num = '3022' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 09:36:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3022' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.25' , '52.25' , NOW() , NOW() ) 14/10/2024 09:36:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93594' 14/10/2024 09:36:46 am >> DELETE FROM ps_document_detail WHERE id_document = '93594' 14/10/2024 09:36:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93594' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '11' , '-11' , '4' , '5.00' , '5' , '0' , '5' , '52.25' ) 14/10/2024 09:41:35 am >> UPDATE ps_product_shop SET active = '1' WHERE id_product = '23032' 14/10/2024 09:42:07 am >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '12253' 14/10/2024 09:49:50 am >> SELECT document_num FROM ps_document WHERE document_num = '150' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 09:49:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '150' , '2024-10-14' , '' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '300.05' , '300.05' , NOW() , NOW() ) 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93595' 14/10/2024 09:49:50 am >> DELETE FROM ps_document_detail WHERE id_document = '93595' 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93595' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.80' , '3.8' , '0' , '15' , '74.29' ) 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93595' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '26' , '-26' , '4' , '3.80' , '3.8' , '0' , '15' , '83.98' ) 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93595' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '36' , '-36' , '4' , '3.80' , '3.8' , '0' , '15' , '116.28' ) 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93595' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 14/10/2024 09:49:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93595' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 14/10/2024 09:52:03 am >> SELECT document_num FROM ps_document WHERE document_num = '3023' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 09:52:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3023' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 14/10/2024 09:52:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93596' 14/10/2024 09:52:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93596' 14/10/2024 09:52:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93596' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2024 10:10:31 am >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:10:31 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '151' , '2024-10-14' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '136.85' , '136.85' , NOW() , NOW() ) 14/10/2024 10:10:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93597' 14/10/2024 10:10:31 am >> DELETE FROM ps_document_detail WHERE id_document = '93597' 14/10/2024 10:10:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 14/10/2024 10:10:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '4154' , 'FESTA DEL PERDONO' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '15' , '51.00' ) 14/10/2024 10:10:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 14/10/2024 10:10:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3024' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:10:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3024' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.10' , '5.82' , NOW() , NOW() ) 14/10/2024 10:10:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93598' 14/10/2024 10:10:59 am >> DELETE FROM ps_document_detail WHERE id_document = '93598' 14/10/2024 10:10:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93598' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 14/10/2024 10:10:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93598' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 14/10/2024 10:13:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3025' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:13:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3025' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.27' , '9.27' , NOW() , NOW() ) 14/10/2024 10:13:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93599' 14/10/2024 10:13:56 am >> DELETE FROM ps_document_detail WHERE id_document = '93599' 14/10/2024 10:13:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93599' , '22893' , 'MIO PICCOLO GIUBILEO - M. GATTAFONI' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 14/10/2024 10:13:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93599' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 14/10/2024 10:13:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93599' , '22982' , 'MESSA IN CHIESA INSIEME AI GRANDI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 14/10/2024 10:16:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:16:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3026' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '828.33' , '768.57' , NOW() , NOW() ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93600' 14/10/2024 10:16:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93600' 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22985' , 'CHE PESCI PIGLIARE ' , '1' , '-1' , '4' , '11.50' , '11.5' , '0' , '5' , '10.93' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '50' , '-50' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '35.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '18' , '18' , '0' , '0' , '36.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7' , '5.7377049180328' , '22' , '0' , '21.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '6019' , 'LUMINO ROSSO - 10B' , '384' , '-384' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '192.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 14/10/2024 10:16:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93600' , '11151' , 'LIBRI' , '25' , '-25' , '4' , '18' , '18' , '0' , '0' , '450.00' ) 14/10/2024 10:18:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:18:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3027' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 14/10/2024 10:18:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93601' 14/10/2024 10:18:04 am >> DELETE FROM ps_document_detail WHERE id_document = '93601' 14/10/2024 10:18:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93601' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '5' , '19.00' ) 14/10/2024 10:23:36 am >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '93597' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:23:36 am >> UPDATE ps_document SET id_document_type = '21', document_num = '151', document_date = '2024-10-14', document_letter = '', id_customer = '2312', id_supplier = '', id_address = '4675584', address1 = 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '136.85', price_tax_excluded = '136.85', date_upd = NOW() WHERE id_document = '93597' 14/10/2024 10:23:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93597' 14/10/2024 10:23:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93597' 14/10/2024 10:23:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 14/10/2024 10:23:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '4154' , 'FESTA DEL PERDONO' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 14/10/2024 10:23:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93597' , '8408' , 'PRENDETE E MANGIATE' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 14/10/2024 10:28:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:28:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3028' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.50' , '79.84' , NOW() , NOW() ) 14/10/2024 10:28:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93602' 14/10/2024 10:28:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93602' 14/10/2024 10:28:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93602' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '75.00' ) 14/10/2024 10:28:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93602' , '2679' , 'CONOSCERE GESU' , '5' , '-5' , '4' , '3' , '3' , '0' , '0' , '15.00' ) 14/10/2024 10:28:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93602' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/10/2024 10:37:43 am >> SELECT document_num FROM ps_document WHERE document_num = '152' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:37:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '152' , '2024-10-14' , '' , '3533' , '0' , '4672868' , 'VIALE FRENTANO 2 66030 MOZZAGROGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '122.75' , '122.75' , NOW() , NOW() ) 14/10/2024 10:37:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93603' 14/10/2024 10:37:43 am >> DELETE FROM ps_document_detail WHERE id_document = '93603' 14/10/2024 10:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93603' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '16' , '-16' , '4' , '2.40' , '2.4' , '0' , '15' , '32.64' ) 14/10/2024 10:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93603' , '2679' , 'CONOSCERE GESU\'' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 14/10/2024 10:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93603' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 14/10/2024 10:37:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93603' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 14/10/2024 10:38:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 10:38:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3029' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.87' , '19.36' , NOW() , NOW() ) 14/10/2024 10:38: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 = '93604' 14/10/2024 10:38:07 am >> DELETE FROM ps_document_detail WHERE id_document = '93604' 14/10/2024 10:38: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 ( '93604' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 14/10/2024 10:38: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 ( '93604' , '18067' , 'ROSARIO BIBLICO - V. SPAGNOLO' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 14/10/2024 10:38: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 ( '93604' , '16909' , 'CUORE A CUORE CON GESU - 8134' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 14/10/2024 10:38: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 ( '93604' , '20968' , 'CROCE SAN BENEDETTO - PG598' , '1' , '-1' , '1' , '13.90' , '11.393442622951' , '22' , '0' , '13.90' ) 14/10/2024 11:02:32 am >> SELECT document_num FROM ps_document WHERE document_num = '18/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 11:02:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '18/L' , '2024-10-14' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '207.20' , '207.20' , NOW() , NOW() ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93605' 14/10/2024 11:02:33 am >> DELETE FROM ps_document_detail WHERE id_document = '93605' 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '20' , '27.20' ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '10' , '27.00' ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '10' , '27.00' ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '10' , '27.00' ) 14/10/2024 11:02:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93605' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '10' , '45.00' ) 14/10/2024 11:23:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2757' AND id_document != '93233' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-20') 14/10/2024 11:23:22 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2757', document_date = '2024-09-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.50', price_tax_excluded = '4.51', date_upd = NOW() WHERE id_document = '93233' 14/10/2024 11:23: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 = '93233' 14/10/2024 11:23:22 am >> DELETE FROM ps_document_detail WHERE id_document = '93233' 14/10/2024 11:23: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 ( '93233' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 14/10/2024 11:23: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 ( '93233' , '16312' , 'DECINA LEGNO CHIARO' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 14/10/2024 11:32:20 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 ( '31' , '481' , '2024-10-11' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '243.68' , '199.74' , NOW() , NOW() ) 14/10/2024 11:32:20 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 = '93606' 14/10/2024 11:32:20 am >> DELETE FROM ps_document_detail WHERE id_document = '93606' 14/10/2024 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93606' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '2' , '2' , '1' , '54' , '44.262295081967' , '22' , '3' , '127.8072' ) 14/10/2024 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 14/10/2024 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 14/10/2024 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93606' , '22782' , 'STOLA - GRECA 2' , '1' , '1' , '1' , '56' , '45.901639344262' , '22' , '3' , '66.2704' ) 14/10/2024 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '22782' AND id_supplier = '118' 14/10/2024 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22782' , '118' , '1' ) 14/10/2024 11:32:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93606' , '19087' , 'SERVIZIO MESSA LINO - 74101' , '1' , '1' , '1' , '28' , '22.950819672131' , '22' , '3' , '33.1352' ) 14/10/2024 11:32:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '19087' AND id_supplier = '118' 14/10/2024 11:32:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19087' , '118' , '1' ) 14/10/2024 11:35:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000502' AND id_product != '5997' AND ean13 != '' 14/10/2024 11:35:04 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000502', date_upd = NOW() WHERE id_product = '5997' 14/10/2024 11:35:04 am >> UPDATE ps_product_lang SET name = 'LUME SOFFIATO CON PIEDE - 1022', description = '' WHERE id_product = '5997' 14/10/2024 11:35:04 am >> UPDATE ps_product SET wholesale_price = '6.65', on_sale = '0', price = '14.754098360655737' WHERE id_product = '5997' 14/10/2024 11:35:04 am >> UPDATE ps_product_shop SET wholesale_price = '6.65', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '147', 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 = '5997' 14/10/2024 11:35:04 am >> DELETE FROM ps_specific_price WHERE id_product = '5997' 14/10/2024 11:40:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000661' AND id_product != '1369' AND ean13 != '' 14/10/2024 11:40:48 am >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '000661', date_upd = NOW() WHERE id_product = '1369' 14/10/2024 11:40:48 am >> UPDATE ps_product_lang SET name = 'RICAMBIO BROCCHETTE DECORATE ART. 500 - 556', description = '' WHERE id_product = '1369' 14/10/2024 11:40:48 am >> UPDATE ps_product SET wholesale_price = '6.89', on_sale = '0', price = '11.475409836065573' WHERE id_product = '1369' 14/10/2024 11:40:48 am >> UPDATE ps_product_shop SET wholesale_price = '6.89', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '147', 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 = '1369' 14/10/2024 11:40:48 am >> DELETE FROM ps_specific_price WHERE id_product = '1369' 14/10/2024 11:42:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000661' AND id_product != '1369' AND ean13 != '' 14/10/2024 11:42:34 am >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '000661', date_upd = NOW() WHERE id_product = '1369' 14/10/2024 11:42:34 am >> UPDATE ps_product_lang SET name = 'RICAMBIO BROCCHETTE DECORATE ART. 500 - 556', description = '' WHERE id_product = '1369' 14/10/2024 11:42:34 am >> UPDATE ps_product SET wholesale_price = '6.89', on_sale = '0', price = '20.491803278688526' WHERE id_product = '1369' 14/10/2024 11:42:34 am >> UPDATE ps_product_shop SET wholesale_price = '6.89', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '147', 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 = '1369' 14/10/2024 11:42:34 am >> DELETE FROM ps_specific_price WHERE id_product = '1369' 14/10/2024 11:43:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000661' AND id_product != '1369' AND ean13 != '' 14/10/2024 11:43:18 am >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '000661', date_upd = NOW() WHERE id_product = '1369' 14/10/2024 11:43:18 am >> UPDATE ps_product_lang SET name = 'RICAMBIO BROCCHETTE DECORATE ART. 500 - 556', description = '' WHERE id_product = '1369' 14/10/2024 11:43:18 am >> UPDATE ps_product SET wholesale_price = '6.89', on_sale = '0', price = '20.491803278688526' WHERE id_product = '1369' 14/10/2024 11:43:18 am >> UPDATE ps_product_shop SET wholesale_price = '6.89', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '147', 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 = '1369' 14/10/2024 11:43:18 am >> DELETE FROM ps_specific_price WHERE id_product = '1369' 14/10/2024 11:47:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000716' AND id_product != '2097' AND ean13 != '' 14/10/2024 11:47:26 am >> UPDATE ps_product SET id_supplier = '12', reference = '2015', ean13 = '000716', date_upd = NOW() WHERE id_product = '2097' 14/10/2024 11:47:26 am >> UPDATE ps_product_lang SET name = 'CIPOLLINA MANGIAFUMO - 1057', description = '' WHERE id_product = '2097' 14/10/2024 11:47:26 am >> UPDATE ps_product SET wholesale_price = '3.33', on_sale = '0', price = '7.377049180327869' WHERE id_product = '2097' 14/10/2024 11:47:26 am >> UPDATE ps_product_shop SET wholesale_price = '3.33', price = '7.377049180327869', id_tax_rules_group = '1', id_category_default = '147', 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 = '2097' 14/10/2024 11:47:26 am >> DELETE FROM ps_specific_price WHERE id_product = '2097' 14/10/2024 11:53:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000400' AND id_product != '7553' AND ean13 != '' 14/10/2024 11:53:49 am >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000400', date_upd = NOW() WHERE id_product = '7553' 14/10/2024 11:53:49 am >> UPDATE ps_product_lang SET name = 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25', description = '' WHERE id_product = '7553' 14/10/2024 11:53:49 am >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '9.426229508196721' WHERE id_product = '7553' 14/10/2024 11:53:49 am >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '147', 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 = '7553' 14/10/2024 11:53:49 am >> DELETE FROM ps_specific_price WHERE id_product = '7553' 14/10/2024 11:54:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001812' AND id_product != '18799' AND ean13 != '' 14/10/2024 11:54:44 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001812', date_upd = NOW() WHERE id_product = '18799' 14/10/2024 11:54:44 am >> UPDATE ps_product_lang SET name = 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30', description = '' WHERE id_product = '18799' 14/10/2024 11:54:44 am >> UPDATE ps_product SET wholesale_price = '4.28', on_sale = '0', price = '9.426229508196721' WHERE id_product = '18799' 14/10/2024 11:54:44 am >> UPDATE ps_product_shop SET wholesale_price = '4.28', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '147', 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 = '18799' 14/10/2024 11:54:44 am >> DELETE FROM ps_specific_price WHERE id_product = '18799' 14/10/2024 12:01:57 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/10/2024 12:01:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23033' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 12:01:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23033' , '1' , '1' , '2' , NOW() , NOW() ) 14/10/2024 12:01:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23033' , '0' , '1' , '0' , '0' ) 14/10/2024 12:04:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003772' AND id_product != '23033' AND ean13 != '' 14/10/2024 12:04:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000003772', date_upd = NOW() WHERE id_product = '23033' 14/10/2024 12:04:09 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X60 - 1142', description = '' WHERE id_product = '23033' 14/10/2024 12:04:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23033' 14/10/2024 12:04:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '147', 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 = '23033' 14/10/2024 12:04:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '23033' 14/10/2024 12:04:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003772' AND id_product != '23033' AND ean13 != '' 14/10/2024 12:04:25 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000003772', date_upd = NOW() WHERE id_product = '23033' 14/10/2024 12:04:25 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X60 - 1142', description = '' WHERE id_product = '23033' 14/10/2024 12:04:25 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '23033' 14/10/2024 12:04:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '147', 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 = '23033' 14/10/2024 12:04:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '23033' 14/10/2024 12:04:27 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23033' 14/10/2024 12:04:27 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23034' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 12:04:27 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23034' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23033' 14/10/2024 12:04:27 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23034' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23033' 14/10/2024 12:06:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003789' AND id_product != '23034' AND ean13 != '' 14/10/2024 12:06:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000003789', date_upd = NOW() WHERE id_product = '23034' 14/10/2024 12:06:03 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X100 - 1143', description = '' WHERE id_product = '23034' 14/10/2024 12:06:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '23034' 14/10/2024 12:06:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '147', 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 = '23034' 14/10/2024 12:06:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '23034' 14/10/2024 12: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 ( '31' , '3171' , '2024-10-11' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '508.37' , '416.70' , NOW() , NOW() ) 14/10/2024 12: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 = '93607' 14/10/2024 12:07:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93607' 14/10/2024 12: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 ( '93607' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '4' , '4' , '1' , '8' , '6.5573770491803' , '22' , '5' , '37.0880' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5997' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5997' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '22220' , 'RICAMBIO TAPPO PER AMPOLLINA 1509-1510 - 101' , '2' , '2' , '1' , '4.5' , '3.6885245901639' , '22' , '5' , '10.4310' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22220' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22220' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '2' , '1' , '6' , '4.9180327868852' , '22' , '5' , '13.9080' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1370' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1370' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '1369' , 'RICAMBIO BROCCHETTE DECORATE ART. 500 - 556' , '2' , '2' , '1' , '10.5' , '8.6065573770492' , '22' , '5' , '24.3390' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1369' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1369' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '2' , '1' , '18.5' , '15.16393442623' , '22' , '5' , '42.8830' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '15000' , 'TECA ALTA IHS - 825' , '1' , '1' , '1' , '14' , '11.475409836066' , '22' , '5' , '16.2260' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15000' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15000' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '6' , '6' , '1' , '6' , '4.9180327868852' , '22' , '5' , '41.7240' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '5' , '5' , '1' , '4' , '3.2786885245902' , '22' , '5' , '23.1800' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2097' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2097' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '22215' , 'CALICE MALTA - 341' , '1' , '1' , '1' , '118' , '96.72131147541' , '22' , '5' , '136.7620' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22215' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22215' , '12' , '1' ) 14/10/2024 12: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 ( '93607' , '778' , 'ASPERGES CON VASETTO O. S. - 1700 ' , '1' , '1' , '1' , '29' , '23.770491803279' , '22' , '5' , '33.6110' ) 14/10/2024 12:07:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '778' AND id_supplier = '12' 14/10/2024 12:07:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '778' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '6011' , 'LUMINELLO VETRO - 474' , '3' , '3' , '1' , '5' , '4.0983606557377' , '22' , '5' , '17.3850' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6011' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6011' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '7553' , 'PARAFIAMMA PIREX PER CARTUCCIA 3.2 - 474/25' , '4' , '4' , '1' , '5' , '4.0983606557377' , '22' , '5' , '23.1800' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7553' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7553' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '4' , '4' , '1' , '5' , '4.0983606557377' , '22' , '5' , '23.1800' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18799' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18799' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '1' , '1' , '1' , '14.5' , '11.885245901639' , '22' , '5' , '16.8055' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21932' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21932' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '23033' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X60 - 1142' , '1' , '1' , '1' , '12.5' , '10.245901639344' , '22' , '5' , '14.4875' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23033' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23033' , '12' , '1' ) 14/10/2024 12:07: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 ( '93607' , '23034' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X100 - 1143' , '1' , '1' , '1' , '16' , '13.114754098361' , '22' , '5' , '18.5440' ) 14/10/2024 12:07:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23034' AND id_supplier = '12' 14/10/2024 12:07:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23034' , '12' , '1' ) 14/10/2024 12:17:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 12:17:45 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' , '3030' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.52' , '9.52' , NOW() , NOW() ) 14/10/2024 12:17:45 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 = '93608' 14/10/2024 12:17:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '93608' 14/10/2024 12:17:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93608' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '5' , '9.52' ) 14/10/2024 12:34:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 12:34:03 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' , '3031' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 14/10/2024 12:34: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 = '93609' 14/10/2024 12:34:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93609' 14/10/2024 12:34: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 ( '93609' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 14/10/2024 12:48:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3032' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 12:48:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3032' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.06' , '15.06' , NOW() , NOW() ) 14/10/2024 12:48: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 = '93610' 14/10/2024 12:48:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93610' 14/10/2024 12:48: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 ( '93610' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '1' , '-1' , '4' , '14.80' , '14.8' , '0' , '5' , '14.06' ) 14/10/2024 12:48: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 ( '93610' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 14/10/2024 12:48:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 12:48:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3033' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '51.00' , '51.00' , NOW() , NOW() ) 14/10/2024 12:48:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93611' 14/10/2024 12:48:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '93611' 14/10/2024 12:48:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93611' , '10917' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MATTEO' , '1' , '-1' , '4' , '51.00' , '51' , '0' , '0' , '51.00' ) 14/10/2024 12:51:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '93576' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 14/10/2024 12:51:47 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2024-10-11', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', 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 = '303.40', price_tax_excluded = '249.68', date_upd = NOW() WHERE id_document = '93576' 14/10/2024 12:51: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 = '93576' 14/10/2024 12:51:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '93576' 14/10/2024 12:51: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 ( '93576' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '-3' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '111.00' ) 14/10/2024 12:51: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 ( '93576' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 14/10/2024 12:51: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 ( '93576' , '20437' , 'LUMINO BIANCO 10BTS000' , '192' , '-192' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '96.00' ) 14/10/2024 12:51: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 ( '93576' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '53.40' ) 14/10/2024 12:51: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 ( '93576' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.00' , '29.508196721311' , '22' , '0' , '36.00' ) 14/10/2024 03:11:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 03:11: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' , '3034' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 14/10/2024 03:11: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 = '93612' 14/10/2024 03:11:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '93612' 14/10/2024 03:11: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 ( '93612' , '22437' , 'BRACCIALE ELASTICO S. BENEDETTO - 434M79' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 14/10/2024 03:11: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 ( '93612' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 14/10/2024 03:12:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 03:12:48 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' , '3035' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 14/10/2024 03:12:48 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 = '93613' 14/10/2024 03:12:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93613' 14/10/2024 03:12:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93613' , '23034' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X100 - 1143' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 14/10/2024 03:12:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93613' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 14/10/2024 03:12:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93613' , '23033' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X60 - 1142' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 14/10/2024 03:37:24 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/10/2024 03:37:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23035' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 03:37:24 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23035' , '1' , '1' , '2' , NOW() , NOW() ) 14/10/2024 03:37:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23035' , '0' , '1' , '0' , '0' ) 14/10/2024 03:40:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118320100' AND id_product != '23035' AND ean13 != '' 14/10/2024 03:40:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '8019118320100', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:21 pm >> UPDATE ps_product_lang SET name = 'padre nostro - spartito', description = '' WHERE id_product = '23035' 14/10/2024 03:40:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '23035' 14/10/2024 03:40:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23035' 14/10/2024 03:40:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118320100' AND id_product != '23035' AND ean13 != '' 14/10/2024 03:40:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '8019118320100', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:53 pm >> UPDATE ps_product_lang SET name = 'padre nostro - spartito', description = '' WHERE id_product = '23035' 14/10/2024 03:40:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0' WHERE id_product = '23035' 14/10/2024 03:40:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '23035' 14/10/2024 03:40:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118320100' AND id_product != '23035' AND ean13 != '' 14/10/2024 03:40:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '8019118320100', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> UPDATE ps_product_lang SET name = 'padre nostro - spartito', description = '' WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.538461538461538' WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.538461538461538', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23036' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 03:40:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23036' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23035' 14/10/2024 03:40:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23036' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23035' 14/10/2024 03:41:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118310170' AND id_product != '23036' AND ean13 != '' 14/10/2024 03:41:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '8019118310170', date_upd = NOW() WHERE id_product = '23036' 14/10/2024 03:41:57 pm >> UPDATE ps_product_lang SET name = 'padre nostro - cd', description = '' WHERE id_product = '23036' 14/10/2024 03:41:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '23036' 14/10/2024 03:41:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23036' 14/10/2024 03:41:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '23036' 14/10/2024 03:41:58 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23036' 14/10/2024 03:41:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23037' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 03:41:58 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23037' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23036' 14/10/2024 03:41:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23037' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23036' 14/10/2024 03:42:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118310170' AND id_product != '23036' AND ean13 != '' 14/10/2024 03:42:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/5', ean13 = '8019118310170', date_upd = NOW() WHERE id_product = '23036' 14/10/2024 03:42:50 pm >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO - CD', description = '' WHERE id_product = '23036' 14/10/2024 03:42:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.0656' WHERE id_product = '23036' 14/10/2024 03:42:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.0656', id_tax_rules_group = '1', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23036' 14/10/2024 03:42:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '23036' 14/10/2024 03:43:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8019118320100' AND id_product != '23035' AND ean13 != '' 14/10/2024 03:43:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '1/6', ean13 = '8019118320100', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:43:03 pm >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO - SPARTITO', description = '' WHERE id_product = '23035' 14/10/2024 03:43:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.5385' WHERE id_product = '23035' 14/10/2024 03:43:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.5385', id_tax_rules_group = '3', id_category_default = '27', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23035' 14/10/2024 03:43:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '23035' 14/10/2024 03:43:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801050349' AND id_product != '23037' AND ean13 != '' 14/10/2024 03:43:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788801050349', date_upd = NOW() WHERE id_product = '23037' 14/10/2024 03:43:58 pm >> UPDATE ps_product_lang SET name = 'HOMO RELIGIOSUS - E. SCOGNAMIGLIO', description = '' WHERE id_product = '23037' 14/10/2024 03:43:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '23037' 14/10/2024 03:43:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23037' 14/10/2024 03:43:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '23037' 14/10/2024 03:43:59 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23037' 14/10/2024 03:43:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23038' , '1' , '' , 'nuovo-prodotto' ) 14/10/2024 03:43:59 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23038' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23037' 14/10/2024 03:44:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23038' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23037' 14/10/2024 03:46: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 ( '33' , '677018' , '2024-10-11' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.56' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.41' , '124.39' , NOW() , NOW() ) 14/10/2024 03:46: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 = '93614' 14/10/2024 03:46:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93614' 14/10/2024 03:46: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 ( '93614' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '12' , '12' , '4' , '2.00' , '2' , '0' , '33' , '16.0800' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '1' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19157' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19157' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '23036' , 'padre nostro - cd' , '1' , '1' , '1' , '11.06' , '9.0655737704918' , '22' , '30' , '9.4452' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23036' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23036' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '23035' , 'padre nostro - spartito' , '1' , '1' , '3' , '11.53' , '11.086538461538' , '4' , '30' , '8.3938' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23035' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23035' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '23037' , 'HOMO RELIGIOSUS - E. SCOGNAMIGLIO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23037' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23037' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '3733' , 'E DANZANDO CANTERANNO VAL.' , '1' , '1' , '4' , '48.00' , '48' , '0' , '30' , '33.6000' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3733' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3733' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '22978' , 'MISTERO PASQUALE E LITURGIA DELLE ORE - A.J. LAMBERT' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22978' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22978' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '19638' , 'STORIA DI CARLO ACUTIS' , '1' , '1' , '4' , '1.90' , '1.9' , '0' , '30' , '1.3300' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19638' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19638' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '22556' , 'NUMERI DI DIO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22556' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22556' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '22876' , 'AMEN - NOV 24' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '33' , '10.4520' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22876' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22876' , '7' , '1' ) 14/10/2024 03:46: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 ( '93614' , '22875' , 'AMEN - DIC 24' , '4' , '4' , '4' , '3.90' , '3.9' , '0' , '33' , '10.4520' ) 14/10/2024 03:46:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22875' AND id_supplier = '7' 14/10/2024 03:46:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22875' , '7' , '1' ) 14/10/2024 03:49:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2734' AND id_document != '93203' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 14/10/2024 03:49:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2734', document_date = '2024-09-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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '93203' 14/10/2024 03:49: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 = '93203' 14/10/2024 03:49:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93203' 14/10/2024 03:49: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 ( '93203' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '7' , '-7' , '1' , '3' , '2.4590163934426' , '22' , '0' , '21.00' ) 14/10/2024 03:49: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 ( '93203' , '19818' , 'INCENSO NATURALE 3A KG 1' , '3' , '-3' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '69.00' ) 14/10/2024 03:51:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2742' AND id_document != '93212' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-19') 14/10/2024 03:51:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2742', document_date = '2024-09-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 = '131.00', price_tax_excluded = '113.15', date_upd = NOW() WHERE id_document = '93212' 14/10/2024 03:51:51 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 = '93212' 14/10/2024 03:51:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93212' 14/10/2024 03:51:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3' , '2.4590163934426' , '22' , '0' , '9.00' ) 14/10/2024 03:51:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 14/10/2024 03:51:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '21.0000' , '21' , '0' , '0' , '21.00' ) 14/10/2024 03:51:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93212' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '9' , '-9' , '1' , '10' , '8.1967213114754' , '22' , '0' , '90.00' ) 14/10/2024 03:52:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '3036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 03:52: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' , '3036' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.80' , '5.72' , NOW() , NOW() ) 14/10/2024 03:52: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 = '93615' 14/10/2024 03:52:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93615' 14/10/2024 03:52: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 ( '93615' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 14/10/2024 03:52: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 ( '93615' , '22912' , 'CALENDARIO DA TAVOLO 2025 - 40825' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 14/10/2024 04:31:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280736505' AND id_product != '23032' AND ean13 != '' 14/10/2024 04:31:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '4/4', ean13 = '9791280736505', date_upd = NOW() WHERE id_product = '23032' 14/10/2024 04:31:10 pm >> UPDATE ps_product_lang SET name = 'MIO LIBRO DI PREGHIERE - N. E. ', description = '

TITOLO:                  IL MIO LIBRO DI PREGHIERE

FORMATO:             9,5 X 14

PAGINE:                 52 illustrate

PREZZO:                € 2,80

ISBN:                      9791280736505


Le preghiere del cristiano, la Messa,  il Santo Rosario, preghiere per le varie occasioni  e alcuni Salmi.

Le occasioni per pregare sono molteplici: i vari momenti della giornata, i momenti di festa, di svago, di gioia, ma anche quelli tristi.

Questo libretto rivolto ai fanciulli raccoglie le preghiere del cristiano con l’aggiunta della Messa, del Santo Rosario e di alcuni Salmi per

accompagnarli nella preghiera quotidiana. Ci sono poi alcune preghiere preparate per le diverse occasioni importanti della loro vita (compleanno, onomastico, ecc…), per lafamiglia e per gli amici, ecc… I disegni che illustrano le varie preghiere rendono il libretto più accattivante e gioioso. 

' WHERE id_product = '23032' 14/10/2024 04:31:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8000' WHERE id_product = '23032' 14/10/2024 04:31:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '23032' 14/10/2024 04:31:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '23032' 14/10/2024 04:31:10 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '23032' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 14/10/2024 04:31:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '108/A' AND id_document != '93576' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-10-11') 14/10/2024 04:31:57 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '108/A', document_date = '2024-10-11', document_letter = 'A', id_customer = '922', id_supplier = '', id_address = '4671011', 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 = '185.40', price_tax_excluded = '151.97', date_upd = NOW() WHERE id_document = '93576' 14/10/2024 04:31: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 = '93576' 14/10/2024 04:31:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '93576' 14/10/2024 04:31: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 ( '93576' , '20437' , 'LUMINO BIANCO 10BTS000' , '192' , '-192' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '96.00' ) 14/10/2024 04:31: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 ( '93576' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '53.40' ) 14/10/2024 04:31: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 ( '93576' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '36.0000' , '29.508196721311' , '22' , '0' , '36.00' ) 14/10/2024 04:32:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2904' AND id_document != '93440' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-04') 14/10/2024 04:32:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2904', document_date = '2024-10-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '203.90', price_tax_excluded = '171.60', date_upd = NOW() WHERE id_document = '93440' 14/10/2024 04:32:43 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 = '93440' 14/10/2024 04:32:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93440' 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '5' , '-5' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '21.50' ) 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 14/10/2024 04:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93440' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 14/10/2024 04:35:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2844' AND id_document != '93352' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-30') 14/10/2024 04:35:03 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2844', document_date = '2024-09-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 = '50.00', price_tax_excluded = '40.98', date_upd = NOW() WHERE id_document = '93352' 14/10/2024 04:35: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 = '93352' 14/10/2024 04:35:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '93352' 14/10/2024 04:35: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 ( '93352' , '6355' , 'MEDAGLIA S. PIO MM 22 - METALLO OX ' , '8' , '-8' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.00' ) 14/10/2024 04:35: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 ( '93352' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 14/10/2024 04:35:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2782' AND id_document != '93270' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-24') 14/10/2024 04:35:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2782', document_date = '2024-09-24', 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 = '106.80', price_tax_excluded = '91.61', date_upd = NOW() WHERE id_document = '93270' 14/10/2024 04:35:59 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 = '93270' 14/10/2024 04:35:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93270' 14/10/2024 04:35: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 ( '93270' , '15000' , 'TECA ALTA IHS - 825' , '1' , '-1' , '1' , '32.0000' , '26.229508196721' , '22' , '0' , '32.00' ) 14/10/2024 04:35: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 ( '93270' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:35: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 ( '93270' , '16689' , 'OSTIA PAN DI CENA mm80' , '8' , '-8' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '16.00' ) 14/10/2024 04:35: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 ( '93270' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '13.80' ) 14/10/2024 04:35: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 ( '93270' , '20437' , 'LUMINO BIANCO 10BTS000' , '70' , '-70' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '35.00' ) 14/10/2024 04:36:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2901' AND id_document != '93436' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-03') 14/10/2024 04:36:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2901', document_date = '2024-10-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '93436' 14/10/2024 04: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 = '93436' 14/10/2024 04:36:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93436' 14/10/2024 04: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 ( '93436' , '16983' , 'TELA 18X25 - SACRO CUORE' , '1' , '-1' , '1' , '9.5000' , '7.7868852459016' , '22' , '0' , '9.50' ) 14/10/2024 04: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 ( '93436' , '20437' , 'LUMINO BIANCO 10BTS000' , '71' , '-71' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '35.50' ) 14/10/2024 04:37:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2940' AND id_document != '93489' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-07') 14/10/2024 04:37:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2940', document_date = '2024-10-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '93489' 14/10/2024 04:37:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93489' 14/10/2024 04:37:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '93489' 14/10/2024 04:37:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93489' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '3.60' ) 14/10/2024 04:37:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93489' , '20437' , 'LUMINO BIANCO 10BTS000' , '51' , '-51' , '1' , '0.4' , '0.32786885245902' , '22' , '0' , '20.40' ) 14/10/2024 04:37:33 pm >> DELETE FROM ps_document WHERE id_document = '93576' 14/10/2024 04:37:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93576' 14/10/2024 04:50:17 pm >> 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') 14/10/2024 04:50:17 pm >> 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' 14/10/2024 04:50: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 = '89371' 14/10/2024 04:50:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89371' 14/10/2024 04:50: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 ( '89371' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 14/10/2024 04:50: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 ( '89371' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 14/10/2024 04:50: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 ( '89371' , '18950' , 'DOV\'E\' FINITO IL CONCILIO? - F. CERRI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 14/10/2024 04:50: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 ( '89371' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/10/2024 04:50: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 ( '89371' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/10/2024 04:50: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 ( '89371' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/10/2024 04:50: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 ( '89371' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/10/2024 04:50: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 ( '89371' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 14/10/2024 04:50: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 ( '89371' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 14/10/2024 04:50: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 ( '89371' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/10/2024 04:50: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 ( '89371' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/10/2024 04:50: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 ( '89371' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/10/2024 04:50: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 ( '89371' , '10645' , 'TI AMO PER SEMPRE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 14/10/2024 04:50: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 ( '89371' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/10/2024 04:50: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 ( '89371' , '14260' , 'CUORE CHE BATTE - TORNARE AD AMARE IL CREATO' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/10/2024 04:50: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 ( '89371' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 14/10/2024 04:50: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 ( '89371' , '3511' , 'DIO PARLA ALL\'UOMO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '8974' , 'RIFORMA DELLA RIFORMA - A. SORRENTINO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '18718' , 'TUA VOCE IN ME - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 14/10/2024 04:50: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 ( '89371' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/10/2024 04:50: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 ( '89371' , '13137' , 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 14/10/2024 04:50: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 ( '89371' , '1379' , 'BRUGNOLI MUSICISTA E COMPOSITORE' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '0' , '9.00' ) 14/10/2024 04:50: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 ( '89371' , '20721' , 'AVE MARIA - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 14/10/2024 04:50: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 ( '89371' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 14/10/2024 04:50: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 ( '89371' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '0' , '8.00' ) 14/10/2024 04:50: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 ( '89371' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '19050' , 'VENITE ADORIAMO - G. D\'AMORE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 14/10/2024 04:50: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 ( '89371' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. D\'AMORE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 14/10/2024 04:50: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 ( '89371' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.5000' , '7.5' , '0' , '0' , '7.50' ) 14/10/2024 04:50: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 ( '89371' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 14/10/2024 04:50: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 ( '89371' , '9996' , 'SIGNORE, TI PREGO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 14/10/2024 04:50: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 ( '89371' , '20610' , 'SOLE ANCHE DI NOTTE - D. BLAIN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '22039' , 'VANGELO DI LUCA - G. ROSSE' , '1' , '-1' , '4' , '69.5000' , '69.5' , '0' , '0' , '69.50' ) 14/10/2024 04:50: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 ( '89371' , '22043' , 'MATTEO - R. FABRIS' , '1' , '-1' , '4' , '48.0000' , '48' , '0' , '0' , '48.00' ) 14/10/2024 04:50: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 ( '89371' , '22044' , 'GIOVANNI - R.E. BROWN' , '1' , '-1' , '4' , '66.5000' , '66.5' , '0' , '0' , '66.50' ) 14/10/2024 04:50: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 ( '89371' , '10299' , 'STORIA DI UN\'ANIMA - 8203' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.0000' , '52' , '0' , '0' , '52.00' ) 14/10/2024 04:50: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 ( '89371' , '3596' , 'DIZIONARIO DI OMILETICA - SODI/TRICCA' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 14/10/2024 04:50: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 ( '89371' , '20985' , 'BIBBIA E LITURGIA - O. VEZZOLI' , '1' , '-1' , '4' , '33.0000' , '33' , '0' , '0' , '33.00' ) 14/10/2024 04:50: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 ( '89371' , '17421' , 'DIALOGO DELLA DIVINA PROVVIDENZA ' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 14/10/2024 04:50: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 ( '89371' , '19054' , 'GRANDE LIBRO DELLE FIABE' , '1' , '-1' , '4' , '39.0000' , '39' , '0' , '0' , '39.00' ) 14/10/2024 04:50: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 ( '89371' , '10565' , 'TEOLOGIA DELLA LITURGIA - J. RATZINGER' , '1' , '-1' , '4' , '55.0000' , '55' , '0' , '0' , '55.00' ) 14/10/2024 04:50: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 ( '89371' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 14/10/2024 04:50: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 ( '89371' , '22170' , 'PREGHIERA DEL CUORE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 14/10/2024 04:50: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 ( '89371' , '15122' , 'PREGHIERE PER OGNI GIORNO DELL\'ANNO - 8738' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 14/10/2024 04:50: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 ( '89371' , '19326' , 'SUL DOLORE - P. CURTAZ' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 14/10/2024 04:50: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 ( '89371' , '13132' , 'IDEA DI RIVELAZIONE - OPERA OMNIA - RATZINGER' , '1' , '-1' , '4' , '75.0000' , '75' , '0' , '0' , '75.00' ) 14/10/2024 04:50: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 ( '89371' , '14418' , 'MISSALE ROMANUM EDITIO TERTIA' , '1' , '-1' , '4' , '200.0000' , '200' , '0' , '0' , '200.00' ) 14/10/2024 04:50: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 ( '89371' , '3733' , 'E DANZANDO CANTERANNO VAL.' , '1' , '-1' , '4' , '48.00' , '48' , '0' , '0' , '48.00' ) 14/10/2024 04:50: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 ( '89371' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '857.5' , '857.5' , '0' , '0' , '857.50' ) 14/10/2024 05:20:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 05:20:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3037' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 14/10/2024 05:20: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 = '93616' 14/10/2024 05:20:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93616' 14/10/2024 05:20: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 ( '93616' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 14/10/2024 05:20: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 ( '93616' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 14/10/2024 05:21:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 05:21:35 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' , '3038' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '76.92' , NOW() , NOW() ) 14/10/2024 05:21: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 = '93617' 14/10/2024 05:21:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '93617' 14/10/2024 05:21: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 ( '93617' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 14/10/2024 05:21: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 ( '93617' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 14/10/2024 05:51:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 05:51:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '153' , '2024-10-14' , '' , '3931' , '0' , '4679347' , 'VIALE DELLA LIBERA 11 80079 PROCIDA' , '' , '' , '12.75' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '170.00' , '170.00' , NOW() , NOW() ) 14/10/2024 05:51:26 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 = '93618' 14/10/2024 05:51:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '93618' 14/10/2024 05:51:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93618' , '21899' , 'SACRA BIBBIA cei/uelci ' , '10' , '-10' , '4' , '18.50' , '18.5' , '0' , '15' , '157.25' ) 14/10/2024 06:01:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '3039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 06:01:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3039' , '2024-10-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.03' , '9.03' , NOW() , NOW() ) 14/10/2024 06:01:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93619' 14/10/2024 06:01:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '93619' 14/10/2024 06:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93619' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 14/10/2024 06:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93619' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 14/10/2024 07:04:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 14/10/2024 07:04:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '154' , '2024-10-14' , '' , '1632' , '0' , '4679142' , 'P.ZZA PLEBISCITO, 11 84030 SANZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '81.70' , '81.70' , NOW() , NOW() ) 14/10/2024 07:04: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 = '93620' 14/10/2024 07:04:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93620' 14/10/2024 07:04: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 ( '93620' , '4154' , 'FESTA DEL PERDONO' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 14/10/2024 07:04: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 ( '93620' , '4480' , 'GESÙ MIO AMICO - VOL. 2°' , '7' , '-7' , '4' , '2.00' , '2' , '0' , '5' , '13.30' ) 14/10/2024 07:04: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 ( '93620' , '8408' , 'PRENDETE E MANGIATE' , '19' , '-19' , '4' , '3.00' , '3' , '0' , '5' , '54.15' )