03/10/2023 08:55:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 03/10/2023 08:55:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21638' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 08:55:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21638' , '1' , '1' , '2' , NOW() , NOW() ) 03/10/2023 08:55:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21638' , '0' , '1' , '0' , '0' ) 03/10/2023 08:57:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002178' AND id_product != '21638' AND ean13 != '' 03/10/2023 08:57:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002178', date_upd = NOW() WHERE id_product = '21638' 03/10/2023 08:57:37 am >> UPDATE ps_product_lang SET name = 'CASULA MARIANA P/LANA - 8418L', description = '' WHERE id_product = '21638' 03/10/2023 08:57:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '709.016393442623' WHERE id_product = '21638' 03/10/2023 08:57:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '709.016393442623', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21638' 03/10/2023 08:57:37 am >> DELETE FROM ps_specific_price WHERE id_product = '21638' 03/10/2023 08:57:39 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21638' 03/10/2023 08:57:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21639' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 08:57:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21639' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21638' 03/10/2023 08:57:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21639' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21638' 03/10/2023 08:58:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002179' AND id_product != '21639' AND ean13 != '' 03/10/2023 08:58:57 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002179', date_upd = NOW() WHERE id_product = '21639' 03/10/2023 08:58:57 am >> UPDATE ps_product_lang SET name = 'CASULA MOIRE - 8237LS', description = '' WHERE id_product = '21639' 03/10/2023 08:58:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '635.2459016393443' WHERE id_product = '21639' 03/10/2023 08:58:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '635.2459016393443', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21639' 03/10/2023 08:58:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21639' 03/10/2023 08:59:01 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 = '21639' 03/10/2023 08:59:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21640' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 08:59:01 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 '21640' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21639' 03/10/2023 08:59:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21640' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21639' 03/10/2023 09:03:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002180' AND id_product != '21640' AND ean13 != '' 03/10/2023 09:03:48 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002180', date_upd = NOW() WHERE id_product = '21640' 03/10/2023 09:03:48 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA TAU ORO - 6645-4', description = '' WHERE id_product = '21640' 03/10/2023 09:03:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '50.81967213114754' WHERE id_product = '21640' 03/10/2023 09:03:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '50.81967213114754', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21640' 03/10/2023 09:03:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21640' 03/10/2023 09:03: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 = '21640' 03/10/2023 09:03:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21641' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 09:03: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 '21641' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21640' 03/10/2023 09:03:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21641' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21640' 03/10/2023 09:07:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002181' AND id_product != '21641' AND ean13 != '' 03/10/2023 09:07:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002181', date_upd = NOW() WHERE id_product = '21641' 03/10/2023 09:07:42 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA TAU - 7553', description = '' WHERE id_product = '21641' 03/10/2023 09:07:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '40.16393442622951' WHERE id_product = '21641' 03/10/2023 09:07:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '40.16393442622951', id_tax_rules_group = '1', id_category_default = '448', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21641' 03/10/2023 09:07:42 am >> DELETE FROM ps_specific_price WHERE id_product = '21641' 03/10/2023 09:07: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 = '21641' 03/10/2023 09:07:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21642' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 09:07: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 '21642' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21641' 03/10/2023 09:07:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21642' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21641' 03/10/2023 09:09:22 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' , '191' , '2023-09-27' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '10' , '0' , '1008.94' , '827.00' , NOW() , NOW() ) 03/10/2023 09:09: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 = '87525' 03/10/2023 09:09:23 am >> DELETE FROM ps_document_detail WHERE id_document = '87525' 03/10/2023 09:09: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 ( '87525' , '21638' , 'CASULA MARIANA P/LANA - 8418L' , '1' , '1' , '1' , '380' , '311.47540983607' , '22' , '0' , '463.6000' ) 03/10/2023 09:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21638' AND id_supplier = '126' 03/10/2023 09:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21638' , '126' , '1' ) 03/10/2023 09:09: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 ( '87525' , '21639' , 'CASULA MOIRE - 8237LS' , '1' , '1' , '1' , '340' , '278.68852459016' , '22' , '0' , '414.8000' ) 03/10/2023 09:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21639' AND id_supplier = '126' 03/10/2023 09:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21639' , '126' , '1' ) 03/10/2023 09:09: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 ( '87525' , '21640' , 'SERVIZIO MESSA TAU ORO - 6645-4' , '1' , '1' , '1' , '25' , '20.491803278689' , '22' , '0' , '30.5000' ) 03/10/2023 09:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21640' AND id_supplier = '126' 03/10/2023 09:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21640' , '126' , '1' ) 03/10/2023 09:09: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 ( '87525' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 03/10/2023 09:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126' 03/10/2023 09:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' ) 03/10/2023 09:09: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 ( '87525' , '21641' , 'SERVIZIO MESSA TAU - 7553' , '1' , '1' , '1' , '20' , '16.393442622951' , '22' , '0' , '24.4000' ) 03/10/2023 09:09:23 am >> DELETE FROM ps_product_supplier WHERE id_product = '21641' AND id_supplier = '126' 03/10/2023 09:09:23 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21641' , '126' , '1' ) 03/10/2023 09:11:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 09:11:46 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' , '2991' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '15.87' , NOW() , NOW() ) 03/10/2023 09:11:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87526' 03/10/2023 09:11:46 am >> DELETE FROM ps_document_detail WHERE id_document = '87526' 03/10/2023 09:11:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87526' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 03/10/2023 09:11:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87526' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 03/10/2023 09:36:04 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1610' 03/10/2023 09:36:04 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 ( '1610' , '10' , '123' , 'PARROCCHIA S. MARIA MED. DI TUTTE LA GRAZIE' , 'DI SALVO ' , 'DON CALOGERO' , 'VIA A. DE GASPERI 25' , '' , '92026' , 'FAVARA' , '' , '' , '3899667588' , '' , '' , NOW() , NOW() ) 03/10/2023 09:36:05 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1610' 03/10/2023 09:37:01 am >> SELECT document_num FROM ps_document WHERE document_num = '130' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 09:37:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '130' , '2023-10-03' , '' , '1610' , '0' , '4679099' , 'VIA A. DE GASPERI 25 92026 FAVARA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '25.40' , '25.40' , NOW() , NOW() ) 03/10/2023 09:37:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87527' 03/10/2023 09:37:01 am >> DELETE FROM ps_document_detail WHERE id_document = '87527' 03/10/2023 09:37:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87527' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '10' , '-10' , '4' , '2.40' , '2.4' , '0' , '15' , '20.40' ) 03/10/2023 10:05:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 10:05:31 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' , '2992' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 03/10/2023 10:05:31 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 = '87528' 03/10/2023 10:05:31 am >> DELETE FROM ps_document_detail WHERE id_document = '87528' 03/10/2023 10:05:31 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 ( '87528' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 03/10/2023 10:30:41 am >> SELECT document_num FROM ps_document WHERE document_num = '2993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 10:30:41 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2993' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 03/10/2023 10:30:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87529' 03/10/2023 10:30:41 am >> DELETE FROM ps_document_detail WHERE id_document = '87529' 03/10/2023 10:30:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87529' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 03/10/2023 10:37:03 am >> SELECT document_num FROM ps_document WHERE document_num = '2994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 10:37: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 ( '11' , '2994' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.10' , '15.66' , NOW() , NOW() ) 03/10/2023 10:37: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 = '87530' 03/10/2023 10:37:03 am >> DELETE FROM ps_document_detail WHERE id_document = '87530' 03/10/2023 10:37: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 ( '87530' , '20026' , 'CANDELA VOTIVA 20X30' , '12' , '-12' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '7.20' ) 03/10/2023 10:37: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 ( '87530' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 03/10/2023 10:37: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 ( '87530' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 03/10/2023 10:45:57 am >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '87498' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-02') 03/10/2023 10:45:57 am >> UPDATE ps_document SET id_document_type = '21', document_num = '126', document_date = '2023-10-02', document_letter = '', id_customer = '2517', id_supplier = '', id_address = '4670931', address1 = 'VIA SALETTE, 46 80057 SANT\\\' ANTONIO ABATE', 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 = '378.68', price_tax_excluded = '378.68', date_upd = NOW() WHERE id_document = '87498' 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87498' 03/10/2023 10:45:57 am >> DELETE FROM ps_document_detail WHERE id_document = '87498' 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '13956' , 'MIRACOLI DI GESU\'' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '7543' , 'PARABOLE DI GESÙ' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '5446' , 'IO SONO CON VOI - GUIDA' , '7' , '-7' , '4' , '8.0000' , '8' , '0' , '15' , '47.60' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '3' , '-3' , '4' , '2.50' , '2.5' , '0' , '15' , '6.38' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '4' , '-4' , '4' , '1.50' , '1.5' , '0' , '15' , '5.10' ) 03/10/2023 10:45:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87498' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '4' , '-4' , '4' , '2.50' , '2.5' , '0' , '15' , '8.50' ) 03/10/2023 10:48:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 10:48:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2995' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '165.25' , '163.57' , NOW() , NOW() ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87531' 03/10/2023 10:48:17 am >> DELETE FROM ps_document_detail WHERE id_document = '87531' 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '5444' , 'IO SONO CON VOI - CAT.' , '15' , '-15' , '4' , '4.95' , '4.95' , '0' , '0' , '74.25' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '8855' , 'REGISTRO DEL CATECHISTA' , '10' , '-10' , '1' , '0.75' , '0.61475409836066' , '22' , '0' , '7.50' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '20190' , 'MISTERO MARIANO NEL MISTERO TRINITARIO' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '5' , '28.50' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '21493' , 'LUISA PICCARRETTA - LO SPLENDORE DELLA DIVINA VOLONTA - M. STANZIONE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '5' , '10.45' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '19139' , 'IMMACOLATA MADRE DI DIO ......' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 03/10/2023 10:48:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87531' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '9' , '-9' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '1.80' ) 03/10/2023 10:56:36 am >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 10:56:36 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' , '82' , '2023-10-03' , '' , '2517' , '0' , '2517' , 'VIA SALETTE, 46 80057 S. ANTONIO ABATE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.75' , '63.75' , NOW() , NOW() ) 03/10/2023 10:56:36 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 = '12948' 03/10/2023 10:56:36 am >> DELETE FROM ps_document_detail WHERE id_document = '12948' 03/10/2023 10:56:36 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 ( '12948' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '30' , '-30' , '4' , '2.50' , '2.5' , '0' , '15' , '63.75' ) 03/10/2023 11:02:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:02:37 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' , '2996' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 03/10/2023 11:02:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87532' 03/10/2023 11:02:37 am >> DELETE FROM ps_document_detail WHERE id_document = '87532' 03/10/2023 11:02:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '60' , '49.180327868852' , '22' , '0' , '120.00' ) 03/10/2023 11:09:24 am >> SELECT document_num FROM ps_document WHERE document_num = '82' AND id_document != '12948' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:09:24 am >> UPDATE ps_document SET id_document_type = '21', document_num = '82', document_date = '2023-10-03', document_letter = '', id_customer = '2517', id_supplier = '', id_address = '2517', address1 = 'VIA SALETTE, 46 80057 S. ANTONIO ABATE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '63.75', price_tax_excluded = '63.75', date_upd = NOW() WHERE id_document = '12948' 03/10/2023 11:09:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12948' 03/10/2023 11:09:24 am >> DELETE FROM ps_document_detail WHERE id_document = '12948' 03/10/2023 11:09:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12948' , '121' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '30' , '-30' , '4' , '2.5000' , '2.5' , '0' , '15' , '63.75' ) 03/10/2023 11:11:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '87532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:11:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2996', document_date = '2023-10-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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '87532' 03/10/2023 11:11:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87532' 03/10/2023 11:11:00 am >> DELETE FROM ps_document_detail WHERE id_document = '87532' 03/10/2023 11:11:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 03/10/2023 11:11:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '60' , '49.180327868852' , '22' , '0' , '60.00' ) 03/10/2023 11:26:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:26:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2997' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 03/10/2023 11:26:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87533' 03/10/2023 11:26:14 am >> DELETE FROM ps_document_detail WHERE id_document = '87533' 03/10/2023 11:26:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87533' , '12238' , 'NAVETTA CLASSICA H13 CM' , '1' , '-1' , '1' , '48.00' , '39.344262295082' , '22' , '0' , '48.00' ) 03/10/2023 11:29:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:29: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' , '2998' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 03/10/2023 11:29: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 = '87534' 03/10/2023 11:29:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87534' 03/10/2023 11:29: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 ( '87534' , '21089' , 'ANELLO ROSARIO ARG. - 6450' , '1' , '-1' , '1' , '28.00' , '22.950819672131' , '22' , '0' , '28.00' ) 03/10/2023 11:44:36 am >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:44:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '96/A' , '2023-10-03' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.50' , '59.20' , NOW() , NOW() ) 03/10/2023 11:44:36 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 = '87535' 03/10/2023 11:44:36 am >> DELETE FROM ps_document_detail WHERE id_document = '87535' 03/10/2023 11:44:36 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 ( '87535' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 03/10/2023 11:44:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87535' , '16456' , 'CINGOLO - CING03' , '2' , '-2' , '1' , '14' , '11.475409836066' , '22' , '0' , '28.00' ) 03/10/2023 11:44:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:44:51 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' , '2999' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.50' , NOW() , NOW() ) 03/10/2023 11:44:51 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 = '87536' 03/10/2023 11:44:51 am >> DELETE FROM ps_document_detail WHERE id_document = '87536' 03/10/2023 11:44:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87536' , '21196' , 'CALENDARIO LITURGICO 2024' , '5' , '-5' , '4' , '0.50' , '0.5' , '0' , '0' , '2.50' ) 03/10/2023 11:49:07 am >> SELECT document_num FROM ps_document WHERE document_num = '3000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 11:49:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3000' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.04' , '10.04' , NOW() , NOW() ) 03/10/2023 11:49:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87537' 03/10/2023 11:49:07 am >> DELETE FROM ps_document_detail WHERE id_document = '87537' 03/10/2023 11:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87537' , '21199' , 'AMEN - OTT 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 03/10/2023 11:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87537' , '16347' , 'PANE QUOTIDIANO ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 03/10/2023 11:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87537' , '21008' , 'GIONA E LA BALENA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 03/10/2023 11:49:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87537' , '21012' , 'PECORELLA SMARRITA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 03/10/2023 12:03:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '3001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 12:03:01 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' , '3001' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '2.87' , NOW() , NOW() ) 03/10/2023 12:03:01 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 = '87538' 03/10/2023 12:03:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '87538' 03/10/2023 12:03:01 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 ( '87538' , '21461' , 'PAROLA PER OGGI 2024' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 03/10/2023 12:05:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002182' AND id_product != '21642' AND ean13 != '' 03/10/2023 12:05:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002182', date_upd = NOW() WHERE id_product = '21642' 03/10/2023 12:05:38 pm >> UPDATE ps_product_lang SET name = 'PISSIDE - 099PA', description = '' WHERE id_product = '21642' 03/10/2023 12:05:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1352.4590163934427' WHERE id_product = '21642' 03/10/2023 12:05:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1352.4590163934427', id_tax_rules_group = '1', id_category_default = '480', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21642' 03/10/2023 12:05:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '21642' 03/10/2023 12:05:40 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 = '21642' 03/10/2023 12:05:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21643' , '1' , '' , 'nuovo-prodotto' ) 03/10/2023 12:05:40 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 '21643' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21642' 03/10/2023 12:05:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21643' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21642' 03/10/2023 12:06:27 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' , '100' , '2023-09-30' , '' , '0' , '149' , '4671100' , 'STRADA DEL LAVORO 211 47894 CHIESANUOVA R.S.M.' , '' , '' , '20' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '913.35' , '748.65' , NOW() , NOW() ) 03/10/2023 12:06:27 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 = '87539' 03/10/2023 12:06:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87539' 03/10/2023 12:06:27 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 ( '87539' , '21642' , 'PISSIDE - 099PA' , '1' , '1' , '1' , '767' , '628.68852459016' , '22' , '5' , '888.9530' ) 03/10/2023 12:06:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21642' AND id_supplier = '149' 03/10/2023 12:06:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21642' , '149' , '1' ) 03/10/2023 12:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 12:10:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '131' , '2023-10-03' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.28' , '150.28' , NOW() , NOW() ) 03/10/2023 12:10:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87540' 03/10/2023 12:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '87540' 03/10/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 03/10/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.50' , '3.5' , '0' , '15' , '68.42' ) 03/10/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 03/10/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87540' , '8855' , 'REGISTRO DEL CATECHISTA' , '6' , '-6' , '0' , '0.75' , '0.75' , '' , '0' , '4.50' ) 03/10/2023 12:18:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 12:18: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' , '3002' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.10' , '65.62' , NOW() , NOW() ) 03/10/2023 12:18: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 = '87541' 03/10/2023 12:18:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '87541' 03/10/2023 12:18: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 ( '87541' , '19231' , 'CARD CARLO ACUTIS - RN93' , '15' , '-15' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '15.00' ) 03/10/2023 12:18: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 ( '87541' , '17528' , 'PREGHIERE EUCARISTICHE PER LA CONCELEBRAZIONE' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '0' , '7.80' ) 03/10/2023 12:18: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 ( '87541' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 03/10/2023 12:18: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 ( '87541' , '21070' , 'A GESU CON FRANCESCO E C. ACUTIS - FERREIRA/CALVARESE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 03/10/2023 12:18: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 ( '87541' , '21618' , 'TRASMETTERE LA FEDE - SALZNO/ACUTIS' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 03/10/2023 12:18: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 ( '87541' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 03/10/2023 12:18: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 ( '87541' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 03/10/2023 12:24:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 12:24:48 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' , '3003' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.14' , '59.96' , NOW() , NOW() ) 03/10/2023 12:24: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 = '87542' 03/10/2023 12:24:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '87542' 03/10/2023 12:24: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 ( '87542' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 03/10/2023 12:24: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 ( '87542' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 03/10/2023 12:24: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 ( '87542' , '21535' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 03/10/2023 12:24: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 ( '87542' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 03/10/2023 12:24: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 ( '87542' , '18657' , 'HO DATO LORO LA TUA PAROLA - G. VALSECCHI' , '1' , '-1' , '4' , '14.4' , '14.4' , '0' , '0' , '14.40' ) 03/10/2023 12:24: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 ( '87542' , '21538' , 'AMEN - NOV. 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 03/10/2023 12:24: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 ( '87542' , '21537' , 'AMEN - DIC. 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 03/10/2023 12:38:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 12:38:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3004' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 03/10/2023 12:38:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87543' 03/10/2023 12:38:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '87543' 03/10/2023 12:38:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87543' , '21640' , 'SERVIZIO MESSA TAU ORO - 6645-4' , '1' , '-1' , '1' , '62.00' , '50.819672131148' , '22' , '0' , '62.00' ) 03/10/2023 12:38:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87543' , '9212' , 'S. FRANCESCO BABY - 023 SF/9 BB' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 03/10/2023 12:58:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2269' AND id_document != '86598' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-01') 03/10/2023 12:58:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2269', document_date = '2023-07-01', 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 = '585.00', price_tax_excluded = '479.51', date_upd = NOW() WHERE id_document = '86598' 03/10/2023 12:58:42 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 = '86598' 03/10/2023 12:58:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '86598' 03/10/2023 12:58: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 ( '86598' , '13844' , 'COLLANINA IN ACCIAIO MADONNA - 1984/M14' , '16' , '-16' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '56.00' ) 03/10/2023 12:58: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 ( '86598' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '105.3' , '86.311475409836' , '22' , '0' , '105.30' ) 03/10/2023 12:58: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 ( '86598' , '13845' , 'COLLANINA IN ACCIAIO ANGELO - 1984/A48' , '20' , '-20' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '70.00' ) 03/10/2023 12:58: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 ( '86598' , '13550' , 'COLLANINA ARGENTATA ORME DELLA SABBIA - 1984/J98' , '7' , '-7' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '24.50' ) 03/10/2023 12:58: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 ( '86598' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '50' , '-50' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '35.00' ) 03/10/2023 12:58: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 ( '86598' , '20068' , 'CORONA ROSARIO ACCIAIO - NS086' , '9' , '-9' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '58.50' ) 03/10/2023 12:58: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 ( '86598' , '18220' , 'CATENA CON CROCE - NS020' , '28' , '-28' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '70.00' ) 03/10/2023 12:58: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 ( '86598' , '21100' , 'COLLANA CON CROCE ACCIAIO - NS014' , '12' , '-12' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '30.00' ) 03/10/2023 12:58: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 ( '86598' , '18222' , 'ROSARIO COLORATO - R316' , '20' , '-20' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '12.00' ) 03/10/2023 12:58: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 ( '86598' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '8' , '-8' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '4.80' ) 03/10/2023 12:58: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 ( '86598' , '20072' , 'BRACCIALE - BC1759N' , '3' , '-3' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '6.00' ) 03/10/2023 12:58: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 ( '86598' , '21099' , 'BRACCIALE DECINA - BD008' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 03/10/2023 12:58: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 ( '86598' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '1.80' ) 03/10/2023 12:58: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 ( '86598' , '18217' , 'BRACCIALE DECINA PIETRE - BD019' , '2' , '-2' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '4.00' ) 03/10/2023 12:58: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 ( '86598' , '18896' , 'BRACCIALE DECINA CROMO - BC1759' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 03/10/2023 12:58: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 ( '86598' , '18899' , 'BRACCIALE DECINA LEGNO - BC169' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 03/10/2023 12:58: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 ( '86598' , '7202' , 'ROSARIO' , '3' , '-3' , '1' , '0.8000' , '0.65573770491803' , '22' , '0' , '2.40' ) 03/10/2023 12:58: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 ( '86598' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 03/10/2023 12:58: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 ( '86598' , '13549' , 'COLLANINA ARGENTATA ALBERO DELLA VITA - 1984/J97' , '9' , '-9' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '31.50' ) 03/10/2023 12:58: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 ( '86598' , '20438' , 'CANDELE VOTIVE 20X40 3B' , '1' , '-1' , '1' , '63.0000' , '51.639344262295' , '22' , '0' , '63.00' ) 03/10/2023 12:58: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 ( '86598' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 03/10/2023 03:02:53 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825031294' AND id_product != '7115' AND ean13 != '' 03/10/2023 03:02:53 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788825031294', date_upd = NOW() WHERE id_product = '7115' 03/10/2023 03:02:53 pm >> UPDATE ps_product_lang SET name = 'NOVENA DEGLI ANGELI - ANGELI', description = '' WHERE id_product = '7115' 03/10/2023 03:02:53 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0000' WHERE id_product = '7115' 03/10/2023 03:02:53 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7115' 03/10/2023 03:02:53 pm >> DELETE FROM ps_specific_price WHERE id_product = '7115' 03/10/2023 03:30:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '97/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 03:30:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '97/A' , '2023-10-03' , 'A' , '3975' , '0' , '4678464' , 'VIA VESCOVADO 4 84014 NOCERA INFERIORE' , '' , 'RITIRATI DA BASILE' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.00' , '58.00' , NOW() , NOW() ) 03/10/2023 03:30:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87544' 03/10/2023 03:30:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '87544' 03/10/2023 03:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87544' , '21616' , 'CARTEGGIO 1925-1926' , '2' , '-2' , '4' , '29.00' , '29' , '0' , '0' , '58.00' ) 03/10/2023 04:12:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 04:12:24 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3005' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '4.00' , NOW() , NOW() ) 03/10/2023 04:12:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87545' 03/10/2023 04:12:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '87545' 03/10/2023 04:12:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87545' , '11376' , 'VIENI SPIRITO SANTO' , '20' , '-20' , '4' , '0.20' , '0.2' , '0' , '0' , '4.00' ) 03/10/2023 04:17:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 04:17: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' , '3006' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.00' , '57.47' , NOW() , NOW() ) 03/10/2023 04:17: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 = '87546' 03/10/2023 04:17:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '87546' 03/10/2023 04:17: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 ( '87546' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 03/10/2023 04:17: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 ( '87546' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 03/10/2023 04:17: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 ( '87546' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 03/10/2023 04:17: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 ( '87546' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 03/10/2023 04:17: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 ( '87546' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '2' , '-2' , '4' , '10' , '10' , '0' , '0' , '20.00' ) 03/10/2023 04:17: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 ( '87546' , '21196' , 'CALENDARIO LITURGICO 2024' , '9' , '-9' , '4' , '0.50' , '0.5' , '0' , '0' , '4.50' ) 03/10/2023 04:19:03 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'd8D8SbCtYUQtbO2d' , NOW() , NOW() ) 03/10/2023 04:19:03 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4030' , '1' ) 03/10/2023 04:19:03 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4030' , '2' ) 03/10/2023 04:19:03 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4030' , '3' ) 03/10/2023 04:20:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4030' 03/10/2023 04:20:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4030' , '10' , '137' , '' , 'PINI' , 'FRANCESCO' , 'VIA PANORAMICA 8' , '' , '40033' , 'CASALECCHIO DI RENO' , '' , '' , '3202343258' , '' , '' , NOW() , NOW() ) 03/10/2023 04:20:22 pm >> UPDATE ps_customer SET email = 'pini.francesco@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4030' 03/10/2023 04:26:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '132' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 04:26: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 ( '21' , '132' , '2023-10-03' , '' , '4030' , '0' , '4679100' , 'VIA PANORAMICA 8 40033 CASALECCHIO DI RENO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '39.20' , '39.20' , NOW() , NOW() ) 03/10/2023 04:26: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 = '87547' 03/10/2023 04:26:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87547' 03/10/2023 04:26: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 ( '87547' , '17257' , 'IO TI BATTEZZO ' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '5' , '34.20' ) 03/10/2023 04:27:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 04:27:56 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' , '133' , '2023-10-03' , '' , '3984' , '0' , '4677546' , 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '167.87' , '167.87' , NOW() , NOW() ) 03/10/2023 04:27:56 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 = '87548' 03/10/2023 04:27:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '87548' 03/10/2023 04:27:56 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 ( '87548' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '15' , '34.00' ) 03/10/2023 04:27:56 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 ( '87548' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '15' , '23.80' ) 03/10/2023 04:27:56 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 ( '87548' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.50' , '3.5' , '0' , '15' , '20.82' ) 03/10/2023 04:27:56 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 ( '87548' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 03/10/2023 04:27:56 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 ( '87548' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '5' , '-5' , '4' , '10.00' , '10' , '0' , '15' , '42.50' ) 03/10/2023 04:27:56 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 ( '87548' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 03/10/2023 04:49:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 04:49: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' , '3007' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '196.00' , '186.09' , NOW() , NOW() ) 03/10/2023 04:49: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 = '87549' 03/10/2023 04:49:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '87549' 03/10/2023 04:49: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 ( '87549' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 03/10/2023 04:49: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 ( '87549' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 03/10/2023 04:49: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 ( '87549' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 03/10/2023 04:49: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 ( '87549' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 03/10/2023 04:49: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 ( '87549' , '1752' , 'CARTUCCIA TRASPARENTE DIAM. 8 - 457' , '1' , '-1' , '1' , '17.75' , '14.549180327869' , '22' , '0' , '17.75' ) 03/10/2023 04:49: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 ( '87549' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 03/10/2023 05:11:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '131' AND id_document != '87540' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 05:11:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '131', document_date = '2023-10-03', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '150.28', price_tax_excluded = '150.28', date_upd = NOW() WHERE id_document = '87540' 03/10/2023 05:11: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 = '87540' 03/10/2023 05:11:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '87540' 03/10/2023 05:11: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 ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 03/10/2023 05:11: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 ( '87540' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '23' , '-23' , '4' , '3.5000' , '3.5' , '0' , '15' , '68.42' ) 03/10/2023 05:11: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 ( '87540' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 03/10/2023 05:11: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 ( '87540' , '8855' , 'REGISTRO DEL CATECHISTA' , '6' , '-6' , '0' , '0.7500' , '0.75' , '0' , '0' , '4.50' ) 03/10/2023 05:12:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '87498' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-02') 03/10/2023 05:12:36 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '126', document_date = '2023-10-02', document_letter = '', id_customer = '2517', id_supplier = '', id_address = '4670931', address1 = 'VIA SALETTE, 46 80057 SANT\\\' ANTONIO ABATE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '378.68', price_tax_excluded = '378.68', date_upd = NOW() WHERE id_document = '87498' 03/10/2023 05:12:36 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 = '87498' 03/10/2023 05:12:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '87498' 03/10/2023 05:12:36 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 ( '87498' , '13956' , 'MIRACOLI DI GESU\'' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 05:12:36 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 ( '87498' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 03/10/2023 05:12:36 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 ( '87498' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 03/10/2023 05:12:36 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 ( '87498' , '7543' , 'PARABOLE DI GESÙ' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 05:12:36 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 ( '87498' , '8408' , 'PRENDETE E MANGIATE' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '15' , '51.00' ) 03/10/2023 05:12:36 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 ( '87498' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 03/10/2023 05:12:36 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 ( '87498' , '5446' , 'IO SONO CON VOI - GUIDA' , '7' , '-7' , '4' , '8.0000' , '8' , '0' , '15' , '47.60' ) 03/10/2023 05:12:36 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 ( '87498' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 03/10/2023 05:12:36 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 ( '87498' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 03/10/2023 05:12:36 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 ( '87498' , '18597' , 'ROSARIO SPIEGATO AI BAMBINI' , '3' , '-3' , '4' , '2.5000' , '2.5' , '0' , '15' , '6.38' ) 03/10/2023 05:12:36 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 ( '87498' , '14929' , 'AVE MARIA, SPIEGATA AI BAMBINI' , '4' , '-4' , '4' , '1.5000' , '1.5' , '0' , '15' , '5.10' ) 03/10/2023 05:12:36 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 ( '87498' , '16065' , 'DIZIONARIO DEI SIMBOLI DEL CRISTIANO' , '4' , '-4' , '4' , '2.5000' , '2.5' , '0' , '15' , '8.50' ) 03/10/2023 05:14:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '23V604605' , '2023-10-03' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.36' , '1' , '0' , '0' , '0' , '' , '11' , '0' , '1577.47' , '1577.17' , NOW() , NOW() ) 03/10/2023 05:14:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87550' 03/10/2023 05:14:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87550' 03/10/2023 05:14: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 ( '87550' , '21517' , 'APRIRSI TEMPO DELLA PRIMA EVANGELIZZAZIONE - SCHEDE' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '35' , '9.75' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21517' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21517' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21515' , 'CINQUE PANI DORZO 2024' , '48' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '231.84' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21515' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21515' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21515' , 'CINQUE PANI DORZO 2024' , '4' , '0' , '4' , '6.9000' , '6.9' , '0' , '100' , '0.00' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21515' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21515' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21516' , 'LAVORARE INSIEME. LAVORARE MEGLIO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '35' , '10.40' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21516' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21516' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21520' , 'TRATTENIMENTI SPIRITUALI - F. DI SALES' , '1' , '0' , '4' , '23.2400' , '23.24' , '0' , '33' , '15.57' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21520' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21520' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21522' , 'MASSIME ETERNE' , '12' , '0' , '4' , '5.5000' , '5.5' , '0' , '30' , '46.20' ) 03/10/2023 05:14:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21522' AND id_supplier = '7' 03/10/2023 05:14:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21522' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21522' , 'MASSIME ETERNE' , '1' , '0' , '4' , '5.5000' , '5.5' , '0' , '100' , '0.00' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21522' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21522' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21495' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21495' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '7410' , 'PADRI DELLA CHIESA - P.F. BEATRICE' , '2' , '0' , '4' , '14.0000' , '14' , '0' , '30' , '19.60' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7410' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7410' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21205' , 'MI AMI TU? - CD' , '1' , '0' , '4' , '16.8000' , '16.8' , '0' , '30' , '11.76' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21205' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21205' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21521' , 'PREGHIERA DELLO STUDENTE - 50 PZ' , '6' , '0' , '1' , '8.1900' , '6.7131' , '22' , '35' , '38.97' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21521' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21521' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21541' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21541' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21530' , 'PRIMA COMUNIONE' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21530' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21530' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21527' , 'MESSALINO FRANCESCANO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '30' , '24.50' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21527' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21527' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '3' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '5.83' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21539' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21539' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21537' , 'AMEN - DIC. 23' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21537' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21537' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21537' , 'AMEN - DIC. 23' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21537' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21537' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21538' , 'AMEN - NOV. 23' , '24' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '62.71' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21538' AND id_supplier = '7' 03/10/2023 05:14:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21538' , '7' , '1' ) 03/10/2023 05:14:27 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 ( '87550' , '21538' , 'AMEN - NOV. 23' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '100' , '0.00' ) 03/10/2023 05:14:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21538' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21538' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21540' , 'INSIEME NELLA MESSA - NOV. 23' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21540' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21540' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21543' , 'PREGARE PER CAMMINARE INSIEME - MANICARDI / GRILLO' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21543' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21543' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21533' , 'CRESCERE CHE CONQUISTA!' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21533' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21533' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21544' , 'VANGELO DISATTESO - SCALIA / DI STEFANO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21544' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21544' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21529' , 'PREGHIERE PER IL CATECHISMO' , '3' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '7.35' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21529' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21529' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21542' , '100 OMELIE N.E. - A. COMASTRI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21542' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21542' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21526' , 'MESSALE FESTIVO 2024' , '3' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '21.00' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21526' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21526' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21536' , 'AIUTO! NEL MONDO STA SCOMPARENDO LAMORE - A. COMASTRI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21536' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21536' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21534' , 'QUELLO CHE SO DI LEI - G. FORLAI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21534' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21534' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21535' , 'MARIA CON I PIEDI PER TERRA - P. CURTAZ' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21535' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21535' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21531' , 'CONFESSIONE ' , '3' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '10.29' ) 03/10/2023 05:14:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21531' AND id_supplier = '7' 03/10/2023 05:14:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21531' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21532' , 'PENSIERI EUCARISTICI 2024' , '2' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '9.66' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21532' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21532' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21528' , 'CHIESA HA BISOGNO DI SACERDOTI? - M. EBNER' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21528' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21528' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21545' , 'SPQR ' , '1' , '0' , '1' , '11.0600' , '9.0656' , '22' , '30' , '9.45' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21545' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21545' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21547' , 'SPQR - SPARTITO' , '1' , '0' , '3' , '11.0500' , '10.625' , '4' , '30' , '8.04' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21547' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21547' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21566' , 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ' , '1' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '4.83' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21566' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21566' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21580' , 'PRIMO LIBRO DEI SANTI ' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '30' , '6.93' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21580' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21580' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21581' , 'PRIMO LIBRO DELLE SANTE' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '30' , '6.93' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21581' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21581' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21577' , 'AVVENTO 2023' , '5' , '0' , '4' , '3.5000' , '3.5' , '0' , '30' , '12.25' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21577' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21577' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21578' , 'CERCATE E TROVERETE ' , '5' , '0' , '4' , '3.8000' , '3.8' , '0' , '30' , '13.30' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21578' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21578' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21576' , 'LUNGO LA STRADA CON LUI - ANNO B - P.R. SCALABRINI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21576' AND id_supplier = '7' 03/10/2023 05:14:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21576' , '7' , '1' ) 03/10/2023 05:14:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21571' , 'BETLEHEM' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 03/10/2023 05:14:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21571' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21571' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21566' , 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ' , '1' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '4.83' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21566' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21566' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21573' , 'CON LA FORZA DELLO SPIRITO' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '33' , '4.69' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21573' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21573' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21569' , 'DOMENICHE DA COLORARE - ANNO B ' , '1' , '0' , '4' , '9.9000' , '9.9' , '0' , '30' , '6.93' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21569' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21569' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21568' , 'CARO GESU AL CATECHISMO ...' , '2' , '0' , '4' , '4.9000' , '4.9' , '0' , '30' , '6.86' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21568' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21568' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21572' , 'DIO DOVE SEI FINITO? - M. PRASTARO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21572' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21572' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21574' , 'PAROLA, IL PANE, LA VITA - ANNO B - L. MAZZINGHI' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '33' , '18.76' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21574' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21574' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21575' , 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21575' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21575' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21570' , 'OPERE COMPLETE - TERESA DAVILA' , '1' , '0' , '4' , '50.0000' , '50' , '0' , '33' , '33.50' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21570' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21570' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21579' , 'SALVE REGINA - A. AMAPANI' , '1' , '0' , '4' , '4.9000' , '4.9' , '0' , '33' , '3.28' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21579' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21579' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21567' , 'VIA DI FRATE FRANCESCO - P. MARANESI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21567' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21567' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21564' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2024' , '12' , '0' , '4' , '6.0000' , '6' , '0' , '30' , '50.40' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21564' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21564' , '7' , '1' ) 03/10/2023 05:14:30 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 ( '87550' , '21564' , 'MESSALINO QUOTIDIANO - NOV DIC GEN 2024' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '100' , '0.00' ) 03/10/2023 05:14:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21564' AND id_supplier = '7' 03/10/2023 05:14:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21564' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21563' , 'AGENDA SAN PAOLO 2024' , '20' , '0' , '1' , '4.8300' , '3.959' , '22' , '0' , '117.85' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21563' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21563' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21589' , 'CREAZIONE RACCONTATA AI BAMBINI - FERRERO/PAIRETTO' , '1' , '0' , '4' , '5.9000' , '5.9' , '0' , '35' , '3.84' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21589' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21589' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21590' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21590' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21591' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 1' , '1' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '4.83' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21591' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21591' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21592' , 'GESU VIENE AD ABITARE CON NOI - SCHEDE 2' , '1' , '0' , '4' , '6.9000' , '6.9' , '0' , '30' , '4.83' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21592' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21592' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21594' , 'CARTONCINO 16X23' , '200' , '0' , '1' , '0.0600' , '0.0492' , '22' , '0' , '14.64' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21594' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21594' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21595' , 'SEGNALIBRO SAN PAOLO' , '500' , '0' , '1' , '0.0600' , '0.0492' , '22' , '0' , '36.60' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21595' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21595' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21596' , 'CARTOLINE PREGHIERE' , '500' , '0' , '1' , '0.0600' , '0.0492' , '22' , '0' , '36.60' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21596' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21596' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '66' , '0' , '1' , '0.2500' , '0.2049' , '22' , '0' , '20.13' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21597' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21597' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21598' , 'SEGNALIBRO PICCOLO SAN PAOLO - PZ 50' , '12' , '0' , '1' , '1.5000' , '1.2295' , '22' , '0' , '21.96' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21598' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21598' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21626' , 'MISSIONE NATALE' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '35' , '8.13' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21626' AND id_supplier = '7' 03/10/2023 05:14:31 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21626' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21627' , 'AVVENTO E NATALE 2023' , '12' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '23.32' ) 03/10/2023 05:14:31 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21627' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21627' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21627' , 'AVVENTO E NATALE 2023' , '1' , '0' , '4' , '2.9000' , '2.9' , '0' , '100' , '0.00' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21627' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21627' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21635' , 'FESTA DEL MIO BATTESIMO' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21635' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21635' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21636' , 'FESTA DELLA MIA CRESIMA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21636' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21636' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '3' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '5.83' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21630' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21630' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21631' , 'INSIEME NELLA MESSA DIC 23' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21631' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21631' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21634' , 'ORDO VIRGINUM, PROFEZIA E SINODALITA - D. VITALI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '33' , '8.04' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21634' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21634' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21628' , 'DOVE VA LA CHIESA? - E. BIANCHI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21628' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21628' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '0' , '4' , '25.0000' , '25' , '0' , '33' , '16.75' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21629' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21629' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21633' , 'BATTESIMO DEI BAMBINI - M. GATTAFONI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '30' , '7.00' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21633' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21633' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21632' , 'GIUSTIZIA BIBLICA E GRAZIA - C. DI SANTE' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '30' , '14.00' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21632' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21632' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21594' , 'CARTONCINO 16X23' , '30' , '0' , '1' , '0.1000' , '0.082' , '22' , '0' , '3.66' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21594' AND id_supplier = '7' 03/10/2023 05:14:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21594' , '7' , '1' ) 03/10/2023 05:14:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '96' , '0' , '1' , '0.2500' , '0.2049' , '22' , '0' , '29.28' ) 03/10/2023 05:14:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21597' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21597' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21590' , 'MERAVIGLIARSI - PRIMO ANNO - SCHEDE' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '35' , '7.80' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21590' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21590' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '16185' , 'DON BOSCO UN SACERDOTE' , '12' , '0' , '4' , '5.0000' , '5' , '0' , '30' , '42.00' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16185' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16185' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '16185' , 'DON BOSCO UN SACERDOTE' , '1' , '0' , '4' , '5.0000' , '5' , '0' , '100' , '0.00' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16185' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16185' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21609' , 'CARLO ACUTIS - OMELIA - A. COMASTRI' , '5' , '0' , '4' , '1.5000' , '1.5' , '0' , '30' , '5.25' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21609' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21609' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '4151' , 'FERIE DEL T. O. - LECTIO BREVIS DISPARI 2' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4151' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4151' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21199' , 'AMEN - OTT 23' , '2' , '0' , '4' , '3.9000' , '3.9' , '0' , '33' , '5.23' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21199' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21199' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '17024' , 'PICCOLO PRINCICE - A. DE S. EXUPERY' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '33' , '8.71' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17024' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17024' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21205' , 'MI AMI TU? - CD' , '1' , '0' , '4' , '16.8000' , '16.8' , '0' , '30' , '11.76' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21205' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21205' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21392' , 'BIBBIA - EDIZIONE SOFT' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21392' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21392' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '8' , '0' , '4' , '9.9000' , '9.9' , '0' , '33' , '53.06' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21610' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21610' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '21610' , 'PAROLA VICINA 2023/2024 ANNO B' , '2' , '0' , '4' , '9.9000' , '9.9' , '0' , '100' , '0.00' ) 03/10/2023 05:14:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21610' AND id_supplier = '7' 03/10/2023 05:14:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21610' , '7' , '1' ) 03/10/2023 05:14: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 ( '87550' , '0' , 'SPESE ACCESSORIE' , '1' , '0' , '4' , '33.2200' , '33.22' , '0' , '0' , '33.22' ) 03/10/2023 05:14:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '7' 03/10/2023 05:14:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '7' , '1' ) 03/10/2023 05:14:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '0' , 'SPESE ACCESSORIE' , '1' , '0' , '1' , '7.4800' , '6.1311' , '22' , '0' , '7.48' ) 03/10/2023 05:14:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '7' 03/10/2023 05:14:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '7' , '1' ) 03/10/2023 05:14:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87550' , '0' , 'SPESE ACCESSORIE' , '1' , '0' , '3' , '0.2100' , '0.2019' , '4' , '0' , '0.21' ) 03/10/2023 05:14:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '7' 03/10/2023 05:14:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '7' , '1' ) 03/10/2023 05:39:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 05:39:03 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' , '3008' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 03/10/2023 05:39:03 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 = '87551' 03/10/2023 05:39:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '87551' 03/10/2023 05:39:03 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 ( '87551' , '20176' , 'ANGELI MUSICANTI CM 9 - AR76' , '36' , '-36' , '1' , '3' , '2.4590163934426' , '22' , '0' , '108.00' ) 03/10/2023 05:39:03 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 ( '87551' , '20172' , 'ANGELO MUSICANTE CM 10 - R12' , '9' , '-9' , '1' , '4' , '3.2786885245902' , '22' , '0' , '36.00' ) 03/10/2023 05:39:03 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 ( '87551' , '20173' , 'ANGELO IN PREGHIERA - R17' , '7' , '-7' , '1' , '4' , '3.2786885245902' , '22' , '0' , '28.00' ) 03/10/2023 05:39:03 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 ( '87551' , '18275' , 'ANGELI DA PARETE CM 12 - 4120' , '3' , '-3' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '13.50' ) 03/10/2023 05:39:03 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 ( '87551' , '20173' , 'ANGELO IN PREGHIERA - R17' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 03/10/2023 05:39:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 05:39: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 ( '11' , '3009' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '300.00' , '245.90' , NOW() , NOW() ) 03/10/2023 05:39: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 = '87552' 03/10/2023 05:39:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '87552' 03/10/2023 05:39: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 ( '87552' , '13158' , 'CASULA MOD. LINEA' , '1' , '-1' , '1' , '300' , '245.90163934426' , '22' , '0' , '300.00' ) 03/10/2023 06:08:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '98/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 06:08:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '98/A' , '2023-10-03' , 'A' , '232' , '0' , '4671450' , 'VIA V. LASPRO, 8/A 84126 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '68.94' , '68.94' , NOW() , NOW() ) 03/10/2023 06:08: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 = '87553' 03/10/2023 06:08:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '87553' 03/10/2023 06:08: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 ( '87553' , '12819' , 'REGISTRO DEL CATECHISTA ' , '4' , '-4' , '4' , '1.00' , '1' , '0' , '15' , '3.40' ) 03/10/2023 06:08: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 ( '87553' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '15' , '14.88' ) 03/10/2023 06:08: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 ( '87553' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 03/10/2023 06:08: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 ( '87553' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 03/10/2023 06:08: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 ( '87553' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '4' , '-4' , '4' , '3.40' , '3.4' , '0' , '15' , '11.56' ) 03/10/2023 06:08: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 ( '87553' , '2679' , 'CONOSCERE GESU' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '15' , '5.95' ) 03/10/2023 06:08: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 ( '87553' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 03/10/2023 06:08: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 ( '87553' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 03/10/2023 06:10:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '87515' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-02') 03/10/2023 06:10:09 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '127', document_date = '2023-10-02', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2602', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '11', id_causal = '0', price_tax_included = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '87515' 03/10/2023 06:10:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87515' 03/10/2023 06:10:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '87515' 03/10/2023 06:12:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 06:12: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' , '3010' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.30' , '51.30' , NOW() , NOW() ) 03/10/2023 06:12: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 = '87554' 03/10/2023 06:12:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '87554' 03/10/2023 06:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87554' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 03/10/2023 06:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87554' , '20880' , 'UN TEMPO PER DIO - J. PHILIPPE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 03/10/2023 06:12:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87554' , '21552' , 'GESU DI TUTTI - V. ANDREOLI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 03/10/2023 06:36:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '3011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 06:36: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' , '3011' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '200.00' , '174.21' , NOW() , NOW() ) 03/10/2023 06:36: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 = '87555' 03/10/2023 06:36:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87555' 03/10/2023 06:36: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 ( '87555' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '143.00' , '117.2131147541' , '22' , '0' , '143.00' ) 03/10/2023 06:36: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 ( '87555' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '45.12' , '45.12' , '0' , '0' , '45.12' ) 03/10/2023 06:36: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 ( '87555' , '14069' , 'SAN FRANCESCO DI PAOLA - G. SCARPITTA' , '1' , '-1' , '4' , '12.50' , '12.5' , '0' , '5' , '11.88' ) 03/10/2023 06:44:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '87515' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-02') 03/10/2023 06:44:48 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '127', document_date = '2023-10-02', document_letter = '', id_customer = '3984', id_supplier = '0', id_address = '4677546', address1 = 'P. ZZA SAN PAOLO, 14 12051 ALBA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '167.87', price_tax_excluded = '167.87', date_upd = NOW() WHERE id_document = '87515' 03/10/2023 06:44: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 = '87515' 03/10/2023 06:44:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '87515' 03/10/2023 06:44: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 ( '87515' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '4' , '-4' , '4' , '10.0000' , '10' , '0' , '15' , '34.00' ) 03/10/2023 06:44: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 ( '87515' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 03/10/2023 06:44: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 ( '87515' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 03/10/2023 06:44: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 ( '87515' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 03/10/2023 06:44: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 ( '87515' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '15' , '42.50' ) 03/10/2023 06:44: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 ( '87515' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '15' , '29.75' ) 03/10/2023 06:44:54 pm >> DELETE FROM ps_document WHERE id_document = '87548' 03/10/2023 06:44:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '87548' 03/10/2023 06:59:51 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '949' 03/10/2023 06:59:51 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '949' , '10' , '219' , 'PARROCCHIA GESU\' NAZARENO' , '' , 'PADRI DOTTRINARI' , 'VIA P. PALMIERI 39' , '' , '10138' , 'TORINO' , '' , '011/4474262' , '' , '' , '97522300017' , NOW() , NOW() ) 03/10/2023 06:59:51 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '949' 03/10/2023 07:01:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '133' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 07:01:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '133' , '2023-10-03' , '' , '949' , '0' , '4679101' , 'VIA P. PALMIERI 39 10138 TORINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '370.60' , '370.60' , NOW() , NOW() ) 03/10/2023 07:01:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87556' 03/10/2023 07:01:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '87556' 03/10/2023 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87556' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '100' , '-100' , '4' , '2.80' , '2.8' , '0' , '15' , '238.00' ) 03/10/2023 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87556' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '15' , '85.00' ) 03/10/2023 07:01:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87556' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 03/10/2023 07:03:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788855450881' AND id_product != '21618' AND ean13 != '' 03/10/2023 07:03:13 pm >> UPDATE ps_product SET id_supplier = '109', reference = 'GONDOLA 1', ean13 = '9788855450881', date_upd = NOW() WHERE id_product = '21618' 03/10/2023 07:03:13 pm >> UPDATE ps_product_lang SET name = 'TRASMETTERE LA FEDE - SALZANO/ACUTIS', description = '' WHERE id_product = '21618' 03/10/2023 07:03:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.0000' WHERE id_product = '21618' 03/10/2023 07:03:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.0000', id_tax_rules_group = '4', id_category_default = '77', 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 = '21618' 03/10/2023 07:03:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '21618' 03/10/2023 07:49:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 03/10/2023 07:49:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3012' , '2023-10-03' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '16.90' , NOW() , NOW() ) 03/10/2023 07:49: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 = '87557' 03/10/2023 07:49:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '87557' 03/10/2023 07:49: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 ( '87557' , '20192' , 'VI CHIEDO IN NOME DI DIO' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' )