06/05/2024 09:02:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 06/05/2024 09:02:29 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', 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 = '17.90', price_tax_excluded = '17.90', date_upd = NOW() WHERE id_document = '89846' 06/05/2024 09:02:29 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 = '89846' 06/05/2024 09:02:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 06/05/2024 09:02:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 06/05/2024 09:02:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 06/05/2024 09:02:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 06/05/2024 09:04:06 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 09:04:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '21' , '2024-05-06' , '' , '7084' , '0' , '172691778' , 'VIA DEI CILIEGI 44/E QUARTIERE TERMINETTO 55049 VIAREGGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 06/05/2024 09:04:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14212' 06/05/2024 09:04:06 am >> DELETE FROM ps_document_detail WHERE id_document = '14212' 06/05/2024 09:04:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14212' , '134' , 'AVE MARIA SPIEGATA AI BAMBINI - N.E.' , '25' , '-25' , '4' , '1.80' , '1.8' , '0' , '5' , '42.75' ) 06/05/2024 09:04:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14212' , '' , 'IMMAGINI' , '5' , '-5' , '4' , '3.8' , '3.8' , '0' , '0' , '19.00' ) 06/05/2024 09:17:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248114' AND id_product != '22402' AND ean13 != '' 06/05/2024 09:17:06 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788884248114', date_upd = NOW() WHERE id_product = '22402' 06/05/2024 09:17:06 am >> UPDATE ps_product_lang SET name = 'REGNO DI DIO E\' UNA SFIDA - F. SHEEN', description = '' WHERE id_product = '22402' 06/05/2024 09:17:06 am >> UPDATE ps_product SET wholesale_price = '11.20', on_sale = '0', price = '16.0000' WHERE id_product = '22402' 06/05/2024 09:17:06 am >> UPDATE ps_product_shop SET wholesale_price = '11.20', price = '16.0000', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22402' 06/05/2024 09:17:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22402' 06/05/2024 09:19:06 am >> SELECT document_num FROM ps_document WHERE document_num = '1428' AND id_document != '91610' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-04') 06/05/2024 09:19:06 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1428', document_date = '2024-05-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.40', price_tax_excluded = '6.89', date_upd = NOW() WHERE id_document = '91610' 06/05/2024 09:19:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91610' 06/05/2024 09:19:06 am >> DELETE FROM ps_document_detail WHERE id_document = '91610' 06/05/2024 09:19:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91610' , '20516' , 'CROCE COMUNIONE - 42/08' , '7' , '-7' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '8.40' ) 06/05/2024 09:48:15 am >> SELECT document_num FROM ps_document WHERE document_num = '1437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 09:48:15 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' , '1437' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/05/2024 09:48: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 = '91619' 06/05/2024 09:48:15 am >> DELETE FROM ps_document_detail WHERE id_document = '91619' 06/05/2024 09:48: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 ( '91619' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/05/2024 10:03:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1438' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:03:26 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' , '1438' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '115.50' , '95.66' , NOW() , NOW() ) 06/05/2024 10:03:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91620' 06/05/2024 10:03:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91620' 06/05/2024 10:03:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '15251' , 'FATE QUESTO IN MEMORIA DI ME' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 06/05/2024 10:03:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 06/05/2024 10:03:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '5823' , 'LIBRO DORO' , '2' , '-2' , '4' , '0.60' , '0.6' , '0' , '0' , '1.20' ) 06/05/2024 10:03:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91620' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 06/05/2024 10:22:09 am >> SELECT document_num FROM ps_document WHERE document_num = '1439' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:22:09 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' , '1439' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.60' , '48.75' , NOW() , NOW() ) 06/05/2024 10:22:09 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 = '91621' 06/05/2024 10:22:09 am >> DELETE FROM ps_document_detail WHERE id_document = '91621' 06/05/2024 10:22:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91621' , '20026' , 'CANDELA VOTIVA 20X40' , '16' , '-16' , '1' , '1.8' , '1.4754098360656' , '22' , '0' , '28.80' ) 06/05/2024 10:22:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91621' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 06/05/2024 10:22:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91621' , '15291' , 'BENEDIZIONI - CROCIFISSIONE A' , '100' , '-100' , '1' , '0.1' , '0.081967213114754' , '22' , '0' , '10.00' ) 06/05/2024 10:22:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91621' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '5' , '-5' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '2.50' ) 06/05/2024 10:22:10 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91621' , '15604' , 'LUIGI MARIA DA MONTFORT' , '1' , '-1' , '4' , '4.8' , '4.8' , '0' , '0' , '4.80' ) 06/05/2024 10:22:50 am >> SELECT document_num FROM ps_document WHERE document_num = '1440' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:22:50 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1440' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '38.00' , NOW() , NOW() ) 06/05/2024 10:22:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91622' 06/05/2024 10:22:50 am >> DELETE FROM ps_document_detail WHERE id_document = '91622' 06/05/2024 10:22:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91622' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 06/05/2024 10:31:34 am >> SELECT document_num FROM ps_document WHERE document_num = '7/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:31: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 ( '23' , '7/L' , '2024-05-06' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '174.90' , '144.92' , NOW() , NOW() ) 06/05/2024 10:31: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 = '91623' 06/05/2024 10:31:34 am >> DELETE FROM ps_document_detail WHERE id_document = '91623' 06/05/2024 10:31: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 ( '91623' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 06/05/2024 10:31: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 ( '91623' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/05/2024 10:31: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 ( '91623' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/05/2024 10:31: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 ( '91623' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/05/2024 10:31: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 ( '91623' , '8887' , 'RELIQUIARIO - 787' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 06/05/2024 10:38:56 am >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:38:56 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '8/L' , '2024-05-06' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '452.90' , '381.85' , NOW() , NOW() ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91624' 06/05/2024 10:38:56 am >> DELETE FROM ps_document_detail WHERE id_document = '91624' 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.0000' , '69.6721' , '22' , '0' , '85.00' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9231' , '4' , '0' , '20.00' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.3000' , '4.1346' , '4' , '0' , '12.90' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3654' , '4' , '0' , '17.50' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.0000' , '1.9231' , '4' , '0' , '20.00' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 06/05/2024 10:38:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8361' , '22' , '0' , '24.00' ) 06/05/2024 10:38:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885' , '22' , '0' , '270.00' ) 06/05/2024 10:39:55 am >> SELECT document_num FROM ps_document WHERE document_num = '1441' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:39:55 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' , '1441' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 06/05/2024 10:39:55 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 = '91625' 06/05/2024 10:39:55 am >> DELETE FROM ps_document_detail WHERE id_document = '91625' 06/05/2024 10:39:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91625' , '3144' , 'CROCE TRILOBATA ' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 06/05/2024 10:48:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1442' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:48:29 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' , '1442' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.64' , '135.13' , NOW() , NOW() ) 06/05/2024 10:48:29 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 = '91626' 06/05/2024 10:48:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91626' 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '16.00' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22111' , 'PREGARE OGGI - 1' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22191' , 'PREGARE CON I SALMI - 2' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22192' , 'PREGHIERA DI GESU - 3' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22445' , 'PARABOLE DELLA PREGHIERA - 5' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22290' , 'CHIESA IN PREGHIERA - 6' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22448' , 'PREGHIERA DI MARIA - 7' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:48:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91626' , '22449' , 'PREGHIERA CHE GESU CI HA INSEGNATO - 8' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 06/05/2024 10:53:07 am >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '91624' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 10:53:07 am >> UPDATE ps_document SET id_document_type = '23', document_num = '8/L', document_date = '2024-05-06', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 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 = '462.90', price_tax_excluded = '391.46', date_upd = NOW() WHERE id_document = '91624' 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91624' 06/05/2024 10:53:07 am >> DELETE FROM ps_document_detail WHERE id_document = '91624' 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '15' , '-15' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '30.00' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '12.90' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 06/05/2024 10:53:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91624' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 06/05/2024 11:01:38 am >> SELECT document_num FROM ps_document WHERE document_num = '8/L' AND id_document != '91624' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 11:01:38 am >> UPDATE ps_document SET id_document_type = '23', document_num = '8/L', document_date = '2024-05-06', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '462.90', price_tax_excluded = '391.46', date_upd = NOW() WHERE id_document = '91624' 06/05/2024 11:01: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 = '91624' 06/05/2024 11:01:38 am >> DELETE FROM ps_document_detail WHERE id_document = '91624' 06/05/2024 11:01: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 ( '91624' , '16051' , 'PISSIDE OFFERTORIALE CM 12X9 - 1894' , '1' , '-1' , '1' , '85.0000' , '69.672131147541' , '22' , '0' , '85.00' ) 06/05/2024 11:01: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 ( '91624' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '15' , '-15' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '30.00' ) 06/05/2024 11:01: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 ( '91624' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '12.90' ) 06/05/2024 11:01: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 ( '91624' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 06/05/2024 11:01: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 ( '91624' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 06/05/2024 11:01: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 ( '91624' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 06/05/2024 11:01: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 ( '91624' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 06/05/2024 11:01: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 ( '91624' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 06/05/2024 11:03:49 am >> SELECT document_num FROM ps_document WHERE document_num = '7/L' AND id_document != '91623' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 11:03:49 am >> UPDATE ps_document SET id_document_type = '23', document_num = '7/L', document_date = '2024-05-06', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '174.90', price_tax_excluded = '144.92', date_upd = NOW() WHERE id_document = '91623' 06/05/2024 11:03: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 = '91623' 06/05/2024 11:03:49 am >> DELETE FROM ps_document_detail WHERE id_document = '91623' 06/05/2024 11:03: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 ( '91623' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 06/05/2024 11:03: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 ( '91623' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/05/2024 11:03: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 ( '91623' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/05/2024 11:03: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 ( '91623' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/05/2024 11:03: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 ( '91623' , '8887' , 'RELIQUIARIO - 787' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 06/05/2024 11:15:32 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 ( '32' , '6024214820' , '2024-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.76' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '61.84' , '61.84' , NOW() , NOW() ) 06/05/2024 11:15:32 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 = '91627' 06/05/2024 11:15:32 am >> DELETE FROM ps_document_detail WHERE id_document = '91627' 06/05/2024 11:15:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91627' , '22386' , 'CREDO SPIEGATO AI CRISTIANI UN PO SCETTICI ' , '1' , '0' , '4' , '10.24' , '10.24' , '0' , '0' , '10.2400' ) 06/05/2024 11:15:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22386' AND id_supplier = '109' 06/05/2024 11:15:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22386' , '109' , '1' ) 06/05/2024 11:15:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91627' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '1' , '0' , '4' , '25.94' , '25.94' , '0' , '0' , '25.9400' ) 06/05/2024 11:15:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '1144' AND id_supplier = '109' 06/05/2024 11:15:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1144' , '109' , '1' ) 06/05/2024 11:15:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91627' , '22331' , 'BIBBIA DI GERUSALEMME - BOTTONE' , '1' , '0' , '4' , '23.9' , '23.9' , '0' , '0' , '23.9000' ) 06/05/2024 11:15:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '22331' AND id_supplier = '109' 06/05/2024 11:15:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22331' , '109' , '1' ) 06/05/2024 11:20: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 ( '32' , '6024214821' , '2024-04-30' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.93' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '70.27' , '70.27' , NOW() , NOW() ) 06/05/2024 11:20: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 = '91628' 06/05/2024 11:20:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91628' 06/05/2024 11:20: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 ( '91628' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '4' , '0' , '4' , '13.445' , '13.445' , '0' , '0' , '53.7800' ) 06/05/2024 11:20:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '109' 06/05/2024 11:20:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '109' , '1' ) 06/05/2024 11:20: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 ( '91628' , '22385' , 'SECRETUM - M. FRANCO' , '1' , '0' , '4' , '14.56' , '14.56' , '0' , '0' , '14.5600' ) 06/05/2024 11:20:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22385' AND id_supplier = '109' 06/05/2024 11:20:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22385' , '109' , '1' ) 06/05/2024 11:26: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 ( '32' , '6024214819' , '2024-05-06' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.96' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '32.15' , '32.15' , NOW() , NOW() ) 06/05/2024 11:26: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 = '91629' 06/05/2024 11:26:48 am >> DELETE FROM ps_document_detail WHERE id_document = '91629' 06/05/2024 11:26: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 ( '91629' , '18756' , 'UNA GIORNATA LUNGA UNA VITA - A. QUARANTA' , '1' , '0' , '4' , '7.15' , '7.15' , '0' , '0' , '7.1500' ) 06/05/2024 11:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '18756' AND id_supplier = '109' 06/05/2024 11:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18756' , '109' , '1' ) 06/05/2024 11:26: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 ( '91629' , '22384' , 'ERESIA DELL\'INFORME - M. MOSEBACH' , '1' , '0' , '4' , '14.29' , '14.29' , '0' , '0' , '14.2900' ) 06/05/2024 11:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22384' AND id_supplier = '109' 06/05/2024 11:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22384' , '109' , '1' ) 06/05/2024 11:26: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 ( '91629' , '22387' , 'GIUSEPPE - D. BUFFONE' , '1' , '0' , '4' , '9.75' , '9.75' , '0' , '0' , '9.7500' ) 06/05/2024 11:26:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '22387' AND id_supplier = '109' 06/05/2024 11:26:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22387' , '109' , '1' ) 06/05/2024 11:54:26 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 ( '32' , '6224723526' , '2024-04-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '5.35' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '239.58' , '239.58' , NOW() , NOW() ) 06/05/2024 11:54:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91630' 06/05/2024 11:54:27 am >> DELETE FROM ps_document_detail WHERE id_document = '91630' 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22456' , 'CENA DELL\'AGNELLO - S. HAHN' , '2' , '0' , '4' , '11.60' , '11.6' , '0' , '0' , '23.2000' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22456' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22456' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22458' , 'LUPA DI MARE - M. POZZA' , '1' , '0' , '4' , '12.47' , '12.47' , '0' , '0' , '12.4700' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22458' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22458' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22455' , 'A DOTTRINA CON DON CAMILLO - S. PINNA' , '1' , '0' , '4' , '15.2' , '15.2' , '0' , '0' , '15.2000' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22455' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22455' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '2' , '0' , '4' , '12.23' , '12.23' , '0' , '0' , '24.4600' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22330' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22330' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22457' , 'GRANDE SINFONIA DI PREGHIERA - L. MAROTTA' , '1' , '0' , '4' , '12' , '12' , '0' , '0' , '12.0000' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22457' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22457' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '2' , '0' , '4' , '1.48' , '1.48' , '0' , '0' , '2.9600' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '18289' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18289' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '21780' , 'FRATELLINO' , '2' , '0' , '4' , '9.355' , '9.355' , '0' , '0' , '18.7100' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21780' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21780' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '7' , '0' , '4' , '9.3586' , '9.3586' , '0' , '0' , '65.5102' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '21697' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21697' , '177' , '1' ) 06/05/2024 11:54:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22374' , 'MOGOL' , '1' , '0' , '4' , '15.64' , '15.64' , '0' , '0' , '15.6400' ) 06/05/2024 11:54:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22374' AND id_supplier = '177' 06/05/2024 11:54:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22374' , '177' , '1' ) 06/05/2024 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '0' , '4' , '13' , '13' , '0' , '0' , '13.0000' ) 06/05/2024 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '21934' AND id_supplier = '177' 06/05/2024 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21934' , '177' , '1' ) 06/05/2024 11:54:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91630' , '22375' , 'SEGRETI DI SUOR LUCIA - S. GAETA' , '2' , '0' , '4' , '15.54' , '15.54' , '0' , '0' , '31.0800' ) 06/05/2024 11:54:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22375' AND id_supplier = '177' 06/05/2024 11:54:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22375' , '177' , '1' ) 06/05/2024 12:02:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1443' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:02: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' , '1443' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.40' , '23.09' , NOW() , NOW() ) 06/05/2024 12:02: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 = '91631' 06/05/2024 12:02:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '91631' 06/05/2024 12:02: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 ( '91631' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 06/05/2024 12:02: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 ( '91631' , '9132' , 'DECINA LEGNO ACERO NATURALE - RG 021-10' , '14' , '-14' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '9.80' ) 06/05/2024 12:02: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 ( '91631' , '21573' , 'CON LA FORZA DELLO SPIRITO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 06/05/2024 12:02: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 ( '91631' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 06/05/2024 12:07:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1444' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:07:12 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' , '1444' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.80' , '3.93' , NOW() , NOW() ) 06/05/2024 12:07:12 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 = '91632' 06/05/2024 12:07:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91632' 06/05/2024 12:07:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91632' , '16310' , 'PORTACHIAVI COLOMBA - KP027' , '4' , '-4' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '4.80' ) 06/05/2024 12:21:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1445' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:21: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' , '1445' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 06/05/2024 12:21: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 = '91633' 06/05/2024 12:21:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '91633' 06/05/2024 12:21: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 ( '91633' , '7202' , 'ARTICOLI RELIGIOSI' , '8' , '-8' , '1' , '5' , '4.0983606557377' , '22' , '0' , '40.00' ) 06/05/2024 12:31:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '42/A' AND id_document != '90923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-23') 06/05/2024 12:31:16 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '42/A', document_date = '2024-03-23', document_letter = 'A', id_customer = '3842', id_supplier = '', id_address = '4673208', address1 = 'VIA SAN LEONARDO 84100 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 = '180.39', price_tax_excluded = '158.48', date_upd = NOW() WHERE id_document = '90923' 06/05/2024 12:31:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90923' 06/05/2024 12:31:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90923' 06/05/2024 12:31: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 ( '90923' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 06/05/2024 12:31: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 ( '90923' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 06/05/2024 12:31: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 ( '90923' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 06/05/2024 12:31: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 ( '90923' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 06/05/2024 12:31: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 ( '90923' , '22168' , 'AMEN - GIU. 2024' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 06/05/2024 12:31: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 ( '90923' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 06/05/2024 12:31: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 ( '90923' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 06/05/2024 12:31: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 ( '90923' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 06/05/2024 12:31: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 ( '90923' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '5' , '-5' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '10.00' ) 06/05/2024 12:31: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 ( '90923' , '6352' , 'MEDAGLIA S. BENEDETTO NIKEL SMALTO - M016' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 06/05/2024 12:31: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 ( '90923' , '' , 'supplica' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 06/05/2024 12:31: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 ( '90923' , '' , 'lampadine' , '50' , '-50' , '1' , '1.2' , '0.98360655737705' , '22' , '0' , '60.00' ) 06/05/2024 12:35:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1446' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:35:30 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' , '1446' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '9.62' , NOW() , NOW() ) 06/05/2024 12:35:30 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 = '91634' 06/05/2024 12:35:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91634' 06/05/2024 12:35: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 ( '91634' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 06/05/2024 12:38:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1447' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:38: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' , '1447' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 06/05/2024 12:38: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 = '91635' 06/05/2024 12:38:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91635' 06/05/2024 12:38: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 ( '91635' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/05/2024 12:38: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 ( '91635' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/05/2024 12:38: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 ( '91635' , '22476' , 'AMEN - AGO 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/05/2024 12:38: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 ( '91635' , '22475' , 'AMEN - LUG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 06/05/2024 12:38:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '1448' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:38:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1448' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 06/05/2024 12:38:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91636' 06/05/2024 12:38:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91636' 06/05/2024 12:38:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91636' , '3193' , 'CROCIFISSO ULIVO SMUSSATO CM 21' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 06/05/2024 12:47:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1449' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 12:47:10 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' , '1449' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 06/05/2024 12:47:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91637' 06/05/2024 12:47:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '91637' 06/05/2024 12:47:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91637' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '35' , '-35' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '17.50' ) 06/05/2024 01:02:08 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 06/05/2024 01:02:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22505' , '1' , '' , 'nuovo-prodotto' ) 06/05/2024 01:02:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22505' , '1' , '1' , '2' , NOW() , NOW() ) 06/05/2024 01:02:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22505' , '0' , '1' , '0' , '0' ) 06/05/2024 01:03:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9787706240602' AND id_product != '22505' AND ean13 != '' 06/05/2024 01:03:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9787706240602', date_upd = NOW() WHERE id_product = '22505' 06/05/2024 01:03:05 pm >> UPDATE ps_product_lang SET name = 'DALL\'ALBA AL TRAMONTO - GIU 24', description = '' WHERE id_product = '22505' 06/05/2024 01:03:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.2' WHERE id_product = '22505' 06/05/2024 01:03:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.2', id_tax_rules_group = '4', id_category_default = '280', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22505' 06/05/2024 01:03:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22505' 06/05/2024 01:03:06 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 = '22505' 06/05/2024 01:03:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22506' , '1' , '' , 'nuovo-prodotto' ) 06/05/2024 01:03:07 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 '22506' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22505' 06/05/2024 01:03:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22506' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22505' 06/05/2024 01:03:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557504' AND id_product != '22506' AND ean13 != '' 06/05/2024 01:03:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831557504', date_upd = NOW() WHERE id_product = '22506' 06/05/2024 01:03:38 pm >> UPDATE ps_product_lang SET name = 'DIGNITAS INFINITA', description = '' WHERE id_product = '22506' 06/05/2024 01:03:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.5' WHERE id_product = '22506' 06/05/2024 01:03:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22506' 06/05/2024 01:03:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22506' 06/05/2024 01:05:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '663456' , '2024-05-02' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.06' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '105.80' , '105.80' , NOW() , NOW() ) 06/05/2024 01:05:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91638' 06/05/2024 01:05:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91638' 06/05/2024 01:05:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91638' , '22505' , 'DALLALBA AL TRAMONTO - GIU 24' , '1' , '1' , '4' , '3.20' , '3.2' , '0' , '30' , '2.2400' ) 06/05/2024 01:05:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22505' AND id_supplier = '7' 06/05/2024 01:05:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22505' , '7' , '1' ) 06/05/2024 01:05:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91638' , '22506' , 'DIGNITAS INFINITA' , '60' , '60' , '4' , '2.50' , '2.5' , '0' , '33' , '100.5000' ) 06/05/2024 01:05:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22506' AND id_supplier = '7' 06/05/2024 01:05:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22506' , '7' , '1' ) 06/05/2024 01:05:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91638' , '22506' , 'DIGNITAS INFINITA' , '5' , '5' , '4' , '2.50' , '2.5' , '0' , '100' , '0.0000' ) 06/05/2024 01:05:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22506' AND id_supplier = '7' 06/05/2024 01:05:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22506' , '7' , '1' ) 06/05/2024 01:11:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1450' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 01:11:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1450' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '138.60' , '119.51' , NOW() , NOW() ) 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91639' 06/05/2024 01:11:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91639' 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91639' , '15291' , 'BENEDIZIONI - CROCIFISSIONE A' , '100' , '-100' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '15.00' ) 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91639' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91639' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91639' , '7311' , 'OSTIA SOTTILE 74MM' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 06/05/2024 01:11:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91639' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 06/05/2024 01:11: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 ( '91639' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 06/05/2024 01:11: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 ( '91639' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 06/05/2024 01:11: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 ( '91639' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 06/05/2024 04:27:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1451' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 04:27:52 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' , '1451' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.90' , '51.98' , NOW() , NOW() ) 06/05/2024 04:27:52 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 = '91640' 06/05/2024 04:27:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '91640' 06/05/2024 04:27:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91640' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 06/05/2024 04:27:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91640' , '3636' , 'DON BOSCO LA MAGNIFICA STORIA' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 06/05/2024 04:33:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1452' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 04:33:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1452' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 06/05/2024 04:33: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 = '91641' 06/05/2024 04:33:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '91641' 06/05/2024 04:33: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 ( '91641' , '22479' , 'NON VI GUARDO PERCHE RISCHIO DI FIDARMI - C. BURGO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/05/2024 04:46:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 04:46: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' , '84' , '2024-05-06' , '' , '2624' , '0' , '4670911' , 'P. ZZA ANNUNZIATA 84095 GIFFONI VALLE PIANA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '41.65' , '41.65' , NOW() , NOW() ) 06/05/2024 04:46: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 = '91642' 06/05/2024 04:46:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91642' 06/05/2024 04:46: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 ( '91642' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '14' , '-14' , '4' , '3.50' , '3.5' , '0' , '15' , '41.65' ) 06/05/2024 04:57:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '73' AND id_document != '91280' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-16') 06/05/2024 04:57:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '73', document_date = '2024-04-16', document_letter = '', id_customer = '4100', id_supplier = '', id_address = '4679310', address1 = 'STRADA PROVINCIALE 12 n. 30 12060 BASTIA MONDOVI\\\'', address2 = '', note = '', price_shipping = '3', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '43.00', price_tax_excluded = '43.00', date_upd = NOW() WHERE id_document = '91280' 06/05/2024 04:57:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91280' 06/05/2024 04:57:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91280' 06/05/2024 04:57:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91280' , '15020' , 'PREGARE OGNI GIORNO' , '40' , '-40' , '4' , '1.0000' , '1' , '0' , '0' , '40.00' ) 06/05/2024 05:00:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '1453' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:00:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1453' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.60' , '25.60' , NOW() , NOW() ) 06/05/2024 05:00:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91643' 06/05/2024 05:00:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '91643' 06/05/2024 05:00:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91643' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 06/05/2024 05:23:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1454' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:23:38 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' , '1454' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 06/05/2024 05:23:38 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 = '91644' 06/05/2024 05:23:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91644' 06/05/2024 05:23:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91644' , '21765' , 'BRACCIALE IN ARG. - 7593/1' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 06/05/2024 05:23:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91644' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 06/05/2024 05:35:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1455' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:35:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1455' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 06/05/2024 05:35:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91645' 06/05/2024 05:35:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '91645' 06/05/2024 05:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91645' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/05/2024 05:35:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91645' , '21684' , 'CEST LA CONFIANCE ' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 06/05/2024 05:37:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1456' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:37:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1456' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/05/2024 05:37: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 = '91646' 06/05/2024 05:37:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91646' 06/05/2024 05:37: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 ( '91646' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/05/2024 05:48:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '1457' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:48:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1457' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.00' , '95.08' , NOW() , NOW() ) 06/05/2024 05:48:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91647' 06/05/2024 05:48:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91647' 06/05/2024 05:48:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91647' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 06/05/2024 05:48: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 ( '91647' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '55' , '45.081967213115' , '22' , '0' , '110.00' ) 06/05/2024 05:58:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1458' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 05:58: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' , '1458' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.80' , '8.85' , NOW() , NOW() ) 06/05/2024 05:58: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 = '91648' 06/05/2024 05:58:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91648' 06/05/2024 05:58: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 ( '91648' , '22408' , 'PASTRELLA CRESIMA - 1302/K178' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 06/05/2024 05:58: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 ( '91648' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 06/05/2024 05:58: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 ( '91648' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/05/2024 06:12:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1459' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 06:12:32 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1459' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.40' , '12.58' , NOW() , NOW() ) 06/05/2024 06:12:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91649' 06/05/2024 06:12:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '91649' 06/05/2024 06:12:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91649' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 06/05/2024 06:12:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91649' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 06/05/2024 06:12:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91649' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 06/05/2024 06:27:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1460' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 06:27: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' , '1460' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.80' , '4.75' , NOW() , NOW() ) 06/05/2024 06:27: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 = '91650' 06/05/2024 06:27:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '91650' 06/05/2024 06:27: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 ( '91650' , '13362' , 'CORONA VETRO MM 6' , '2' , '-2' , '1' , '2.9' , '2.3770491803279' , '22' , '0' , '5.80' ) 06/05/2024 07:25:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '1461' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-06') 06/05/2024 07:25: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' , '1461' , '2024-05-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.90' , '2.38' , NOW() , NOW() ) 06/05/2024 07:25: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 = '91651' 06/05/2024 07:25:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '91651' 06/05/2024 07:25:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91651' , '21155' , 'BRACCIALE TENNIS + MEDAGLIA - 209' , '1' , '-1' , '1' , '2.90' , '2.3770491803279' , '22' , '0' , '2.90' )