16/09/2024 09:31:09 am >> SELECT document_num FROM ps_document WHERE document_num = '2694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 09:31:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2694' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.00' , '41.80' , NOW() , NOW() ) 16/09/2024 09:31:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93150' 16/09/2024 09:31:09 am >> DELETE FROM ps_document_detail WHERE id_document = '93150' 16/09/2024 09:31: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 ( '93150' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '51.00' ) 16/09/2024 09:32:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 09:32: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' , '2695' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.90' , '5.66' , NOW() , NOW() ) 16/09/2024 09:32: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 = '93151' 16/09/2024 09:32:01 am >> DELETE FROM ps_document_detail WHERE id_document = '93151' 16/09/2024 09:32: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 ( '93151' , '11756' , 'VINO BIANCO SECCO - 14%' , '1' , '-1' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '6.90' ) 16/09/2024 09:42:47 am >> SELECT document_num FROM ps_document WHERE document_num = '2696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 09:42:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2696' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 16/09/2024 09:42:47 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93152' 16/09/2024 09:42:47 am >> DELETE FROM ps_document_detail WHERE id_document = '93152' 16/09/2024 09:42:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93152' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '0' , '3.80' ) 16/09/2024 10:07:58 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'ej7uVZTCGWqOPqMx' , NOW() , NOW() ) 16/09/2024 10:07:58 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7106' , '1' ) 16/09/2024 10:07:59 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7106' , '2' ) 16/09/2024 10:07:59 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7106' , '3' ) 16/09/2024 10:10:43 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7106' 16/09/2024 10:10:43 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 ( '7106' , '10' , '160' , 'PARROCCHIA SAN PIETRO AP.' , 'MANCINI' , 'DON GIACINTO' , 'VIA INDIPENDENZA 25' , '' , '03020' , 'TORRICE' , '' , '' , '3331572079' , '' , '92003460604' , NOW() , NOW() ) 16/09/2024 10:10:43 am >> UPDATE ps_customer SET email = 'giacintomancini@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7106' 16/09/2024 10:13:42 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7106' 16/09/2024 10:13:42 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 ( '7106' , '10' , '160' , 'PARROCCHIA SAN PIETRO AP.' , 'MANCINI' , 'DON GIACINTO' , 'VIA INDIPENDENZA 25' , '' , '03020' , 'TORRICE' , '' , '' , '3331572079' , '' , '92003460604' , NOW() , NOW() ) 16/09/2024 10:13:42 am >> UPDATE ps_customer SET email = 'giacintomancini@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7106' 16/09/2024 10:14:48 am >> SELECT document_num FROM ps_document WHERE document_num = '32' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 10:14:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '32' , '2024-09-16' , '' , '7106' , '0' , '177359042' , 'VIA INDIPENDENZA 25 03020 TORRICE' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '223.48' , '223.48' , NOW() , NOW() ) 16/09/2024 10:14: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 = '14748' 16/09/2024 10:14:49 am >> DELETE FROM ps_document_detail WHERE id_document = '14748' 16/09/2024 10:14: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 ( '14748' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '15' , '106.25' ) 16/09/2024 10:14: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 ( '14748' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '15' , '106.25' ) 16/09/2024 10:14: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 ( '14748' , '126' , 'SACRAMENTO DEL PERDONO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 16/09/2024 10:14: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 ( '14748' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 16/09/2024 10:31:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 10:31:53 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' , '2697' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 16/09/2024 10:31:53 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 = '93153' 16/09/2024 10:31:53 am >> DELETE FROM ps_document_detail WHERE id_document = '93153' 16/09/2024 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93153' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 16/09/2024 10:31:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93153' , '21099' , 'BRACCIALE DECINA - BD008' , '3' , '-3' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '6.00' ) 16/09/2024 11:02:07 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/09/2024 11:02:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22915' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 11:02:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22915' , '1' , '1' , '2' , NOW() , NOW() ) 16/09/2024 11:02:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22915' , '0' , '1' , '0' , '0' ) 16/09/2024 11:03:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895060941' AND id_product != '22915' AND ean13 != '' 16/09/2024 11:03:12 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788895060941', date_upd = NOW() WHERE id_product = '22915' 16/09/2024 11:03:12 am >> UPDATE ps_product_lang SET name = 'CINQUE PANI D\'ORZO 2025', description = '' WHERE id_product = '22915' 16/09/2024 11:03:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '22915' 16/09/2024 11:03:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '250', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22915' 16/09/2024 11:03:12 am >> DELETE FROM ps_specific_price WHERE id_product = '22915' 16/09/2024 11:05:39 am >> SELECT document_num FROM ps_document WHERE document_num = '2698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 11:05:39 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' , '2698' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 16/09/2024 11:05:39 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 = '93154' 16/09/2024 11:05:39 am >> DELETE FROM ps_document_detail WHERE id_document = '93154' 16/09/2024 11:05:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93154' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/09/2024 11:18: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 ( '33' , '673620' , '2024-09-12' , '' , '0' , '0' , '0' , '' , '' , '' , '5.84' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '210.15' , '210.15' , NOW() , NOW() ) 16/09/2024 11:18: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 = '93155' 16/09/2024 11:18:52 am >> DELETE FROM ps_document_detail WHERE id_document = '93155' 16/09/2024 11:18: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 ( '93155' , '22713' , 'AMEN - SET 24' , '2' , '2' , '4' , '3.90' , '3.9' , '0' , '33' , '5.2260' ) 16/09/2024 11:18: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 ( '93155' , '22915' , 'CINQUE PANI DORZO 2025' , '36' , '36' , '4' , '7.90' , '7.9' , '0' , '30' , '199.0800' ) 16/09/2024 11:18: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 ( '93155' , '22915' , 'CINQUE PANI DORZO 2025' , '3' , '3' , '4' , '7.90' , '7.9' , '0' , '100' , '0.0000' ) 16/09/2024 11:21:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861249844' AND id_product != '21646' AND ean13 != '' 16/09/2024 11:21:09 am >> UPDATE ps_product SET id_supplier = '7', reference = '2/2', ean13 = '9788861249844', date_upd = NOW() WHERE id_product = '21646' 16/09/2024 11:21:10 am >> UPDATE ps_product_lang SET name = 'PERDONATI - QUADERNO', description = '' WHERE id_product = '21646' 16/09/2024 11:21:10 am >> UPDATE ps_product SET wholesale_price = '5.25', on_sale = '0', price = '7.5000' WHERE id_product = '21646' 16/09/2024 11:21:10 am >> UPDATE ps_product_shop SET wholesale_price = '5.25', price = '7.5000', 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 = '21646' 16/09/2024 11:21:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21646' 16/09/2024 11:23:42 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' , '673621' , '2024-09-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '17.88' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '573.09' , '573.09' , NOW() , NOW() ) 16/09/2024 11:23: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 = '93156' 16/09/2024 11:23:42 am >> DELETE FROM ps_document_detail WHERE id_document = '93156' 16/09/2024 11:23: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 ( '93156' , '21441' , 'AMATI - AGENDA DEL CATECHISTA' , '2' , '2' , '4' , '7.50' , '7.5' , '0' , '30+7' , '9.7650' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21441' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21441' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21587' , 'PERDONATI - GUIDA' , '6' , '6' , '4' , '7.50' , '7.5' , '0' , '30+7' , '29.2950' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21587' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21587' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21442' , 'AMATI - QUADERNO' , '2' , '2' , '4' , '7.50' , '7.5' , '0' , '30+7' , '9.7650' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21442' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21442' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21646' , 'PERDONATI - QUADERNO' , '35' , '35' , '4' , '7.50' , '7.5' , '0' , '30+7' , '170.8875' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21646' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21646' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '22804' , 'PANE E VINO - N.E. - SUSSIDIO' , '50' , '50' , '4' , '5.00' , '5' , '0' , '35+7' , '151.1250' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22804' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22804' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '22803' , 'PANE E VINO - N.E. - GUIDA 3' , '6' , '6' , '4' , '15.00' , '15' , '0' , '35+7' , '54.4050' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '22803' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22803' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21436' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21436' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21437' , 'IMPRONTE DI MISERICORDIA - CALENDALBUM 2 - N.E.' , '20' , '20' , '4' , '5.00' , '5' , '0' , '35+7' , '60.4500' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21437' AND id_supplier = '7' 16/09/2024 11:23:42 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21437' , '7' , '1' ) 16/09/2024 11:23: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 ( '93156' , '21735' , 'IMPRONTE DI MISERICORDIA - GUIDA 2 - N.E.' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 16/09/2024 11:23:42 am >> DELETE FROM ps_product_supplier WHERE id_product = '21735' AND id_supplier = '7' 16/09/2024 11:23:43 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21735' , '7' , '1' ) 16/09/2024 11:35:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2468' AND id_document != '92875' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-26') 16/09/2024 11:35:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2468', document_date = '2024-08-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.80', price_tax_excluded = '5.30', date_upd = NOW() WHERE id_document = '92875' 16/09/2024 11:35: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 = '92875' 16/09/2024 11:35:21 am >> DELETE FROM ps_document_detail WHERE id_document = '92875' 16/09/2024 11:35: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 ( '92875' , '19599' , 'ROSARIO PER LA PRIMA COMUNIONE - 197/13' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 16/09/2024 11:35: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 ( '92875' , '21012' , 'PECORELLA SMARRITA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 16/09/2024 11:35: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 ( '92875' , '21011' , 'BUON SAMARITANO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 16/09/2024 01:01:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 01:01:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '110' , '2024-09-16' , '' , '1832' , '0' , '4670920' , 'C.DA PANTANO 85010 PIGNOLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '80.25' , '80.25' , NOW() , NOW() ) 16/09/2024 01:01:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93157' 16/09/2024 01:01:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93157' 16/09/2024 01:01:34 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 ( '93157' , '8408' , 'PRENDETE E MANGIATE' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '15' , '40.80' ) 16/09/2024 01:01:34 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 ( '93157' , '4154' , 'FESTA DEL PERDONO' , '14' , '-14' , '4' , '3.00' , '3' , '0' , '15' , '35.70' ) 16/09/2024 01:01:34 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 ( '93157' , '8855' , 'REGISTRO DEL CATECHISTA' , '5' , '-5' , '4' , '0.75' , '0.75' , '0' , '0' , '3.75' ) 16/09/2024 02:08:23 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/09/2024 02:08:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22916' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:08:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22916' , '1' , '1' , '2' , NOW() , NOW() ) 16/09/2024 02:08:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22916' , '0' , '1' , '0' , '0' ) 16/09/2024 02:08:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902555' AND id_product != '22916' AND ean13 != '' 16/09/2024 02:08:55 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902555', date_upd = NOW() WHERE id_product = '22916' 16/09/2024 02:08:55 pm >> UPDATE ps_product_lang SET name = 'FOULARD GIUBILEO GRANDE', description = '' WHERE id_product = '22916' 16/09/2024 02:08:55 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '22916' 16/09/2024 02:08:55 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '221', 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 = '22916' 16/09/2024 02:08:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '22916' 16/09/2024 02:08:55 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22916' 16/09/2024 02:08:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22917' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:08:56 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22917' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22916' 16/09/2024 02:08:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22917' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22916' 16/09/2024 02:09:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902531' AND id_product != '22917' AND ean13 != '' 16/09/2024 02:09:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902531', date_upd = NOW() WHERE id_product = '22917' 16/09/2024 02:09:17 pm >> UPDATE ps_product_lang SET name = 'FOULARD GIUBILEO PICCOLO', description = '' WHERE id_product = '22917' 16/09/2024 02:09:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8688524590163933' WHERE id_product = '22917' 16/09/2024 02:09:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8688524590163933', id_tax_rules_group = '1', id_category_default = '221', 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 = '22917' 16/09/2024 02:09:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '22917' 16/09/2024 02:09:18 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22917' 16/09/2024 02:09:18 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22918' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:09:18 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22918' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22917' 16/09/2024 02:09:18 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22918' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22917' 16/09/2024 02:10:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902494' AND id_product != '22918' AND ean13 != '' 16/09/2024 02:10:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902494', date_upd = NOW() WHERE id_product = '22918' 16/09/2024 02:10:01 pm >> UPDATE ps_product_lang SET name = 'FOULARD GIUBILEO GRANDE', description = '' WHERE id_product = '22918' 16/09/2024 02:10:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '22918' 16/09/2024 02:10:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '221', 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 = '22918' 16/09/2024 02:10:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '22918' 16/09/2024 02:10:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902555' AND id_product != '22916' AND ean13 != '' 16/09/2024 02:10:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902555', date_upd = NOW() WHERE id_product = '22916' 16/09/2024 02:10:26 pm >> UPDATE ps_product_lang SET name = 'SACCA GIUBILEO ', description = '' WHERE id_product = '22916' 16/09/2024 02:10:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.8689' WHERE id_product = '22916' 16/09/2024 02:10:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.8689', id_tax_rules_group = '1', id_category_default = '221', 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 = '22916' 16/09/2024 02:10:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22916' 16/09/2024 02:10:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902494' AND id_product != '22918' AND ean13 != '' 16/09/2024 02:10:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902494', date_upd = NOW() WHERE id_product = '22918' 16/09/2024 02:10:30 pm >> UPDATE ps_product_lang SET name = 'FOULARD GIUBILEO GRANDE', description = '' WHERE id_product = '22918' 16/09/2024 02:10:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.934426229508198' WHERE id_product = '22918' 16/09/2024 02:10:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.934426229508198', id_tax_rules_group = '1', id_category_default = '221', 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 = '22918' 16/09/2024 02:10:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '22918' 16/09/2024 02:10:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22918' 16/09/2024 02:10:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22919' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:10:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22919' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22918' 16/09/2024 02:10:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22919' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22918' 16/09/2024 02:11:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8051884902661' AND id_product != '22919' AND ean13 != '' 16/09/2024 02:11:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051884902661', date_upd = NOW() WHERE id_product = '22919' 16/09/2024 02:11:32 pm >> UPDATE ps_product_lang SET name = 'STOLA GIUBILEO 2025', description = '' WHERE id_product = '22919' 16/09/2024 02:11:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.147540983606557' WHERE id_product = '22919' 16/09/2024 02:11:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.147540983606557', id_tax_rules_group = '1', id_category_default = '221', 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 = '22919' 16/09/2024 02:11:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22919' 16/09/2024 02:11:34 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22919' 16/09/2024 02:11:34 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22920' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:11:34 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22920' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22919' 16/09/2024 02:11:34 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22920' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22919' 16/09/2024 02:12:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002297' AND id_product != '22919' AND ean13 != '' 16/09/2024 02:13:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002298' AND id_product != '22919' AND ean13 != '' 16/09/2024 02:13:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002298', date_upd = NOW() WHERE id_product = '22919' 16/09/2024 02:13:41 pm >> UPDATE ps_product_lang SET name = 'STOLA GIUBILEO 2025', description = '' WHERE id_product = '22919' 16/09/2024 02:13:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.1475' WHERE id_product = '22919' 16/09/2024 02:13:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.1475', id_tax_rules_group = '1', id_category_default = '221', 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 = '22919' 16/09/2024 02:13:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22919' 16/09/2024 02:16:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002298' AND id_product != '22919' AND ean13 != '' 16/09/2024 02:16:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002298', date_upd = NOW() WHERE id_product = '22919' 16/09/2024 02:16:03 pm >> UPDATE ps_product_lang SET name = 'STOLA GIUBILEO 2025', description = '' WHERE id_product = '22919' 16/09/2024 02:16:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.1475' WHERE id_product = '22919' 16/09/2024 02:16:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.1475', id_tax_rules_group = '1', id_category_default = '221', 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 = '22919' 16/09/2024 02:16:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '22919' 16/09/2024 02:16:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8056697757774' AND id_product != '22920' AND ean13 != '' 16/09/2024 02:16:22 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8056697757774', date_upd = NOW() WHERE id_product = '22920' 16/09/2024 02:16:22 pm >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA GIUBILEO 2025', description = '' WHERE id_product = '22920' 16/09/2024 02:16:22 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '22920' 16/09/2024 02:16:22 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '221', 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 = '22920' 16/09/2024 02:16:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '22920' 16/09/2024 02:16:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8056697757774' AND id_product != '22920' AND ean13 != '' 16/09/2024 02:16:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8056697757774', date_upd = NOW() WHERE id_product = '22920' 16/09/2024 02:16:52 pm >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA GIUBILEO 2025', description = '' WHERE id_product = '22920' 16/09/2024 02:16:52 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '22920' 16/09/2024 02:16:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '221', 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 = '22920' 16/09/2024 02:16:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '22920' 16/09/2024 02:16:53 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22920' 16/09/2024 02:16:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22921' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:16:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22921' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22920' 16/09/2024 02:16:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22921' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22920' 16/09/2024 02:17:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002299' AND id_product != '22921' AND ean13 != '' 16/09/2024 02:17:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002299', date_upd = NOW() WHERE id_product = '22921' 16/09/2024 02:17:32 pm >> UPDATE ps_product_lang SET name = 'CASULA GIUBILEO 2025', description = '' WHERE id_product = '22921' 16/09/2024 02:17:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '69.67213114754098' WHERE id_product = '22921' 16/09/2024 02:17:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '69.67213114754098', id_tax_rules_group = '1', id_category_default = '221', 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 = '22921' 16/09/2024 02:17:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22921' 16/09/2024 02:19:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002299' AND id_product != '22921' AND ean13 != '' 16/09/2024 02:19:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002299', date_upd = NOW() WHERE id_product = '22921' 16/09/2024 02:19:27 pm >> UPDATE ps_product_lang SET name = 'CASULA GIUBILEO 2025', description = '' WHERE id_product = '22921' 16/09/2024 02:19:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '69.67213114754098' WHERE id_product = '22921' 16/09/2024 02:19:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '69.67213114754098', id_tax_rules_group = '1', id_category_default = '221', 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 = '22921' 16/09/2024 02:19:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22921' 16/09/2024 02:19:28 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22921' 16/09/2024 02:19:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22922' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:19:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22922' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22921' 16/09/2024 02:19:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22922' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22921' 16/09/2024 02:19:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002300' AND id_product != '22922' AND ean13 != '' 16/09/2024 02:19:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002300', date_upd = NOW() WHERE id_product = '22922' 16/09/2024 02:19:46 pm >> UPDATE ps_product_lang SET name = 'COPRI LEGGIO GIUBILEO 2025', description = '' WHERE id_product = '22922' 16/09/2024 02:19:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '53.278688524590166' WHERE id_product = '22922' 16/09/2024 02:19:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '53.278688524590166', id_tax_rules_group = '1', id_category_default = '221', 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 = '22922' 16/09/2024 02:19:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22922' 16/09/2024 02:19:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22922' 16/09/2024 02:19:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22923' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:19:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22923' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22922' 16/09/2024 02:19:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22923' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22922' 16/09/2024 02:20:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002301' AND id_product != '22923' AND ean13 != '' 16/09/2024 02:20:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002301', date_upd = NOW() WHERE id_product = '22923' 16/09/2024 02:20:21 pm >> UPDATE ps_product_lang SET name = 'ROLL UP GIUBILEO 2025', description = '' WHERE id_product = '22923' 16/09/2024 02:20:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '53.278688524590166' WHERE id_product = '22923' 16/09/2024 02:20:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '53.278688524590166', id_tax_rules_group = '1', id_category_default = '221', 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 = '22923' 16/09/2024 02:20:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '22923' 16/09/2024 02:20:23 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22923' 16/09/2024 02:20:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22924' , '1' , '' , 'nuovo-prodotto' ) 16/09/2024 02:20:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22924' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22923' 16/09/2024 02:20:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22924' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22923' 16/09/2024 02:23:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '307/2024/PA' , '2024-09-16' , '2024' , '0' , '11' , '2606' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '588.04' , '482.00' , NOW() , NOW() ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93158' 16/09/2024 02:23:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93158' 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '4' , '4' , '1' , '30' , '24.590163934426' , '22' , '0' , '146.4000' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22922' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22922' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22923' , 'ROLL UP GIUBILEO 2025' , '3' , '3' , '1' , '30' , '24.590163934426' , '22' , '' , '109.8000' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22923' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22923' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22921' , 'CASULA GIUBILEO 2025' , '4' , '4' , '1' , '40' , '32.786885245902' , '22' , '0' , '195.2000' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22921' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22921' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22920' , 'SERVIZIO MESSA GIUBILEO 2025' , '1' , '1' , '1' , '30' , '24.590163934426' , '22' , '' , '36.6000' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22920' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22920' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22919' , 'STOLA GIUBILEO 2025' , '4' , '4' , '1' , '17.5' , '14.344262295082' , '22' , '0' , '85.4000' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22919' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22919' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22916' , 'SACCA GIUBILEO ' , '1' , '1' , '1' , '1.75' , '1.4344262295082' , '22' , '0' , '2.1350' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22916' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22916' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22917' , 'FOULARD GIUBILEO PICCOLO' , '1' , '1' , '1' , '1.75' , '1.4344262295082' , '22' , '0' , '2.1350' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22917' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22917' , '11' , '1' ) 16/09/2024 02:23:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93158' , '22918' , 'FOULARD GIUBILEO GRANDE' , '1' , '1' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '10.3700' ) 16/09/2024 02:23:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22918' AND id_supplier = '11' 16/09/2024 02:23:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22918' , '11' , '1' ) 16/09/2024 03:53:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 03:53:04 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' , '2699' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.90' , '101.56' , NOW() , NOW() ) 16/09/2024 03:53: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 = '93159' 16/09/2024 03:53:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '93159' 16/09/2024 03:53: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 ( '93159' , '18400' , 'CAMICE DUE PIEGONI POL. CERNIERA SPALLA - 405/TPAS' , '1' , '-1' , '1' , '74.00' , '60.655737704918' , '22' , '0' , '74.00' ) 16/09/2024 03:53: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 ( '93159' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 16/09/2024 04:35:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 04:35:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2700' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.25' , '66.15' , NOW() , NOW() ) 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93160' 16/09/2024 04:35:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '93160' 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/09/2024 04:35:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 16/09/2024 05:01:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 05:01:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '111' , '2024-09-16' , '' , '90' , '0' , '4679182' , 'VIA GIANANI 98051 BARCELLONA POZZO DI GOTTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '460.00' , '460.00' , NOW() , NOW() ) 16/09/2024 05:01:24 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 = '93161' 16/09/2024 05:01:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '93161' 16/09/2024 05:01:24 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 ( '93161' , '5444' , 'IO SONO CON VOI - CAT.' , '11' , '-11' , '4' , '5.50' , '5.5' , '0' , '5' , '57.47' ) 16/09/2024 05:01:24 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 ( '93161' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.80' , '2.8' , '0' , '15' , '40.46' ) 16/09/2024 05:01:24 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 ( '93161' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.80' , '2.8' , '0' , '15' , '45.22' ) 16/09/2024 05:01:24 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 ( '93161' , '11193' , 'VENITE CON ME CAT.' , '28' , '-28' , '4' , '5.50' , '5.5' , '0' , '5' , '146.30' ) 16/09/2024 05:01:25 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 ( '93161' , '11191' , 'VENITE CON ME 1 PARTE' , '29' , '-29' , '4' , '2.80' , '2.8' , '0' , '15' , '69.02' ) 16/09/2024 05:01:25 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 ( '93161' , '11192' , 'VENITE CON ME 2 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 16/09/2024 05:01:25 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 ( '93161' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.50' , '5.5' , '0' , '5' , '26.13' ) 16/09/2024 05:01:25 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 ( '93161' , '9675' , 'SARETE MIEI TESTIMONI' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '15' , '17.85' ) 16/09/2024 05:01:25 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 ( '93161' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '7' , '-7' , '4' , '2.50' , '2.5' , '0' , '15' , '14.88' ) 16/09/2024 05:01:25 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 ( '93161' , '' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.17' , '-0.17' , '0' , '0' , '-0.17' ) 16/09/2024 05:07:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '93161' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 05:07:59 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '111', document_date = '2024-09-16', document_letter = '', id_customer = '90', id_supplier = '', id_address = '4679182', address1 = 'VIA GIANANI 98051 BARCELLONA POZZO DI GOTTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '460.00', price_tax_excluded = '460.00', date_upd = NOW() WHERE id_document = '93161' 16/09/2024 05:07:59 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 = '93161' 16/09/2024 05:07:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '93161' 16/09/2024 05:07:59 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 ( '93161' , '5444' , 'IO SONO CON VOI - CAT.' , '11' , '-11' , '4' , '5.5000' , '5.5' , '0' , '5' , '57.47' ) 16/09/2024 05:07:59 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 ( '93161' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.8000' , '2.8' , '0' , '15' , '40.46' ) 16/09/2024 05:07:59 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 ( '93161' , '5458' , 'IO SONO CON VOI 2 PARTE' , '19' , '-19' , '4' , '2.8000' , '2.8' , '0' , '15' , '45.22' ) 16/09/2024 05:07:59 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 ( '93161' , '11193' , 'VENITE CON ME CAT.' , '28' , '-28' , '4' , '5.5000' , '5.5' , '0' , '5' , '146.30' ) 16/09/2024 05:07:59 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 ( '93161' , '11191' , 'VENITE CON ME 1 PARTE' , '29' , '-29' , '4' , '2.8000' , '2.8' , '0' , '15' , '69.02' ) 16/09/2024 05:07:59 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 ( '93161' , '11192' , 'VENITE CON ME 2 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 16/09/2024 05:07:59 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 ( '93161' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '5' , '-5' , '4' , '5.5000' , '5.5' , '0' , '5' , '26.13' ) 16/09/2024 05:07:59 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 ( '93161' , '9675' , 'SARETE MIEI TESTIMONI' , '6' , '-6' , '4' , '3.5000' , '3.5' , '0' , '15' , '17.85' ) 16/09/2024 05:07:59 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 ( '93161' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '7' , '-7' , '4' , '2.5000' , '2.5' , '0' , '15' , '14.88' ) 16/09/2024 05:07:59 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 ( '93161' , '0' , 'ARROTONDAMENTO' , '1' , '-1' , '4' , '-0.1700' , '-0.17' , '0' , '0' , '-0.17' ) 16/09/2024 05:23:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '38/E' AND id_document != '93140' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-14') 16/09/2024 05:23:07 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '38/E', document_date = '2024-09-14', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '2581.68', price_tax_excluded = '2581.68', date_upd = NOW() WHERE id_document = '93140' 16/09/2024 05:23: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 = '93140' 16/09/2024 05:23:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '93140' 16/09/2024 05:23: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 ( '93140' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '500' , '-500' , '4' , '1.0000' , '1' , '0' , '38' , '310.00' ) 16/09/2024 05:23: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 ( '93140' , '5457' , 'IO SONO CON VOI 1 PARTE' , '280' , '-280' , '4' , '2.8000' , '2.8' , '0' , '38' , '486.08' ) 16/09/2024 05:23: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 ( '93140' , '5458' , 'IO SONO CON VOI 2 PARTE' , '280' , '-280' , '4' , '2.8000' , '2.8' , '0' , '38' , '486.08' ) 16/09/2024 05:23: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 ( '93140' , '11191' , 'VENITE CON ME 1 PARTE' , '280' , '-280' , '4' , '2.8000' , '2.8' , '0' , '38' , '486.08' ) 16/09/2024 05:23: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 ( '93140' , '11192' , 'VENITE CON ME 2 PARTE' , '270' , '-270' , '4' , '2.8000' , '2.8' , '0' , '38' , '468.72' ) 16/09/2024 05:23: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 ( '93140' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '3.8000' , '3.8' , '0' , '38' , '23.56' ) 16/09/2024 05:23: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 ( '93140' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '3.8000' , '3.8' , '0' , '38' , '23.56' ) 16/09/2024 05:23: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 ( '93140' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.8000' , '3.8' , '0' , '38' , '23.56' ) 16/09/2024 05:23: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 ( '93140' , '8408' , 'PRENDETE E MANGIATE' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '38' , '93.00' ) 16/09/2024 05:23: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 ( '93140' , '4154' , 'FESTA DEL PERDONO' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '38' , '55.80' ) 16/09/2024 05:23: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 ( '93140' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '30' , '-30' , '4' , '2.4000' , '2.4' , '0' , '38' , '44.64' ) 16/09/2024 05:23: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 ( '93140' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '38' , '55.80' ) 16/09/2024 05:23: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 ( '93140' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '5' , '-5' , '4' , '8.0000' , '8' , '0' , '38' , '24.80' ) 16/09/2024 05:26:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2700' AND id_document != '93160' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 05:26:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2700', document_date = '2024-09-16', 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 = '75.25', price_tax_excluded = '66.15', date_upd = NOW() WHERE id_document = '93160' 16/09/2024 05:26:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93160' 16/09/2024 05:26:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '93160' 16/09/2024 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '22870' , 'AGENDA SAN PAOLO 2025' , '3' , '-3' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '30.00' ) 16/09/2024 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/09/2024 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 16/09/2024 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/09/2024 05:26:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93160' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 16/09/2024 06:00:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 06:00:43 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' , '2701' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.58' , '17.58' , NOW() , NOW() ) 16/09/2024 06:00: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 = '93162' 16/09/2024 06:00:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93162' 16/09/2024 06:00: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 ( '93162' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.50' , '18.5' , '0' , '5' , '17.58' ) 16/09/2024 06:13:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 06:13:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2702' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.50' , '14.34' , NOW() , NOW() ) 16/09/2024 06:13:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93163' 16/09/2024 06:13:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93163' 16/09/2024 06:13:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93163' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '17.50' ) 16/09/2024 06:15:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '92376' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-21') 16/09/2024 06:15:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2061', document_date = '2024-06-21', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA SAN LEONARDO 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '525.00', price_tax_excluded = '447.63', date_upd = NOW() WHERE id_document = '92376' 16/09/2024 06:15: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 = '92376' 16/09/2024 06:15:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '92376' 16/09/2024 06:15: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 ( '92376' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 16/09/2024 06:15: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 ( '92376' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 16/09/2024 06:15: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 ( '92376' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 16/09/2024 06:15: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 ( '92376' , '22168' , 'AMEN - GIU. 2024' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 16/09/2024 06:15: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 ( '92376' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 16/09/2024 06:15: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 ( '92376' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 16/09/2024 06:15: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 ( '92376' , '5095' , 'IMMAGINI ASSORTITE X 100' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 16/09/2024 06:15: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 ( '92376' , '22476' , 'AMEN - AGO 2024' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 16/09/2024 06:15: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 ( '92376' , '22475' , 'AMEN - LUG. 2024' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 16/09/2024 06:15: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 ( '92376' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '3' , '-3' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '3.00' ) 16/09/2024 06:15: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 ( '92376' , '1523' , 'CALICE PELTRO - CM 20 - 698' , '1' , '-1' , '1' , '420.5700' , '344.72950819672' , '22' , '0' , '420.57' ) 16/09/2024 06:15:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2419' AND id_document != '92813' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-05') 16/09/2024 06:15:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2419', document_date = '2024-08-05', 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 = '31.15', date_upd = NOW() WHERE id_document = '92813' 16/09/2024 06:15:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92813' 16/09/2024 06:15:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '92813' 16/09/2024 06:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/09/2024 06:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 16/09/2024 06:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 16/09/2024 06:15:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92813' , '5095' , 'IMMAGINI ASSORTITE X 100' , '1' , '-1' , '1' , '7.1' , '5.8196721311475' , '22' , '0' , '7.10' ) 16/09/2024 07:13:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 07:13:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2703' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.00' , '80.33' , NOW() , NOW() ) 16/09/2024 07:13:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93164' 16/09/2024 07:13:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '93164' 16/09/2024 07:13:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93164' , '18422' , 'STOLA RASO PL RICAMO CROCE - 7759' , '1' , '-1' , '1' , '98.00' , '80.327868852459' , '22' , '0' , '98.00' ) 16/09/2024 07:19:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-16') 16/09/2024 07:19:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2704' , '2024-09-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 16/09/2024 07:19:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93165' 16/09/2024 07:19:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93165' 16/09/2024 07:19:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93165' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' )