26/07/2023 09:11:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2483' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 09:11: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 ( '11' , '2483' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 26/07/2023 09:11: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 = '86874' 26/07/2023 09:11:33 am >> DELETE FROM ps_document_detail WHERE id_document = '86874' 26/07/2023 09:11: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 ( '86874' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 26/07/2023 09:15:52 am >> SELECT document_num FROM ps_document WHERE document_num = '2484' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 09:15:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2484' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.50' , '35.33' , NOW() , NOW() ) 26/07/2023 09:15:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86875' 26/07/2023 09:15:52 am >> DELETE FROM ps_document_detail WHERE id_document = '86875' 26/07/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86875' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '-2' , '1' , '19.50' , '15.983606557377' , '22' , '0' , '39.00' ) 26/07/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86875' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 26/07/2023 09:16:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2485' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 09:16: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' , '2485' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 26/07/2023 09:16: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 = '86876' 26/07/2023 09:16:04 am >> DELETE FROM ps_document_detail WHERE id_document = '86876' 26/07/2023 09:16: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 ( '86876' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 26/07/2023 09:33:07 am >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '85832' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-13') 26/07/2023 09:33:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '26', document_date = '2023-06-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = 'RESA AL FORNITORE - N. C. RICEVUTA', 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 = '237.50', price_tax_excluded = '237.50', date_upd = NOW() WHERE id_document = '85832' 26/07/2023 09:33: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 = '85832' 26/07/2023 09:33:07 am >> DELETE FROM ps_document_detail WHERE id_document = '85832' 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13369' , 'CRISTO, MARIA, LA CHIESA E I POPOLI - C.M. GALLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13370' , 'CAMMINARE NELLAMORE - FUMAGALLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '13371' , 'VOLTI, GESTI E LUOGHI - L. CASULA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '18622' , 'FRATERNITA SEGNO DEI TEMPI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16719' , 'INTRODUZIONE ALLA FILOSOFIA - A. MELI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '19356' , 'SCIOGLIMENTO DEL MATRIMONIO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '20578' , 'TOTUM AMORIS EST ' , '23' , '-23' , '4' , '2.0000' , '2' , '0' , '0' , '46.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16269' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '17578' , 'CIELO SULLA TERRA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '18514' , 'SOGNO DELLA FRATERNITA UNIVERSALE - E. SCOGNAMIGLIO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '4430' , 'GESÙ DI NAZARET: DALLINGRESSO IN GERUSALEMME... - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '5966' , 'LUCE DEL MONDO - BENEDETTO XVI ' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '17660' , 'PAPA FRANCESCO UN UOMO DI PAROLA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 26/07/2023 09:33:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85832' , '16715' , 'SACRAMENTO DELLA CONFESSIONE - R. MARTINELLI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 26/07/2023 09:33:26 am >> SELECT document_num FROM ps_document WHERE document_num = '27' AND id_document != '85833' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-13') 26/07/2023 09:33:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '27', document_date = '2023-06-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2686', address1 = 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO', address2 = '', note = 'RESO GUASTO AL FORNITORE - N. C. RICEVUTA', 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 = '60.00', price_tax_excluded = '60.00', date_upd = NOW() WHERE id_document = '85833' 26/07/2023 09:33:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85833' 26/07/2023 09:33:26 am >> DELETE FROM ps_document_detail WHERE id_document = '85833' 26/07/2023 09:33:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85833' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '-1' , '4' , '60.0000' , '60' , '0' , '0' , '60.00' ) 26/07/2023 10:08:19 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '86599' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-01') 26/07/2023 10:08:19 am >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2023-07-01', document_letter = 'A', id_customer = '1203', id_supplier = '', id_address = '4669427', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '458.40', price_tax_excluded = '380.70', date_upd = NOW() WHERE id_document = '86599' 26/07/2023 10:08:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86599' 26/07/2023 10:08:19 am >> DELETE FROM ps_document_detail WHERE id_document = '86599' 26/07/2023 10:08:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86599' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 26/07/2023 10:08: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 ( '86599' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 26/07/2023 10:08: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 ( '86599' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '270.00' ) 26/07/2023 10:08: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 ( '86599' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '56.00' ) 26/07/2023 10:08: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 ( '86599' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49.4' , '40.491803278689' , '22' , '0' , '49.40' ) 26/07/2023 10:13:36 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2023 10:13:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21447' , '1' , '' , 'nuovo-prodotto' ) 26/07/2023 10:13:36 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21447' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2023 10:13:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21447' , '0' , '1' , '0' , '0' ) 26/07/2023 10:16:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000471' AND id_product != '21447' AND ean13 != '' 26/07/2023 10:16:43 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000471', date_upd = NOW() WHERE id_product = '21447' 26/07/2023 10:16:43 am >> UPDATE ps_product_lang SET name = 'FAZZOLETTO TULLE ', description = '' WHERE id_product = '21447' 26/07/2023 10:16:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.09836065573771' WHERE id_product = '21447' 26/07/2023 10:16:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.09836065573771', id_tax_rules_group = '1', id_category_default = '411', 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 = '21447' 26/07/2023 10:16:43 am >> DELETE FROM ps_specific_price WHERE id_product = '21447' 26/07/2023 10:20:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002075' AND id_product != '20469' AND ean13 != '' 26/07/2023 10:20:50 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002075', date_upd = NOW() WHERE id_product = '20469' 26/07/2023 10:20:50 am >> UPDATE ps_product_lang SET name = 'CINGOLO - CING34 ', description = '' WHERE id_product = '20469' 26/07/2023 10:20:51 am >> UPDATE ps_product SET wholesale_price = '13.91', on_sale = '0', price = '28.6885' WHERE id_product = '20469' 26/07/2023 10:20:51 am >> UPDATE ps_product_shop SET wholesale_price = '13.91', price = '28.6885', id_tax_rules_group = '1', id_category_default = '411', 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 = '20469' 26/07/2023 10:20:51 am >> DELETE FROM ps_specific_price WHERE id_product = '20469' 26/07/2023 10:24:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001322' AND id_product != '16456' AND ean13 != '' 26/07/2023 10:24:29 am >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = '001322', date_upd = NOW() WHERE id_product = '16456' 26/07/2023 10:24:29 am >> UPDATE ps_product_lang SET name = 'CINGOLO - CING03', description = '' WHERE id_product = '16456' 26/07/2023 10:24:29 am >> UPDATE ps_product SET wholesale_price = '5.56', on_sale = '0', price = '12.295081967213115' WHERE id_product = '16456' 26/07/2023 10:24:30 am >> UPDATE ps_product_shop SET wholesale_price = '5.56', price = '12.295081967213115', id_tax_rules_group = '1', id_category_default = '411', 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 = '16456' 26/07/2023 10:24:30 am >> DELETE FROM ps_specific_price WHERE id_product = '16456' 26/07/2023 10:26:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'B225/CA' AND id_product != '19861' AND ean13 != '' 26/07/2023 10:26:13 am >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'B225/CA', date_upd = NOW() WHERE id_product = '19861' 26/07/2023 10:26:13 am >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B225/CA', description = '' WHERE id_product = '19861' 26/07/2023 10:26:13 am >> UPDATE ps_product SET wholesale_price = '8.82', on_sale = '0', price = '18.852459016393443' WHERE id_product = '19861' 26/07/2023 10:26:13 am >> UPDATE ps_product_shop SET wholesale_price = '8.82', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '411', 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 = '19861' 26/07/2023 10:26:13 am >> DELETE FROM ps_specific_price WHERE id_product = '19861' 26/07/2023 10:27:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'B18/FE' AND id_product != '16271' AND ean13 != '' 26/07/2023 10:27:20 am >> UPDATE ps_product SET id_supplier = '95', reference = '', ean13 = 'B18/FE', date_upd = NOW() WHERE id_product = '16271' 26/07/2023 10:27:20 am >> UPDATE ps_product_lang SET name = 'FERMAGLIO ORO - B18/FE', description = '' WHERE id_product = '16271' 26/07/2023 10:27:20 am >> UPDATE ps_product SET wholesale_price = '5.42', on_sale = '0', price = '11.885245901639344' WHERE id_product = '16271' 26/07/2023 10:27:20 am >> UPDATE ps_product_shop SET wholesale_price = '5.42', price = '11.885245901639344', id_tax_rules_group = '1', id_category_default = '411', 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 = '16271' 26/07/2023 10:27:20 am >> DELETE FROM ps_specific_price WHERE id_product = '16271' 26/07/2023 10:28:00 am >> 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 = '16271' 26/07/2023 10:28:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21448' , '1' , '' , 'nuovo-prodotto' ) 26/07/2023 10:28:00 am >> 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 '21448' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '16271' 26/07/2023 10:28:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21448' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '16271' 26/07/2023 10:29:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'B170/CA' AND id_product != '21448' AND ean13 != '' 26/07/2023 10:29:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'B170/CA', date_upd = NOW() WHERE id_product = '21448' 26/07/2023 10:29:06 am >> UPDATE ps_product_lang SET name = 'FERMAGLIO - B170/CA', description = '' WHERE id_product = '21448' 26/07/2023 10:29:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '21448' 26/07/2023 10:29:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '411', 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 = '21448' 26/07/2023 10:29:06 am >> DELETE FROM ps_specific_price WHERE id_product = '21448' 26/07/2023 10:31:02 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 26/07/2023 10:31:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21449' , '1' , '' , 'nuovo-prodotto' ) 26/07/2023 10:31:02 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21449' , '1' , '1' , '2' , NOW() , NOW() ) 26/07/2023 10:31:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21449' , '0' , '1' , '0' , '0' ) 26/07/2023 10:31:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = 'P472' AND id_product != '21449' AND ean13 != '' 26/07/2023 10:31:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'P472', date_upd = NOW() WHERE id_product = '21449' 26/07/2023 10:31:53 am >> UPDATE ps_product_lang SET name = 'BALZA MARIANA - P472', description = '' WHERE id_product = '21449' 26/07/2023 10:31:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '21449' 26/07/2023 10:31:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '411', 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 = '21449' 26/07/2023 10:31:53 am >> DELETE FROM ps_specific_price WHERE id_product = '21449' 26/07/2023 10:32:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000471' AND id_product != '21447' AND ean13 != '' 26/07/2023 10:32:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000471', date_upd = NOW() WHERE id_product = '21447' 26/07/2023 10:32:48 am >> UPDATE ps_product_lang SET name = 'VELO TULLE ', description = '' WHERE id_product = '21447' 26/07/2023 10:32:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.0984' WHERE id_product = '21447' 26/07/2023 10:32:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.0984', id_tax_rules_group = '1', id_category_default = '411', 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 = '21447' 26/07/2023 10:32:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21447' 26/07/2023 10:33:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '354' , '2023-07-20' , '' , '0' , '95' , '2757' , 'VIA A. POLENGHI, 97 26845 CODOGNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '487.23' , '399.37' , NOW() , NOW() ) 26/07/2023 10:33:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86877' 26/07/2023 10:33:28 am >> DELETE FROM ps_document_detail WHERE id_document = '86877' 26/07/2023 10:33:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '21447' , 'VELO TULLE ' , '6' , '6' , '1' , '24.8' , '20.327868852459' , '22' , '3' , '176.0899' ) 26/07/2023 10:33:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '21447' AND id_supplier = '95' 26/07/2023 10:33:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21447' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '20469' , 'CINGOLO - CING34 ' , '1' , '1' , '1' , '14.34' , '11.754098360656' , '22' , '3' , '16.9700' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '20469' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20469' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '16456' , 'CINGOLO - CING03' , '5' , '5' , '1' , '6.15' , '5.0409836065574' , '22' , '3' , '36.3895' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16456' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16456' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '19861' , 'FERMAGLIO - B225/CA' , '3' , '3' , '1' , '9.58' , '7.8524590163934' , '22' , '3' , '34.0109' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '19861' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19861' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '16271' , 'FERMAGLIO ORO - B18/FE' , '3' , '3' , '1' , '6.02' , '4.9344262295082' , '22' , '3' , '21.3722' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '16271' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16271' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '21448' , 'FERMAGLIO - B170/CA' , '3' , '3' , '1' , '15.97' , '13.090163934426' , '22' , '3' , '56.6967' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21448' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21448' , '95' , '1' ) 26/07/2023 10:33:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86877' , '21449' , 'BALZA MARIANA - P472' , '13.5' , '13.5' , '1' , '9.12' , '7.4754098360656' , '22' , '3' , '145.7002' ) 26/07/2023 10:33:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '21449' AND id_supplier = '95' 26/07/2023 10:33:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21449' , '95' , '1' ) 26/07/2023 11:05:06 am >> SELECT document_num FROM ps_document WHERE document_num = '79/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 11:05:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '79/A' , '2023-07-26' , 'A' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '17.50' , NOW() , NOW() ) 26/07/2023 11:05:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86878' 26/07/2023 11:05:06 am >> DELETE FROM ps_document_detail WHERE id_document = '86878' 26/07/2023 11:05:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86878' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.70' , '0.7' , '0' , '0' , '17.50' ) 26/07/2023 11:24:45 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' , '1/2808' , '2023-07-03' , '2808' , '0' , '131' , '4670575' , 'VIA RAFFAELE RUGGI, 29 80125 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '110.86' , '90.87' , NOW() , NOW() ) 26/07/2023 11:24:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86879' 26/07/2023 11:24:45 am >> DELETE FROM ps_document_detail WHERE id_document = '86879' 26/07/2023 11:24:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86879' , '15801' , 'ARGENTO A PESO' , '10' , '10' , '1' , '9.087' , '7.4483606557377' , '22' , '0' , '110.8614' ) 26/07/2023 11:24:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '15801' AND id_supplier = '131' 26/07/2023 11:24:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15801' , '131' , '1' ) 26/07/2023 11:26:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1651' AND id_document != '84320' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-13') 26/07/2023 11:26:04 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1651', document_date = '2023-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '101.00', price_tax_excluded = '85.70', date_upd = NOW() WHERE id_document = '84320' 26/07/2023 11:26: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 = '84320' 26/07/2023 11:26:04 am >> DELETE FROM ps_document_detail WHERE id_document = '84320' 26/07/2023 11:26: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 ( '84320' , '15801' , 'ARGENTO A PESO' , '10' , '-10' , '1' , '4.485' , '3.6762295081967' , '22' , '0' , '44.90' ) 26/07/2023 11:26: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 ( '84320' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '39.95' , '32.745901639344' , '22' , '0' , '39.95' ) 26/07/2023 11:26: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 ( '84320' , '19379' , 'MISTERI MARIANI' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 26/07/2023 11:32:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2486' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 11:32:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2486' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 26/07/2023 11:32:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86880' 26/07/2023 11:32:30 am >> DELETE FROM ps_document_detail WHERE id_document = '86880' 26/07/2023 11:32:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86880' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 26/07/2023 11:32:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86880' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 26/07/2023 12:15:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2487' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 12:15:32 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' , '2487' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '19.38' , NOW() , NOW() ) 26/07/2023 12:15:32 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 = '86881' 26/07/2023 12:15:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '86881' 26/07/2023 12:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86881' , '19104' , 'LUMINELLI A OLIO' , '9' , '-9' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '9.00' ) 26/07/2023 12:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86881' , '19702' , 'MADRE TERESA PARLA AL TUO CUORE - A. COMASTRI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 26/07/2023 12:15:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86881' , '20306' , 'RAGGI DI LUCE - A. COMASTRI' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '0' , '8.00' ) 26/07/2023 03:27:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2488' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 03:27:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2488' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '5.08' , NOW() , NOW() ) 26/07/2023 03:27:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86882' 26/07/2023 03:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86882' 26/07/2023 03:27:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86882' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 26/07/2023 04:33:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1631' AND id_document != '84299' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-12') 26/07/2023 04:33:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1631', document_date = '2023-05-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '84299' 26/07/2023 04:33:10 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 = '84299' 26/07/2023 04:33:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '84299' 26/07/2023 04:33:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84299' , '21377' , 'CASULA POLIESTERE IHS' , '2' , '-2' , '1' , '42.5' , '34.83606557377' , '22' , '0' , '85.00' ) 26/07/2023 04:33:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1635' AND id_document != '84303' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-12') 26/07/2023 04:33:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1635', document_date = '2023-05-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '141.83', date_upd = NOW() WHERE id_document = '84303' 26/07/2023 04:33:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84303' 26/07/2023 04:33:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '84303' 26/07/2023 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84303' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '99.00' ) 26/07/2023 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84303' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 26/07/2023 04:33:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84303' , '21377' , 'CASULA POLIESTERE IHS' , '1' , '-1' , '1' , '53.5' , '43.852459016393' , '22' , '0' , '53.50' ) 26/07/2023 04:33:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1737' AND id_document != '84423' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-19') 26/07/2023 04:33:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1737', document_date = '2023-05-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 = '60.00', price_tax_excluded = '49.72', date_upd = NOW() WHERE id_document = '84423' 26/07/2023 04:33: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 = '84423' 26/07/2023 04:33:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '84423' 26/07/2023 04:33:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84423' , '21377' , 'CASULA POLIESTERE IHS' , '1' , '-1' , '1' , '53.2' , '43.606557377049' , '22' , '0' , '53.20' ) 26/07/2023 04:33:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84423' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 26/07/2023 04:33:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84423' , '18803' , 'SANTA RITA DA CASCIA - 8046' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 26/07/2023 04:35:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1795' AND id_document != '84491' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-23') 26/07/2023 04:35:40 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1795', document_date = '2023-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '84.50', price_tax_excluded = '69.26', date_upd = NOW() WHERE id_document = '84491' 26/07/2023 04:35:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84491' 26/07/2023 04:35:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '84491' 26/07/2023 04:35: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 ( '84491' , '21376' , 'CASULA POL. LEGGERO - CS25L' , '2' , '-2' , '1' , '42.25' , '34.631147540984' , '22' , '0' , '84.50' ) 26/07/2023 05:05:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2435' AND id_document != '86818' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-19') 26/07/2023 05:05:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2435', document_date = '2023-07-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 = '245.00', price_tax_excluded = '200.82', date_upd = NOW() WHERE id_document = '86818' 26/07/2023 05:05:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86818' 26/07/2023 05:05:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '86818' 26/07/2023 05:05:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86818' , '21043' , 'STOLA IN LANA TESS. TELAIO - 75/1633' , '1' , '-1' , '1' , '245' , '200.81967213115' , '22' , '0' , '245.00' ) 26/07/2023 05:09:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1488' AND id_document != '84124' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-03') 26/07/2023 05:09:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1488', document_date = '2023-05-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 = '66.00', price_tax_excluded = '54.10', date_upd = NOW() WHERE id_document = '84124' 26/07/2023 05:09:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84124' 26/07/2023 05:09:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '84124' 26/07/2023 05:09: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 ( '84124' , '14368' , 'CLERGY NERO - COTONE - 38' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 26/07/2023 05:09: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 ( '84124' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 26/07/2023 05:09: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 ( '84124' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '60' , '-60' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '12.00' ) 26/07/2023 05:12:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '1137' AND id_document != '82658' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-04') 26/07/2023 05:12:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1137', document_date = '2023-04-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 = '263.00', price_tax_excluded = '217.92', date_upd = NOW() WHERE id_document = '82658' 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82658' 26/07/2023 05:12:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '82658' 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '0.6500' , '0.65' , '0' , '0' , '0.65' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '1' , '-1' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '15.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '14163' , 'PARACERA OTTONE LUCIDO - Q120' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '18036' , 'FERITE FERITOIE ' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '2123' , 'CLERGY BIANCO MM - MISTO 41' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '2151' , 'CLERGY BLU MM - COTONE 41 ' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '40' , '-40' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '12.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '2160' , 'CLERGY BLU MM - MISTO 44 ' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '2157' , 'CLERGY BLU MM - MISTO 41 ' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '11999' , 'CLERGY GRIGIO CHIARO ML - COTONE 40' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '18618' , 'MEDAGLIA SAN MICHELE - OV22/MC' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 26/07/2023 05:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82658' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 26/07/2023 05:23:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '86653' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-07-06') 26/07/2023 05:23:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '106', document_date = '2023-07-06', document_letter = '', id_customer = '690', id_supplier = '', id_address = '4670873', address1 = 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO', address2 = '', note = '', price_shipping = '0', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '42.00', price_tax_excluded = '42.00', date_upd = NOW() WHERE id_document = '86653' 26/07/2023 05:23:13 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 = '86653' 26/07/2023 05:23:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86653' 26/07/2023 05:23:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86653' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '0' , '42.00' ) 26/07/2023 06:11:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2489' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 06:11:28 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' , '2489' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 26/07/2023 06:11:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86883' 26/07/2023 06:11:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '86883' 26/07/2023 06:11:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86883' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 26/07/2023 06:11:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86883' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 26/07/2023 06:49:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2490' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 06:49: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' , '2490' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '10.98' , NOW() , NOW() ) 26/07/2023 06:49: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 = '86884' 26/07/2023 06:49:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '86884' 26/07/2023 06:49: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 ( '86884' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 26/07/2023 06:49: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 ( '86884' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 26/07/2023 06:49: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 ( '86884' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 26/07/2023 07:13:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253322' AND id_product != '21068' AND ean13 != '' 26/07/2023 07:13:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/4', ean13 = '9791281253322', date_upd = NOW() WHERE id_product = '21068' 26/07/2023 07:13:35 pm >> UPDATE ps_product_lang SET name = 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2023', description = '' WHERE id_product = '21068' 26/07/2023 07:13:35 pm >> UPDATE ps_product SET wholesale_price = '4.20', on_sale = '0', price = '6.0000' WHERE id_product = '21068' 26/07/2023 07:13:35 pm >> UPDATE ps_product_shop SET wholesale_price = '4.20', price = '6.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21068' 26/07/2023 07:13:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21068' 26/07/2023 07:14:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2491' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 07:14:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2491' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 26/07/2023 07:14:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86885' 26/07/2023 07:14:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '86885' 26/07/2023 07:14:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86885' , '21068' , 'MESSALINO QUOTIDIANO - AGO/SET/OTT 2023' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 26/07/2023 07:40:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2492' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-26') 26/07/2023 07:40:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2492' , '2023-07-26' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 26/07/2023 07:40:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86886' 26/07/2023 07:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '86886' 26/07/2023 07:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86886' , '1220' , 'BICCHIERI FLAMBEAUX - PZ. 50' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 26/07/2023 07:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86886' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' )