21/12/2023 09:28:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4097' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 09:28:00 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' , '4097' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.85' , '97.85' , NOW() , NOW() ) 21/12/2023 09:28: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 = '89618' 21/12/2023 09:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89618' 21/12/2023 09:28: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 ( '89618' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 21/12/2023 09:28: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 ( '89618' , '22007' , 'BELLEZZA NASCOSTA IN TE - G. DALYATA' , '4' , '-4' , '4' , '22.00' , '22' , '0' , '5' , '83.60' ) 21/12/2023 09:31:35 am >> SELECT document_num FROM ps_document WHERE document_num = '4098' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 09:31:35 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' , '4098' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.00' , '91.80' , NOW() , NOW() ) 21/12/2023 09:31:35 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 = '89619' 21/12/2023 09:31:35 am >> DELETE FROM ps_document_detail WHERE id_document = '89619' 21/12/2023 09:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89619' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/12/2023 09:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89619' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/12/2023 09:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89619' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 21/12/2023 09:35:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 09:35:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4099' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '172.40' , '142.68' , NOW() , NOW() ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89620' 21/12/2023 09:35:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89620' 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '18032' , 'BRUCIAINCENSO H 11' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' ) 21/12/2023 09:35:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89620' , '21445' , 'PAROLA E I GIORNI 2024' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 21/12/2023 09:45:14 am >> SELECT document_num FROM ps_document WHERE document_num = '4100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 09:45:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4100' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.76' , '103.08' , NOW() , NOW() ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89621' 21/12/2023 09:45:14 am >> DELETE FROM ps_document_detail WHERE id_document = '89621' 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '15498' , 'CROCE SAN BENEDETTO SMALTATA - CZ5NIK' , '4' , '-4' , '1' , '17.50' , '14.344262295082' , '22' , '0' , '70.00' ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '21513' , 'COMPENDIO DELLA DOTTRINA SOCIALE DELLA CHIESA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '21926' , 'STORIA DI NATALE' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 21/12/2023 09:45:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89621' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 21/12/2023 10:16:25 am >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 10:16:25 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' , '4101' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.50' , '72.54' , NOW() , NOW() ) 21/12/2023 10:16:25 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 = '89622' 21/12/2023 10:16:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89622' 21/12/2023 10:16: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 ( '89622' , '21839' , 'NATIVITA IN RESINA CM 8 - P725' , '15' , '-15' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '67.50' ) 21/12/2023 10:16: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 ( '89622' , '13054' , 'ADDOBBI LASER' , '14' , '-14' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '21.00' ) 21/12/2023 10:23:02 am >> SELECT document_num FROM ps_document WHERE document_num = '4102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 10:23:02 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' , '4102' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '13.95' , NOW() , NOW() ) 21/12/2023 10:23:02 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 = '89623' 21/12/2023 10:23:02 am >> DELETE FROM ps_document_detail WHERE id_document = '89623' 21/12/2023 10:23:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89623' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '5.00' ) 21/12/2023 10:23:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89623' , '20548' , 'MEDAGLIA SAN BENEDETTO -T18/SBB' , '6' , '-6' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '1.80' ) 21/12/2023 10:23:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89623' , '9134' , 'ROSARIO LEGNO CHIARO E CORDA - 20519' , '6' , '-6' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '9.00' ) 21/12/2023 10:23:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89623' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 21/12/2023 10:37:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616898' AND id_product != '10299' AND ean13 != '' 21/12/2023 10:37:31 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616898', date_upd = NOW() WHERE id_product = '10299' 21/12/2023 10:37:31 am >> UPDATE ps_product_lang SET name = 'STORIA DI UN\'ANIMA - 8203', description = '' WHERE id_product = '10299' 21/12/2023 10:37:31 am >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '12' WHERE id_product = '10299' 21/12/2023 10:37:31 am >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10299' 21/12/2023 10:37:31 am >> DELETE FROM ps_specific_price WHERE id_product = '10299' 21/12/2023 10:40:22 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/12/2023 10:40:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22015' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 10:40:22 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22015' , '1' , '1' , '2' , NOW() , NOW() ) 21/12/2023 10:40:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22015' , '0' , '1' , '0' , '0' ) 21/12/2023 10:44:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 21/12/2023 10:44:13 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048684', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:44:13 am >> UPDATE ps_product_lang SET name = 'medjugorje - vera storia - 8953', description = '' WHERE id_product = '22015' 21/12/2023 10:44:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '22015' 21/12/2023 10:44:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:44:14 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 21/12/2023 10:44:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 21/12/2023 10:44:26 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048684', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:44:26 am >> UPDATE ps_product_lang SET name = 'medjugorje - vera storia - 8953', description = '' WHERE id_product = '22015' 21/12/2023 10:44:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '22015' 21/12/2023 10:44:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:44:26 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 21/12/2023 10:45:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048684' AND id_product != '22015' AND ean13 != '' 21/12/2023 10:45:09 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048684', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:45:09 am >> UPDATE ps_product_lang SET name = 'MEDJUGORJE VERA STORIA - 8593', description = '' WHERE id_product = '22015' 21/12/2023 10:45:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.0000' WHERE id_product = '22015' 21/12/2023 10:45:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22015' 21/12/2023 10:45:09 am >> DELETE FROM ps_specific_price WHERE id_product = '22015' 21/12/2023 10:46: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 ( '31' , '20967/00/2023' , '2023-12-19' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '213.60' , '211.44' , NOW() , NOW() ) 21/12/2023 10:46: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 = '89624' 21/12/2023 10:46:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89624' 21/12/2023 10:46: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 ( '89624' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '60' , '60' , '4' , '5.00' , '5' , '0' , '40' , '180.0000' ) 21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '21778' AND id_supplier = '38' 21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21778' , '38' , '1' ) 21/12/2023 10:46: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 ( '89624' , '9617' , 'SANTE PIAGHE DI NOSTRO SIGNORE GESÙ CRISTO - 8194' , '3' , '3' , '4' , '2.00' , '2' , '0' , '40' , '3.6000' ) 21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '9617' AND id_supplier = '38' 21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9617' , '38' , '1' ) 21/12/2023 10:46: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 ( '89624' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 21/12/2023 10:46: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 ( '89624' , '22015' , 'MEDJUGORJE VERA STORIA - 8593' , '2' , '2' , '4' , '9.00' , '9' , '0' , '40' , '10.8000' ) 21/12/2023 10:46:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '22015' AND id_supplier = '38' 21/12/2023 10:46:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22015' , '38' , '1' ) 21/12/2023 10:46: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 ( '89624' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '2' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '12.0048' ) 21/12/2023 10:46:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '21653' AND id_supplier = '38' 21/12/2023 10:46:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21653' , '38' , '1' ) 21/12/2023 10:46:37 am >> SELECT document_num FROM ps_document WHERE document_num = '4081' AND id_document != '89600' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-20') 21/12/2023 10:46:37 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4081', document_date = '2023-12-20', 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 = '21.80', price_tax_excluded = '19.64', date_upd = NOW() WHERE id_document = '89600' 21/12/2023 10:46:37 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 = '89600' 21/12/2023 10:46:37 am >> DELETE FROM ps_document_detail WHERE id_document = '89600' 21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89600' , '11323' , 'VIA DELLAMORE - VINCENZO PAGLIA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89600' , '9815' , 'SEGNO DELLA CROCE' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89600' , '9617' , 'SANTE PIAGHE DI NOSTRO SIGNORE GESÙ CRISTO - 8194' , '1' , '-1' , '4' , '1.8' , '1.8' , '0' , '0' , '1.80' ) 21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89600' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/12/2023 10:46:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89600' , '20445' , 'MARIA GORETTI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 21/12/2023 11:02:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 11:02:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4103' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '6.23' , NOW() , NOW() ) 21/12/2023 11:02:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89625' 21/12/2023 11:02:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89625' 21/12/2023 11:02:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89625' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 21/12/2023 11:02:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89625' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 21/12/2023 11:40:09 am >> SELECT document_num FROM ps_document WHERE document_num = '4104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 11:40: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' , '4104' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 21/12/2023 11:40: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 = '89626' 21/12/2023 11:40:09 am >> DELETE FROM ps_document_detail WHERE id_document = '89626' 21/12/2023 11:40: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 ( '89626' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/12/2023 11:44:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/12/2023 11:44:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22016' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:44:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22016' , '1' , '1' , '2' , NOW() , NOW() ) 21/12/2023 11:44:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22016' , '0' , '1' , '0' , '0' ) 21/12/2023 11:45:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788850256501' AND id_product != '22016' AND ean13 != '' 21/12/2023 11:45:07 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788850256501', date_upd = NOW() WHERE id_product = '22016' 21/12/2023 11:45:07 am >> UPDATE ps_product_lang SET name = 'COMANDANTE ALFA', description = '' WHERE id_product = '22016' 21/12/2023 11:45:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22016' 21/12/2023 11:45:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '456', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22016' 21/12/2023 11:45:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22016' 21/12/2023 11:45:08 am >> 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 = '22016' 21/12/2023 11:45:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22017' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:45:08 am >> 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 '22017' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22016' 21/12/2023 11:45:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22017' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22016' 21/12/2023 11:46:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254781128' AND id_product != '22017' AND ean13 != '' 21/12/2023 11:46:36 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791254781128', date_upd = NOW() WHERE id_product = '22017' 21/12/2023 11:46:36 am >> UPDATE ps_product_lang SET name = 'UOMO DI DIO - A. SCHNEIDER', description = '' WHERE id_product = '22017' 21/12/2023 11:46:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '22017' 21/12/2023 11:46:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22017' 21/12/2023 11:46:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22017' 21/12/2023 11:46:39 am >> 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 = '22017' 21/12/2023 11:46:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22018' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:46:39 am >> 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 '22018' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22017' 21/12/2023 11:46:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22018' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22017' 21/12/2023 11:47:59 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '1' ) 21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '2' ) 21/12/2023 11:47:59 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '537' , '3' ) 21/12/2023 11:47:59 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '537' , '1' , 'CAROCCI EDITORE' , LOWER('CAROCCI-EDITORE') ) 21/12/2023 11:47:59 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '537' , '1' , '0' ) 21/12/2023 11:48:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020058' AND id_product != '22018' AND ean13 != '' 21/12/2023 11:48:06 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788829020058', date_upd = NOW() WHERE id_product = '22018' 21/12/2023 11:48:06 am >> UPDATE ps_product_lang SET name = 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN', description = '' WHERE id_product = '22018' 21/12/2023 11:48:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22018' 21/12/2023 11:48:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '537', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22018' 21/12/2023 11:48:06 am >> DELETE FROM ps_specific_price WHERE id_product = '22018' 21/12/2023 11:48:07 am >> 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 = '22018' 21/12/2023 11:48:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22019' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:48:07 am >> 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 '22019' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22018' 21/12/2023 11:48:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22019' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22018' 21/12/2023 11:48:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020065' AND id_product != '22019' AND ean13 != '' 21/12/2023 11:48:42 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788829020065', date_upd = NOW() WHERE id_product = '22019' 21/12/2023 11:48:42 am >> UPDATE ps_product_lang SET name = 'NUOVO TESTAMENTO INTRODUZIONE - B. EHRMAN', description = '' WHERE id_product = '22019' 21/12/2023 11:48:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24' WHERE id_product = '22019' 21/12/2023 11:48:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24', id_tax_rules_group = '4', id_category_default = '537', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22019' 21/12/2023 11:48:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22019' 21/12/2023 11:48:43 am >> 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 = '22019' 21/12/2023 11:48:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22020' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:48:43 am >> 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 '22020' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22019' 21/12/2023 11:48:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22020' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22019' 21/12/2023 11:51:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712344' AND id_product != '22020' AND ean13 != '' 21/12/2023 11:51:07 am >> UPDATE ps_product SET id_supplier = '', reference = '5/5', ean13 = '9791254712344', date_upd = NOW() WHERE id_product = '22020' 21/12/2023 11:51:07 am >> UPDATE ps_product_lang SET name = 'STORIA DI FRANCESCO - G. NUCCI', description = '' WHERE id_product = '22020' 21/12/2023 11:51:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22020' 21/12/2023 11:51:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22020' 21/12/2023 11:51:07 am >> DELETE FROM ps_specific_price WHERE id_product = '22020' 21/12/2023 11:51:08 am >> 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 = '22020' 21/12/2023 11:51:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22021' , '1' , '' , 'nuovo-prodotto' ) 21/12/2023 11:51:08 am >> 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 '22021' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22020' 21/12/2023 11:51:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22021' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22020' 21/12/2023 11:52:03 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788829020058' AND id_product != '22018' AND ean13 != '' 21/12/2023 11:52:03 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788829020058', date_upd = NOW() WHERE id_product = '22018' 21/12/2023 11:52:03 am >> UPDATE ps_product_lang SET name = 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN', description = '' WHERE id_product = '22018' 21/12/2023 11:52:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22018' 21/12/2023 11:52:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '537', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22018' 21/12/2023 11:52:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22018' 21/12/2023 11:56:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '01182520' , '2023-12-18' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '236.50' , '236.50' , NOW() , NOW() ) 21/12/2023 11:56: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 = '89627' 21/12/2023 11:56:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89627' 21/12/2023 11:56: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 ( '89627' , '22020' , 'STORIA DI FRANCESCO - G. NUCCI' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '22020' AND id_supplier = '109' 21/12/2023 11:56:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22020' , '109' , '1' ) 21/12/2023 11:56: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 ( '89627' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '21999' AND id_supplier = '109' 21/12/2023 11:56:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21999' , '109' , '1' ) 21/12/2023 11:56: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 ( '89627' , '22019' , 'NUOVO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' , '1' , '4' , '24.00' , '24' , '0' , '0' , '24.00' ) 21/12/2023 11:56:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '22019' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22019' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '22018' , 'ANTICO TESTAMENTO INTRODUZIONE - B. EHRMAN' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22018' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22018' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '5823' , 'LIBRO D\'ORO' , '50' , '50' , '4' , '0.60' , '0.6' , '0' , '0' , '30.0000' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '5823' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5823' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '21618' , 'TRASMETTERE LA FEDE - SALZANO/ACUTIS' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21618' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21618' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22000' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22000' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '22016' , 'COMANDANTE ALFA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '0' , '12.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22016' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22016' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '22017' , 'UOMO DI DIO - A. SCHNEIDER' , '1' , '1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '22017' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22017' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21998' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21998' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '21997' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21997' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '12068' , 'VERA MISERICORDIA' , '1' , '1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '12068' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12068' , '109' , '1' ) 21/12/2023 11:56:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89627' , '8314' , 'PREGHIERA QUOTIDIANA DI ISRAELE - L. CATTANI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 21/12/2023 11:56:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '8314' AND id_supplier = '109' 21/12/2023 11:56:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8314' , '109' , '1' ) 21/12/2023 12:18:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 12:18:37 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 ( '24' , '145/A' , '2023-12-21' , 'A' , '230' , '0' , '4668969' , 'VIA G. NICOTERA, 66 84080 PELLEZZANO' , '' , 'ACCONTO € 150' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '350.00' , NOW() , NOW() ) 21/12/2023 12:18:37 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 = '89628' 21/12/2023 12:18:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '89628' 21/12/2023 12:18:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '' , 'PRESEPE ANTICO' , '1' , '-1' , '0' , '350' , '350' , '' , '0' , '350.00' ) 21/12/2023 12:24:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 12:24: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' , '4105' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '43.44' , NOW() , NOW() ) 21/12/2023 12:24: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 = '89629' 21/12/2023 12:24:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89629' 21/12/2023 12:24: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 ( '89629' , '21864' , 'BAMBINELLO CM 30 - PKS30-C' , '1' , '-1' , '1' , '53.00' , '43.44262295082' , '22' , '0' , '53.00' ) 21/12/2023 12:41:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '138/A' AND id_document != '89312' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-04') 21/12/2023 12:41:11 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '138/A', document_date = '2023-12-04', document_letter = 'A', id_customer = '4074', id_supplier = '0', id_address = '4679229', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO € 250 IN 7 ASSEGNI TOTALE € 1750 RESTA A SALDO € 550', 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 = '2300.00', price_tax_excluded = '1885.25', date_upd = NOW() WHERE id_document = '89312' 21/12/2023 12:41:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89312' 21/12/2023 12:41:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89312' 21/12/2023 12:41:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89312' , '20863' , 'CASULA ACETATO/VISCOSA - 65/19246' , '2' , '-2' , '1' , '1150.0000' , '942.62295081967' , '22' , '0' , '2300.00' ) 21/12/2023 12:41:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 21/12/2023 12:41:32 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '0', id_address = '4679228', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO € 220, 00 - € 150+ €240', 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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87349' 21/12/2023 12:41:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '0' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '0' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '0' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '0' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '0' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 21/12/2023 12:41:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 21/12/2023 12:53:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 12:53:13 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' , '4106' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 21/12/2023 12:53:13 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 = '89630' 21/12/2023 12:53:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89630' 21/12/2023 12:53:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89630' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 21/12/2023 03:31:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '4107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 03:31:47 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' , '4107' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.90' , '49.30' , NOW() , NOW() ) 21/12/2023 03:31:47 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 = '89631' 21/12/2023 03:31:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89631' 21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89631' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '3' , '-3' , '4' , '14' , '14' , '0' , '0' , '42.00' ) 21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89631' , '17872' , 'GIGLER PER LUMINELLO - 474/G' , '2' , '-2' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '7.80' ) 21/12/2023 03:31:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89631' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 21/12/2023 03:39:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '88284' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 21/12/2023 03:39:09 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '106/A', document_date = '2023-10-13', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'RESTANO 83.30', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '96.24', price_tax_excluded = '96.24', date_upd = NOW() WHERE id_document = '88284' 21/12/2023 03:39: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 = '88284' 21/12/2023 03:39:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88284' 21/12/2023 03:39: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 ( '88284' , '4154' , 'FESTA DEL PERDONO' , '31' , '-31' , '4' , '3.0000' , '3' , '0' , '15' , '79.05' ) 21/12/2023 03:39: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 ( '88284' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 21/12/2023 03:39: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 ( '88284' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '15' , '2.55' ) 21/12/2023 03:39: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 ( '88284' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '15' , '2.89' ) 21/12/2023 03:39: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 ( '88284' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '15' , '-15' , '0' , '0.50' , '0.5' , '' , '0' , '7.50' ) 21/12/2023 04:03:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '4108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 04:03:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4108' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 21/12/2023 04:03:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89632' 21/12/2023 04:03:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89632' 21/12/2023 04:03:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89632' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 21/12/2023 05:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 05:45:51 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' , '4109' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 21/12/2023 05:45:51 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 = '89633' 21/12/2023 05:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89633' 21/12/2023 05:45:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89633' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 21/12/2023 05:53:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '4110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 05:53:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4110' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.13' , NOW() , NOW() ) 21/12/2023 05:53:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89634' 21/12/2023 05:53:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89634' 21/12/2023 05:53:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89634' , '20705' , 'CANDELA CUBO' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 21/12/2023 06:00:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 06:00:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4111' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.55' , '65.55' , NOW() , NOW() ) 21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89635' 21/12/2023 06:00:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89635' 21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89635' , '8314' , 'PREGHIERA QUOTIDIANA DI ISRAELE - L. CATTANI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89635' , '12068' , 'VERA MISERICORDIA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 21/12/2023 06:00:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89635' , '5891' , 'LITURGIA DELLE ORE I - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 21/12/2023 06:48:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '4112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 06:48:59 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' , '4112' , '2023-12-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 21/12/2023 06:48: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 = '89636' 21/12/2023 06:48:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89636' 21/12/2023 06:48: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 ( '89636' , '19859' , 'CINGOLO - CING 29' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 21/12/2023 07:03:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3944' AND id_document != '89436' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-12') 21/12/2023 07:03:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3944', document_date = '2023-12-12', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA TORRIONE 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 = '161.44', price_tax_excluded = '155.67', date_upd = NOW() WHERE id_document = '89436' 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89436' 21/12/2023 07:03:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89436' 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '13322' , 'IMMAGINI 70X100 GESU\' MISERICORDIOSO' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '19742' , 'ENCICLICHE SOCIALI' , '1' , '-1' , '4' , '49.0000' , '49' , '0' , '5' , '46.55' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '3978' , 'EUCARISTIA: RITO E VITA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '18047' , 'CUSTODIA LITURGIA DELLE ORE 4 VOL ECO PELLE - L100E' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '21166' , 'ENCICLICHE SOCIALI ' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '5' , '24.70' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '13780' , 'RISCOPRIAMO LA BELLEZZA DEL BATTESIMO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '15' , '5.10' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 21/12/2023 07:03:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89436' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 21/12/2023 07:03: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 ( '89436' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 21/12/2023 07:03: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 ( '89436' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 21/12/2023 07:03: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 ( '89436' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.4000' , '3.4' , '0' , '15' , '2.89' ) 21/12/2023 07:03: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 ( '89436' , '2679' , 'CONOSCERE GESU' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 21/12/2023 07:03: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 ( '89436' , '2765' , 'CORONA FRANCESCANA' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 21/12/2023 07:03: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 ( '89436' , '19786' , 'ROSARIO MADREPERLA MM5 - 10M5' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 21/12/2023 07:31:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '145/A' AND id_document != '89628' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-21') 21/12/2023 07:31:55 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '145/A', document_date = '2023-12-21', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', address2 = '', note = 'ACCONTO € 150', 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 = '495.00', price_tax_excluded = '495.00', date_upd = NOW() WHERE id_document = '89628' 21/12/2023 07:31:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89628' 21/12/2023 07:31:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '89628' 21/12/2023 07:31:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '0' , 'PRESEPE ANTICO' , '1' , '-1' , '0' , '350.0000' , '350' , '0' , '0' , '350.00' ) 21/12/2023 07:31:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89628' , '' , 'CAMPANA IN VETRO' , '1' , '-1' , '0' , '145' , '145' , '' , '0' , '145.00' )