15/10/2024 08:44:08 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/10/2024 08:44:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23039' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 08:44:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23039' , '1' , '1' , '2' , NOW() , NOW() ) 15/10/2024 08:44:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23039' , '0' , '1' , '0' , '0' ) 15/10/2024 08:44:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049605' AND id_product != '23039' AND ean13 != '' 15/10/2024 08:44:49 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788884049605', date_upd = NOW() WHERE id_product = '23039' 15/10/2024 08:44:49 am >> UPDATE ps_product_lang SET name = 'LUISA PICCARRETA - 8664', description = '' WHERE id_product = '23039' 15/10/2024 08:44:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '23039' 15/10/2024 08:44:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', 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 = '23039' 15/10/2024 08:44:49 am >> DELETE FROM ps_specific_price WHERE id_product = '23039' 15/10/2024 08:44:50 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 = '23039' 15/10/2024 08:44:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23040' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 08:44:50 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 '23040' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23039' 15/10/2024 08:44:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23040' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23039' 15/10/2024 08:45:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256391455' AND id_product != '23040' AND ean13 != '' 15/10/2024 08:45:45 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791256391455', date_upd = NOW() WHERE id_product = '23040' 15/10/2024 08:45:45 am >> UPDATE ps_product_lang SET name = 'SAN GABRIELE DELL\'ADDOLORATA - 8756', description = '' WHERE id_product = '23040' 15/10/2024 08:45:45 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23040' 15/10/2024 08:45:45 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', 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 = '23040' 15/10/2024 08:45:45 am >> DELETE FROM ps_specific_price WHERE id_product = '23040' 15/10/2024 08:45:47 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 = '23040' 15/10/2024 08:45:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23041' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 08:45:47 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 '23041' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23040' 15/10/2024 08:45:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23041' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23040' 15/10/2024 08:47:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '10944' AND id_product != '23041' AND ean13 != '' 15/10/2024 08:47:40 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '10944', date_upd = NOW() WHERE id_product = '23041' 15/10/2024 08:47:40 am >> UPDATE ps_product_lang SET name = 'CORONA SANTA RITA - 10944', description = '' WHERE id_product = '23041' 15/10/2024 08:47:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.213114754098362' WHERE id_product = '23041' 15/10/2024 08:47:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.213114754098362', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '42', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23041' 15/10/2024 08:47:40 am >> DELETE FROM ps_specific_price WHERE id_product = '23041' 15/10/2024 08:47:42 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 = '23041' 15/10/2024 08:47:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23042' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 08:47:42 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 '23042' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23041' 15/10/2024 08:47:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23042' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23041' 15/10/2024 08:48:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '14882/00/2024' , '2024-10-11' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '179.04' , '173.59' , NOW() , NOW() ) 15/10/2024 08:48:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93621' 15/10/2024 08:48:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93621' 15/10/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '30' , '30' , '4' , '5.00' , '5' , '0' , '40' , '90.0000' ) 15/10/2024 08:48:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '22845' AND id_supplier = '38' 15/10/2024 08:48:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22845' , '38' , '1' ) 15/10/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '19503' , 'UN MESE CON MARIA - 8064' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 15/10/2024 08:48:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '19503' AND id_supplier = '38' 15/10/2024 08:48:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19503' , '38' , '1' ) 15/10/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '8245' , 'PREGATE IL SANTO ROSARIO OGNI GIORNO - 8234' , '5' , '5' , '4' , '2.00' , '2' , '0' , '40' , '6.0000' ) 15/10/2024 08:48:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '8245' AND id_supplier = '38' 15/10/2024 08:48:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8245' , '38' , '1' ) 15/10/2024 08:48:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '2' , '2' , '4' , '4.00' , '4' , '0' , '40' , '4.8000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '3388' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3388' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '22509' , 'SANTA GEMMA E IL DIAVOLO - 8607' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22509' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22509' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '22413' , 'VITA DI SAN GIUSEPPE - 8653' , '1' , '1' , '4' , '15.00' , '15' , '0' , '40' , '9.0000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22413' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22413' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '23039' , 'LUISA PICCARRETA - 8664' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23039' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23039' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '23040' , 'SAN GABRIELE DELLADDOLORATA - 8756' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23040' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23040' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '12904' , 'NOVENA DELLE ROSE A S. TERESA LISIEUX' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '40' , '1.8000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '12904' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12904' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '2' , '2' , '4' , '10.00' , '10' , '0' , '40' , '12.0000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13034' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13034' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '23041' , 'CORONA SANTA RITA - 10944' , '3' , '3' , '1' , '7.21' , '5.9098360655738' , '22' , '40' , '15.8332' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23041' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23041' , '38' , '1' ) 15/10/2024 08:48:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93621' , '22911' , 'AGENDA LITURGICO PASTORALE 2025 - 40821' , '2' , '2' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '14.4058' ) 15/10/2024 08:48:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '22911' AND id_supplier = '38' 15/10/2024 08:48:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22911' , '38' , '1' ) 15/10/2024 09:53:55 am >> SELECT document_num FROM ps_document WHERE document_num = '3040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 09:53:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3040' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 15/10/2024 09:53:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93622' 15/10/2024 09:53:55 am >> DELETE FROM ps_document_detail WHERE id_document = '93622' 15/10/2024 09:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93622' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 15/10/2024 10:07:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3984' 15/10/2024 10:07:48 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 ( '3984' , '10' , '210' , 'PARR. S. GIACOMO' , 'GALLO ' , 'DON VINCENZO ' , 'VIA M. ALETTA 1' , '' , '84030' , 'MONTE S. GIACOMO' , '' , '' , '3494248267' , '' , '92002550652' , NOW() , NOW() ) 15/10/2024 10:07:48 am >> UPDATE ps_customer SET email = 'enzogallo@yahoo.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3984' 15/10/2024 10:08:23 am >> SELECT document_num FROM ps_document WHERE document_num = '155' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 10:08:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '155' , '2024-10-15' , '' , '3984' , '0' , '4679386' , 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '105.40' , '105.40' , NOW() , NOW() ) 15/10/2024 10:08:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93623' 15/10/2024 10:08:23 am >> DELETE FROM ps_document_detail WHERE id_document = '93623' 15/10/2024 10:08:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93623' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '10' , '-10' , '4' , '3.80' , '3.8' , '0' , '15' , '32.30' ) 15/10/2024 10:08:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93623' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '10' , '-10' , '4' , '3.80' , '3.8' , '0' , '15' , '32.30' ) 15/10/2024 10:08:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93623' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.80' , '3.8' , '0' , '15' , '32.30' ) 15/10/2024 10:08:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93623' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/10/2024 10:32:48 am >> SELECT document_num FROM ps_document WHERE document_num = '3041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 10:32: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 ( '11' , '3041' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 15/10/2024 10:32:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93624' 15/10/2024 10:32:48 am >> DELETE FROM ps_document_detail WHERE id_document = '93624' 15/10/2024 10:32:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93624' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 15/10/2024 10:51:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 10:51:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3042' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 15/10/2024 10:51:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93625' 15/10/2024 10:51:27 am >> DELETE FROM ps_document_detail WHERE id_document = '93625' 15/10/2024 10:51:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93625' , '23037' , 'HOMO RELIGIOSUS - E. SCOGNAMIGLIO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/10/2024 11:33:03 am >> SELECT document_num FROM ps_document WHERE document_num = '156' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 11:33:03 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' , '156' , '2024-10-15' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '48.96' , '48.96' , NOW() , NOW() ) 15/10/2024 11:33:03 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 = '93626' 15/10/2024 11:33:03 am >> DELETE FROM ps_document_detail WHERE id_document = '93626' 15/10/2024 11:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93626' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '24' , '-24' , '4' , '2.40' , '2.4' , '0' , '15' , '48.96' ) 15/10/2024 11:53:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 11:53:04 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3043' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 15/10/2024 11:53:04 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93627' 15/10/2024 11:53:04 am >> DELETE FROM ps_document_detail WHERE id_document = '93627' 15/10/2024 11:53:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93627' , '22703' , 'UNA LOTTA PER LA VITA - E. BIANCHI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 15/10/2024 11:53:04 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93627' , '21340' , 'ECCO LAGNELLO DI DIO - M.D. GOUTIERRE' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 15/10/2024 11:55:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 11:55: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' , '3044' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.51' , '58.51' , NOW() , NOW() ) 15/10/2024 11:55: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 = '93628' 15/10/2024 11:55:02 am >> DELETE FROM ps_document_detail WHERE id_document = '93628' 15/10/2024 11:55: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 ( '93628' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 15/10/2024 11:55: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 ( '93628' , '21820' , 'GESU COSTRUIAMO UN MONDO NUOVO' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 15/10/2024 11:55: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 ( '93628' , '21592' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 2' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 15/10/2024 11:55: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 ( '93628' , '21709' , 'GESU E IL PANE DI VITA' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 15/10/2024 11:55: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 ( '93628' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '5' , '6.56' ) 15/10/2024 11:55: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 ( '93628' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 15/10/2024 11:55: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 ( '93628' , '20301' , 'CREDIAMO - LE PRINCIPALI VERITA DI FEDE' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 15/10/2024 11:55: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 ( '93628' , '2879' , 'CRESIMA: IL MIRACOLO DI SEGUIRE GESÙ - C. PELLEGRINO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 15/10/2024 11:55: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 ( '93628' , '12895' , 'PASSI VERSO LA CRESIMA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '0' , '5' ) 15/10/2024 11:55: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 ( '93628' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.5' , '16.5' , '0' , '5' , '15.68' ) 15/10/2024 11:55:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 11:55:16 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' , '3045' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.15' , '16.15' , NOW() , NOW() ) 15/10/2024 11:55:16 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 = '93629' 15/10/2024 11:55:16 am >> DELETE FROM ps_document_detail WHERE id_document = '93629' 15/10/2024 11:55:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93629' , '20882' , 'CREDO LA VITA ETERNA - BENEDETTO XVI' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '5' , '16.15' ) 15/10/2024 12:07:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 12:07:33 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' , '3046' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '162.38' , '153.72' , NOW() , NOW() ) 15/10/2024 12:07:33 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 = '93630' 15/10/2024 12:07:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93630' 15/10/2024 12:07:33 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 ( '93630' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.80' , '2.8' , '0' , '5' , '31.92' ) 15/10/2024 12:07:33 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 ( '93630' , '5458' , 'IO SONO CON VOI 2 PARTE' , '11' , '-11' , '4' , '2.80' , '2.8' , '0' , '5' , '29.26' ) 15/10/2024 12:07:33 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 ( '93630' , '13956' , 'MIRACOLI DI GESU' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '5' , '14.25' ) 15/10/2024 12:07:33 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 ( '93630' , '7543' , 'PARABOLE DI GESÙ' , '9' , '-9' , '4' , '3.00' , '3' , '0' , '5' , '25.65' ) 15/10/2024 12:07:33 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 ( '93630' , '5457' , 'IO SONO CON VOI 1 PARTE' , '5' , '-5' , '4' , '2.80' , '2.8' , '0' , '5' , '13.30' ) 15/10/2024 12:07:33 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 ( '93630' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '4' , '-4' , '1' , '12' , '9.8360655737705' , '22' , '0' , '48.00' ) 15/10/2024 12:09:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 12:09: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' , '3047' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.00' , '123.77' , NOW() , NOW() ) 15/10/2024 12:09: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 = '93631' 15/10/2024 12:09:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '93631' 15/10/2024 12:09: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 ( '93631' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 15/10/2024 12:09: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 ( '93631' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 15/10/2024 12:09: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 ( '93631' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/10/2024 12:09:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '3048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 12:09: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 ( '11' , '3048' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.20' , '6.20' , NOW() , NOW() ) 15/10/2024 12:09: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 = '93632' 15/10/2024 12:09:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '93632' 15/10/2024 12:09: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 ( '93632' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 15/10/2024 12:09: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 ( '93632' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 15/10/2024 12:09: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 ( '93632' , '23015' , 'PELLEGRINI DI SPERANZA - SUSSIDIO GIUBILEO ADULTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 15/10/2024 12:35:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '157' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 12:35:35 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' , '157' , '2024-10-15' , '' , '4060' , '0' , '4679203' , 'PIAZZA DONATORI DI SANGUE 1 37050 CADEGLIOPPI DI OPPEANO ' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '60.10' , '60.10' , NOW() , NOW() ) 15/10/2024 12:35:35 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 = '93633' 15/10/2024 12:35:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '93633' 15/10/2024 12:35: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 ( '93633' , '4154' , 'FESTA DEL PERDONO' , '16' , '-16' , '4' , '3.00' , '3' , '0' , '5' , '45.60' ) 15/10/2024 12:35: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 ( '93633' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 15/10/2024 12:43:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3049' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 12:43:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3049' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.30' , '7.62' , NOW() , NOW() ) 15/10/2024 12:43:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93634' 15/10/2024 12:43:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '93634' 15/10/2024 12:43:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93634' , '21595' , 'SEGNALIBRO SAN PAOLO' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 15/10/2024 12:43:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93634' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 15/10/2024 12:43:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93634' , '5095' , 'IMMAGINI ISONZO ASSORTITE X 100' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 15/10/2024 03:40:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3050' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 03:40:31 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' , '3050' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 15/10/2024 03:40:31 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 = '93635' 15/10/2024 03:40:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '93635' 15/10/2024 03:40:31 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 ( '93635' , '12819' , 'REGISTRO DEL CATECHISTA ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 15/10/2024 03:53:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '93618' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-14') 15/10/2024 03:53:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '153', document_date = '2024-10-14', document_letter = '', id_customer = '3931', id_supplier = '', id_address = '4679347', address1 = 'VIALE DELLA LIBERA 11 80079 PROCIDA', address2 = '', note = '', price_shipping = '12.75', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '7', id_causal = '0', price_tax_included = '170.00', price_tax_excluded = '170.00', date_upd = NOW() WHERE id_document = '93618' 15/10/2024 03:53: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 = '93618' 15/10/2024 03:53:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '93618' 15/10/2024 03:53: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 ( '93618' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '10' , '-10' , '4' , '18.50' , '18.5' , '0' , '15' , '157.25' ) 15/10/2024 04:08:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868984106' AND id_product != '23042' AND ean13 != '' 15/10/2024 04:08:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788868984106', date_upd = NOW() WHERE id_product = '23042' 15/10/2024 04:08:10 pm >> UPDATE ps_product_lang SET name = 'PADRE NOSTRO - J. ZUMSTEIN', description = '' WHERE id_product = '23042' 15/10/2024 04:08:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.5' WHERE id_product = '23042' 15/10/2024 04:08:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.5', id_tax_rules_group = '4', id_category_default = '257', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23042' 15/10/2024 04:08:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23042' 15/10/2024 04:08:14 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 = '23042' 15/10/2024 04:08:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23043' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 04:08:14 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 '23043' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23042' 15/10/2024 04:08:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23043' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23042' 15/10/2024 04:09:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256270446' AND id_product != '23043' AND ean13 != '' 15/10/2024 04:09:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791256270446', date_upd = NOW() WHERE id_product = '23043' 15/10/2024 04:09:10 pm >> UPDATE ps_product_lang SET name = 'PREGHIAMO CON MARIA', description = '' WHERE id_product = '23043' 15/10/2024 04:09:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '23043' 15/10/2024 04:09:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '137', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23043' 15/10/2024 04:09:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '23043' 15/10/2024 04:09:13 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 = '23043' 15/10/2024 04:09:13 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23044' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 04:09:13 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 '23044' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23043' 15/10/2024 04:09:13 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23044' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23043' 15/10/2024 04:10:27 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 15/10/2024 04:10:27 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '546' , '1' ) 15/10/2024 04:10:27 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '546' , '2' ) 15/10/2024 04:10:27 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '546' , '3' ) 15/10/2024 04:10:27 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '546' , '1' , 'SCHOLE\'' , LOWER('SCHOLE\'') ) 15/10/2024 04:10:27 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '546' , '1' , '0' ) 15/10/2024 04:10:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788828406150' AND id_product != '23044' AND ean13 != '' 15/10/2024 04:10:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788828406150', date_upd = NOW() WHERE id_product = '23044' 15/10/2024 04:10:34 pm >> UPDATE ps_product_lang SET name = 'NUOVA STORIA DELLA PEDAGOGIA - F. DE GIORGI', description = '' WHERE id_product = '23044' 15/10/2024 04:10:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30' WHERE id_product = '23044' 15/10/2024 04:10:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30', id_tax_rules_group = '4', id_category_default = '546', id_argoment_default = '281', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23044' 15/10/2024 04:10:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '23044' 15/10/2024 04:10:38 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 = '23044' 15/10/2024 04:10:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23045' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 04:10:38 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 '23045' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23044' 15/10/2024 04:10:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23045' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23044' 15/10/2024 04:11:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259853745' AND id_product != '23045' AND ean13 != '' 15/10/2024 04:11:21 pm >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9791259853745', date_upd = NOW() WHERE id_product = '23045' 15/10/2024 04:11:21 pm >> UPDATE ps_product_lang SET name = 'DIO DEI NOSTRI PADRI - A. CAZZULLO', description = '' WHERE id_product = '23045' 15/10/2024 04:11:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.5' WHERE id_product = '23045' 15/10/2024 04:11:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.5', id_tax_rules_group = '4', id_category_default = '533', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23045' 15/10/2024 04:11:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '23045' 15/10/2024 04:11:24 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 = '23045' 15/10/2024 04:11:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23046' , '1' , '' , 'nuovo-prodotto' ) 15/10/2024 04:11:24 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 '23046' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23045' 15/10/2024 04:11:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23046' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23045' 15/10/2024 04:13:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '286411' , '2024-10-14' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '183.50' , '183.50' , NOW() , NOW() ) 15/10/2024 04:13:25 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 = '93636' 15/10/2024 04:13:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '93636' 15/10/2024 04:13: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 ( '93636' , '23043' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '13.00' , '13' , '0' , '0' , '39.0000' ) 15/10/2024 04:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23043' AND id_supplier = '109' 15/10/2024 04:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23043' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '23044' , 'NUOVA STORIA DELLA PEDAGOGIA - F. DE GIORGI' , '1' , '1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 15/10/2024 04:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23044' AND id_supplier = '109' 15/10/2024 04:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23044' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '2' , '4' , '19.50' , '19.5' , '0' , '0' , '39.0000' ) 15/10/2024 04:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23045' AND id_supplier = '109' 15/10/2024 04:13:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23045' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '0' , '20.00' ) 15/10/2024 04:13:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17413' AND id_supplier = '109' 15/10/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17413' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 15/10/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16205' AND id_supplier = '109' 15/10/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16205' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 15/10/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16204' AND id_supplier = '109' 15/10/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16204' , '109' , '1' ) 15/10/2024 04:13: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 ( '93636' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 15/10/2024 04:13:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22861' AND id_supplier = '109' 15/10/2024 04:13:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22861' , '109' , '1' ) 15/10/2024 04:13:47 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '286411', document_date = '2024-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '193.00', price_tax_excluded = '193.00', date_upd = NOW() WHERE id_document = '93636' 15/10/2024 04:13: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 = '93636' 15/10/2024 04:13:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '93636' 15/10/2024 04:13: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 ( '93636' , '23043' , 'PREGHIAMO CON MARIA' , '3' , '3' , '4' , '13.0000' , '13' , '0' , '0' , '39.00' ) 15/10/2024 04:13: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 ( '93636' , '23044' , 'NUOVA STORIA DELLA PEDAGOGIA - F. DE GIORGI' , '1' , '1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/10/2024 04:13: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 ( '93636' , '23045' , 'DIO DEI NOSTRI PADRI - A. CAZZULLO' , '2' , '2' , '4' , '19.5000' , '19.5' , '0' , '0' , '39.00' ) 15/10/2024 04:13: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 ( '93636' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/10/2024 04:13: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 ( '93636' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 15/10/2024 04:13: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 ( '93636' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 15/10/2024 04:13: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 ( '93636' , '22861' , 'E LA TUA PARTE 3 - 12/14 ANNI' , '1' , '1' , '4' , '16.5000' , '16.5' , '0' , '0' , '16.50' ) 15/10/2024 04:13: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 ( '93636' , '23042' , 'PADRE NOSTRO - J. ZUMSTEIN' , '1' , '1' , '4' , '9.50' , '9.5' , '0' , '0' , '9.50' ) 15/10/2024 04:33:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 04:33:49 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' , '158' , '2024-10-15' , '' , '4081' , '0' , '4679276' , 'VIA PAZZIGNO 6 80146 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '105.00' , '105.00' , NOW() , NOW() ) 15/10/2024 04:33:49 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 = '93637' 15/10/2024 04:33:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '93637' 15/10/2024 04:33:49 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 ( '93637' , '22987' , 'GIUSEPPE MOSCATI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2024 04:33:49 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 ( '93637' , '7105' , 'NOVENA A SAN PIO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 15/10/2024 04:33:49 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 ( '93637' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 15/10/2024 04:33:49 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 ( '93637' , '22988' , 'PREGHIERA DANZA DELLO SPIRITO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2024 04:33:49 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 ( '93637' , '22953' , 'NOVENA DELLE ROSE' , '1' , '-1' , '4' , '1.10' , '1.1' , '0' , '0' , '1.10' ) 15/10/2024 04:33:49 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 ( '93637' , '22952' , 'ROSARIO CON SANTA TERESA DI G. BAMBINO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2024 04:33:49 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 ( '93637' , '22767' , 'CUORE DI MAMMA - A. COMASTRI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/10/2024 04:33:49 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 ( '93637' , '22871' , 'SPERANZA NON DELUDE - M. DE ROSA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 15/10/2024 04:33:49 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 ( '93637' , '22877' , 'OH, MAMMA CELESTE! - F. CRISTOFARO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '22884' , 'MARIA CAREZZA DI DIO - D. LIGAS' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '6988' , 'NELLE TUE MANI LA MIA VITA - FR. M. DAVIDE' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '22989' , 'MARIA MODELLO DI ISPIRAZIONE - S. VITA' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '22986' , 'GIOVANNI DI DIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '23043' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '13.00' , '13' , '0' , '5' , '24.70' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '16969' , 'CORONA DELLE ROSE - 10974' , '2' , '-2' , '4' , '5.40' , '5.4' , '0' , '0' , '10.80' ) 15/10/2024 04:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93637' , '' , 'contrassegno ' , '1' , '-1' , '4' , '2.37' , '2.37' , '0' , '0' , '2.37' ) 15/10/2024 04:47:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3051' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 04:47: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' , '3051' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '67.62' , NOW() , NOW() ) 15/10/2024 04:47: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 = '93638' 15/10/2024 04:47:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '93638' 15/10/2024 04:47: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 ( '93638' , '13929' , 'COPRILEGGIO - 317/TP' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 15/10/2024 04:47: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 ( '93638' , '6314' , 'MEDAGLIA LOURDES MM 22' , '50' , '-50' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '12.50' ) 15/10/2024 04:48:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3052' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 04:48:39 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' , '3052' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 15/10/2024 04:48:39 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 = '93639' 15/10/2024 04:48:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93639' 15/10/2024 04:48:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93639' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 15/10/2024 05:33:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3053' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 05:33:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3053' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.06' , '57.06' , NOW() , NOW() ) 15/10/2024 05:33:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93640' 15/10/2024 05:33:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '93640' 15/10/2024 05:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93640' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 15/10/2024 05:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93640' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 15/10/2024 05:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93640' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 15/10/2024 05:33:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93640' , '22846' , 'CALENDARIO LITURGICO 2025 - 8665' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 15/10/2024 05:43:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '33' AND id_document != '14749' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-25') 15/10/2024 05:43:17 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '33', document_date = '2024-09-25', document_letter = '', id_customer = '7107', id_supplier = '', id_address = '177359045', address1 = 'FRAZ. CASAL 4 38047 SEGONZANO', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '38.00', price_tax_excluded = '38.00', date_upd = NOW() WHERE id_document = '14749' 15/10/2024 05:43:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14749' 15/10/2024 05:43:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '14749' 15/10/2024 05:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14749' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 15/10/2024 05:43:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14749' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '29.1' , '29.1' , '0' , '0' , '29.10' ) 15/10/2024 05:48:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3054' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 05:48:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3054' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '83.50' , '70.16' , NOW() , NOW() ) 15/10/2024 05:48:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93641' 15/10/2024 05:48:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93641' 15/10/2024 05:48:42 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 ( '93641' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 15/10/2024 05:48:42 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 ( '93641' , '22955' , 'PREGHIERA OSSIGENO PER LANIMA - J. PHILIPPE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 15/10/2024 05:49:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '3055' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 05:49:11 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' , '3055' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.08' , '19.08' , NOW() , NOW() ) 15/10/2024 05:49: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 = '93642' 15/10/2024 05:49:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '93642' 15/10/2024 05:49: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 ( '93642' , '15024' , 'CATECHISMO DELLA CHIESA CATTOLICA N.E.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 15/10/2024 05:49: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 ( '93642' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/10/2024 05:49: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 ( '93642' , '11278' , 'VI HO CHIAMATO AMICI' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 15/10/2024 06:19:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3054' AND id_document != '93641' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 06:19:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3054', document_date = '2024-10-15', 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 = '83.50', price_tax_excluded = '70.16', date_upd = NOW() WHERE id_document = '93641' 15/10/2024 06:19:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93641' 15/10/2024 06:19:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '93641' 15/10/2024 06:19:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93641' , '22955' , 'PREGHIERA OSSIGENO PER LANIMA - J. PHILIPPE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 15/10/2024 06:19:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93641' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:19:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93641' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:21:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2719' AND id_document != '93183' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-18') 15/10/2024 06:21:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2719', document_date = '2024-09-18', 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 = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '93183' 15/10/2024 06:21:53 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 = '93183' 15/10/2024 06:21:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '93183' 15/10/2024 06:21: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 ( '93183' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:22:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2073' AND id_document != '92395' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-25') 15/10/2024 06:22:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2073', document_date = '2024-06-25', 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 = '76.50', price_tax_excluded = '62.70', date_upd = NOW() WHERE id_document = '92395' 15/10/2024 06:22: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 = '92395' 15/10/2024 06:22:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92395' 15/10/2024 06:22: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 ( '92395' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:22: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 ( '92395' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 15/10/2024 06:22:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1850' AND id_document != '92124' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-03') 15/10/2024 06:22:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1850', document_date = '2024-06-03', 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 = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '92124' 15/10/2024 06:22:28 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 = '92124' 15/10/2024 06:22:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '92124' 15/10/2024 06:22:28 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 ( '92124' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:22:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '1406' AND id_document != '91580' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-03') 15/10/2024 06:22:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1406', document_date = '2024-05-03', 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 = '111.00', price_tax_excluded = '90.98', date_upd = NOW() WHERE id_document = '91580' 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91580' 15/10/2024 06:22:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '91580' 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '12816' , 'LIBRO DEI DEFUNTI' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '20983' , 'CLERGY MM LIMITED 80/20' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/10/2024 06:22:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91580' , '9150' , 'ROSARIO LEGNO SCURO E CORDA - 99999' , '14' , '-14' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '14.00' ) 15/10/2024 07:10:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001693' AND id_product != '18131' AND ean13 != '' 15/10/2024 07:10:23 pm >> UPDATE ps_product SET id_supplier = '148', reference = '', ean13 = '001693', date_upd = NOW() WHERE id_product = '18131' 15/10/2024 07:10:23 pm >> UPDATE ps_product_lang SET name = 'TAU MEDIO CM3 - T6/t5', description = '' WHERE id_product = '18131' 15/10/2024 07:10:23 pm >> UPDATE ps_product SET wholesale_price = '0.29', on_sale = '0', price = '0.8197' WHERE id_product = '18131' 15/10/2024 07:10:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.29', price = '0.8197', id_tax_rules_group = '1', id_category_default = '477', 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 = '18131' 15/10/2024 07:10:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '18131' 15/10/2024 07:11:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3056' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 07:11:33 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' , '3056' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 15/10/2024 07:11:33 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 = '93643' 15/10/2024 07:11:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '93643' 15/10/2024 07:11:33 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 ( '93643' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 15/10/2024 07:18:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001701' AND id_product != '18139' AND ean13 != '' 15/10/2024 07:18:43 pm >> UPDATE ps_product SET id_supplier = '148', reference = '', ean13 = '001701', date_upd = NOW() WHERE id_product = '18139' 15/10/2024 07:18:43 pm >> UPDATE ps_product_lang SET name = 'TAU SNODATO PADRE NOSTRO PICCOLO', description = '' WHERE id_product = '18139' 15/10/2024 07:18:43 pm >> UPDATE ps_product SET wholesale_price = '3.10', on_sale = '0', price = '8.032786885245903' WHERE id_product = '18139' 15/10/2024 07:18:43 pm >> UPDATE ps_product_shop SET wholesale_price = '3.10', price = '8.032786885245903', id_tax_rules_group = '1', id_category_default = '477', 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 = '18139' 15/10/2024 07:18:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '18139' 15/10/2024 07:20: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 ( '31' , '661/2024' , '2024-10-15' , '2024' , '0' , '148' , '4671093' , 'VIALE EUROPA 62 - FRAZ. OSPEDALICCHIO 06083 BASTIA UMBRA ' , '' , '' , '11.9' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '729.44' , '597.90' , NOW() , NOW() ) 15/10/2024 07:20: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 = '93644' 15/10/2024 07:20:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '93644' 15/10/2024 07:20: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 ( '93644' , '18129' , 'TAU COLORATO - T56' , '300' , '300' , '1' , '0.48' , '0.39344262295082' , '22' , '0' , '175.6800' ) 15/10/2024 07:20:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '148' 15/10/2024 07:20:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '148' , '1' ) 15/10/2024 07:20: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 ( '93644' , '18131' , 'TAU MEDIO CM3 - T6' , '1200' , '1200' , '1' , '0.33' , '0.27049180327869' , '22' , '0' , '483.1200' ) 15/10/2024 07:20:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18131' AND id_supplier = '148' 15/10/2024 07:20:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18131' , '148' , '1' ) 15/10/2024 07:20:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93644' , '18139' , 'TAU SNODATO PADRE NOSTRO PICCOLO' , '5' , '5' , '1' , '4' , '3.2786885245902' , '22' , '0' , '24.4000' ) 15/10/2024 07:20:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18139' AND id_supplier = '148' 15/10/2024 07:20:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18139' , '148' , '1' ) 15/10/2024 07:20:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93644' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '5' , '5' , '1' , '5.2' , '4.2622950819672' , '22' , '0' , '31.7200' ) 15/10/2024 07:20:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18140' AND id_supplier = '148' 15/10/2024 07:20:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18140' , '148' , '1' ) 15/10/2024 07:37:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3057' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-15') 15/10/2024 07:37: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' , '3057' , '2024-10-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.77' , '34.77' , NOW() , NOW() ) 15/10/2024 07:37: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 = '93645' 15/10/2024 07:37:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '93645' 15/10/2024 07:37: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 ( '93645' , '8289' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 15/10/2024 07:37: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 ( '93645' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '5' , '19.00' ) 15/10/2024 07:37: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 ( '93645' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '-2' , '4' , '3.80' , '3.8' , '0' , '5' , '7.22' )