08/11/2023 08:59:46 am >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 08/11/2023 08:59:46 am >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '110.10', price_tax_excluded = '110.10', date_upd = NOW() WHERE id_document = '81317' 08/11/2023 08:59: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 = '81317' 08/11/2023 08:59:46 am >> DELETE FROM ps_document_detail WHERE id_document = '81317' 08/11/2023 08:59: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 ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 08/11/2023 08:59: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 ( '81317' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 08/11/2023 08:59: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 ( '81317' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 08/11/2023 08:59: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 ( '81317' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 08/11/2023 08:59: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 ( '81317' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 08/11/2023 08:59: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 ( '81317' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 08/11/2023 08:59: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 ( '81317' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 08/11/2023 08:59: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 ( '81317' , '21708' , 'TU SEI SPECIALE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 08/11/2023 08:59: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 ( '81317' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 08/11/2023 08:59: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 ( '81317' , '21783' , 'NATALE DEL CUORE - A.M. CANOPI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 08/11/2023 09:13:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3496' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 09:13:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3496' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.90' , '60.17' , NOW() , NOW() ) 08/11/2023 09:13:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88803' 08/11/2023 09:13:14 am >> DELETE FROM ps_document_detail WHERE id_document = '88803' 08/11/2023 09:13:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88803' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 08/11/2023 09:13:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88803' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/11/2023 09:13:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88803' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 08/11/2023 09:32:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3497' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 09:32:58 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' , '3497' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 08/11/2023 09:32:58 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 = '88804' 08/11/2023 09:32:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88804' 08/11/2023 09:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88804' , '18885' , 'BAMBINELLO CM 23 - PB9942' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 08/11/2023 09:48:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3498' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 09:48: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' , '3498' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 08/11/2023 09:48: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 = '88805' 08/11/2023 09:48:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88805' 08/11/2023 09:48: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 ( '88805' , '21775' , 'AMORE VINCE - C. AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 08/11/2023 09:48: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 ( '88805' , '21772' , 'UNA VOCE CI GUIDA - 3/6 ANNI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 08/11/2023 10:05:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3499' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 10:05:49 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' , '3499' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '27.87' , NOW() , NOW() ) 08/11/2023 10:05:49 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 = '88806' 08/11/2023 10:05:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88806' 08/11/2023 10:05:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88806' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34' , '27.868852459016' , '22' , '0' , '34.00' ) 08/11/2023 10:26:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3487' AND id_document != '88777' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 08/11/2023 10:26:15 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3487', document_date = '2023-11-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '109.03', price_tax_excluded = '105.05', date_upd = NOW() WHERE id_document = '88777' 08/11/2023 10:26:15 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 = '88777' 08/11/2023 10:26:15 am >> DELETE FROM ps_document_detail WHERE id_document = '88777' 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '19891' , 'FATTI PER LETERNITA - F. SHEEN' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '20974' , 'COSE E LA MESSA? R. CASTILLO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '21745' , 'VENUTA DI DIO - F. KAMPHAUS' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '14487' , 'PREGHIERA DELLE 5 DITA' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '0' , '6.00' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '5429' , 'IO CREDO RISORGERÒ - VISSANI/PICCOTTI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '5570' , 'LAUDATO SÌ ' , '1' , '-1' , '4' , '1.5' , '1.5' , '0' , '0' , '1.50' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '17854' , 'MISERICORDIA PER IL CUORE - A. COMASTRI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '5823' , 'LIBRO DORO' , '5' , '-5' , '4' , '0.6000' , '0.6' , '0' , '0' , '3.00' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '18923' , 'CI SARANNO SANTI TRA I BAMBINI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 08/11/2023 10:26:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88777' , '14120' , 'GESU\' MISERICORDIOSO - ARS 7X12' , '100' , '-100' , '1' , '0.1300' , '0.10655737704918' , '22' , '0' , '13.00' ) 08/11/2023 10:44:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3500' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 10:44:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3500' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.50' , '45.22' , NOW() , NOW() ) 08/11/2023 10:44:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88807' 08/11/2023 10:44:34 am >> DELETE FROM ps_document_detail WHERE id_document = '88807' 08/11/2023 10:44:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88807' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 08/11/2023 10:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88807' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 08/11/2023 10:44:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88807' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/11/2023 10:47:38 am >> SELECT document_num FROM ps_document WHERE document_num = '17/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 10:47:38 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' , '17/L' , '2023-11-08' , 'L' , '3804' , '0' , '4672783' , 'VIA BASTIONI, 4 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '396.00' , '396.00' , NOW() , NOW() ) 08/11/2023 10:47:38 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 = '88808' 08/11/2023 10:47:38 am >> DELETE FROM ps_document_detail WHERE id_document = '88808' 08/11/2023 10:47:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88808' , '21784' , 'NON DISTOGLIERE LO SGUARDO DAL POVERO' , '200' , '-200' , '4' , '2.20' , '2.2' , '0' , '10' , '396.00' ) 08/11/2023 10:49:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3501' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 10:49: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' , '3501' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.50' , '19.26' , NOW() , NOW() ) 08/11/2023 10:49: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 = '88809' 08/11/2023 10:49:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88809' 08/11/2023 10:49:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88809' , '18096' , 'QUADRETTO LACCATO - 2942' , '1' , '-1' , '1' , '23.50' , '19.262295081967' , '22' , '0' , '23.50' ) 08/11/2023 11:12:58 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/11/2023 11:12:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21789' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 11:12:58 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21789' , '1' , '1' , '2' , NOW() , NOW() ) 08/11/2023 11:12:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21789' , '0' , '1' , '0' , '0' ) 08/11/2023 11:33:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3502' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 11:33:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3502' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 08/11/2023 11:33: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 = '88810' 08/11/2023 11:33:19 am >> DELETE FROM ps_document_detail WHERE id_document = '88810' 08/11/2023 11:33: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 ( '88810' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 08/11/2023 11:33: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 ( '88810' , '20793' , 'GRANDI DELLA BIBBIA - C. MARTINI' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 08/11/2023 11:36:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3503' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 11:36:36 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' , '3503' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 08/11/2023 11:36: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 = '88811' 08/11/2023 11:36:36 am >> DELETE FROM ps_document_detail WHERE id_document = '88811' 08/11/2023 11:36: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 ( '88811' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 08/11/2023 11:51:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3504' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 11:51:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3504' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.49' , '38.49' , NOW() , NOW() ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88812' 08/11/2023 11:51:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88812' 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/11/2023 11:51:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88812' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 08/11/2023 12:07:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3505' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:07:58 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' , '3505' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '254.51' , '254.51' , NOW() , NOW() ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88813' 08/11/2023 12:07:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88813' 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.00' , '99' , '0' , '5' , '94.05' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '5' , '1.81' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '11022' , 'VANGELI TRADOTTI E COMMENTATI' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '5' , '61.75' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '8278' , 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO C' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '8277' , 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO B' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 08/11/2023 12:07:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88813' , '8276' , 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO A' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 08/11/2023 12:14:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3506' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:14: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' , '3506' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 08/11/2023 12:14: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 = '88814' 08/11/2023 12:14:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '88814' 08/11/2023 12:14: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 ( '88814' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 08/11/2023 12:16:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:16:08 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' , '245' , '2023-11-08' , '' , '2757' , '0' , '4671725' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '114.24' , '114.24' , NOW() , NOW() ) 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88815' 08/11/2023 12:16:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88815' 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88815' , '2679' , 'CONOSCERE GESU\'' , '19' , '-19' , '4' , '3.50' , '3.5' , '0' , '15' , '56.52' ) 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88815' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '16' , '-16' , '4' , '3.40' , '3.4' , '0' , '15' , '46.24' ) 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88815' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88815' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 08/11/2023 12:16:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88815' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 08/11/2023 12:18:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3507' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:18: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' , '3507' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '209.00' , '209.00' , NOW() , NOW() ) 08/11/2023 12:18: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 = '88816' 08/11/2023 12:18:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '88816' 08/11/2023 12:18: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 ( '88816' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 08/11/2023 12:18: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 ( '88816' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '14' , '-14' , '4' , '5.00' , '5' , '0' , '5' , '66.50' ) 08/11/2023 12:18: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 ( '88816' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '13' , '-13' , '4' , '5.00' , '5' , '0' , '5' , '61.75' ) 08/11/2023 12:21:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3508' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:21:11 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' , '3508' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '3.60' , NOW() , NOW() ) 08/11/2023 12:21:11 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 = '88817' 08/11/2023 12:21:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '88817' 08/11/2023 12:21:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88817' , '21677' , 'LAUDATE DEUM ' , '3' , '-3' , '4' , '1.20' , '1.2' , '0' , '0' , '3.60' ) 08/11/2023 12:23:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '246' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:23: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 ( '21' , '246' , '2023-11-08' , '' , '3992' , '0' , '4677901' , 'VIA CHIESA 84090 MONTECORVINO PUGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '121.38' , '121.38' , NOW() , NOW() ) 08/11/2023 12:23: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 = '88818' 08/11/2023 12:23:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88818' 08/11/2023 12:23: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 ( '88818' , '13397' , 'MIO GESU\'' , '12' , '-12' , '4' , '3.50' , '3.5' , '0' , '15' , '35.70' ) 08/11/2023 12:23: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 ( '88818' , '5457' , 'IO SONO CON VOI 1 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 08/11/2023 12:23: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 ( '88818' , '5458' , 'IO SONO CON VOI 2 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 08/11/2023 12:23: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 ( '88818' , '11191' , 'VENITE CON ME 1 PARTE' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 08/11/2023 12:23: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 ( '88818' , '11192' , 'VENITE CON ME 2 PARTE' , '8' , '-8' , '4' , '2.80' , '2.8' , '0' , '15' , '19.04' ) 08/11/2023 12:23: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 ( '88818' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '7' , '-7' , '4' , '2.40' , '2.4' , '0' , '15' , '14.28' ) 08/11/2023 12:23:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3509' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:23:34 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' , '3509' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.50' , NOW() , NOW() ) 08/11/2023 12:23:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88819' 08/11/2023 12:23:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '88819' 08/11/2023 12:23: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 ( '88819' , '11193' , 'VENITE CON ME CAT.' , '1' , '-1' , '4' , '5.25' , '5.25' , '0' , '0' , '5.25' ) 08/11/2023 12:23: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 ( '88819' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.25' , '5.25' , '0' , '0' , '5.25' ) 08/11/2023 12:24:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '245' AND id_document != '88815' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:24:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '245', document_date = '2023-11-08', document_letter = '', id_customer = '2757', id_supplier = '', id_address = '4671725', address1 = 'VIA CIRILLO 84085 MERCATO SAN SEVERINO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '114.24', price_tax_excluded = '114.24', date_upd = NOW() WHERE id_document = '88815' 08/11/2023 12:24: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 = '88815' 08/11/2023 12:24:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88815' 08/11/2023 12:24: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 ( '88815' , '2679' , 'CONOSCERE GESU\'' , '19' , '-19' , '4' , '3.5000' , '3.5' , '0' , '15' , '56.52' ) 08/11/2023 12:24: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 ( '88815' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '16' , '-16' , '4' , '3.4000' , '3.4' , '0' , '15' , '46.24' ) 08/11/2023 12:24: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 ( '88815' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 08/11/2023 12:24: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 ( '88815' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 08/11/2023 12:24: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 ( '88815' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 08/11/2023 12:35:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3510' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:35:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3510' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 08/11/2023 12:35:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88820' 08/11/2023 12:35:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88820' 08/11/2023 12:35:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88820' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '30.00' ) 08/11/2023 12:44:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3511' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 12:44:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3511' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '8.85' , NOW() , NOW() ) 08/11/2023 12:44:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88821' 08/11/2023 12:44:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88821' 08/11/2023 12:44:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88821' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 08/11/2023 12:44:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88821' , '14624' , 'SANTA TERESA BABY - 023 STH/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 08/11/2023 12:48:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3255' AND id_document != '88431' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-19') 08/11/2023 12:48:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3255', document_date = '2023-10-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 = '115.00', price_tax_excluded = '102.02', date_upd = NOW() WHERE id_document = '88431' 08/11/2023 12:48: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 = '88431' 08/11/2023 12:48:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88431' 08/11/2023 12:48: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 ( '88431' , '19863' , 'FERMAGLIO - 21399/FE' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 08/11/2023 12:48: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 ( '88431' , '19795' , 'STOLA IN ASSISI CON RICAMO - 633' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 08/11/2023 12:48: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 ( '88431' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '24' , '24' , '0' , '0' , '24.00' ) 08/11/2023 12:48: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 ( '88431' , '21195' , 'IO MA NON PIU IO - P. G. FRASSATI - P. ASOLAN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 08/11/2023 12:50:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019186' AND id_product != '8278' AND ean13 != '' 08/11/2023 12:50:22 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/7', ean13 = '9788825019186', date_upd = NOW() WHERE id_product = '8278' 08/11/2023 12:50:22 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO C', description = '' WHERE id_product = '8278' 08/11/2023 12:50:22 pm >> UPDATE ps_product SET wholesale_price = '14.00', on_sale = '0', price = '20.0000' WHERE id_product = '8278' 08/11/2023 12:50:22 pm >> UPDATE ps_product_shop SET wholesale_price = '14.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8278' 08/11/2023 12:50:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '8278' 08/11/2023 12:50:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019179' AND id_product != '8277' AND ean13 != '' 08/11/2023 12:50:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/7', ean13 = '9788825019179', date_upd = NOW() WHERE id_product = '8277' 08/11/2023 12:50:35 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO B', description = '' WHERE id_product = '8277' 08/11/2023 12:50:35 pm >> UPDATE ps_product SET wholesale_price = '14.00', on_sale = '0', price = '20.0000' WHERE id_product = '8277' 08/11/2023 12:50:35 pm >> UPDATE ps_product_shop SET wholesale_price = '14.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8277' 08/11/2023 12:50:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '8277' 08/11/2023 12:50:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825019155' AND id_product != '8276' AND ean13 != '' 08/11/2023 12:50:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/7', ean13 = '9788825019155', date_upd = NOW() WHERE id_product = '8276' 08/11/2023 12:50:46 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA DEI FEDELI NEI GIORNI FESTIVI - ANNO A', description = '' WHERE id_product = '8276' 08/11/2023 12:50:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20.0000' WHERE id_product = '8276' 08/11/2023 12:50:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8276' 08/11/2023 12:50:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '8276' 08/11/2023 01:04:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3512' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 01:04:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3512' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.86' , '20.86' , NOW() , NOW() ) 08/11/2023 01:04: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 = '88822' 08/11/2023 01:04:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '88822' 08/11/2023 01:04: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 ( '88822' , '15610' , 'MAMMA E PAPA A CATECHISMO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 08/11/2023 01:04: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 ( '88822' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '2' , '-2' , '4' , '5.25' , '5.25' , '0' , '0' , '10.50' ) 08/11/2023 01:04: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 ( '88822' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 08/11/2023 02:38:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934185112' AND id_product != '21789' AND ean13 != '' 08/11/2023 02:38:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934185112', date_upd = NOW() WHERE id_product = '21789' 08/11/2023 02:38:51 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CON CUSCINO CM 15 - PB18511', description = '' WHERE id_product = '21789' 08/11/2023 02:38:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '21789' 08/11/2023 02:38:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '458', 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 = '21789' 08/11/2023 02:38:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21789' 08/11/2023 02:38:52 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 = '21789' 08/11/2023 02:38:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21790' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:38:52 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 '21790' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21789' 08/11/2023 02:38:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21790' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21789' 08/11/2023 02:40:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934168320' AND id_product != '21790' AND ean13 != '' 08/11/2023 02:40:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934168320', date_upd = NOW() WHERE id_product = '21790' 08/11/2023 02:40:45 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 20 - PB16832', description = '' WHERE id_product = '21790' 08/11/2023 02:40:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.573770491803279' WHERE id_product = '21790' 08/11/2023 02:40:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '458', 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 = '21790' 08/11/2023 02:40:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '21790' 08/11/2023 02:41:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934168320' AND id_product != '21790' AND ean13 != '' 08/11/2023 02:41:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934168320', date_upd = NOW() WHERE id_product = '21790' 08/11/2023 02:41:51 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 20 - PB16832', description = '' WHERE id_product = '21790' 08/11/2023 02:41:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '21790' 08/11/2023 02:41:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '458', 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 = '21790' 08/11/2023 02:41:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21790' 08/11/2023 02:42:19 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/11/2023 02:42:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21791' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:42:19 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21791' , '1' , '1' , '2' , NOW() , NOW() ) 08/11/2023 02:42:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21791' , '0' , '1' , '0' , '0' ) 08/11/2023 02:43:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934059437' AND id_product != '21791' AND ean13 != '' 08/11/2023 02:43:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934059437', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:43:22 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 21 - PB15943', description = '' WHERE id_product = '21791' 08/11/2023 02:43:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.229508196721312' WHERE id_product = '21791' 08/11/2023 02:43:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.229508196721312', id_tax_rules_group = '1', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:43:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '21791' 08/11/2023 02:43:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934059437' AND id_product != '21791' AND ean13 != '' 08/11/2023 02:43:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934059437', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:43:41 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 21 - PB15943', description = '' WHERE id_product = '21791' 08/11/2023 02:43:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '21791' 08/11/2023 02:43:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:43:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21791' 08/11/2023 02:44:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934059437' AND id_product != '21791' AND ean13 != '' 08/11/2023 02:44:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934059437', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:44:17 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 21 - PB15943', description = '' WHERE id_product = '21791' 08/11/2023 02:44:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '21791' 08/11/2023 02:44:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '458', 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 = '21791' 08/11/2023 02:44:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '21791' 08/11/2023 02:44:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934059437' AND id_product != '21791' AND ean13 != '' 08/11/2023 02:44:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934059437', date_upd = NOW() WHERE id_product = '21791' 08/11/2023 02:44:51 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 21 - PB15943', description = '' WHERE id_product = '21791' 08/11/2023 02:44:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.59016393442623' WHERE id_product = '21791' 08/11/2023 02:44:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '458', 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 = '21791' 08/11/2023 02:44:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '21791' 08/11/2023 02:44:52 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 = '21791' 08/11/2023 02:44:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21792' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:44:52 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 '21792' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21791' 08/11/2023 02:44:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21792' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21791' 08/11/2023 02:46:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB11786' AND id_product != '21792' AND ean13 != '' 08/11/2023 02:46:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB11786', date_upd = NOW() WHERE id_product = '21792' 08/11/2023 02:46:11 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 60 - PB11786', description = '' WHERE id_product = '21792' 08/11/2023 02:46:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '184.4262295081967' WHERE id_product = '21792' 08/11/2023 02:46:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '184.4262295081967', id_tax_rules_group = '1', id_category_default = '458', 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 = '21792' 08/11/2023 02:46:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '21792' 08/11/2023 02:46:14 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 = '21792' 08/11/2023 02:46:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21793' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:46:14 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 '21793' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21792' 08/11/2023 02:46:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21793' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21792' 08/11/2023 02:47:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934085900' AND id_product != '21793' AND ean13 != '' 08/11/2023 02:47:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934085900', date_upd = NOW() WHERE id_product = '21793' 08/11/2023 02:47:55 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 17 - PB8590', description = '' WHERE id_product = '21793' 08/11/2023 02:47:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '21793' 08/11/2023 02:47:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '458', 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 = '21793' 08/11/2023 02:47:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '21793' 08/11/2023 02:48:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934085900' AND id_product != '21793' AND ean13 != '' 08/11/2023 02:48:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934085900', date_upd = NOW() WHERE id_product = '21793' 08/11/2023 02:48:13 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 17 - PB8590', description = '' WHERE id_product = '21793' 08/11/2023 02:48:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '21793' 08/11/2023 02:48:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '458', 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 = '21793' 08/11/2023 02:48:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '21793' 08/11/2023 02:48:19 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 = '21793' 08/11/2023 02:48:19 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21794' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:48:19 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 '21794' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21793' 08/11/2023 02:48:19 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21794' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21793' 08/11/2023 02:49:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '' AND id_product != '21794' AND ean13 != '' 08/11/2023 02:49:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '', date_upd = NOW() WHERE id_product = '21794' 08/11/2023 02:49:41 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 23 - PB9422', description = '' WHERE id_product = '21794' 08/11/2023 02:49:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.868852459016395' WHERE id_product = '21794' 08/11/2023 02:49:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '458', 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 = '21794' 08/11/2023 02:49:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21794' 08/11/2023 02:49:42 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 = '21794' 08/11/2023 02:49:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21795' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:49:42 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 '21795' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21794' 08/11/2023 02:49:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21795' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21794' 08/11/2023 02:51:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934094223' AND id_product != '17571' AND ean13 != '' 08/11/2023 02:51:12 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934094223', date_upd = NOW() WHERE id_product = '17571' 08/11/2023 02:51:12 pm >> UPDATE ps_product_lang SET name = 'BAMBINO IN RESINA CM 23 - PB9422', description = '' WHERE id_product = '17571' 08/11/2023 02:51:12 pm >> UPDATE ps_product SET wholesale_price = '10.26', on_sale = '0', price = '27.868852459016395' WHERE id_product = '17571' 08/11/2023 02:51:12 pm >> UPDATE ps_product_shop SET wholesale_price = '10.26', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '458', 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 = '17571' 08/11/2023 02:51:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '17571' 08/11/2023 02:55:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934092571' AND id_product != '19072' AND ean13 != '' 08/11/2023 02:55:06 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934092571', date_upd = NOW() WHERE id_product = '19072' 08/11/2023 02:55:06 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CON AUREOLA CM 37 - PB9257', description = '' WHERE id_product = '19072' 08/11/2023 02:55:06 pm >> UPDATE ps_product SET wholesale_price = '34.01', on_sale = '0', price = '71.3115' WHERE id_product = '19072' 08/11/2023 02:55:06 pm >> UPDATE ps_product_shop SET wholesale_price = '34.01', price = '71.3115', id_tax_rules_group = '1', id_category_default = '458', 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 = '19072' 08/11/2023 02:55:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '19072' 08/11/2023 02:56:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934198884' AND id_product != '21795' AND ean13 != '' 08/11/2023 02:56:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934198884', date_upd = NOW() WHERE id_product = '21795' 08/11/2023 02:56:55 pm >> UPDATE ps_product_lang SET name = 'GRUPPO NATIVITA\' CM 10 LEGNO - PB19888', description = '' WHERE id_product = '21795' 08/11/2023 02:56:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.4426229508196724' WHERE id_product = '21795' 08/11/2023 02:56:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.4426229508196724', id_tax_rules_group = '1', id_category_default = '458', 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 = '21795' 08/11/2023 02:56:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '21795' 08/11/2023 02:56:56 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 = '21795' 08/11/2023 02:56:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21796' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:56:56 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 '21796' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21795' 08/11/2023 02:56:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21796' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21795' 08/11/2023 02:58:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934198891' AND id_product != '21796' AND ean13 != '' 08/11/2023 02:58:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8022934198891', date_upd = NOW() WHERE id_product = '21796' 08/11/2023 02:58:24 pm >> UPDATE ps_product_lang SET name = 'SET NATIVITA\' CON CAPANNA CM 15 - PB19889', description = '' WHERE id_product = '21796' 08/11/2023 02:58:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.327868852459017' WHERE id_product = '21796' 08/11/2023 02:58:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.327868852459017', id_tax_rules_group = '1', id_category_default = '458', 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 = '21796' 08/11/2023 02:58:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '21796' 08/11/2023 02:58:25 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 = '21796' 08/11/2023 02:58:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21797' , '1' , '' , 'nuovo-prodotto' ) 08/11/2023 02:58:25 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 '21797' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21796' 08/11/2023 02:58:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21797' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21796' 08/11/2023 02:59:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '4978' , '2023-11-02' , '' , '0' , '134' , '4670785' , 'VIA ROMA 44 00053 CIVITAVECCHIA' , '' , '' , '37.46' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1569.54' , '1286.50' , NOW() , NOW() ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88823' 08/11/2023 02:59:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88823' 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21789' , 'BAMBINELLO CON CUSCINO CM 15 - PB18511' , '3' , '3' , '1' , '12.8' , '10.491803278689' , '22' , '5' , '44.5056' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21789' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21789' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21790' , 'BAMBINELLO CM 20 - PB16832' , '18' , '18' , '1' , '7.9' , '6.4754098360656' , '22' , '20+5' , '131.8478' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21790' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21790' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21791' , 'BAMBINELLO CM 21 - PB15943' , '4' , '4' , '1' , '13.8' , '11.311475409836' , '22' , '5' , '63.9768' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21791' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21791' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21792' , 'BAMBINO CM 60 - PB11786' , '1' , '1' , '1' , '99.8' , '81.803278688525' , '22' , '20+5' , '92.5346' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21792' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21792' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21793' , 'BAMBINELLO CM 17 - PB8590' , '24' , '24' , '1' , '8.2' , '6.7213114754098' , '22' , '20+5' , '182.4730' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21793' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21793' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '12' , '12' , '1' , '14.8' , '12.131147540984' , '22' , '20+5' , '164.6707' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17571' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17571' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '6' , '6' , '1' , '36.9' , '30.245901639344' , '22' , '20+5' , '205.2821' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19072' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19072' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21777' , 'BAMBINO BETLEMME CM 15 - PB5467' , '48' , '48' , '1' , '5.28' , '4.327868852459' , '22' , '20+5' , '234.9896' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21777' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21777' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21776' , 'BAMBINELLO CM 10 - PB0500' , '72' , '72' , '1' , '2.98' , '2.4426229508197' , '22' , '20+5' , '198.9400' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21776' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21776' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21795' , 'GRUPPO NATIVITA CM 10 LEGNO - PB19888' , '96' , '96' , '1' , '1.88' , '1.5409836065574' , '22' , '20+5' , '167.3411' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21795' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21795' , '134' , '1' ) 08/11/2023 02:59:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88823' , '21796' , 'SET NATIVITA CON CAPANNA CM 15 - PB19889' , '12' , '12' , '1' , '2.68' , '2.1967213114754' , '22' , '5' , '37.2734' ) 08/11/2023 02:59:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21796' AND id_supplier = '134' 08/11/2023 02:59:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21796' , '134' , '1' ) 08/11/2023 03:35:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3513' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 03:35:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3513' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 08/11/2023 03:35:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88824' 08/11/2023 03:35:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88824' 08/11/2023 03:35:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88824' , '2679' , 'CONOSCERE GESU\'' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 08/11/2023 03:35:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88824' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 08/11/2023 03:37:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3514' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 03:37:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3514' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 08/11/2023 03:37: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 = '88825' 08/11/2023 03:37:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '88825' 08/11/2023 03:37: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 ( '88825' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/11/2023 03:37: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 ( '88825' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/11/2023 03:41:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934099419' AND id_product != '19071' AND ean13 != '' 08/11/2023 03:41:40 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934099419', date_upd = NOW() WHERE id_product = '19071' 08/11/2023 03:41:40 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 32 - PB9941', description = '' WHERE id_product = '19071' 08/11/2023 03:41:40 pm >> UPDATE ps_product SET wholesale_price = '17.44', on_sale = '0', price = '49.18032786885246' WHERE id_product = '19071' 08/11/2023 03:41:40 pm >> UPDATE ps_product_shop SET wholesale_price = '17.44', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '458', 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 = '19071' 08/11/2023 03:41:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '19071' 08/11/2023 03:41:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8022934099419' AND id_product != '19071' AND ean13 != '' 08/11/2023 03:41:56 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '8022934099419', date_upd = NOW() WHERE id_product = '19071' 08/11/2023 03:41:56 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 32 - PB9941', description = '' WHERE id_product = '19071' 08/11/2023 03:41:56 pm >> UPDATE ps_product SET wholesale_price = '17.44', on_sale = '0', price = '49.18032786885246' WHERE id_product = '19071' 08/11/2023 03:41:56 pm >> UPDATE ps_product_shop SET wholesale_price = '17.44', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '458', 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 = '19071' 08/11/2023 03:41:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '19071' 08/11/2023 03:42:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8000000118264' AND id_product != '19996' AND ean13 != '' 08/11/2023 03:42:37 pm >> UPDATE ps_product SET id_supplier = '58', reference = '', ean13 = '8000000118264', date_upd = NOW() WHERE id_product = '19996' 08/11/2023 03:42:37 pm >> UPDATE ps_product_lang SET name = 'GESU\' BAMBINO CM 34 - BJ142-34E', description = '' WHERE id_product = '19996' 08/11/2023 03:42:37 pm >> UPDATE ps_product SET wholesale_price = '18.65', on_sale = '0', price = '45.08196721311476' WHERE id_product = '19996' 08/11/2023 03:42:37 pm >> UPDATE ps_product_shop SET wholesale_price = '18.65', price = '45.08196721311476', id_tax_rules_group = '1', id_category_default = '164', 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 = '19996' 08/11/2023 03:42:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '19996' 08/11/2023 03:43:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8000000118332' AND id_product != '19997' AND ean13 != '' 08/11/2023 03:43:32 pm >> UPDATE ps_product SET id_supplier = '58', reference = '', ean13 = '8000000118332', date_upd = NOW() WHERE id_product = '19997' 08/11/2023 03:43:32 pm >> UPDATE ps_product_lang SET name = 'GESU\' BAMBINO CM 34 - BJ140-34E', description = '' WHERE id_product = '19997' 08/11/2023 03:43:32 pm >> UPDATE ps_product SET wholesale_price = '18.65', on_sale = '0', price = '45.08196721311476' WHERE id_product = '19997' 08/11/2023 03:43:32 pm >> UPDATE ps_product_shop SET wholesale_price = '18.65', price = '45.08196721311476', id_tax_rules_group = '1', id_category_default = '164', 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 = '19997' 08/11/2023 03:43:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '19997' 08/11/2023 03:43:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8000000118332' AND id_product != '19997' AND ean13 != '' 08/11/2023 03:43:47 pm >> UPDATE ps_product SET id_supplier = '58', reference = '', ean13 = '8000000118332', date_upd = NOW() WHERE id_product = '19997' 08/11/2023 03:43:47 pm >> UPDATE ps_product_lang SET name = 'GESU\' BAMBINO CM 34 - BJ140-34E', description = '' WHERE id_product = '19997' 08/11/2023 03:43:47 pm >> UPDATE ps_product SET wholesale_price = '18.65', on_sale = '0', price = '45.0820' WHERE id_product = '19997' 08/11/2023 03:43:47 pm >> UPDATE ps_product_shop SET wholesale_price = '18.65', price = '45.0820', id_tax_rules_group = '1', id_category_default = '164', 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 = '19997' 08/11/2023 03:43:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19997' 08/11/2023 04:13:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3083' AND id_document != '88170' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-09') 08/11/2023 04:13:21 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3083', document_date = '2023-10-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '54.15', price_tax_excluded = '54.15', date_upd = NOW() WHERE id_document = '88170' 08/11/2023 04:13: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 = '88170' 08/11/2023 04:13:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '88170' 08/11/2023 04:13: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 ( '88170' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 08/11/2023 04:13: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 ( '88170' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 08/11/2023 04:13: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 ( '88170' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '5' , '9.50' ) 08/11/2023 04:13: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 ( '88170' , '21645' , 'LAUDATE DEUM' , '1' , '-1' , '4' , '1.9000' , '1.9' , '0' , '0' , '1.90' ) 08/11/2023 04:13: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 ( '88170' , '19805' , 'DESIDERIO DESIDERAVI' , '14' , '-14' , '4' , '2.0000' , '2' , '0' , '5' , '26.60' ) 08/11/2023 04:14:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3340' AND id_document != '88552' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 08/11/2023 04:14:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3340', document_date = '2023-10-26', 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 = '56.81', price_tax_excluded = '56.81', date_upd = NOW() WHERE id_document = '88552' 08/11/2023 04:14: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 = '88552' 08/11/2023 04:14:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88552' 08/11/2023 04:14: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 ( '88552' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:14: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 ( '88552' , '21626' , 'MISSIONE NATALE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:14: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 ( '88552' , '21718' , 'LITURGIA: ARTE PRIMA CHE PLASMA - A. PORRECA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 08/11/2023 04:14: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 ( '88552' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '-1' , '4' , '10.8000' , '10.8' , '0' , '0' , '10.80' ) 08/11/2023 04:14: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 ( '88552' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '2' , '-2' , '4' , '4.5000' , '4.5' , '0' , '0' , '9.00' ) 08/11/2023 04:14: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 ( '88552' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:14: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 ( '88552' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:14: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 ( '88552' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9' , '9' , '0' , '0' , '9.00' ) 08/11/2023 04:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3340' AND id_document != '88552' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 08/11/2023 04:15:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3340', document_date = '2023-10-26', 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 = '56.81', price_tax_excluded = '56.81', date_upd = NOW() WHERE id_document = '88552' 08/11/2023 04:15: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 = '88552' 08/11/2023 04:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '88552' 08/11/2023 04:15: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 ( '88552' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:15: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 ( '88552' , '21626' , 'MISSIONE NATALE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:15: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 ( '88552' , '21718' , 'LITURGIA: ARTE PRIMA CHE PLASMA - A. PORRECA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 08/11/2023 04:15: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 ( '88552' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '-1' , '4' , '10.8000' , '10.8' , '0' , '0' , '10.80' ) 08/11/2023 04:15: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 ( '88552' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:15: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 ( '88552' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:15: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 ( '88552' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:15: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 ( '88552' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '13.5' , '13.5' , '0' , '0' , '13.50' ) 08/11/2023 04:16:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3340' AND id_document != '88552' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 08/11/2023 04:16:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3340', document_date = '2023-10-26', 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 = '56.81', price_tax_excluded = '56.81', date_upd = NOW() WHERE id_document = '88552' 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88552' 08/11/2023 04:16:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88552' 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '21626' , 'MISSIONE NATALE' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '21718' , 'LITURGIA: ARTE PRIMA CHE PLASMA - A. PORRECA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '-1' , '4' , '10.8000' , '10.8' , '0' , '0' , '10.80' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '2' , '-2' , '4' , '4.5000' , '4.5' , '0' , '0' , '9.00' ) 08/11/2023 04:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88552' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9' , '9' , '0' , '0' , '9.00' ) 08/11/2023 04:25:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '476' AND id_document != '81308' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-10') 08/11/2023 04:25:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '476', document_date = '2023-02-10', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '4.50', price_tax_excluded = '4.50', date_upd = NOW() WHERE id_document = '81308' 08/11/2023 04:25: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 = '81308' 08/11/2023 04:25:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '81308' 08/11/2023 04:25: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 ( '81308' , '18704' , 'IN_SEGUENDO GESU\' A NAZARET' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 08/11/2023 05:19:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023288954' , '2023-10-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.32' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '10.66' , '10.66' , NOW() , NOW() ) 08/11/2023 05:19:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88826' 08/11/2023 05:19:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '88826' 08/11/2023 05:19: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 ( '88826' , '21733' , 'GUARIRE CON LE PARABOLE - R. CHEIAB' , '1' , '0' , '4' , '10.34' , '10.34' , '0' , '0' , '10.3400' ) 08/11/2023 05:19:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21733' AND id_supplier = '109' 08/11/2023 05:19:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21733' , '109' , '1' ) 08/11/2023 05:23:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023288952' , '2023-10-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.85' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '67.21' , '67.21' , NOW() , NOW() ) 08/11/2023 05:23: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 = '88827' 08/11/2023 05:23:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '88827' 08/11/2023 05:23: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 ( '88827' , '21725' , 'GIOVANNI AMENDOLA UNA VITA ....' , '1' , '0' , '4' , '14' , '14' , '0' , '0' , '14.0000' ) 08/11/2023 05:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21725' AND id_supplier = '109' 08/11/2023 05:23:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21725' , '109' , '1' ) 08/11/2023 05:23:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88827' , '5823' , 'LIBRO DORO' , '100' , '0' , '4' , '0.4199' , '0.4199' , '0' , '0' , '41.9900' ) 08/11/2023 05:23:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 08/11/2023 05:23:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 08/11/2023 05:23:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88827' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '1' , '0' , '4' , '9.37' , '9.37' , '0' , '0' , '9.3700' ) 08/11/2023 05:23:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21475' AND id_supplier = '109' 08/11/2023 05:23:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21475' , '109' , '1' ) 08/11/2023 05:25:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6023288953' , '' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.21' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '7.55' , '7.55' , NOW() , NOW() ) 08/11/2023 05:25:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88828' 08/11/2023 05:25:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88828' 08/11/2023 05:25:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88828' , '21734' , 'CHI HA TOCCATO LE MIE VESTI? ANNO B' , '1' , '0' , '4' , '7.34' , '7.34' , '0' , '0' , '7.3400' ) 08/11/2023 05:25:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21734' AND id_supplier = '109' 08/11/2023 05:25:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21734' , '109' , '1' ) 08/11/2023 05:26: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 ( '32' , '6023288955' , '2023-10-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.18' , '4' , '0' , '0' , '0' , '' , '10' , '0' , '76.59' , '76.59' , NOW() , NOW() ) 08/11/2023 05:26: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 = '88829' 08/11/2023 05:26:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '88829' 08/11/2023 05:26: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 ( '88829' , '10916' , 'UNA COMUNITÀ LEGGE IL VANGELO DI MARCO' , '1' , '0' , '4' , '38.91' , '38.91' , '0' , '0' , '38.9100' ) 08/11/2023 05:26:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10916' AND id_supplier = '109' 08/11/2023 05:26:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10916' , '109' , '1' ) 08/11/2023 05:26: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 ( '88829' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '0' , '4' , '35.5' , '35.5' , '0' , '0' , '35.5000' ) 08/11/2023 05:26:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17864' AND id_supplier = '109' 08/11/2023 05:26:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17864' , '109' , '1' ) 08/11/2023 05:35: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 ( '32' , '6223744232' , '2023-10-31' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '241.89' , '241.89' , NOW() , NOW() ) 08/11/2023 05: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 = '88830' 08/11/2023 05:35:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88830' 08/11/2023 05: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 ( '88830' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '0' , '4' , '9.308' , '9.308' , '0' , '0' , '46.5400' ) 08/11/2023 05:35:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 08/11/2023 05:35:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 08/11/2023 05: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 ( '88830' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '0' , '4' , '13.11' , '13.11' , '0' , '0' , '13.1100' ) 08/11/2023 05:35:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20494' AND id_supplier = '177' 08/11/2023 05:35:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20494' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '0' , '4' , '15.52' , '15.52' , '0' , '0' , '15.5200' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21699' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21699' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '21670' , 'PER CUSTODIRE IL FUOCO - L. M. EPICOCO' , '1' , '0' , '4' , '9.31' , '9.31' , '0' , '0' , '9.3100' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21670' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21670' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '21670' , 'PER CUSTODIRE IL FUOCO - L. M. EPICOCO' , '3' , '0' , '4' , '8.9334' , '8.9334' , '0' , '0' , '26.8002' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21670' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21670' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '21606' , 'UCCISERO ANCHE I BAMBINI' , '1' , '0' , '4' , '11.47' , '11.47' , '0' , '0' , '11.4700' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21606' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21606' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '21671' , 'RESISTI CUORE' , '1' , '0' , '4' , '14.89' , '14.89' , '0' , '0' , '14.8900' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21671' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21671' , '177' , '1' ) 08/11/2023 05:35:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88830' , '20393' , 'DON MILANI - TUTTE LE OPERE' , '1' , '0' , '4' , '104.25' , '104.25' , '0' , '0' , '104.2500' ) 08/11/2023 05:35:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20393' AND id_supplier = '177' 08/11/2023 05:35:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20393' , '177' , '1' ) 08/11/2023 05:38:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '2492' , '2023-10-31' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '9.01' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '170.01' , '170.01' , NOW() , NOW() ) 08/11/2023 05:38:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88831' 08/11/2023 05:38:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '88831' 08/11/2023 05:38:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88831' , '19383' , 'EVANGELO COFANETTO - VALTORTA' , '1' , '0' , '4' , '230.0000' , '230' , '0' , '30' , '161.00' ) 08/11/2023 05:38:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19383' AND id_supplier = '47' 08/11/2023 05:38:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19383' , '47' , '1' ) 08/11/2023 05:53:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3515' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 05:53: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' , '3515' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 08/11/2023 05:53: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 = '88832' 08/11/2023 05:53:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '88832' 08/11/2023 05:53: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 ( '88832' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/11/2023 05:57:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3516' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 05:57: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' , '3516' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 08/11/2023 05:57: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 = '88833' 08/11/2023 05:57:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '88833' 08/11/2023 05:57:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88833' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 08/11/2023 06:32:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 06:32: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 ( '21' , '247' , '2023-11-08' , '' , '2912' , '0' , '4672779' , 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '94.25' , '94.25' , NOW() , NOW() ) 08/11/2023 06:32: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 = '88834' 08/11/2023 06:32:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '88834' 08/11/2023 06:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '-3' , '4' , '3.00' , '3' , '0' , '15' , '7.65' ) 08/11/2023 06:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '2679' , 'CONOSCERE GESU' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '5' , '49.88' ) 08/11/2023 06:32:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '18' , '-18' , '4' , '2.40' , '2.4' , '0' , '15' , '36.72' ) 08/11/2023 06:33:29 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6453' 08/11/2023 06:33:29 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '6453' , '10' , '210' , 'PARROCCHIA S. MARIA DELLE GRAZIE' , 'PIERRI' , 'DON LUIGI' , 'P. ZZA CARMINE PASTORE, 10' , '' , '84080' , 'CAPRIGLIA - PELLEZZANO' , '' , '' , '3476383166' , '' , '95019720655' , NOW() , NOW() ) 08/11/2023 06:33:29 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6453' 08/11/2023 06:34:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 06:34:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '99' , '2023-11-08' , '' , '6453' , '0' , '154022853' , 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '78.63' , '78.63' , NOW() , NOW() ) 08/11/2023 06:34:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13232' 08/11/2023 06:34:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '13232' 08/11/2023 06:34:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13232' , '123' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 08/11/2023 06:34:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13232' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '5' , '-5' , '4' , '2.50' , '2.5' , '0' , '15' , '10.63' ) 08/11/2023 06:34: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 ( '13232' , '17' , 'LA FEDE NELLO ZAINETTO' , '10' , '-10' , '4' , '5' , '5' , '0' , '15' , '42.50' ) 08/11/2023 06:40:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '88834' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 06:40:02 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '247', document_date = '2023-11-08', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4672779', address1 = 'P. ZZA CARMINE PASTORE, 10 84080 CAPRIGLIA - PELLEZZANO', 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 = '94.25', price_tax_excluded = '94.25', date_upd = NOW() WHERE id_document = '88834' 08/11/2023 06:40:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88834' 08/11/2023 06:40:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '88834' 08/11/2023 06:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '12813' , 'MARIA MADRE NOSTRA' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '15' , '7.65' ) 08/11/2023 06:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '2679' , 'CONOSCERE GESU' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '5' , '49.88' ) 08/11/2023 06:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88834' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '18' , '-18' , '4' , '2.4000' , '2.4' , '0' , '15' , '36.72' ) 08/11/2023 06:42:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3517' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 06:42:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3517' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.00' , '94.26' , NOW() , NOW() ) 08/11/2023 06:42:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88835' 08/11/2023 06:42:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '88835' 08/11/2023 06:42:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88835' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '-2' , '1' , '8.5' , '6.9672131147541' , '22' , '' , '17.00' ) 08/11/2023 06:42:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88835' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '98' , '80.327868852459' , '22' , '0' , '98.00' ) 08/11/2023 07:14:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '118/A' AND id_document != '88672' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-31') 08/11/2023 07:14:20 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '118/A', document_date = '2023-10-31', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA BATTIPAGLIA', 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 = '158.20', price_tax_excluded = '135.74', date_upd = NOW() WHERE id_document = '88672' 08/11/2023 07:14: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 = '88672' 08/11/2023 07:14:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '88672' 08/11/2023 07:14: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 ( '88672' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '25' , '-25' , '4' , '0.7000' , '0.7' , '0' , '0' , '17.50' ) 08/11/2023 07:14: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 ( '88672' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '3.80' ) 08/11/2023 07:14: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 ( '88672' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/11/2023 07:14: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 ( '88672' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/11/2023 07:14: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 ( '88672' , '' , 'LAMPADINE' , '97' , '-97' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '116.40' ) 08/11/2023 07:38:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3518' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 07:38:01 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' , '3518' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 08/11/2023 07:38:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88836' 08/11/2023 07:38:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '88836' 08/11/2023 07:38:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88836' , '21778' , 'SULLA TUA PAROLA - GEN FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/11/2023 07:38:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88836' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/11/2023 07:38:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88836' , '21515' , 'CINQUE PANI DORZO 2024' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 08/11/2023 07:44:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '3519' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-08') 08/11/2023 07:44:23 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' , '3519' , '2023-11-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.75' , '2.70' , NOW() , NOW() ) 08/11/2023 07:44: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 = '88837' 08/11/2023 07:44:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '88837' 08/11/2023 07:44: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 ( '88837' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 08/11/2023 07:44: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 ( '88837' , '21650' , 'AVVENTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' )