02/11/2023 08:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '88284' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 02/11/2023 08:30:59 am >> UPDATE ps_document SET id_document_type = '24', document_num = '106/A', document_date = '2023-10-13', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'RESTANO 83.30', 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 = '287.05', price_tax_excluded = '287.05', date_upd = NOW() WHERE id_document = '88284' 02/11/2023 08:30:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88284' 02/11/2023 08:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88284' 02/11/2023 08:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '-23' , '4' , '3.4000' , '3.4' , '0' , '15' , '66.47' ) 02/11/2023 08:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '29' , '-29' , '4' , '3.5000' , '3.5' , '0' , '15' , '86.28' ) 02/11/2023 08:31:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4154' , 'FESTA DEL PERDONO' , '31' , '-31' , '4' , '3.0000' , '3' , '0' , '15' , '79.05' ) 02/11/2023 08:31:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/11/2023 08:31:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 02/11/2023 08:31:55 am >> SELECT document_num FROM ps_document WHERE document_num = '112/A' AND id_document != '88581' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-27') 02/11/2023 08:31:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '112/A', document_date = '2023-10-27', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'RESTANO 136.97', 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 = '259.97', price_tax_excluded = '259.97', date_upd = NOW() WHERE id_document = '88581' 02/11/2023 08:31: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 = '88581' 02/11/2023 08:31:55 am >> DELETE FROM ps_document_detail WHERE id_document = '88581' 02/11/2023 08:31: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 ( '88581' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '29' , '-29' , '4' , '2.8000' , '2.8' , '0' , '15' , '69.02' ) 02/11/2023 08:31: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 ( '88581' , '4120' , 'FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '15' , '15.30' ) 02/11/2023 08:31: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 ( '88581' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 02/11/2023 08:31: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 ( '88581' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 02/11/2023 08:31: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 ( '88581' , '17325' , 'ALLA SCOPERTA DELLA CASA DI GESU' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 02/11/2023 08:31: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 ( '88581' , '0' , 'lumino elettrico' , '2' , '-2' , '4' , '6.9000' , '6.9' , '0' , '0' , '13.80' ) 02/11/2023 08:31: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 ( '88581' , '4120' , 'FEDE NELLO ZAINETTO' , '27' , '-27' , '4' , '6.0000' , '6' , '0' , '15' , '137.70' ) 02/11/2023 08:36:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3421' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 08:36:18 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' , '3421' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.06' , '16.06' , NOW() , NOW() ) 02/11/2023 08:36:18 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 = '88674' 02/11/2023 08:36:18 am >> DELETE FROM ps_document_detail WHERE id_document = '88674' 02/11/2023 08:36:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88674' , '20494' , 'TI VOGLIO FELICE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 02/11/2023 09:10:04 am >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '88284' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 02/11/2023 09:10:04 am >> UPDATE ps_document SET id_document_type = '24', document_num = '106/A', document_date = '2023-10-13', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'RESTANO 83.30', 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 = '83.30', price_tax_excluded = '83.30', date_upd = NOW() WHERE id_document = '88284' 02/11/2023 09:10:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88284' 02/11/2023 09:10:05 am >> DELETE FROM ps_document_detail WHERE id_document = '88284' 02/11/2023 09:10:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4154' , 'FESTA DEL PERDONO' , '31' , '-31' , '4' , '3.0000' , '3' , '0' , '15' , '79.05' ) 02/11/2023 09:10:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 02/11/2023 09:11:13 am >> SELECT document_num FROM ps_document WHERE document_num = '112/A' AND id_document != '88581' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-27') 02/11/2023 09:11:13 am >> UPDATE ps_document SET id_document_type = '24', document_num = '112/A', document_date = '2023-10-27', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', 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 = '137.70', price_tax_excluded = '137.70', date_upd = NOW() WHERE id_document = '88581' 02/11/2023 09:11:13 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 = '88581' 02/11/2023 09:11:13 am >> DELETE FROM ps_document_detail WHERE id_document = '88581' 02/11/2023 09:11:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88581' , '4120' , 'FEDE NELLO ZAINETTO' , '27' , '-27' , '4' , '6.0000' , '6' , '0' , '15' , '137.70' ) 02/11/2023 09:26:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3422' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 09:26:01 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' , '3422' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '24.50' , NOW() , NOW() ) 02/11/2023 09:26:01 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 = '88675' 02/11/2023 09:26:01 am >> DELETE FROM ps_document_detail WHERE id_document = '88675' 02/11/2023 09:26:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88675' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 02/11/2023 09:26:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3423' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 09:26:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3423' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.53' , '16.53' , NOW() , NOW() ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88676' 02/11/2023 09:26:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88676' 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 02/11/2023 09:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88676' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '0.8' , '0.8' , '0' , '0' , '1.60' ) 02/11/2023 09:32:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3170' AND id_document != '88297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-14') 02/11/2023 09:32:58 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3170', document_date = '2023-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '88297' 02/11/2023 09:32:58 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88297' 02/11/2023 09:32:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88297' 02/11/2023 09:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88297' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 02/11/2023 09:32:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88297' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '60' , '-60' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '21.00' ) 02/11/2023 09:46:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3424' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 09:46:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3424' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 02/11/2023 09:46:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88677' 02/11/2023 09:46:28 am >> DELETE FROM ps_document_detail WHERE id_document = '88677' 02/11/2023 09:46: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 ( '88677' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/11/2023 09:46: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 ( '88677' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/11/2023 09:57:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851414566' AND id_product != '11022' AND ean13 != '' 02/11/2023 09:57:35 am >> UPDATE ps_product SET id_supplier = '119', reference = '11/6', ean13 = '9788851414566', date_upd = NOW() WHERE id_product = '11022' 02/11/2023 09:57:35 am >> UPDATE ps_product_lang SET name = 'VANGELI TRADOTTI E COMMENTATI', description = '' WHERE id_product = '11022' 02/11/2023 09:57:35 am >> UPDATE ps_product SET wholesale_price = '34.10', on_sale = '0', price = '65' WHERE id_product = '11022' 02/11/2023 09:57:35 am >> UPDATE ps_product_shop SET wholesale_price = '34.10', price = '65', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11022' 02/11/2023 09:57:35 am >> DELETE FROM ps_specific_price WHERE id_product = '11022' 02/11/2023 10:01:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861245471' AND id_product != '10748' AND ean13 != '' 02/11/2023 10:01:04 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861245471', date_upd = NOW() WHERE id_product = '10748' 02/11/2023 10:01:04 am >> UPDATE ps_product_lang SET name = 'TU MI CHIAMI PER NOME', description = '' WHERE id_product = '10748' 02/11/2023 10:01:04 am >> UPDATE ps_product SET wholesale_price = '4.13', on_sale = '0', price = '6.9' WHERE id_product = '10748' 02/11/2023 10:01:04 am >> UPDATE ps_product_shop SET wholesale_price = '4.13', price = '6.9', id_tax_rules_group = '4', id_category_default = '26', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10748' 02/11/2023 10:01:04 am >> DELETE FROM ps_specific_price WHERE id_product = '10748' 02/11/2023 10:02:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '646602' , '2023-10-30' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '33.37' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1059.81' , '1059.81' , NOW() , NOW() ) 02/11/2023 10:02: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 = '88678' 02/11/2023 10:02:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88678' 02/11/2023 10:02: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 ( '88678' , '18710' , 'SERVIRE A MESSA ' , '1' , '1' , '4' , '6.00' , '6' , '0' , '33' , '4.0200' ) 02/11/2023 10:02:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '18710' AND id_supplier = '7' 02/11/2023 10:02:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18710' , '7' , '1' ) 02/11/2023 10:02: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 ( '88678' , '11022' , 'VANGELI TRADOTTI E COMMENTATI' , '1' , '1' , '4' , '65.00' , '65' , '0' , '33' , '43.5500' ) 02/11/2023 10:02:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '11022' AND id_supplier = '7' 02/11/2023 10:02:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11022' , '7' , '1' ) 02/11/2023 10:02: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 ( '88678' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '28' , '28' , '4' , '11.90' , '11.9' , '0' , '35+7' , '201.4194' ) 02/11/2023 10:02:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '21410' AND id_supplier = '7' 02/11/2023 10:02:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21410' , '7' , '1' ) 02/11/2023 10:02: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 ( '88678' , '12895' , 'PASSI VERSO LA CRESIMA' , '39' , '39' , '4' , '7.90' , '7.9' , '0' , '35+7' , '186.2465' ) 02/11/2023 10:02:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '12895' AND id_supplier = '7' 02/11/2023 10:02:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12895' , '7' , '1' ) 02/11/2023 10:02: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 ( '88678' , '17318' , 'CONOSCI LO SPIRITO SANTO - GUIDA' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30+7' , '6.3798' ) 02/11/2023 10:02:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '17318' AND id_supplier = '7' 02/11/2023 10:02:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17318' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '17243' , 'DIARIO DELLA MIA CRESIMA' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '30+7' , '7.6818' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '17243' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17243' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '17245' , 'DIARIO DELLA MIA PRIMA COMUNIONE' , '2' , '2' , '4' , '5.90' , '5.9' , '0' , '30+7' , '7.6818' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '17245' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17245' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5451' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5451' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '19937' , 'SANTI A COLORI' , '1' , '1' , '4' , '8.90' , '8.9' , '0' , '30+7' , '5.7939' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19937' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19937' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '50' , '50' , '4' , '3.00' , '3' , '0' , '35+7' , '90.6750' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '50' , '50' , '4' , '3.00' , '3' , '0' , '35+7' , '90.6750' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+7' , '181.3500' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '10748' , 'TU MI CHIAMI PER NOME' , '35' , '35' , '4' , '6.90' , '6.9' , '0' , '30+7' , '157.2165' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '10748' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10748' , '7' , '1' ) 02/11/2023 10:02:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88678' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33+7' , '7.4772' ) 02/11/2023 10:02:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 02/11/2023 10:02:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 02/11/2023 10:02: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 ( '88678' , '11280' , 'VI HO CHIAMATO AMICI - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+7' , '7.2540' ) 02/11/2023 10:02:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11280' AND id_supplier = '7' 02/11/2023 10:02:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11280' , '7' , '1' ) 02/11/2023 10:08:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3425' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:08: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' , '3425' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.58' , '61.40' , NOW() , NOW() ) 02/11/2023 10:08: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 = '88679' 02/11/2023 10:08:50 am >> DELETE FROM ps_document_detail WHERE id_document = '88679' 02/11/2023 10:08: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 ( '88679' , '18667' , 'SCOPRIAMO LA CRESIMA' , '13' , '-13' , '4' , '4.90' , '4.9' , '0' , '5' , '60.58' ) 02/11/2023 10:08: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 ( '88679' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/11/2023 10:10:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:10:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3426' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 02/11/2023 10:10:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88680' 02/11/2023 10:10:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88680' 02/11/2023 10:10:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88680' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 02/11/2023 10:13:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:13:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3427' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/11/2023 10:13:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88681' 02/11/2023 10:13:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88681' 02/11/2023 10:13:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88681' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/11/2023 10:15:59 am >> SELECT document_num FROM ps_document WHERE document_num = '3428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:15:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3428' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 02/11/2023 10:15:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88682' 02/11/2023 10:15:59 am >> DELETE FROM ps_document_detail WHERE id_document = '88682' 02/11/2023 10:15:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88682' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '28' , '22.950819672131' , '22' , '0' , '28.00' ) 02/11/2023 10:40:49 am >> SELECT document_num FROM ps_document WHERE document_num = '52/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:40:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '52/E' , '2023-11-02' , 'E' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '98.00' , '98.00' , NOW() , NOW() ) 02/11/2023 10:40: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 = '88683' 02/11/2023 10:40:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88683' 02/11/2023 10:40: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 ( '88683' , '8408' , 'PRENDETE E MANGIATE' , '50' , '-50' , '4' , '3.00' , '3' , '0' , '38' , '93.00' ) 02/11/2023 10:51:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983936' AND id_product != '18657' AND ean13 != '' 02/11/2023 10:51:48 am >> UPDATE ps_product SET id_supplier = '53', reference = '7/2', ean13 = '9788895983936', date_upd = NOW() WHERE id_product = '18657' 02/11/2023 10:51:49 am >> UPDATE ps_product_lang SET name = 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI', description = '' WHERE id_product = '18657' 02/11/2023 10:51:49 am >> UPDATE ps_product SET wholesale_price = '3.80', on_sale = '0', price = '16.0000' WHERE id_product = '18657' 02/11/2023 10:51:49 am >> UPDATE ps_product_shop SET wholesale_price = '3.80', price = '16.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '64', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18657' 02/11/2023 10:51:49 am >> DELETE FROM ps_specific_price WHERE id_product = '18657' 02/11/2023 10:51:49 am >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '18657' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 02/11/2023 10:52:11 am >> SELECT document_num FROM ps_document WHERE document_num = '222' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 10:52:11 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' , '222' , '2023-11-02' , '' , '3496' , '0' , '4679075' , 'VIA ALLA BASILICA 1 23808 VERCURAGO' , '' , 'COPIE OMAGGIO AUTORE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 02/11/2023 10:52:11 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 = '88684' 02/11/2023 10:52:11 am >> DELETE FROM ps_document_detail WHERE id_document = '88684' 02/11/2023 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88684' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '100' , '0.00' ) 02/11/2023 10:52:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88684' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '5' , '-5' , '4' , '16.00' , '16' , '0' , '100' , '0.00' ) 02/11/2023 11:11:13 am >> SELECT document_num FROM ps_document WHERE document_num = '28/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 11:11:13 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' , '28/S' , '2023-11-02' , 'S' , '3730' , '0' , '4681792' , 'VIA NAZIONALE APPIA 81022 CASAGIOVE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '315.00' , '315.00' , NOW() , NOW() ) 02/11/2023 11:11:13 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 = '13225' 02/11/2023 11:11:13 am >> DELETE FROM ps_document_detail WHERE id_document = '13225' 02/11/2023 11:11:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13225' , '17' , 'LA FEDE NELLO ZAINETTO' , '4' , '-4' , '4' , '5' , '5' , '0' , '38' , '12.40' ) 02/11/2023 11:11:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13225' , '17' , 'LA FEDE NELLO ZAINETTO' , '80' , '-80' , '4' , '6.00' , '6' , '0' , '38' , '297.60' ) 02/11/2023 11:15:17 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'tYfGplXchP4PR81t' , NOW() , NOW() ) 02/11/2023 11:15:17 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7071' , '1' ) 02/11/2023 11:15:18 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7071' , '2' ) 02/11/2023 11:15:18 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7071' , '3' ) 02/11/2023 11:16:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7071' 02/11/2023 11:16:33 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7071' , '10' , '183' , '' , 'MANNA' , 'MARCO' , 'PRIMA TRAVERSA BENEDETTO CROCE 1' , '' , '80021' , 'AFRAGOLA' , '' , '' , '3516188052' , '' , '' , NOW() , NOW() ) 02/11/2023 11:16:33 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7071' 02/11/2023 11:18:04 am >> SELECT document_num FROM ps_document WHERE document_num = '96' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 11:18:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '96' , '2023-11-02' , '' , '3541' , '0' , '4670291' , 'PRIMA TRAVERSA BENEDETTO CROCE 1 80021 AFRAGOLA' , '' , '' , '2.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 02/11/2023 11:18:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13226' 02/11/2023 11:18:04 am >> DELETE FROM ps_document_detail WHERE id_document = '13226' 02/11/2023 11:18:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13226' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 02/11/2023 11:44:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 11:44: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' , '3429' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 02/11/2023 11:44: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 = '88685' 02/11/2023 11:44:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88685' 02/11/2023 11:44: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 ( '88685' , '16592' , 'CORONCINA PER LE ANIME DEI SACERDOTI... 8195' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 02/11/2023 11:53:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '216' , '2023-10-30' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.80' , '140.00' , NOW() , NOW() ) 02/11/2023 11:53:27 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 = '88686' 02/11/2023 11:53:27 am >> DELETE FROM ps_document_detail WHERE id_document = '88686' 02/11/2023 11:53: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 ( '88686' , '21423' , 'STOLA ROMANA S. MOIRE - 7092S' , '1' , '1' , '1' , '140' , '114.75409836066' , '22' , '0' , '170.8000' ) 02/11/2023 11:53:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '21423' AND id_supplier = '126' 02/11/2023 11:53:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21423' , '126' , '1' ) 02/11/2023 11:55:19 am >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 11:55:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '223' , '2023-11-02' , '' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.22' , '164.22' , NOW() , NOW() ) 02/11/2023 11:55:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88687' 02/11/2023 11:55:19 am >> DELETE FROM ps_document_detail WHERE id_document = '88687' 02/11/2023 11:55:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88687' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '15' , '25.50' ) 02/11/2023 11:55:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88687' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '48' , '-48' , '4' , '3.40' , '3.4' , '0' , '15' , '138.72' ) 02/11/2023 11:55:41 am >> SELECT document_num FROM ps_document WHERE document_num = '223' AND id_document != '88687' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 11:55:41 am >> UPDATE ps_document SET id_document_type = '21', document_num = '223', document_date = '2023-11-02', document_letter = '', id_customer = '1203', id_supplier = '', id_address = '4669427', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = 'DA SALDARE', 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 = '164.22', price_tax_excluded = '164.22', date_upd = NOW() WHERE id_document = '88687' 02/11/2023 11:55:41 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 = '88687' 02/11/2023 11:55:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88687' 02/11/2023 11:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88687' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '15' , '25.50' ) 02/11/2023 11:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88687' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '48' , '-48' , '4' , '3.4000' , '3.4' , '0' , '15' , '138.72' ) 02/11/2023 11:57:57 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '88242' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-12') 02/11/2023 11:57:57 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2023-10-12', document_letter = 'A', id_customer = '1203', id_supplier = '', id_address = '4669427', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '143.05', price_tax_excluded = '129.35', date_upd = NOW() WHERE id_document = '88242' 02/11/2023 11:57:57 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 = '88242' 02/11/2023 11:57:57 am >> DELETE FROM ps_document_detail WHERE id_document = '88242' 02/11/2023 11:57: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 ( '88242' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '21627' , 'AVVENTO E NATALE 2023' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '1' , '-1' , '1' , '59.0000' , '48.360655737705' , '22' , '0' , '59.00' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '18284' , 'SEI NATO ORIGINALE - C. ACUTIS' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '20690' , 'CARLO ACUTIS APOSTOLO DEI MILLENNIALS - V. RIZZO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 02/11/2023 11:57:58 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88242' , '8855' , 'REGISTRO DEL CATECHISTA' , '7' , '-7' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '5.25' ) 02/11/2023 12:07:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '88658' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-31') 02/11/2023 12:07:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2023-10-31', document_letter = 'A', id_customer = '3821', id_supplier = '', id_address = '4672560', address1 = 'P. ZZA S. CATERINA 1 84090 GIFFONI SEI CASALI', 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 = '143.37', price_tax_excluded = '143.37', date_upd = NOW() WHERE id_document = '88658' 02/11/2023 12:07:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88658' 02/11/2023 12:07:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '88658' 02/11/2023 12:07:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88658' , '10751' , 'TU MI PERDONI' , '12' , '-12' , '4' , '5.9000' , '5.9' , '0' , '10' , '63.72' ) 02/11/2023 12:07:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88658' , '14719' , 'TU MI AMI DAVVERO' , '15' , '-15' , '4' , '5.9000' , '5.9' , '0' , '10' , '79.65' ) 02/11/2023 12:10:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '111' , '2023-10-31' , '' , '0' , '149' , '4671100' , 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '92.48' , '75.80' , NOW() , NOW() ) 02/11/2023 12:10:50 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 = '88688' 02/11/2023 12:10:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '88688' 02/11/2023 12:10:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88688' , '19852' , 'PATENA CON GRECA CM 19 - 999/7 D' , '1' , '1' , '1' , '64' , '52.459016393443' , '22' , '5' , '74.1760' ) 02/11/2023 12:10:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19852' AND id_supplier = '149' 02/11/2023 12:10:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19852' , '149' , '1' ) 02/11/2023 12:12:04 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '111', document_date = '2023-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4671100', address1 = 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.', address2 = '', note = '', price_shipping = '15.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '92.48', price_tax_excluded = '75.80', date_upd = NOW() WHERE id_document = '88688' 02/11/2023 12:12:04 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 = '88688' 02/11/2023 12:12:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '88688' 02/11/2023 12:12:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88688' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '1' , '1' , '64' , '52.459016393443' , '22' , '5' , '74.1760' ) 02/11/2023 12:13:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000866' AND id_product != '19848' AND ean13 != '' 02/11/2023 12:13:06 pm >> UPDATE ps_product SET id_supplier = '149', reference = '', ean13 = '000866', date_upd = NOW() WHERE id_product = '19848' 02/11/2023 12:13:06 pm >> UPDATE ps_product_lang SET name = 'PATENA CON GRECA CM 19 - 999/7 A', description = '' WHERE id_product = '19848' 02/11/2023 12:13:06 pm >> UPDATE ps_product SET wholesale_price = '45.00', on_sale = '0', price = '118.85245901639344' WHERE id_product = '19848' 02/11/2023 12:13:06 pm >> UPDATE ps_product_shop SET wholesale_price = '45.00', price = '118.85245901639344', id_tax_rules_group = '1', id_category_default = '480', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19848' 02/11/2023 12:13:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '19848' 02/11/2023 12:51:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-02') 02/11/2023 12:51: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' , '3430' , '2023-11-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 02/11/2023 12:51: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 = '88689' 02/11/2023 12:51:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88689' 02/11/2023 12:51: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 ( '88689' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' )