15/10/2022 08:34:18 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '7914' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-14') 15/10/2022 08:34:18 am >> UPDATE ps_document SET id_document_type = '21', document_num = '97', document_date = '2022-10-14', document_letter = '', id_customer = '6995', id_supplier = '', id_address = '88682001', address1 = 'VIA DEL CASTELLO 56040 CASALE MARITTIMO', address2 = '', note = '', price_shipping = '6.9', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '69.90', price_tax_excluded = '69.90', date_upd = NOW() WHERE id_document = '7914' 15/10/2022 08:34: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 = '7914' 15/10/2022 08:34:18 am >> DELETE FROM ps_document_detail WHERE id_document = '7914' 15/10/2022 08:34: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 ( '7914' , '75' , 'IL SEGNO DELLA CROCE' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '10' , '13.50' ) 15/10/2022 08:34:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '75' AND id_supplier = '' 15/10/2022 08:34:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '75' , '' , '1' ) 15/10/2022 08:34: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 ( '7914' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '10' , '13.50' ) 15/10/2022 08:34:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 15/10/2022 08:34:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 15/10/2022 08:34: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 ( '7914' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '10' , '13.50' ) 15/10/2022 08:34:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '55' AND id_supplier = '' 15/10/2022 08:34:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '55' , '' , '1' ) 15/10/2022 08:34: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 ( '7914' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '10' , '-10' , '4' , '2.50' , '2.5' , '0' , '10' , '22.50' ) 15/10/2022 08:34:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '24' AND id_supplier = '' 15/10/2022 08:34:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24' , '' , '1' ) 15/10/2022 08:35:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001723' AND id_product != '18239' AND ean13 != '' 15/10/2022 08:35:56 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001723', date_upd = NOW() WHERE id_product = '18239' 15/10/2022 08:35:56 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA - MARIANO M/l - 7051', description = '' WHERE id_product = '18239' 15/10/2022 08:35:56 am >> UPDATE ps_product SET wholesale_price = '25.00', on_sale = '0', price = '51.6393' WHERE id_product = '18239' 15/10/2022 08:35:56 am >> UPDATE ps_product_shop SET wholesale_price = '25.00', price = '51.6393', id_tax_rules_group = '1', id_category_default = '448', 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 = '18239' 15/10/2022 08:35:56 am >> DELETE FROM ps_specific_price WHERE id_product = '18239' 15/10/2022 08:37:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801027549' AND id_product != '3438' AND ean13 != '' 15/10/2022 08:37:55 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/3', ean13 = '9788801027549', date_upd = NOW() WHERE id_product = '3438' 15/10/2022 08:37:55 am >> UPDATE ps_product_lang SET name = 'DIECI COMANDAMENTI SPIEGATI AI RAGAZZI - V. BOCCI', description = '' WHERE id_product = '3438' 15/10/2022 08:37:56 am >> UPDATE ps_product SET wholesale_price = '3.19', on_sale = '0', price = '4.9000' WHERE id_product = '3438' 15/10/2022 08:37:56 am >> UPDATE ps_product_shop SET wholesale_price = '3.19', price = '4.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '22', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3438' 15/10/2022 08:37:56 am >> DELETE FROM ps_specific_price WHERE id_product = '3438' 15/10/2022 08:38:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8032727896903' AND id_product != '9797' AND ean13 != '' 15/10/2022 08:38:18 am >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '8032727896903', date_upd = NOW() WHERE id_product = '9797' 15/10/2022 08:38:18 am >> UPDATE ps_product_lang SET name = 'SEGNALIBRO CRESIMA - 95-26 ', description = '' WHERE id_product = '9797' 15/10/2022 08:38:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.2049' WHERE id_product = '9797' 15/10/2022 08:38:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.2049', id_tax_rules_group = '1', id_category_default = '175', 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 = '9797' 15/10/2022 08:38:18 am >> DELETE FROM ps_specific_price WHERE id_product = '9797' 15/10/2022 08:39:42 am >> SELECT document_num FROM ps_document WHERE document_num = '3045' AND id_document != '66348' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-14') 15/10/2022 08:39:42 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3045', document_date = '2022-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 = '18.75', price_tax_excluded = '18.25', date_upd = NOW() WHERE id_document = '66348' 15/10/2022 08:39:42 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 = '66348' 15/10/2022 08:39:42 am >> DELETE FROM ps_document_detail WHERE id_document = '66348' 15/10/2022 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 - OGGETTI' , '8' , '-8' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '2.00' ) 15/10/2022 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '9797' AND id_supplier = '' 15/10/2022 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9797' , '' , '1' ) 15/10/2022 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/10/2022 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/10/2022 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/10/2022 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 15/10/2022 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7936' AND id_supplier = '' 15/10/2022 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7936' , '' , '1' ) 15/10/2022 08:39:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66348' , '7923' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. B' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 15/10/2022 08:39:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '7923' AND id_supplier = '' 15/10/2022 08:39:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7923' , '' , '1' ) 15/10/2022 08:58:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3409' 15/10/2022 08:58:14 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 ( '3409' , '10' , '232' , '' , 'DON GIUSEPPE' , 'PERNIGOTTI' , 'VIA VALLE DEI PRINCIPI 9' , '' , '01034' , 'FABRICA DI ROMA' , 'PARR. S. GRATILIANO E FELICISSIMA' , '' , '3392466613' , '' , '90015920565 ' , NOW() , NOW() ) 15/10/2022 08:58:14 am >> UPDATE ps_customer SET email = 'pernigotti43@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3409' 15/10/2022 09:05:24 am >> SELECT document_num FROM ps_document WHERE document_num = '169' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 09:05:24 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' , '169' , '2022-10-15' , '' , '3409' , '0' , '4675737' , 'VIA VALLE DEI PRINCIPI 9 01034 FABRICA DI ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '135.00' , '135.00' , NOW() , NOW() ) 15/10/2022 09:05:24 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 = '66369' 15/10/2022 09:05:24 am >> DELETE FROM ps_document_detail WHERE id_document = '66369' 15/10/2022 09:05:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66369' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '30' , '-30' , '4' , '5.00' , '5' , '0' , '10' , '135.00' ) 15/10/2022 09:15:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3063' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 09:15:23 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' , '3063' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.80' , '9.67' , NOW() , NOW() ) 15/10/2022 09:15:23 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 = '66370' 15/10/2022 09:15:23 am >> DELETE FROM ps_document_detail WHERE id_document = '66370' 15/10/2022 09:15:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66370' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11.8' , '9.672131147541' , '22' , '0' , '11.80' ) 15/10/2022 09:15:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 15/10/2022 09:15:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 15/10/2022 09:24:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3064' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 09:24: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' , '3064' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.11' , '93.11' , NOW() , NOW() ) 15/10/2022 09:24: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 = '66371' 15/10/2022 09:24:30 am >> DELETE FROM ps_document_detail WHERE id_document = '66371' 15/10/2022 09:24: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 ( '66371' , '5868' , 'LINEAMENTI DI PATROLOGIA - L. DATTRINO' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 15/10/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '5868' AND id_supplier = '' 15/10/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5868' , '' , '1' ) 15/10/2022 09:24: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 ( '66371' , '19140' , 'CODICE DI DIRITTO CANONICO N.E.' , '1' , '-1' , '4' , '69.50' , '69.5' , '0' , '5' , '66.03' ) 15/10/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19140' AND id_supplier = '' 15/10/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19140' , '' , '1' ) 15/10/2022 09:24: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 ( '66371' , '4326' , 'GAUDIUM ET SPES' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 15/10/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '4326' AND id_supplier = '' 15/10/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4326' , '' , '1' ) 15/10/2022 09:24: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 ( '66371' , '6005' , 'LUMEN GENTIUM' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2022 09:24:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '6005' AND id_supplier = '' 15/10/2022 09:24:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6005' , '' , '1' ) 15/10/2022 10:07:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3065' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 10:07:41 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' , '3065' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '15.38' , NOW() , NOW() ) 15/10/2022 10:07: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 = '66372' 15/10/2022 10:07:41 am >> DELETE FROM ps_document_detail WHERE id_document = '66372' 15/10/2022 10:07: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 ( '66372' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '4' , '-4' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '16.00' ) 15/10/2022 10:07:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/10/2022 10:07:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/10/2022 10:09:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3066' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 10:09:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3066' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.63' , '16.63' , NOW() , NOW() ) 15/10/2022 10:09: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 = '66373' 15/10/2022 10:09:04 am >> DELETE FROM ps_document_detail WHERE id_document = '66373' 15/10/2022 10:09: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 ( '66373' , '9104' , 'ROSARIO E VEGLIA DI PREGHIERA PER I DEFUNTI - R. GOZZELINO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/10/2022 10:09:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '9104' AND id_supplier = '' 15/10/2022 10:09:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9104' , '' , '1' ) 15/10/2022 10:09: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 ( '66373' , '9086' , 'ROSARIO CON I DEFUNTI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2022 10:09:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '9086' AND id_supplier = '' 15/10/2022 10:09:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9086' , '' , '1' ) 15/10/2022 10:09: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 ( '66373' , '16177' , 'ROSARIO PER I DEFUNTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 15/10/2022 10:09:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '16177' AND id_supplier = '' 15/10/2022 10:09:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16177' , '' , '1' ) 15/10/2022 10:09: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 ( '66373' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2022 10:09:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '17274' AND id_supplier = '' 15/10/2022 10:09:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17274' , '' , '1' ) 15/10/2022 10:09: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 ( '66373' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '5' , '1.90' ) 15/10/2022 10:09:05 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 15/10/2022 10:09:05 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 15/10/2022 10:37:10 am >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 10:37:10 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' , '170' , '2022-10-15' , '' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '140.00' , NOW() , NOW() ) 15/10/2022 10:37:10 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 = '66374' 15/10/2022 10:37:10 am >> DELETE FROM ps_document_detail WHERE id_document = '66374' 15/10/2022 10:37: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 ( '66374' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.50' , '3.5' , '0' , '15' , '74.38' ) 15/10/2022 10:37: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 ( '66374' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:37: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 ( '66374' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:37: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 ( '66374' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 15/10/2022 10:37: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 ( '66374' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 15/10/2022 10:37: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 ( '66374' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:37: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 ( '66374' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 15/10/2022 10:37: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 ( '66374' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '25' , '-25' , '4' , '1.00' , '1' , '0' , '15' , '21.25' ) 15/10/2022 10:37: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 ( '66374' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '15' , '5.10' ) 15/10/2022 10:37: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 ( '66374' , '' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.68' , '-0.68' , '0' , '0' , '-0.68' ) 15/10/2022 10:38:08 am >> SELECT document_num FROM ps_document WHERE document_num = '3067' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 10:38:08 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' , '3067' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 15/10/2022 10:38:08 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 = '66375' 15/10/2022 10:38:08 am >> DELETE FROM ps_document_detail WHERE id_document = '66375' 15/10/2022 10:38: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 ( '66375' , '961' , 'BASSORILIEVO BIMBO - OGGETTI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 15/10/2022 10:38:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '961' AND id_supplier = '' 15/10/2022 10:38:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '961' , '' , '1' ) 15/10/2022 10:43:50 am >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '66374' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 10:43:50 am >> UPDATE ps_document SET id_document_type = '21', document_num = '170', document_date = '2022-10-15', document_letter = '', id_customer = '1175', id_supplier = '', id_address = '4672789', address1 = 'VIA 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 = '15', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '140.00', date_upd = NOW() WHERE id_document = '66374' 15/10/2022 10:43: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 = '66374' 15/10/2022 10:43:50 am >> DELETE FROM ps_document_detail WHERE id_document = '66374' 15/10/2022 10:43: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 ( '66374' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.5000' , '3.5' , '0' , '15' , '74.38' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.5000' , '3.5' , '0' , '15' , '5.95' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '12813' , 'MARIA MADRE NOSTRA' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12813' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12813' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '25' , '-25' , '4' , '1.0000' , '1' , '0' , '15' , '21.25' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 15/10/2022 10:43:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 15/10/2022 10:43: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 ( '66374' , '12819' , 'REGISTRO DEL CATECHISTA ' , '6' , '-6' , '4' , '1.0000' , '1' , '0' , '15' , '5.10' ) 15/10/2022 10:43:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 15/10/2022 10:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 15/10/2022 10:43:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66374' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.6800' , '-0.68' , '0' , '0' , '-0.68' ) 15/10/2022 10:43:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 15/10/2022 10:43:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 15/10/2022 10:48:00 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '7914' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-14') 15/10/2022 10:48:00 am >> UPDATE ps_document SET id_document_type = '21', document_num = '97', document_date = '2022-10-14', document_letter = '', id_customer = '6995', id_supplier = '', id_address = '88682001', address1 = 'VIA DEL CASTELLO 56040 CASALE MARITTIMO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '66.40', price_tax_excluded = '66.40', date_upd = NOW() WHERE id_document = '7914' 15/10/2022 10:48:00 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 = '7914' 15/10/2022 10:48:00 am >> DELETE FROM ps_document_detail WHERE id_document = '7914' 15/10/2022 10:48: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 ( '7914' , '75' , 'IL SEGNO DELLA CROCE' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:48:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '75' AND id_supplier = '' 15/10/2022 10:48:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '75' , '' , '1' ) 15/10/2022 10:48: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 ( '7914' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:48:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '125' AND id_supplier = '' 15/10/2022 10:48:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '125' , '' , '1' ) 15/10/2022 10:48: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 ( '7914' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:48:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '55' AND id_supplier = '' 15/10/2022 10:48:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '55' , '' , '1' ) 15/10/2022 10:48: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 ( '7914' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 15/10/2022 10:48:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '24' AND id_supplier = '' 15/10/2022 10:48:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24' , '' , '1' ) 15/10/2022 10:49:18 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6995' 15/10/2022 10:49:18 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 ( '6995' , '10' , '197' , 'PARROCCHIA DI CASALE MARITTIMO' , 'GIOVANNINI' , 'DON GIULIANO' , 'VIA DEL CASTELLO 20' , '' , '56040' , 'CASALE MARITTIMO' , '' , '' , '3315339009' , '' , '83003410509' , NOW() , NOW() ) 15/10/2022 10:49:18 am >> UPDATE ps_customer SET email = 'dongiuliano12@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6995' 15/10/2022 10:49:46 am >> SELECT document_num FROM ps_document WHERE document_num = '97' AND id_document != '7914' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-10-14') 15/10/2022 10:49:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '97', document_date = '2022-10-14', document_letter = '', id_customer = '6995', id_supplier = '0', id_address = '88682002', address1 = 'VIA DEL CASTELLO 56040 CASALE MARITTIMO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '66.40', price_tax_excluded = '66.40', date_upd = NOW() WHERE id_document = '7914' 15/10/2022 10:49:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '7914' 15/10/2022 10:49:46 am >> DELETE FROM ps_document_detail WHERE id_document = '7914' 15/10/2022 10:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7914' , '75' , 'IL SEGNO DELLA CROCE' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7914' , '125' , 'MIE PREGHIERINE - N. E.' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7914' , '55' , 'AVE MARIA ,SPIEGATA AI BAMBINI' , '10' , '-10' , '4' , '1.5000' , '1.5' , '0' , '15' , '12.75' ) 15/10/2022 10:49:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '7914' , '24' , 'PADRE NOSTRO SPIEGATO AI BAMBINI N. E.' , '10' , '-10' , '4' , '2.5000' , '2.5' , '0' , '15' , '21.25' ) 15/10/2022 11:14:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3068' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:14:21 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' , '3068' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 15/10/2022 11:14:21 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 = '66376' 15/10/2022 11:14:21 am >> DELETE FROM ps_document_detail WHERE id_document = '66376' 15/10/2022 11:14:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66376' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/10/2022 11:14:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '' 15/10/2022 11:14:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '' , '1' ) 15/10/2022 11:22:29 am >> SELECT document_num FROM ps_document WHERE document_num = '76/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:22: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 ( '24' , '76/A' , '2022-10-15' , 'A' , '188' , '0' , '4668955' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '23.08' , NOW() , NOW() ) 15/10/2022 11:22: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 = '66377' 15/10/2022 11:22:29 am >> DELETE FROM ps_document_detail WHERE id_document = '66377' 15/10/2022 11:22: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 ( '66377' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/10/2022 11:22: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 ( '66377' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 15/10/2022 11:28:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3069' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:28:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3069' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '175.88' , '175.07' , NOW() , NOW() ) 15/10/2022 11:28: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 = '66378' 15/10/2022 11:28:49 am >> DELETE FROM ps_document_detail WHERE id_document = '66378' 15/10/2022 11:28: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 ( '66378' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '18' , '-18' , '4' , '2.7' , '2.7' , '0' , '0' , '48.60' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '18' , '-18' , '4' , '2.7' , '2.7' , '0' , '0' , '48.60' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '2.7' , '2.7' , '0' , '0' , '27.00' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '8600' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8600' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '2' , '-2' , '4' , '10.8' , '10.8' , '0' , '0' , '21.60' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '11193' , 'VENITE CON ME CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '18064' , 'SCOPRIAMO INSIEME LE RELIGIONI' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '18064' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18064' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5473' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5473' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/10/2022 11:28:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 15/10/2022 11:28:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 15/10/2022 11:28: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 ( '66378' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/10/2022 11:28:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4697' AND id_supplier = '' 15/10/2022 11:28:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4697' , '' , '1' ) 15/10/2022 11:44:58 am >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:44:58 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '10/L' , '2022-10-15' , 'L' , '3390' , '0' , '4670737' , 'VIA S. CALENDA, 162 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 15/10/2022 11:44: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 = '66379' 15/10/2022 11:44:58 am >> DELETE FROM ps_document_detail WHERE id_document = '66379' 15/10/2022 11:44: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 ( '66379' , '13212' , 'NATIVITA 5 PZ - 2416NA00' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 15/10/2022 11:52:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3070' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:52:17 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' , '3070' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '4.51' , NOW() , NOW() ) 15/10/2022 11:52:17 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 = '66380' 15/10/2022 11:52:17 am >> DELETE FROM ps_document_detail WHERE id_document = '66380' 15/10/2022 11:52:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66380' , '19129' , 'BRUCIAINCENSO ALADINO - ALA' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 15/10/2022 11:52:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '19129' AND id_supplier = '' 15/10/2022 11:52:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19129' , '' , '1' ) 15/10/2022 11:54:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3071' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:54:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3071' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 15/10/2022 11:54: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 = '66381' 15/10/2022 11:54:34 am >> DELETE FROM ps_document_detail WHERE id_document = '66381' 15/10/2022 11:54: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 ( '66381' , '18839' , 'MEDAGLIONE SMALTATO' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 15/10/2022 11:54:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '18839' AND id_supplier = '' 15/10/2022 11:54:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18839' , '' , '1' ) 15/10/2022 11:54: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 ( '66381' , '19129' , 'BRUCIAINCENSO ALADINO - ALA' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 15/10/2022 11:54:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '19129' AND id_supplier = '' 15/10/2022 11:54:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19129' , '' , '1' ) 15/10/2022 11:54: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 ( '66381' , '5958' , 'LUCAS 25G - FIORI DARANCIO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 15/10/2022 11:54:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '5958' AND id_supplier = '' 15/10/2022 11:54:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5958' , '' , '1' ) 15/10/2022 11:54: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 ( '66381' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/10/2022 11:54:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 15/10/2022 11:54:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 15/10/2022 11:59:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3072' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 11:59: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 ( '11' , '3072' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 15/10/2022 11:59: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 = '66382' 15/10/2022 11:59:06 am >> DELETE FROM ps_document_detail WHERE id_document = '66382' 15/10/2022 11:59: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 ( '66382' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 15/10/2022 11:59:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 15/10/2022 11:59:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 15/10/2022 12:00:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2913' AND id_document != '63594' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 15/10/2022 12:00:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2913', document_date = '2022-10-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '28.40', price_tax_excluded = '26.60', date_upd = NOW() WHERE id_document = '63594' 15/10/2022 12:00:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63594' 15/10/2022 12:00:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '63594' 15/10/2022 12:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63594' , '17875' , 'VITA COME FINE DEL MONDO - L. EPICOCO' , '1' , '-1' , '4' , '18.4' , '18.4' , '0' , '0' , '18.40' ) 15/10/2022 12:00:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17875' AND id_supplier = '' 15/10/2022 12:00:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17875' , '' , '1' ) 15/10/2022 12:00:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63594' , '19938' , 'AGENDA 2023 SAN PAOLO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/10/2022 12:00:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19938' AND id_supplier = '' 15/10/2022 12:00:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19938' , '' , '1' ) 15/10/2022 12:01:55 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3390' 15/10/2022 12:01:55 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3390' , '10' , '210' , 'ASSOCIAZIONE NOI PER TE' , '' , '' , 'VIA S. CALENDA, 162' , '' , '84126' , 'SALERNO' , 'SEDE LEGALE: PRESIDIO OSP. G. DA PROCIDA' , '089693237' , '3275895421' , '' , '95095950655' , NOW() , NOW() ) 15/10/2022 12:01:55 pm >> UPDATE ps_customer SET email = 'noiperte@tiscali.it', sdi = '0000000', pec = 'noiperte@pec.it', date_upd = NOW() WHERE id_customer = '3390' 15/10/2022 12:02:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '10/L' AND id_document != '66379' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 12:02:08 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '10/L', document_date = '2022-10-15', document_letter = 'L', id_customer = '3390', id_supplier = '0', id_address = '4675738', address1 = 'VIA S. CALENDA, 162 84126 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '55.00', price_tax_excluded = '45.08', date_upd = NOW() WHERE id_document = '66379' 15/10/2022 12:02:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66379' 15/10/2022 12:02:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '66379' 15/10/2022 12:02:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66379' , '13212' , 'NATIVITA 5 PZ - 2416NA00' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 15/10/2022 12:07:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2663' AND id_document != '61710' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-07') 15/10/2022 12:07:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2663', document_date = '2022-09-07', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '37.62', date_upd = NOW() WHERE id_document = '61710' 15/10/2022 12:07:14 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 = '61710' 15/10/2022 12:07:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61710' 15/10/2022 12:07:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61710' , '18747' , 'GESU NELLA MIA STORIA - G. AROSIO' , '1' , '-1' , '4' , '7.1' , '7.1' , '0' , '0' , '7.10' ) 15/10/2022 12:07:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18747' AND id_supplier = '' 15/10/2022 12:07:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18747' , '' , '1' ) 15/10/2022 12:07:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61710' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 15/10/2022 12:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 15/10/2022 12:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 15/10/2022 12:07:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61710' , '11124' , 'VANGELO SECONDO GIOVANNI - E. BOSSETTI' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '5' , '20.90' ) 15/10/2022 12:07:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11124' AND id_supplier = '' 15/10/2022 12:07:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11124' , '' , '1' ) 15/10/2022 12:07:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3024' AND id_document != '65810' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-12') 15/10/2022 12:07:43 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3024', document_date = '2022-10-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '142.00', price_tax_excluded = '119.37', date_upd = NOW() WHERE id_document = '65810' 15/10/2022 12:07:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '65810' 15/10/2022 12:07:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '65810' 15/10/2022 12:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65810' , '13523' , 'COPPIA AMPOLLINE 50 CC - 508' , '1' , '-1' , '1' , '27.9000' , '22.868852459016' , '22' , '0' , '27.90' ) 15/10/2022 12:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13523' AND id_supplier = '' 15/10/2022 12:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13523' , '' , '1' ) 15/10/2022 12:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65810' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '96.00' ) 15/10/2022 12:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 15/10/2022 12:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 15/10/2022 12:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65810' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '7.60' ) 15/10/2022 12:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/10/2022 12:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/10/2022 12:07:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '65810' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '1' , '-1' , '4' , '10.5' , '10.5' , '0' , '0' , '10.50' ) 15/10/2022 12:07:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19501' AND id_supplier = '' 15/10/2022 12:07:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19501' , '' , '1' ) 15/10/2022 12:45:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3073' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 12:45:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3073' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 15/10/2022 12:45:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66383' 15/10/2022 12:45:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '66383' 15/10/2022 12:45:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66383' , '16864' , 'CROCIFISSO SAGOMATO 40X25 - 104062' , '1' , '-1' , '1' , '125' , '102.45901639344' , '22' , '0' , '125.00' ) 15/10/2022 12:45:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16864' AND id_supplier = '' 15/10/2022 12:45:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16864' , '' , '1' ) 15/10/2022 12:50:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3074' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 12:50: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 ( '11' , '3074' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 15/10/2022 12:50: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 = '66384' 15/10/2022 12:50:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '66384' 15/10/2022 12:50: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 ( '66384' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 15/10/2022 12:50:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 15/10/2022 12:50:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 15/10/2022 12:50: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 ( '66384' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 15/10/2022 12:50:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 15/10/2022 12:50:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 15/10/2022 12:52:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '3075' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 12:52:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3075' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.80' , '21.43' , NOW() , NOW() ) 15/10/2022 12:52:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66385' 15/10/2022 12:52:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '66385' 15/10/2022 12:52:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66385' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '6.50' ) 15/10/2022 12:52:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11756' AND id_supplier = '' 15/10/2022 12:52:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11756' , '' , '1' ) 15/10/2022 12:52:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66385' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 15/10/2022 12:52:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 15/10/2022 12:52:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 15/10/2022 12:52:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '66385' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 15/10/2022 12:52:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 15/10/2022 12:52:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 15/10/2022 12:52: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 ( '66385' , '18222' , 'ROSARIO COLORATO - R316' , '15' , '-15' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '10.50' ) 15/10/2022 12:52:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 15/10/2022 12:52:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 15/10/2022 12:54:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3076' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-15') 15/10/2022 12:54:17 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' , '3076' , '2022-10-15' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.20' , '2.62' , NOW() , NOW() ) 15/10/2022 12:54:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '66386' 15/10/2022 12:54:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '66386' 15/10/2022 12:54: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 ( '66386' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '3.20' ) 15/10/2022 12:54:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '' 15/10/2022 12:54:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '' , '1' ) 15/10/2022 12:59:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2411' AND id_document != '59868' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-30') 15/10/2022 12:59:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2411', document_date = '2022-07-30', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '140.03', date_upd = NOW() WHERE id_document = '59868' 15/10/2022 12:59:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59868' 15/10/2022 12:59:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '59868' 15/10/2022 12:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '19889' , 'CROCE CERCHIO CM 25 ARG - 7019/04' , '1' , '-1' , '1' , '35.2' , '28.852459016393' , '22' , '0' , '35.20' ) 15/10/2022 12:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19889' AND id_supplier = '' 15/10/2022 12:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19889' , '' , '1' ) 15/10/2022 12:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 15/10/2022 12:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 15/10/2022 12:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 15/10/2022 12:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '17257' , 'IO TI BATTEZZO ' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '0' , '1.80' ) 15/10/2022 12:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17257' AND id_supplier = '' 15/10/2022 12:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17257' , '' , '1' ) 15/10/2022 12:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '19196' , 'STOLA DIACONALE MARIANA - 149DP' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 15/10/2022 12:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19196' AND id_supplier = '' 15/10/2022 12:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19196' , '' , '1' ) 15/10/2022 12:59:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59868' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/10/2022 12:59:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 15/10/2022 12:59:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' )