22/09/2023 08:11:50 am >> SELECT document_num FROM ps_document WHERE document_num = '22/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 08:11:50 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 ( '23' , '22/S' , '2023-09-22' , 'S' , '3487' , '0' , '144688386' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '135.00' , '135.00' , NOW() , NOW() ) 22/09/2023 08:11:50 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 = '12150' 22/09/2023 08:11:50 am >> DELETE FROM ps_document_detail WHERE id_document = '12150' 22/09/2023 08:11:50 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 ( '12150' , '111' , 'I NONNI SONO UN TESORO' , '150' , '-150' , '4' , '1.80' , '1.8' , '0' , '50' , '135.00' ) 22/09/2023 10:09:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2874' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:09:28 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' , '2874' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 22/09/2023 10:09:28 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 = '87365' 22/09/2023 10:09:28 am >> DELETE FROM ps_document_detail WHERE id_document = '87365' 22/09/2023 10:09:28 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 ( '87365' , '13040' , 'LIBRO DEL BEBE - AZZURRO' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 22/09/2023 10:15:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2875' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:15:21 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' , '2875' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '103.00' , '84.43' , NOW() , NOW() ) 22/09/2023 10:15:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87366' 22/09/2023 10:15:21 am >> DELETE FROM ps_document_detail WHERE id_document = '87366' 22/09/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87366' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 22/09/2023 10:15:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87366' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/09/2023 10:18:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2876' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:18: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 ( '11' , '2876' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '245.00' , '200.82' , NOW() , NOW() ) 22/09/2023 10:18: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 = '87367' 22/09/2023 10:18:36 am >> DELETE FROM ps_document_detail WHERE id_document = '87367' 22/09/2023 10:18: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 ( '87367' , '4859' , 'ICONA DIPINTA 30x35' , '1' , '-1' , '1' , '245.00' , '200.81967213115' , '22' , '0' , '245.00' ) 22/09/2023 10:26:38 am >> SELECT document_num FROM ps_document WHERE document_num = '2877' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:26:38 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' , '2877' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.98' , '9.98' , NOW() , NOW() ) 22/09/2023 10:26:38 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 = '87368' 22/09/2023 10:26:38 am >> DELETE FROM ps_document_detail WHERE id_document = '87368' 22/09/2023 10:26:38 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 ( '87368' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/09/2023 10:26:38 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 ( '87368' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 22/09/2023 10:29:07 am >> SELECT document_num FROM ps_document WHERE document_num = '2878' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:29:08 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' , '2878' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.31' , '13.31' , NOW() , NOW() ) 22/09/2023 10:29:08 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 = '87369' 22/09/2023 10:29:08 am >> DELETE FROM ps_document_detail WHERE id_document = '87369' 22/09/2023 10:29:08 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 ( '87369' , '5559' , 'LASCIATE CHE I BAMBINI VENGANO A ME' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 22/09/2023 10:29:08 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 ( '87369' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '5' , '5.23' ) 22/09/2023 10:29:08 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 ( '87369' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 22/09/2023 10:37:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001930' AND id_product != '19212' AND ean13 != '' 22/09/2023 10:37:56 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001930', date_upd = NOW() WHERE id_product = '19212' 22/09/2023 10:37:56 am >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X20 - 113', description = '' WHERE id_product = '19212' 22/09/2023 10:37:56 am >> UPDATE ps_product SET wholesale_price = '3.33', on_sale = '0', price = '7.786885245901639' WHERE id_product = '19212' 22/09/2023 10:37:56 am >> UPDATE ps_product_shop SET wholesale_price = '3.33', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '147', 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 = '19212' 22/09/2023 10:37:56 am >> DELETE FROM ps_specific_price WHERE id_product = '19212' 22/09/2023 10:57:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2879' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 10:57:19 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' , '2879' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '75.48' , NOW() , NOW() ) 22/09/2023 10:57:19 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 = '87370' 22/09/2023 10:57:19 am >> DELETE FROM ps_document_detail WHERE id_document = '87370' 22/09/2023 10:57:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '16689' , 'OSTIA PAN DI CENA mm80' , '15' , '-15' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '30.00' ) 22/09/2023 10:57:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '21511' , 'INSTRUMENTUM LABORIS - SINODO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 22/09/2023 10:57:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '20678' , 'SINODALITA - C. MILITELLO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 22/09/2023 10:57:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87370' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18.65' , '15.286885245902' , '22' , '0' , '18.65' ) 22/09/2023 11:20:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2880' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 11:20:28 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' , '2880' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.00' , '76.45' , NOW() , NOW() ) 22/09/2023 11:20:28 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 = '87371' 22/09/2023 11:20:28 am >> DELETE FROM ps_document_detail WHERE id_document = '87371' 22/09/2023 11:20:28 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 ( '87371' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 22/09/2023 11:20:28 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 ( '87371' , '2756' , 'CORONA ANGELICA - 8197' , '3' , '-3' , '4' , '1.50' , '1.5' , '0' , '0' , '4.50' ) 22/09/2023 11:20:28 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 ( '87371' , '7104' , 'NOVENA A SAN MICHELE ARCANGELO - 8196' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 22/09/2023 11:20:28 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 ( '87371' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '20' , '-20' , '4' , '0.9' , '0.9' , '0' , '0' , '18.00' ) 22/09/2023 11:20:28 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 ( '87371' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '10' , '-10' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '45.00' ) 22/09/2023 11:20:28 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 ( '87371' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.57' , '4.5655737704918' , '22' , '0' , '5.57' ) 22/09/2023 11:40:44 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/09/2023 11:40:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21566' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:40:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21566' , '1' , '1' , '2' , NOW() , NOW() ) 22/09/2023 11:40:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21566' , '0' , '1' , '0' , '0' ) 22/09/2023 11:41:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870680' AND id_product != '21566' AND ean13 != '' 22/09/2023 11:41:32 am >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892870680', date_upd = NOW() WHERE id_product = '21566' 22/09/2023 11:41:32 am >> UPDATE ps_product_lang SET name = 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ', description = '' WHERE id_product = '21566' 22/09/2023 11:41:32 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '21566' 22/09/2023 11:41:32 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '21566' 22/09/2023 11:41:32 am >> DELETE FROM ps_specific_price WHERE id_product = '21566' 22/09/2023 11:41:33 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 = '21566' 22/09/2023 11:41:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21567' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:41:33 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 '21567' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21566' 22/09/2023 11:41:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21567' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21566' 22/09/2023 11:42:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825056044' AND id_product != '21567' AND ean13 != '' 22/09/2023 11:42:24 am >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788825056044', date_upd = NOW() WHERE id_product = '21567' 22/09/2023 11:42:24 am >> UPDATE ps_product_lang SET name = 'VIA DI FRATE FRANCESCO - P. MARANESI', description = '' WHERE id_product = '21567' 22/09/2023 11:42:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21567' 22/09/2023 11:42:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21567' 22/09/2023 11:42:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21567' 22/09/2023 11:42:26 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 = '21567' 22/09/2023 11:42:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21568' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:42:26 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 '21568' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21567' 22/09/2023 11:42:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21568' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21567' 22/09/2023 11:43:23 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572182' AND id_product != '21568' AND ean13 != '' 22/09/2023 11:43:23 am >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788867572182', date_upd = NOW() WHERE id_product = '21568' 22/09/2023 11:43:23 am >> UPDATE ps_product_lang SET name = 'CARO GESU\' AL CATECHISMO ...', description = '' WHERE id_product = '21568' 22/09/2023 11:43:23 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '21568' 22/09/2023 11:43:23 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', 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 = '21568' 22/09/2023 11:43:23 am >> DELETE FROM ps_specific_price WHERE id_product = '21568' 22/09/2023 11:43:31 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 = '21568' 22/09/2023 11:43:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21569' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:43:31 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 '21569' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21568' 22/09/2023 11:43:32 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21569' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21568' 22/09/2023 11:44:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870734' AND id_product != '21569' AND ean13 != '' 22/09/2023 11:44:05 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788892870734', date_upd = NOW() WHERE id_product = '21569' 22/09/2023 11:44:05 am >> UPDATE ps_product_lang SET name = 'DOMENICHE DA COLORARE - ANNO B ', description = '' WHERE id_product = '21569' 22/09/2023 11:44:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21569' 22/09/2023 11:44:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', 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 = '21569' 22/09/2023 11:44:05 am >> DELETE FROM ps_specific_price WHERE id_product = '21569' 22/09/2023 11:44:06 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 = '21569' 22/09/2023 11:44:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21570' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:44:06 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 '21570' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21569' 22/09/2023 11:44:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21570' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21569' 22/09/2023 11:44:58 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556705' AND id_product != '21570' AND ean13 != '' 22/09/2023 11:44:58 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788831556705', date_upd = NOW() WHERE id_product = '21570' 22/09/2023 11:44:58 am >> UPDATE ps_product_lang SET name = 'OPERE COMPLETE - TERESA D\'AVILA', description = '' WHERE id_product = '21570' 22/09/2023 11:44:58 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '50' WHERE id_product = '21570' 22/09/2023 11:44:58 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '50', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21570' 22/09/2023 11:44:58 am >> DELETE FROM ps_specific_price WHERE id_product = '21570' 22/09/2023 11:44:59 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 = '21570' 22/09/2023 11:44:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21571' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:44:59 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 '21571' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21570' 22/09/2023 11:44:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21571' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21570' 22/09/2023 11:45:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884247964' AND id_product != '21571' AND ean13 != '' 22/09/2023 11:45:44 am >> UPDATE ps_product SET id_supplier = '', reference = '5/1', ean13 = '9788884247964', date_upd = NOW() WHERE id_product = '21571' 22/09/2023 11:45:44 am >> UPDATE ps_product_lang SET name = 'BETLEHEM', description = '' WHERE id_product = '21571' 22/09/2023 11:45:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '21571' 22/09/2023 11:45:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21571' 22/09/2023 11:45:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21571' 22/09/2023 11:45:45 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 = '21571' 22/09/2023 11:45:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21572' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:45:45 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 '21572' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21571' 22/09/2023 11:45:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21572' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21571' 22/09/2023 11:46:48 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242821' AND id_product != '21572' AND ean13 != '' 22/09/2023 11:46:48 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788892242821', date_upd = NOW() WHERE id_product = '21572' 22/09/2023 11:46:48 am >> UPDATE ps_product_lang SET name = 'DIO DOVE SEI FINITO? - M. PRASTARO', description = '' WHERE id_product = '21572' 22/09/2023 11:46:48 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21572' 22/09/2023 11:46:48 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21572' 22/09/2023 11:46:48 am >> DELETE FROM ps_specific_price WHERE id_product = '21572' 22/09/2023 11:47: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 = '21572' 22/09/2023 11:47:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21573' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:47: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 '21573' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21572' 22/09/2023 11:47:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21573' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21572' 22/09/2023 11:47:47 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fHTiPyWWzxi6UR93' , NOW() , NOW() ) 22/09/2023 11:47:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4027' , '1' ) 22/09/2023 11:47:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4027' , '2' ) 22/09/2023 11:47:47 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4027' , '3' ) 22/09/2023 11:51:29 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4027' 22/09/2023 11:51:29 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 ( '4027' , '10' , '135' , 'PARROCCHIA SANTI GERVASIO E PRTASIO' , 'GUSMINI' , 'DON ROBERTO' , 'VIA MONTEGRAPPA 13' , '' , '24050' , 'SPIRANO' , '' , '' , '3492119646' , '' , '84001170160' , NOW() , NOW() ) 22/09/2023 11:51:29 am >> UPDATE ps_customer SET email = 'roberto.gusmini@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4027' 22/09/2023 11:51:49 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4027' 22/09/2023 11:51:49 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 ( '4027' , '10' , '135' , 'PARROCCHIA SANTI GERVASIO E PRTASIO' , 'GUSMINI' , 'DON ROBERTO' , 'VIA MONTEGRAPPA 13' , '' , '24050' , 'SPIRANO' , '' , '' , '3492119646' , '' , '84001170160' , NOW() , NOW() ) 22/09/2023 11:51:49 am >> UPDATE ps_customer SET email = 'roberto.gusmini@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4027' 22/09/2023 11:53:55 am >> SELECT document_num FROM ps_document WHERE document_num = '121' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 11:53:55 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '121' , '2023-09-22' , '' , '4027' , '0' , '4679084' , 'VIA MONTEGRAPPA 13 24050 SPIRANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '92.90' , '92.90' , NOW() , NOW() ) 22/09/2023 11:53:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87372' 22/09/2023 11:53:55 am >> DELETE FROM ps_document_detail WHERE id_document = '87372' 22/09/2023 11:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87372' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '10' , '36.00' ) 22/09/2023 11:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87372' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '10' , '36.00' ) 22/09/2023 11:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87372' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '0' , '20.00' , '20' , '' , '10' , '18.00' ) 22/09/2023 11:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87372' , '' , 'CONTRASSEGNO' , '1' , '-1' , '0' , '2.9' , '2.9' , '' , '0' , '2.90' ) 22/09/2023 11:54:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556484' AND id_product != '21573' AND ean13 != '' 22/09/2023 11:54:51 am >> UPDATE ps_product SET id_supplier = '', reference = '4/4', ean13 = '9788831556484', date_upd = NOW() WHERE id_product = '21573' 22/09/2023 11:54:51 am >> UPDATE ps_product_lang SET name = 'CON LA FORZA DELLO SPIRITO', description = '' WHERE id_product = '21573' 22/09/2023 11:54:51 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '21573' 22/09/2023 11:54:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '40', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21573' 22/09/2023 11:54:51 am >> DELETE FROM ps_specific_price WHERE id_product = '21573' 22/09/2023 11:54:52 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 = '21573' 22/09/2023 11:54:52 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21574' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:54:52 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 '21574' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21573' 22/09/2023 11:54:52 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21574' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21573' 22/09/2023 11:57:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242777' AND id_product != '21574' AND ean13 != '' 22/09/2023 11:57:16 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788892242777', date_upd = NOW() WHERE id_product = '21574' 22/09/2023 11:57:16 am >> UPDATE ps_product_lang SET name = 'PAROLA, IL PANE, LA VITA - ANNO B - L. MAZZINGHI', description = '' WHERE id_product = '21574' 22/09/2023 11:57:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '21574' 22/09/2023 11:57:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', 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 = '21574' 22/09/2023 11:57:16 am >> DELETE FROM ps_specific_price WHERE id_product = '21574' 22/09/2023 11:57:16 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 = '21574' 22/09/2023 11:57:16 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21575' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:57:16 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 '21575' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21574' 22/09/2023 11:57:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21575' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21574' 22/09/2023 11:58:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870802' AND id_product != '21575' AND ean13 != '' 22/09/2023 11:58:01 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788892870802', date_upd = NOW() WHERE id_product = '21575' 22/09/2023 11:58:01 am >> UPDATE ps_product_lang SET name = 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA', description = '' WHERE id_product = '21575' 22/09/2023 11:58:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '21575' 22/09/2023 11:58:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '26', 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 = '21575' 22/09/2023 11:58:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21575' 22/09/2023 11:58:02 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 = '21575' 22/09/2023 11:58:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21576' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:58:02 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 '21576' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21575' 22/09/2023 11:58:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21576' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21575' 22/09/2023 11:58:50 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278928' AND id_product != '21576' AND ean13 != '' 22/09/2023 11:58:50 am >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788831278928', date_upd = NOW() WHERE id_product = '21576' 22/09/2023 11:58:50 am >> UPDATE ps_product_lang SET name = 'LUNGO LA STRADA CON LUI - ANNO B - P.R. SCALABRINI', description = '' WHERE id_product = '21576' 22/09/2023 11:58:50 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21576' 22/09/2023 11:58:50 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '97', 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 = '21576' 22/09/2023 11:58:50 am >> DELETE FROM ps_specific_price WHERE id_product = '21576' 22/09/2023 11:58:51 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 = '21576' 22/09/2023 11:58:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21577' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:58:51 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 '21577' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21576' 22/09/2023 11:58:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21577' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21576' 22/09/2023 11:59:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278935' AND id_product != '21577' AND ean13 != '' 22/09/2023 11:59:18 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831278935', date_upd = NOW() WHERE id_product = '21577' 22/09/2023 11:59:18 am >> UPDATE ps_product_lang SET name = 'AVVENTO 2023', description = '' WHERE id_product = '21577' 22/09/2023 11:59:18 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.5' WHERE id_product = '21577' 22/09/2023 11:59:18 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.5', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21577' 22/09/2023 11:59:18 am >> DELETE FROM ps_specific_price WHERE id_product = '21577' 22/09/2023 11:59:20 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 = '21577' 22/09/2023 11:59:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21578' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 11:59:20 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 '21578' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21577' 22/09/2023 11:59:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21578' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21577' 22/09/2023 12:00:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831278942' AND id_product != '21578' AND ean13 != '' 22/09/2023 12:00:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788831278942', date_upd = NOW() WHERE id_product = '21578' 22/09/2023 12:00:01 pm >> UPDATE ps_product_lang SET name = 'CERCATE E TROVERETE ', description = '' WHERE id_product = '21578' 22/09/2023 12:00:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.8' WHERE id_product = '21578' 22/09/2023 12:00:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.8', id_tax_rules_group = '4', id_category_default = '97', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21578' 22/09/2023 12:00:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '21578' 22/09/2023 12:00:02 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 = '21578' 22/09/2023 12:00:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21579' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 12:00:02 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 '21579' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21578' 22/09/2023 12:00:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21579' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21578' 22/09/2023 12:00:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556101' AND id_product != '21579' AND ean13 != '' 22/09/2023 12:00:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788831556101', date_upd = NOW() WHERE id_product = '21579' 22/09/2023 12:00:46 pm >> UPDATE ps_product_lang SET name = 'SALVE REGINA - A. AMAPANI', description = '' WHERE id_product = '21579' 22/09/2023 12:00:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '21579' 22/09/2023 12:00:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '188', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21579' 22/09/2023 12:00:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '21579' 22/09/2023 12:00:47 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 = '21579' 22/09/2023 12:00:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21580' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 12:00:47 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 '21580' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21579' 22/09/2023 12:00:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21580' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21579' 22/09/2023 12:01:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870567' AND id_product != '21580' AND ean13 != '' 22/09/2023 12:01:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892870567', date_upd = NOW() WHERE id_product = '21580' 22/09/2023 12:01:21 pm >> UPDATE ps_product_lang SET name = 'PRIMO LIBRO DEI SANTI ', description = '' WHERE id_product = '21580' 22/09/2023 12:01:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21580' 22/09/2023 12:01:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '21580' 22/09/2023 12:01:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '21580' 22/09/2023 12:01:22 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 = '21580' 22/09/2023 12:01:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21581' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 12:01:22 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 '21581' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21580' 22/09/2023 12:01:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21581' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21580' 22/09/2023 12:03:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892870574' AND id_product != '21581' AND ean13 != '' 22/09/2023 12:03:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/4', ean13 = '9788892870574', date_upd = NOW() WHERE id_product = '21581' 22/09/2023 12:03:36 pm >> UPDATE ps_product_lang SET name = 'PRIMO LIBRO DELLE SANTE', description = '' WHERE id_product = '21581' 22/09/2023 12:03:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21581' 22/09/2023 12:03:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '26', 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 = '21581' 22/09/2023 12:03:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21581' 22/09/2023 12:03:37 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 = '21581' 22/09/2023 12:03:37 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21582' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 12:03:37 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 '21582' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21581' 22/09/2023 12:03:37 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21582' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21581' 22/09/2023 12:05:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788867572182' AND id_product != '21568' AND ean13 != '' 22/09/2023 12:05:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '2/2', ean13 = '9788867572182', date_upd = NOW() WHERE id_product = '21568' 22/09/2023 12:05:31 pm >> UPDATE ps_product_lang SET name = 'CARO GESU\' AL CATECHISMO ...', description = '' WHERE id_product = '21568' 22/09/2023 12:05:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '21568' 22/09/2023 12:05:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', 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 = '21568' 22/09/2023 12:05:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '21568' 22/09/2023 12:08:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '640812' , '2023-09-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '5.29' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '187.40' , '187.40' , NOW() , NOW() ) 22/09/2023 12:08:40 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 = '87373' 22/09/2023 12:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '87373' 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21566' , 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '30' , '4.8300' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21566' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21566' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21580' , 'PRIMO LIBRO DEI SANTI ' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21580' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21580' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21581' , 'PRIMO LIBRO DELLE SANTE' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21581' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21581' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21577' , 'AVVENTO 2023' , '5' , '5' , '4' , '3.50' , '3.5' , '0' , '30' , '12.2500' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21577' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21577' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21578' , 'CERCATE E TROVERETE ' , '5' , '5' , '4' , '3.80' , '3.8' , '0' , '30' , '13.3000' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21578' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21578' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21576' , 'LUNGO LA STRADA CON LUI - ANNO B - P.R. SCALABRINI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21576' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21576' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21571' , 'BETLEHEM' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21571' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21571' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21566' , 'CON FRANCESCO ALLA SCOPERTA DELLA REGOLA ' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '30' , '4.8300' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21566' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21566' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21573' , 'CON LA FORZA DELLO SPIRITO' , '2' , '2' , '4' , '3.50' , '3.5' , '0' , '33' , '4.6900' ) 22/09/2023 12:08:40 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21573' AND id_supplier = '7' 22/09/2023 12:08:40 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21573' , '7' , '1' ) 22/09/2023 12:08:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21569' , 'DOMENICHE DA COLORARE - ANNO B ' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21569' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21569' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21568' , 'CARO GESU AL CATECHISMO ...' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21568' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21568' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21572' , 'DIO DOVE SEI FINITO? - M. PRASTARO' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21572' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21572' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21574' , 'PAROLA, IL PANE, LA VITA - ANNO B - L. MAZZINGHI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '33' , '18.7600' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21574' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21574' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21575' , 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21575' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21575' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21570' , 'OPERE COMPLETE - TERESA DAVILA' , '1' , '1' , '4' , '50.00' , '50' , '0' , '33' , '33.5000' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21570' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21570' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21579' , 'SALVE REGINA - A. AMAPANI' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '33' , '3.2830' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21579' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21579' , '7' , '1' ) 22/09/2023 12:08:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87373' , '21567' , 'VIA DI FRATE FRANCESCO - P. MARANESI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 22/09/2023 12:08:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21567' AND id_supplier = '7' 22/09/2023 12:08:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21567' , '7' , '1' ) 22/09/2023 12:24:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2881' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 12:24:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2881' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.30' , '3.07' , NOW() , NOW() ) 22/09/2023 12:24:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87374' 22/09/2023 12:24:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '87374' 22/09/2023 12:24:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87374' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/09/2023 12:24:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87374' , '14777' , 'DECINA LEGNO CON LACCIO' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 22/09/2023 12:50:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2882' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 12:50: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' , '2882' , '2023-09-22' , '' , '0' , '0' , '0' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '793.95' , '714.16' , NOW() , NOW() ) 22/09/2023 12:50: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 = '87375' 22/09/2023 12:50:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '87375' 22/09/2023 12:50: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 ( '87375' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.0000' , '6.5574' , '22' , '0' , '96.00' ) 22/09/2023 12:50: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 ( '87375' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3654' , '4' , '0' , '35.00' ) 22/09/2023 12:50: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 ( '87375' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885' , '22' , '0' , '270.00' ) 22/09/2023 12:50:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.4000' , '1.1475' , '22' , '0' , '56.00' ) 22/09/2023 12:50:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 22/09/2023 12:50:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '19582' , 'SACRA BIBBIA TASC. TELATA - 8058' , '13' , '-13' , '4' , '25.00' , '25' , '0' , '5' , '308.75' ) 22/09/2023 12:50:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '21392' , 'BIBBIA - EDIZIONE SOFT' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 22/09/2023 12:59:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2883' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 12:59:10 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' , '2883' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '181.20' , '148.52' , NOW() , NOW() ) 22/09/2023 12:59:10 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 = '87376' 22/09/2023 12:59:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '87376' 22/09/2023 12:59:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87376' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '1' , '-1' , '1' , '12.20' , '10' , '22' , '0' , '12.20' ) 22/09/2023 12:59:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87376' , '16865' , 'CROCIFISSO SAGOMATO 28X20 - 102860' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 22/09/2023 12:59:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87376' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45' , '36.885245901639' , '22' , '0' , '90.00' ) 22/09/2023 01:03:51 pm >> DELETE FROM ps_document WHERE id_document = '86599' 22/09/2023 01:03:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '86599' 22/09/2023 01:07:49 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4027' 22/09/2023 01:07:49 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 ( '4027' , '10' , '135' , 'PARROCCHIA SANTI GERVASIO E PROTASIO' , 'GUSMINI' , 'DON ROBERTO' , 'VIA MONTE GRAPPA 13' , '' , '24050' , 'SPIRANO' , '' , '' , '3492119646' , '' , '84001170160' , NOW() , NOW() ) 22/09/2023 01:07:49 pm >> UPDATE ps_customer SET email = 'roberto.gusmini@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4027' 22/09/2023 03:43:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 22/09/2023 03:43:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 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 = '0', id_causal = '0', price_tax_included = '110.60', price_tax_excluded = '110.60', date_upd = NOW() WHERE id_document = '81317' 22/09/2023 03:43: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 = '81317' 22/09/2023 03:43:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 22/09/2023 03:43: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 ( '81317' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 22/09/2023 03:43: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 ( '81317' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 22/09/2023 03:43: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 ( '81317' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/09/2023 03:43: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 ( '81317' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 22/09/2023 03:43: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 ( '81317' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 22/09/2023 03:43: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 ( '81317' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/09/2023 03:43: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 ( '81317' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/09/2023 03:43: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 ( '81317' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/09/2023 03:43: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 ( '81317' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/09/2023 03:43: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 ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/09/2023 03:43: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 ( '81317' , '21575' , 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 22/09/2023 04:00:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2884' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 04:00:05 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' , '2884' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.90' , '79.39' , NOW() , NOW() ) 22/09/2023 04:00:05 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 = '87377' 22/09/2023 04:00:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '87377' 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '18131' , 'TAU MEDIO CM3 - T6' , '50' , '-50' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '50.00' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/09/2023 04:00:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87377' , '5106' , 'SAN FRANCESCO - 356' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 22/09/2023 04:11:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2885' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 04:11:18 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' , '2885' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '6.35' , NOW() , NOW() ) 22/09/2023 04:11:18 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 = '87378' 22/09/2023 04:11:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '87378' 22/09/2023 04:11:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87378' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '2' , '-2' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '6.60' ) 22/09/2023 04:21:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2886' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 04:21:08 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' , '2886' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.49' , NOW() , NOW() ) 22/09/2023 04:21:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87379' 22/09/2023 04:21:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '87379' 22/09/2023 04:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87379' , '18140' , 'TAU SNODATO PADRE NOSTRO MEDIO' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 22/09/2023 04:21:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87379' , '18141' , 'TAU SNODATO PADRE NOSTRO GRANDE' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 22/09/2023 04:22:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000019742' AND id_product != '21582' AND ean13 != '' 22/09/2023 04:22:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000019742', date_upd = NOW() WHERE id_product = '21582' 22/09/2023 04:22:49 pm >> UPDATE ps_product_lang SET name = 'MINIALTARE - 976', description = '' WHERE id_product = '21582' 22/09/2023 04:22:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '204.91803278688525' WHERE id_product = '21582' 22/09/2023 04:22:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '204.91803278688525', id_tax_rules_group = '1', id_category_default = '147', 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 = '21582' 22/09/2023 04:22:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '21582' 22/09/2023 04:23:28 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/09/2023 04:23:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21583' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 04:23:28 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21583' , '1' , '1' , '2' , NOW() , NOW() ) 22/09/2023 04:23:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21583' , '0' , '1' , '0' , '0' ) 22/09/2023 04:25:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016598' AND id_product != '21583' AND ean13 != '' 22/09/2023 04:25:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016598', date_upd = NOW() WHERE id_product = '21583' 22/09/2023 04:25:27 pm >> UPDATE ps_product_lang SET name = 'CUSTODIA PELLE LITURGIA DELLE ORE - 731', description = '' WHERE id_product = '21583' 22/09/2023 04:25:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '27.049180327868854' WHERE id_product = '21583' 22/09/2023 04:25:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '27.049180327868854', id_tax_rules_group = '1', id_category_default = '147', 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 = '21583' 22/09/2023 04:25:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '21583' 22/09/2023 04:27: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 ( '31' , '3047' , '2023-09-21' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '208.13' , '170.60' , NOW() , NOW() ) 22/09/2023 04:27: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 = '87380' 22/09/2023 04:27:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87380' 22/09/2023 04:27: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 ( '87380' , '10495' , 'TECA IHS CM 9 - 881' , '1' , '1' , '1' , '24' , '19.672131147541' , '22' , '5' , '27.8160' ) 22/09/2023 04:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10495' AND id_supplier = '12' 22/09/2023 04:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10495' , '12' , '1' ) 22/09/2023 04:27: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 ( '87380' , '21582' , 'MINIALTARE - 976' , '1' , '1' , '1' , '103.5' , '84.83606557377' , '22' , '5' , '119.9565' ) 22/09/2023 04:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21582' AND id_supplier = '12' 22/09/2023 04:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21582' , '12' , '1' ) 22/09/2023 04:27: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 ( '87380' , '21583' , 'CUSTODIA PELLE LITURGIA DELLE ORE - 731' , '3' , '3' , '1' , '13.5' , '11.065573770492' , '22' , '5' , '46.9395' ) 22/09/2023 04:27:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21583' AND id_supplier = '12' 22/09/2023 04:27:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21583' , '12' , '1' ) 22/09/2023 04:54:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2887' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 04:54: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' , '2887' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.24' , '20.24' , NOW() , NOW() ) 22/09/2023 04:54: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 = '87381' 22/09/2023 04:54:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87381' 22/09/2023 04:54: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 ( '87381' , '21205' , 'MI AMI TU? - CD' , '1' , '-1' , '4' , '16.80' , '16.8' , '0' , '5' , '15.96' ) 22/09/2023 04:54: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 ( '87381' , '21143' , 'AGGIUNTA CANTI 2023' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 22/09/2023 04:54:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2888' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 04:54: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 ( '11' , '2888' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.36' , '12.05' , NOW() , NOW() ) 22/09/2023 04:54: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 = '87382' 22/09/2023 04:54:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '87382' 22/09/2023 04:54: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 ( '87382' , '21143' , 'AGGIUNTA CANTI 2023' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 22/09/2023 04:54: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 ( '87382' , '21142' , 'AGGIUNTA SPARTITI 2023' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '5' , '8.08' ) 22/09/2023 05:31:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2889' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 05:31: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 ( '11' , '2889' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 22/09/2023 05:31: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 = '87383' 22/09/2023 05:31:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '87383' 22/09/2023 05:31:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87383' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 22/09/2023 05:39:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '14' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 05:39: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 ( '24' , '14' , '2023-09-22' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '820.00' , '820.00' , NOW() , NOW() ) 22/09/2023 05:39: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 = '12151' 22/09/2023 05:39:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '12151' 22/09/2023 05:39: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 ( '12151' , '50' , 'PERDONAMI SIGNORE' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 22/09/2023 05:39: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 ( '12151' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '160' , '-160' , '4' , '2.00' , '2' , '0' , '0' , '320.00' ) 22/09/2023 05:40:26 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/09/2023 05:40:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21584' , '1' , '' , 'nuovo-prodotto' ) 22/09/2023 05:40:26 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21584' , '1' , '1' , '2' , NOW() , NOW() ) 22/09/2023 05:40:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21584' , '0' , '1' , '0' , '0' ) 22/09/2023 05:41:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '42/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 05:41: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 ( '23' , '42/E' , '2023-09-22' , 'E' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '1152.00' , '944.26' , NOW() , NOW() ) 22/09/2023 05:41: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 = '87384' 22/09/2023 05:41:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87384' 22/09/2023 05:41: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 ( '87384' , '12817' , 'LIBRO DEI MATRIMONI' , '24' , '-24' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '576.00' ) 22/09/2023 05:41: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 ( '87384' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 22/09/2023 05:41: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 ( '87384' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '288.00' ) 22/09/2023 05:57:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2890' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 05:57:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2890' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '125.00' , '102.46' , NOW() , NOW() ) 22/09/2023 05:57:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87385' 22/09/2023 05:57:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '87385' 22/09/2023 05:57: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 ( '87385' , '15669' , 'IMMACOLATA DEL MURILLO CM 43 - PA404' , '1' , '-1' , '1' , '125' , '102.45901639344' , '22' , '0' , '125.00' ) 22/09/2023 06:13:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:13:14 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' , '122' , '2023-09-22' , '' , '618' , '0' , '4671023' , 'S. ANGELO 84085 MERCATO S. SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '204.77' , '204.77' , NOW() , NOW() ) 22/09/2023 06:13: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 = '87386' 22/09/2023 06:13:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87386' 22/09/2023 06:13: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 ( '87386' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '15' , '28.90' ) 22/09/2023 06:13: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 ( '87386' , '5457' , 'IO SONO CON VOI 1 PARTE' , '16' , '-16' , '4' , '2.80' , '2.8' , '0' , '15' , '38.08' ) 22/09/2023 06:13: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 ( '87386' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 22/09/2023 06:13: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 ( '87386' , '11191' , 'VENITE CON ME 1 PARTE' , '7' , '-7' , '4' , '2.80' , '2.8' , '0' , '15' , '16.66' ) 22/09/2023 06:13: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 ( '87386' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '15' , '14.28' ) 22/09/2023 06:13: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 ( '87386' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.50' , '3.5' , '0' , '15' , '44.63' ) 22/09/2023 06:13: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 ( '87386' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.40' , '2.4' , '0' , '15' , '26.52' ) 22/09/2023 06:15:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '2891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:15: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' , '2891' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '205.94' , '204.64' , NOW() , NOW() ) 22/09/2023 06:15: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 = '87387' 22/09/2023 06:15:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '87387' 22/09/2023 06:15: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 ( '87387' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.00' , '0.81967213114754' , '22' , '10' , '7.20' ) 22/09/2023 06:15: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 ( '87387' , '5444' , 'IO SONO CON VOI - CAT.' , '13' , '-13' , '4' , '5.50' , '5.5' , '0' , '5' , '67.99' ) 22/09/2023 06:15: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 ( '87387' , '11193' , 'VENITE CON ME CAT.' , '10' , '-10' , '4' , '5.50' , '5.5' , '0' , '5' , '52.30' ) 22/09/2023 06:15: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 ( '87387' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '15' , '-15' , '4' , '5.50' , '5.5' , '0' , '5' , '78.45' ) 22/09/2023 06:15:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '122' AND id_document != '87386' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:15:49 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '122', document_date = '2023-09-22', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', 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 = '200.09', price_tax_excluded = '200.09', date_upd = NOW() WHERE id_document = '87386' 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87386' 22/09/2023 06:15:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '87386' 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.4000' , '3.4' , '0' , '15' , '28.90' ) 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '5457' , 'IO SONO CON VOI 1 PARTE' , '16' , '-16' , '4' , '2.8000' , '2.8' , '0' , '15' , '38.08' ) 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.8000' , '2.8' , '0' , '15' , '35.70' ) 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '11191' , 'VENITE CON ME 1 PARTE' , '7' , '-7' , '4' , '2.8000' , '2.8' , '0' , '15' , '16.66' ) 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.8000' , '2.8' , '0' , '15' , '14.28' ) 22/09/2023 06:15:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87386' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 22/09/2023 06:15: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 ( '87386' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '13' , '-13' , '4' , '2.4000' , '2.4' , '0' , '30' , '21.84' ) 22/09/2023 06:16:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2892' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:16: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' , '2892' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.83' , '12.83' , NOW() , NOW() ) 22/09/2023 06:16: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 = '87388' 22/09/2023 06:16:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '87388' 22/09/2023 06:16: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 ( '87388' , '14682' , 'PER UNA LETTURA LAICA DELLA BIBBIA - S. FAUSTI' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.83' ) 22/09/2023 06:39:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '44/A' AND id_document != '82607' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-03') 22/09/2023 06:39:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '44/A', document_date = '2023-04-03', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'acconto € 15,00 4/9/23', 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 = '800.00', price_tax_excluded = '655.74', date_upd = NOW() WHERE id_document = '82607' 22/09/2023 06:39:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82607' 22/09/2023 06:39:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '82607' 22/09/2023 06:39: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 ( '82607' , '18372' , 'CASULA LANA LUREX - 65/001909' , '1' , '-1' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 22/09/2023 06:39: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 ( '82607' , '19448' , 'CASULA P/LANA - 8237L' , '1' , '-1' , '1' , '550' , '450.81967213115' , '22' , '0' , '550.00' ) 22/09/2023 06:42:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2891' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:43:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2893' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 06:43:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2893' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 22/09/2023 06:43:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87389' 22/09/2023 06:43:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '87389' 22/09/2023 06:43:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87389' , '21042' , 'AMITTO MISTO LANA - 60/3113' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 22/09/2023 06:43:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87389' , '14114' , 'CINGOLO ORO - CING08ORO' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 22/09/2023 07:18:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '2882' AND id_document != '87375' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 07:18:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2882', document_date = '2023-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA', 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 = '793.95', price_tax_excluded = '714.16', date_upd = NOW() WHERE id_document = '87375' 22/09/2023 07:18:18 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 = '87375' 22/09/2023 07:18:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '87375' 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '11384' , 'VINO BIANCO DOLCE - 102' , '12' , '-12' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '96.00' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.4000' , '1.1475409836066' , '22' , '0' , '56.00' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '19582' , 'SACRA BIBBIA TASC. TELATA - 8058' , '13' , '-13' , '4' , '25.0000' , '25' , '0' , '5' , '308.75' ) 22/09/2023 07:18:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87375' , '21392' , 'BIBBIA - EDIZIONE SOFT' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 22/09/2023 07:21:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '36' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 07:21:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '36' , '2023-09-22' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1340.00' , '1340.00' , NOW() , NOW() ) 22/09/2023 07:21:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87390' 22/09/2023 07:21:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '87390' 22/09/2023 07:21: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 ( '87390' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '100' , '-100' , '4' , '5.00' , '5' , '0' , '0' , '500.00' ) 22/09/2023 07:21: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 ( '87390' , '13397' , 'MIO GESU\'' , '240' , '-240' , '4' , '3.50' , '3.5' , '0' , '0' , '840.00' ) 22/09/2023 07:34:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '42/E' AND id_document != '87384' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 07:34:58 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '42/E', document_date = '2023-09-22', document_letter = 'E', id_customer = '3000', id_supplier = '0', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '1152.00', price_tax_excluded = '944.26', date_upd = NOW() WHERE id_document = '87384' 22/09/2023 07:34: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 = '87384' 22/09/2023 07:34:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '87384' 22/09/2023 07:34: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 ( '87384' , '12817' , 'LIBRO DEI MATRIMONI' , '24' , '-24' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '576.00' ) 22/09/2023 07:34: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 ( '87384' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 22/09/2023 07:34: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 ( '87384' , '12815' , 'LIBRO DEI CRESIMATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 22/09/2023 07:37:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '2894' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 07:37: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' , '2894' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.30' , '29.11' , NOW() , NOW() ) 22/09/2023 07:37: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 = '87391' 22/09/2023 07:37:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '87391' 22/09/2023 07:37: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 ( '87391' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 22/09/2023 07:37: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 ( '87391' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 22/09/2023 07:37: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 ( '87391' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 22/09/2023 07:37: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 ( '87391' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/09/2023 07:37: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 ( '87391' , '20515' , 'DECINA ULIVO - 04/7-D' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 22/09/2023 07:37: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 ( '87391' , '20644' , 'STOLA - PST022' , '1' , '-1' , '1' , '28.50' , '23.360655737705' , '22' , '0' , '28.50' ) 22/09/2023 07:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-20') 22/09/2023 07:42:59 pm >> UPDATE ps_customer SET deleted='1' , active = '0' WHERE id_customer = '87360' 22/09/2023 07:44:25 pm >> DELETE FROM ps_document WHERE id_document = '87360' 22/09/2023 07:44:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '87360' 22/09/2023 07:45:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '41/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-20') 22/09/2023 07:45:15 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 ( '23' , '41/E' , '2023-09-20' , 'E' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '291.60' , '291.60' , NOW() , NOW() ) 22/09/2023 07:45:15 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 = '87392' 22/09/2023 07:45:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '87392' 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '15' , '-15' , '4' , '3.4000' , '3.4' , '0' , '20' , '40.80' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '10' , '10.80' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '25' , '-25' , '4' , '3.0000' , '3' , '0' , '10' , '67.50' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '20' , '-20' , '4' , '3.0000' , '3' , '0' , '10' , '54.00' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '10' , '27.00' ) 22/09/2023 07:45:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87392' , '12819' , 'REGISTRO DEL CATECHISTA ' , '30' , '-30' , '1' , '1.0000' , '0.8197' , '22' , '20' , '24.00' ) 22/09/2023 07:55:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2895' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-22') 22/09/2023 07:55:14 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' , '2895' , '2023-09-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 22/09/2023 07:55: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 = '87393' 22/09/2023 07:55:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87393' 22/09/2023 07:55: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 ( '87393' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' )