27/01/2023 09:55:53 am >> SELECT document_num FROM ps_document WHERE document_num = '283' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 09:55:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '283' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 27/01/2023 09:55:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80552' 27/01/2023 09:55:53 am >> DELETE FROM ps_document_detail WHERE id_document = '80552' 27/01/2023 09:55:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80552' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 27/01/2023 09:58:27 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821598531' AND id_product != '1114' AND ean13 != '' 27/01/2023 09:58:27 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/3', ean13 = '9788821598531', date_upd = NOW() WHERE id_product = '1114' 27/01/2023 09:58:27 am >> UPDATE ps_product_lang SET name = 'BIBBIA DEGLI SPOSI', description = '' WHERE id_product = '1114' 27/01/2023 09:58:27 am >> UPDATE ps_product SET wholesale_price = '12.40', on_sale = '0', price = '18.5000' WHERE id_product = '1114' 27/01/2023 09:58:27 am >> UPDATE ps_product_shop SET wholesale_price = '12.40', price = '18.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1114' 27/01/2023 09:58:27 am >> DELETE FROM ps_specific_price WHERE id_product = '1114' 27/01/2023 09:59:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594113' AND id_product != '1128' AND ean13 != '' 27/01/2023 09:59:15 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/3', ean13 = '9788821594113', date_upd = NOW() WHERE id_product = '1128' 27/01/2023 09:59:15 am >> UPDATE ps_product_lang SET name = 'BIBBIA DELLA CRESIMA - RIL', description = '' WHERE id_product = '1128' 27/01/2023 09:59:15 am >> UPDATE ps_product SET wholesale_price = '8.64', on_sale = '0', price = '12.9000' WHERE id_product = '1128' 27/01/2023 09:59:15 am >> UPDATE ps_product_shop SET wholesale_price = '8.64', price = '12.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1128' 27/01/2023 09:59:15 am >> DELETE FROM ps_specific_price WHERE id_product = '1128' 27/01/2023 09:59:31 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851421182' AND id_product != '15437' AND ean13 != '' 27/01/2023 09:59:31 am >> UPDATE ps_product SET id_supplier = '114', reference = '11/3', ean13 = '9788851421182', date_upd = NOW() WHERE id_product = '15437' 27/01/2023 09:59:31 am >> UPDATE ps_product_lang SET name = 'BIBBIA DELLA PRIMA COMUNIONE', description = '' WHERE id_product = '15437' 27/01/2023 09:59:31 am >> UPDATE ps_product SET wholesale_price = '16.48', on_sale = '0', price = '24.9000' WHERE id_product = '15437' 27/01/2023 09:59:31 am >> UPDATE ps_product_shop SET wholesale_price = '16.48', price = '24.9000', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15437' 27/01/2023 09:59:31 am >> DELETE FROM ps_specific_price WHERE id_product = '15437' 27/01/2023 09:59:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594090' AND id_product != '1132' AND ean13 != '' 27/01/2023 09:59:46 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/3', ean13 = '9788821594090', date_upd = NOW() WHERE id_product = '1132' 27/01/2023 09:59:46 am >> UPDATE ps_product_lang SET name = 'BIBBIA DELLA PRIMA COMUNIONE - RIL', description = '' WHERE id_product = '1132' 27/01/2023 09:59:46 am >> UPDATE ps_product SET wholesale_price = '8.64', on_sale = '0', price = '12.9000' WHERE id_product = '1132' 27/01/2023 09:59:46 am >> UPDATE ps_product_shop SET wholesale_price = '8.64', price = '12.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1132' 27/01/2023 09:59:46 am >> DELETE FROM ps_specific_price WHERE id_product = '1132' 27/01/2023 09:59:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594106' AND id_product != '1133' AND ean13 != '' 27/01/2023 09:59:57 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788821594106', date_upd = NOW() WHERE id_product = '1133' 27/01/2023 09:59:57 am >> UPDATE ps_product_lang SET name = 'BIBBIA DELLA PRIMA COMUNIONE - RIL+SC', description = '' WHERE id_product = '1133' 27/01/2023 09:59:57 am >> UPDATE ps_product SET wholesale_price = '12.39', on_sale = '0', price = '18.5000' WHERE id_product = '1133' 27/01/2023 09:59:57 am >> UPDATE ps_product_shop SET wholesale_price = '12.39', price = '18.5000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1133' 27/01/2023 09:59:57 am >> DELETE FROM ps_specific_price WHERE id_product = '1133' 27/01/2023 10:02:49 am >> SELECT document_num FROM ps_document WHERE document_num = '284' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 10:02:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '284' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 27/01/2023 10:02:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80553' 27/01/2023 10:02:49 am >> DELETE FROM ps_document_detail WHERE id_document = '80553' 27/01/2023 10:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80553' , '9452' , 'SAN GIOVANNI BOSCO - 50' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 27/01/2023 10:15:05 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '12998' 27/01/2023 10:15:05 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '12998' 27/01/2023 10:15:46 am >> SELECT document_num FROM ps_document WHERE document_num = '21' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 10:15: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 ( '21' , '21' , '2023-01-27' , '' , '1175' , '0' , '4672789' , 'VIA BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '29.75' , '29.75' , NOW() , NOW() ) 27/01/2023 10:15: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 = '80554' 27/01/2023 10:15:46 am >> DELETE FROM ps_document_detail WHERE id_document = '80554' 27/01/2023 10:15: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 ( '80554' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 27/01/2023 10:16:51 am >> SELECT document_num FROM ps_document WHERE document_num = '285' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 10:16: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' , '285' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '6.73' , NOW() , NOW() ) 27/01/2023 10:16: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 = '80555' 27/01/2023 10:16:51 am >> DELETE FROM ps_document_detail WHERE id_document = '80555' 27/01/2023 10:16: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 ( '80555' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/01/2023 10:39:49 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11007' 27/01/2023 10:39:49 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '11007' 27/01/2023 10:43:27 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1098' 27/01/2023 10:43:27 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '1098' 27/01/2023 10:44:37 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '1208' 27/01/2023 10:44:37 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '1208' 27/01/2023 10:45:28 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16892' 27/01/2023 10:45:28 am >> UPDATE ps_stock_available SET quantity = quantity + '-3' WHERE id_product = '16892' 27/01/2023 10:45:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226708' AND id_product != '19685' AND ean13 != '' 27/01/2023 10:45:54 am >> UPDATE ps_product SET id_supplier = '7', reference = '7/4', ean13 = '9788892226708', date_upd = NOW() WHERE id_product = '19685' 27/01/2023 10:45:54 am >> UPDATE ps_product_lang SET name = 'AMEN - OTT 2022', description = '' WHERE id_product = '19685' 27/01/2023 10:45:54 am >> UPDATE ps_product SET wholesale_price = '2.61', on_sale = '0', price = '3.9000' WHERE id_product = '19685' 27/01/2023 10:45:54 am >> UPDATE ps_product_shop SET wholesale_price = '2.61', price = '3.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19685' 27/01/2023 10:45:54 am >> DELETE FROM ps_specific_price WHERE id_product = '19685' 27/01/2023 10:47:45 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7176' 27/01/2023 10:47:45 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '7176' 27/01/2023 10:48:25 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7183' 27/01/2023 10:48:25 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '7183' 27/01/2023 10:49:07 am >> DELETE FROM ps_product WHERE id_product = '7185' 27/01/2023 10:49:07 am >> DELETE FROM ps_product_shop WHERE id_product = '7185' 27/01/2023 10:49:07 am >> DELETE FROM ps_product_lang WHERE id_product = '7185' 27/01/2023 10:49:07 am >> DELETE FROM ps_stock_available WHERE id_product = '7185' 27/01/2023 10:56:33 am >> SELECT document_num FROM ps_document WHERE document_num = '286' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 10:56:33 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' , '286' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 27/01/2023 10:56:33 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 = '80556' 27/01/2023 10:56:33 am >> DELETE FROM ps_document_detail WHERE id_document = '80556' 27/01/2023 10:56:33 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 ( '80556' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 27/01/2023 11:08:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791280192257' AND id_product != '5759' AND ean13 != '' 27/01/2023 11:08:29 am >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9791280192257', date_upd = NOW() WHERE id_product = '5759' 27/01/2023 11:08:29 am >> UPDATE ps_product_lang SET name = 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A', description = '' WHERE id_product = '5759' 27/01/2023 11:08:29 am >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '60.0000' WHERE id_product = '5759' 27/01/2023 11:08:29 am >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '60.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5759' 27/01/2023 11:08:29 am >> DELETE FROM ps_specific_price WHERE id_product = '5759' 27/01/2023 11:08:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820979874' AND id_product != '5760' AND ean13 != '' 27/01/2023 11:08:35 am >> UPDATE ps_product SET id_supplier = '79', reference = '0', ean13 = '9788820979874', date_upd = NOW() WHERE id_product = '5760' 27/01/2023 11:08:35 am >> UPDATE ps_product_lang SET name = 'LEZIONARIO DOMENICALE E FESTIVO - ANNO B', description = '' WHERE id_product = '5760' 27/01/2023 11:08:35 am >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '60.0000' WHERE id_product = '5760' 27/01/2023 11:08:35 am >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '60.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5760' 27/01/2023 11:08:35 am >> DELETE FROM ps_specific_price WHERE id_product = '5760' 27/01/2023 11:08:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820979881' AND id_product != '5761' AND ean13 != '' 27/01/2023 11:08:45 am >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788820979881', date_upd = NOW() WHERE id_product = '5761' 27/01/2023 11:08:45 am >> UPDATE ps_product_lang SET name = 'LEZIONARIO DOMENICALE E FESTIVO - ANNO C', description = '' WHERE id_product = '5761' 27/01/2023 11:08:46 am >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '60.0000' WHERE id_product = '5761' 27/01/2023 11:08:46 am >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '60.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5761' 27/01/2023 11:08:46 am >> DELETE FROM ps_specific_price WHERE id_product = '5761' 27/01/2023 11:08:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788820979874' AND id_product != '5760' AND ean13 != '' 27/01/2023 11:08:56 am >> UPDATE ps_product SET id_supplier = '79', reference = '', ean13 = '9788820979874', date_upd = NOW() WHERE id_product = '5760' 27/01/2023 11:08:56 am >> UPDATE ps_product_lang SET name = 'LEZIONARIO DOMENICALE E FESTIVO - ANNO B', description = '' WHERE id_product = '5760' 27/01/2023 11:08:56 am >> UPDATE ps_product SET wholesale_price = '42.00', on_sale = '0', price = '60.0000' WHERE id_product = '5760' 27/01/2023 11:08:56 am >> UPDATE ps_product_shop SET wholesale_price = '42.00', price = '60.0000', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5760' 27/01/2023 11:08:56 am >> DELETE FROM ps_specific_price WHERE id_product = '5760' 27/01/2023 11:15:16 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '10110' 27/01/2023 11:15:16 am >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '10110' 27/01/2023 11:19:24 am >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 11:19:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '287' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.94' , '71.53' , NOW() , NOW() ) 27/01/2023 11:19: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 = '80557' 27/01/2023 11:19:24 am >> DELETE FROM ps_document_detail WHERE id_document = '80557' 27/01/2023 11:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80557' , '17583' , 'FRATELLI TUTTI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 27/01/2023 11:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80557' , '4401' , 'GESÙ CONFIDO IN TE' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 27/01/2023 11:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80557' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '1' , '-1' , '4' , '39.50' , '39.5' , '0' , '5' , '37.53' ) 27/01/2023 11:19:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80557' , '783' , 'ASPERGES TASCABILE - 816' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 27/01/2023 11:29:01 am >> SELECT document_num FROM ps_document WHERE document_num = '288' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 11:29:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '288' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.75' , '18.85' , NOW() , NOW() ) 27/01/2023 11:29: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 = '80558' 27/01/2023 11:29:01 am >> DELETE FROM ps_document_detail WHERE id_document = '80558' 27/01/2023 11:29: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 ( '80558' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 27/01/2023 11:29: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 ( '80558' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 27/01/2023 11:29: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 ( '80558' , '11191' , 'VENITE CON ME 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/01/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 ( '80558' , '11192' , 'VENITE CON ME 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/01/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 ( '80558' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/01/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 ( '80558' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/01/2023 12:21:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '289' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 12:21:55 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' , '289' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 27/01/2023 12:21:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80559' 27/01/2023 12:21:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '80559' 27/01/2023 12:21:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80559' , '20585' , 'MESSALINO QUOTIDIANO - FEB/MAR/APR 2023' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 27/01/2023 03:20:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '90' AND id_document != '78230' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 27/01/2023 03:20:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '90', document_date = '2023-01-10', 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 = '157.00', price_tax_excluded = '128.69', date_upd = NOW() WHERE id_document = '78230' 27/01/2023 03:20: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 = '78230' 27/01/2023 03:20:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '78230' 27/01/2023 03:20: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 ( '78230' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '-1' , '1' , '94' , '77.049180327869' , '22' , '0' , '94.00' ) 27/01/2023 03:20: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 ( '78230' , '1914' , 'CERA DELLA LITURGIA' , '14' , '-14' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '63.00' ) 27/01/2023 03:21:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '80490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 27/01/2023 03:21:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '242', document_date = '2023-01-24', 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 = '570.00', price_tax_excluded = '478.81', date_upd = NOW() WHERE id_document = '80490' 27/01/2023 03:21:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80490' 27/01/2023 03:21:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '80490' 27/01/2023 03:21: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 ( '80490' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 27/01/2023 03:21: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 ( '80490' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 27/01/2023 03:21: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 ( '80490' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 27/01/2023 03:21: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 ( '80490' , '1914' , 'CERA DELLA LITURGIA' , '46' , '-46' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '207.00' ) 27/01/2023 03:21: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 ( '80490' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '0.9800' , '0.98' , '0' , '0' , '0.98' ) 27/01/2023 03:21: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 ( '80490' , '14001' , 'PAROLE GESTI SILENZI DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 27/01/2023 03:21: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 ( '80490' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 27/01/2023 03:21: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 ( '80490' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 27/01/2023 03:21: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 ( '80490' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 27/01/2023 03:21: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 ( '80490' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '9.9300' , '8.1393442622951' , '22' , '0' , '9.93' ) 27/01/2023 03:21: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 ( '80490' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '275.3' , '225.65573770492' , '22' , '0' , '275.30' ) 27/01/2023 03:23:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 03:23:07 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' , '290' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.00' , '614.75' , NOW() , NOW() ) 27/01/2023 03:23:07 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 = '80560' 27/01/2023 03:23:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '80560' 27/01/2023 03:23:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80560' , '19904' , 'TALARE' , '1' , '-1' , '1' , '750' , '614.75409836066' , '22' , '0' , '750.00' ) 27/01/2023 03:25:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '290' AND id_document != '80560' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 03:25:50 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '290', document_date = '2023-01-27', 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 = '750.00', price_tax_excluded = '614.75', date_upd = NOW() WHERE id_document = '80560' 27/01/2023 03:25: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 = '80560' 27/01/2023 03:25:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '80560' 27/01/2023 03:25: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 ( '80560' , '19904' , 'TALARE' , '1' , '-1' , '1' , '670' , '549.18032786885' , '22' , '0' , '670.00' ) 27/01/2023 03:25:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80560' , '19906' , 'FASCIA' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 27/01/2023 05:40:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '291' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 05:40:00 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' , '291' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '67.31' , NOW() , NOW() ) 27/01/2023 05:40:00 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 = '80561' 27/01/2023 05:40:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '80561' 27/01/2023 05:40:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80561' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '20' , '-20' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '70.00' ) 27/01/2023 05:55:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '292' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 05:55:28 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' , '292' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 27/01/2023 05:55:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80562' 27/01/2023 05:55:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '80562' 27/01/2023 05:55: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 ( '80562' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 27/01/2023 06:11:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '293' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 06:11: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' , '293' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 27/01/2023 06:11: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 = '80563' 27/01/2023 06:11:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '80563' 27/01/2023 06:11: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 ( '80563' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 27/01/2023 06:12:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '293' AND id_document != '80563' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 06:12:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '293', document_date = '2023-01-27', 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 = '14.00', price_tax_excluded = '11.48', date_upd = NOW() WHERE id_document = '80563' 27/01/2023 06:12:38 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 = '80563' 27/01/2023 06:12:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '80563' 27/01/2023 06:12:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80563' , '13723' , 'CROCE GERUSALEMME CON BASE CM 12' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 27/01/2023 06:47:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867570645' AND id_product != '20435' AND ean13 != '' 27/01/2023 06:47:42 pm >> UPDATE ps_product SET id_supplier = '7', reference = '2/3', ean13 = '9788867570645', date_upd = NOW() WHERE id_product = '20435' 27/01/2023 06:47:42 pm >> UPDATE ps_product_lang SET name = 'BIBBIA E IL TESORO NASCOSTO', description = '' WHERE id_product = '20435' 27/01/2023 06:47:42 pm >> UPDATE ps_product SET wholesale_price = '3.15', on_sale = '0', price = '4.5000' WHERE id_product = '20435' 27/01/2023 06:47:42 pm >> UPDATE ps_product_shop SET wholesale_price = '3.15', price = '4.5000', id_tax_rules_group = '4', id_category_default = '51', id_argoment_default = '12', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20435' 27/01/2023 06:47:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20435' 27/01/2023 06:58:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983738' AND id_product != '17695' AND ean13 != '' 27/01/2023 06:58:51 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983738', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 06:58:51 pm >> UPDATE ps_product_lang SET name = 'VIA LUCIS CON SAN CESARE DE BUS', description = '' WHERE id_product = '17695' 27/01/2023 06:58:51 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '3.8000' WHERE id_product = '17695' 27/01/2023 06:58:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '3.8000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 06:58:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '17695' 27/01/2023 06:58:51 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '17695' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:01:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983738' AND id_product != '17695' AND ean13 != '' 27/01/2023 07:01:33 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983738', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:01:33 pm >> UPDATE ps_product_lang SET name = 'VIA LUCIS CON SAN CESARE DE BUS', description = '

In questa Via Lucis contempliamo la presenza gloriosa e visibile di Gesù Risorto tra i suoi fino alla Pentecoste.

Ci facciamo aiutare dalle riflessioni di San Cesare De Bus tratte dalle sue omelie.

' WHERE id_product = '17695' 27/01/2023 07:01:33 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '3.8000' WHERE id_product = '17695' 27/01/2023 07:01:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '3.8000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:01:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '17695' 27/01/2023 07:01:33 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '17695' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:01:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983738' AND id_product != '17695' AND ean13 != '' 27/01/2023 07:01:45 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983738', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:01:45 pm >> UPDATE ps_product_lang SET name = 'VIA LUCIS CON SAN CESARE DE BUS', description = '

In questa Via Lucis contempliamo la presenza gloriosa e visibile di Gesù Risorto tra i suoi fino alla Pentecoste.

Ci facciamo aiutare dalle riflessioni di San Cesare De Bus tratte dalle sue omelie.

' WHERE id_product = '17695' 27/01/2023 07:01:45 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '3.8000' WHERE id_product = '17695' 27/01/2023 07:01:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '3.8000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:01:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '17695' 27/01/2023 07:01:45 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '17695' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:02:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423670' AND id_product != '523' AND ean13 != '' 27/01/2023 07:02:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '4/3', ean13 = '9788886423670', date_upd = NOW() WHERE id_product = '523' 27/01/2023 07:02:51 pm >> UPDATE ps_product_lang SET name = 'AMORE VINCE LA MORTE - VIA CRUCIS', description = '

\"Via Crucis\" rivolta ai ragazzi con un linguaggio adatto a loro che gli permette di celebrarla in modo più attivo.

' WHERE id_product = '523' 27/01/2023 07:02:51 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '0.8500' WHERE id_product = '523' 27/01/2023 07:02:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '0.8500', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '523' 27/01/2023 07:02:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '523' 27/01/2023 07:02:51 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '523' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:03:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983851' AND id_product != '18528' AND ean13 != '' 27/01/2023 07:03:19 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788895983851', date_upd = NOW() WHERE id_product = '18528' 27/01/2023 07:03:19 pm >> UPDATE ps_product_lang SET name = 'CON GESU\' VERSO IL CALVARIO - P. G. VALSECCHI', description = '

Ripercorrendo le stazioni della Via Crucis, accompagnando Gesù fino al Calvario, noi cerchiamo di comprendere, per quanto possibile, la grandezza del suo amore. Un amore che deve diventare il nostro programma di vita.

' WHERE id_product = '18528' 27/01/2023 07:03:19 pm >> UPDATE ps_product SET wholesale_price = '0.18', on_sale = '0', price = '1.5000' WHERE id_product = '18528' 27/01/2023 07:03:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.18', price = '1.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18528' 27/01/2023 07:03:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '18528' 27/01/2023 07:03:19 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '18528' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:04:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983653' AND id_product != '16667' AND ean13 != '' 27/01/2023 07:04:17 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788895983653', date_upd = NOW() WHERE id_product = '16667' 27/01/2023 07:04:17 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS', description = '

“Perché cercate tra i morti colui che\r\nè vivo? Non è qui, è risuscitato”, con questa frase del Vangelo di Luca\r\n(24,5-6) scopriamo la vera finalità della nostra esistenza che non è\r\nterrena ma aspira all’eternità.

\r\n\r\n

Celebriamo la Via Crucis, ricordando\r\nla strada percorsa da Gesù verso il Calvario, ma tante volte sperimentiamo\r\nquesta via dolorosa anche per noi stessi. Ma preghiamo anche per le persone\r\nche ancora oggi sono chiamate ad affrontare situazioni di vita dolorose.

' WHERE id_product = '16667' 27/01/2023 07:04:17 pm >> UPDATE ps_product SET wholesale_price = '0.48', on_sale = '0', price = '3.0000' WHERE id_product = '16667' 27/01/2023 07:04:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.48', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16667' 27/01/2023 07:04:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '16667' 27/01/2023 07:04:17 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '16667' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:04:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983653' AND id_product != '16667' AND ean13 != '' 27/01/2023 07:04:40 pm >> UPDATE ps_product SET id_supplier = '53', reference = '', ean13 = '9788895983653', date_upd = NOW() WHERE id_product = '16667' 27/01/2023 07:04:40 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS', description = '

“Perché cercate tra i morti colui che\r\nè vivo? Non è qui, è risuscitato”, con questa frase del Vangelo di Luca\r\n(24,5-6) scopriamo la vera finalità della nostra esistenza che non è\r\nterrena ma aspira all’eternità.

\r\n\r\n

Celebriamo la Via Crucis, ricordando\r\nla strada percorsa da Gesù verso il Calvario, ma tante volte sperimentiamo\r\nquesta via dolorosa anche per noi stessi. Ma preghiamo anche per le persone\r\nche ancora oggi sono chiamate ad affrontare situazioni di vita dolorose.

' WHERE id_product = '16667' 27/01/2023 07:04:40 pm >> UPDATE ps_product SET wholesale_price = '0.48', on_sale = '0', price = '3.0000' WHERE id_product = '16667' 27/01/2023 07:04:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.48', price = '3.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16667' 27/01/2023 07:04:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '16667' 27/01/2023 07:04:41 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '16667' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:05:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983639' AND id_product != '16665' AND ean13 != '' 27/01/2023 07:05:12 pm >> UPDATE ps_product SET id_supplier = '125', reference = '', ean13 = '9788895983639', date_upd = NOW() WHERE id_product = '16665' 27/01/2023 07:05:13 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS Dialogata per comunità parrocchiali', description = '

La pratica della Via Crucis ha lo scopo\r\ndi accompagnare Gesù fino al sepolcro, per meditare e cercare di comprendere\r\nsempre più la grandezza del suo amore per noi.

Questa Via Crucis è molto breve ed\r\nessenziale. Ogni singola stazione è illustrata da una lettura biblica,\r\ndopo un momento di silenzio, fa seguito una preghiera litanica e il\r\nGloria.

\r\n\r\n\r\n\r\n

Può\r\nessere utilizzata anche da persone singole,\r\nsoprattutto da malati e anziani che pregano e si associano alla passione\r\ndel Signore.

' WHERE id_product = '16665' 27/01/2023 07:05:13 pm >> UPDATE ps_product SET wholesale_price = '0.23', on_sale = '0', price = '1.0000' WHERE id_product = '16665' 27/01/2023 07:05:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.23', price = '1.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16665' 27/01/2023 07:05:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '16665' 27/01/2023 07:05:13 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '16665' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:05:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983820' AND id_product != '17696' AND ean13 != '' 27/01/2023 07:05:26 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983820', date_upd = NOW() WHERE id_product = '17696' 27/01/2023 07:05:26 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS CON SAN CESARE DE BUS', description = '' WHERE id_product = '17696' 27/01/2023 07:05:26 pm >> UPDATE ps_product SET wholesale_price = '0.48', on_sale = '0', price = '2.5000' WHERE id_product = '17696' 27/01/2023 07:05:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.48', price = '2.5000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17696' 27/01/2023 07:05:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '17696' 27/01/2023 07:05:26 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '17696' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:05:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983738' AND id_product != '17695' AND ean13 != '' 27/01/2023 07:05:37 pm >> UPDATE ps_product SET id_supplier = '53', reference = '13/3', ean13 = '9788895983738', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:05:37 pm >> UPDATE ps_product_lang SET name = 'VIA LUCIS CON SAN CESARE DE BUS', description = '

In questa Via Lucis contempliamo la presenza gloriosa e visibile di Gesù Risorto tra i suoi fino alla Pentecoste.

Ci facciamo aiutare dalle riflessioni di San Cesare De Bus tratte dalle sue omelie.

' WHERE id_product = '17695' 27/01/2023 07:05:37 pm >> UPDATE ps_product SET wholesale_price = '0.95', on_sale = '0', price = '3.8000' WHERE id_product = '17695' 27/01/2023 07:05:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.95', price = '3.8000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '28', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17695' 27/01/2023 07:05:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '17695' 27/01/2023 07:05:37 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '17695' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:08:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895983431' AND id_product != '13137' AND ean13 != '' 27/01/2023 07:08:58 pm >> UPDATE ps_product SET id_supplier = '107', reference = '1/2', ean13 = '9788895983431', date_upd = NOW() WHERE id_product = '13137' 27/01/2023 07:08:58 pm >> UPDATE ps_product_lang SET name = 'CON LA BIBBIA E IL CATECHISMO - S. LA PEGNA', description = '

E\' un contributo alla storia della catechesi e della vita consacrata. Nella lettera ai consacrati P. Francesco dice che occorre \"guardare il passato con gratitudine\" per proiettarsi al futuro con le sue novità e sfide. Tanti Dottrinari sull\'esempio del Beato Cesare, hanno servito la chiesa\"con la Bibbia e il catechismo in mano\".

' WHERE id_product = '13137' 27/01/2023 07:08:58 pm >> UPDATE ps_product SET wholesale_price = '1.27', on_sale = '0', price = '10.0000' WHERE id_product = '13137' 27/01/2023 07:08:58 pm >> UPDATE ps_product_shop SET wholesale_price = '1.27', price = '10.0000', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '145', id_internal_category = '4', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13137' 27/01/2023 07:08:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '13137' 27/01/2023 07:08:59 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '13137' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:10:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423663' AND id_product != '11312' AND ean13 != '' 27/01/2023 07:10:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '4/3', ean13 = '9788886423663', date_upd = NOW() WHERE id_product = '11312' 27/01/2023 07:10:42 pm >> UPDATE ps_product_lang SET name = 'VIA CRUCIS PER RAGAZZI ', description = '

\"Via Crucis\" rivolta ai ragazzi con un linguaggio adatto a loro che gli permette di celebrarla in modo più attivo.

' WHERE id_product = '11312' 27/01/2023 07:10:42 pm >> UPDATE ps_product SET wholesale_price = '0.26', on_sale = '0', price = '0.8500' WHERE id_product = '11312' 27/01/2023 07:10:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.26', price = '0.8500', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '50', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '11312' 27/01/2023 07:10:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '11312' 27/01/2023 07:10:42 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '11312' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/01/2023 07:14:07 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/01/2023 07:14:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20685' , '1' , '' , 'nuovo-prodotto' ) 27/01/2023 07:14:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20685' , '1' , '1' , '2' , NOW() , NOW() ) 27/01/2023 07:14:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20685' , '0' , '1' , '0' , '0' ) 27/01/2023 07:44:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 07:44:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '294' , '2023-01-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.00' , '97.54' , NOW() , NOW() ) 27/01/2023 07:44:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80564' 27/01/2023 07:44:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '80564' 27/01/2023 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.30' , '0.24590163934426' , '22' , '10' , '27.00' ) 27/01/2023 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '15294' , 'BENEDIZIONI - RISURREZIONE B' , '600' , '-600' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '90.00' ) 27/01/2023 07:44:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '19231' , 'CARD CARLO ACUTIS - RN93' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/01/2023 07:52:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 07:52:23 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' , '14/A' , '2023-01-27' , 'A' , '3865' , '0' , '4673708' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.35' , '65.93' , NOW() , NOW() ) 27/01/2023 07:52:23 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 = '80565' 27/01/2023 07:52:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '80565' 27/01/2023 07:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80565' , '18357' , 'MIE PREGHIERINE N.E.' , '30' , '-30' , '4' , '1.50' , '1.5' , '0' , '15' , '38.25' ) 27/01/2023 07:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80565' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/01/2023 07:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80565' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 27/01/2023 07:52:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80565' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 27/01/2023 07:54:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '294' AND id_document != '80564' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-27') 27/01/2023 07:54:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '294', document_date = '2023-01-27', 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 = '119.00', price_tax_excluded = '97.54', date_upd = NOW() WHERE id_document = '80564' 27/01/2023 07:54:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80564' 27/01/2023 07:54:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '80564' 27/01/2023 07:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '10' , '27.00' ) 27/01/2023 07:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '19231' , 'CARD CARLO ACUTIS - RN93' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 27/01/2023 07:54:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80564' , '1041' , 'BENEDIZIONI' , '600' , '-600' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '90.00' )