16/10/2023 08:42:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '15985/00/2023' , '2023-10-12' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '172.20' , '172.20' , NOW() , NOW() ) 16/10/2023 08:42:26 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 = '88306' 16/10/2023 08:42:26 am >> DELETE FROM ps_document_detail WHERE id_document = '88306' 16/10/2023 08:42:26 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 ( '88306' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '50' , '50' , '4' , '5.00' , '5' , '0' , '40' , '150.0000' ) 16/10/2023 08:42:26 am >> DELETE FROM ps_product_supplier WHERE id_product = '21519' AND id_supplier = '38' 16/10/2023 08:42:26 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21519' , '38' , '1' ) 16/10/2023 08:42:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88306' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 16/10/2023 08:42:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '3612' AND id_supplier = '38' 16/10/2023 08:42:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3612' , '38' , '1' ) 16/10/2023 08:42:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88306' , '13633' , 'SAN LUIGI MARIA DI MONTFORT - 8386' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 16/10/2023 08:42:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '13633' AND id_supplier = '38' 16/10/2023 08:42:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13633' , '38' , '1' ) 16/10/2023 08:42:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88306' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '5' , '5' , '4' , '2.00' , '2' , '0' , '40' , '6.0000' ) 16/10/2023 08:42:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7271' AND id_supplier = '38' 16/10/2023 08:42:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7271' , '38' , '1' ) 16/10/2023 08:42:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88306' , '13034' , 'STORIE DELLA BIBBIA IN 1000 ADESIVI - 8887' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 16/10/2023 08:42:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '13034' AND id_supplier = '38' 16/10/2023 08:42:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13034' , '38' , '1' ) 16/10/2023 08:54:01 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/10/2023 08:54:01 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21677' , '1' , '' , 'nuovo-prodotto' ) 16/10/2023 08:54:01 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21677' , '1' , '1' , '2' , NOW() , NOW() ) 16/10/2023 08:54:01 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21677' , '0' , '1' , '0' , '0' ) 16/10/2023 08:54:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831557108' AND id_product != '21677' AND ean13 != '' 16/10/2023 08:54:35 am >> UPDATE ps_product SET id_supplier = '', reference = '14', ean13 = '9788831557108', date_upd = NOW() WHERE id_product = '21677' 16/10/2023 08:54:35 am >> UPDATE ps_product_lang SET name = 'LAUDATE DEUM ', description = '' WHERE id_product = '21677' 16/10/2023 08:54:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.2' WHERE id_product = '21677' 16/10/2023 08:54:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.2', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21677' 16/10/2023 08:54:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21677' 16/10/2023 08:54:37 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 = '21677' 16/10/2023 08:54:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21678' , '1' , '' , 'nuovo-prodotto' ) 16/10/2023 08:54:37 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 '21678' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21677' 16/10/2023 08:54:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21678' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21677' 16/10/2023 09:00:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '644266' , '2023-10-12' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '10.59' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '313.12' , '313.12' , NOW() , NOW() ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88307' 16/10/2023 09:00:14 am >> DELETE FROM ps_document_detail WHERE id_document = '88307' 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21395' , 'CONVERTIRE LA CATECHESI - AAVV' , '2' , '2' , '4' , '10.00' , '10' , '0' , '35+7' , '12.0900' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21395' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21395' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '1' , '4' , '15.00' , '15' , '0' , '35+7' , '9.0675' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '14530' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14530' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21677' , 'LAUDATE DEUM ' , '12' , '12' , '4' , '1.20' , '1.2' , '0' , '33' , '9.6480' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21677' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21677' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21677' , 'LAUDATE DEUM ' , '1' , '1' , '4' , '1.20' , '1.2' , '0' , '100' , '0.0000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21677' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21677' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21435' , 'MINISTERO DEL CATECHISTA E I MINISTERI ' , '1' , '1' , '4' , '15.00' , '15' , '0' , '30' , '10.5000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21435' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21435' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '15032' , 'ABBRACCIO BENEDICENTE - H. NOUWEN' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '15032' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15032' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21106' , 'UNA COMUNITA DAL RITO - G. COSTA' , '1' , '1' , '4' , '25.00' , '25' , '0' , '30' , '17.5000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21106' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21106' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '20886' , 'VIAGGIO NEL CIELO DELLANIMA CON TERESA DAVILA - R. TAVELLI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '20886' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20886' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21536' , 'AIUTO! NEL MONDO STA SCOMPARENDO LAMORE - A. COMASTRI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21536' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21536' , '7' , '1' ) 16/10/2023 09:00:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88307' , '21541' , 'OMELIE SUI SANTI - A. COMASTRI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 16/10/2023 09:00:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '21541' AND id_supplier = '7' 16/10/2023 09:00:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21541' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '5739' , 'LETTERE PAOLINE E ALTRE LETTERE - 6 - LOGOS' , '2' , '2' , '4' , '35.00' , '35' , '0' , '35' , '45.5000' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5739' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5739' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '4001' , 'EVANGELO DI PAOLO - A. PITTA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '35' , '13.0000' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '4001' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4001' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '18647' , 'SCOPRIAMO INSIEME AVVENTO E NATALE' , '1' , '1' , '4' , '4.90' , '4.9' , '0' , '30' , '3.4300' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '18647' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18647' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '3' , '3' , '4' , '5.00' , '5' , '0' , '35' , '9.7500' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '10741' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10741' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '13431' , 'PASSI VERSO LEUCARISTIA' , '3' , '3' , '4' , '5.90' , '5.9' , '0' , '35' , '11.5050' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '13431' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13431' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '60' , '60' , '4' , '2.00' , '2' , '0' , '35' , '78.0000' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11540' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11540' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '5' , '5' , '4' , '2.00' , '2' , '0' , '100' , '0.0000' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '11540' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11540' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '5832' , 'LIBRO DEI SANTI' , '2' , '2' , '4' , '12.90' , '12.9' , '0' , '30' , '18.0600' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '5832' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5832' , '7' , '1' ) 16/10/2023 09:00:15 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 ( '88307' , '19805' , 'DESIDERIO DESIDERAVI' , '8' , '8' , '4' , '2.00' , '2' , '0' , '33' , '10.7200' ) 16/10/2023 09:00:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '7' 16/10/2023 09:00:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '7' , '1' ) 16/10/2023 09:18:48 am >> SELECT document_num FROM ps_document WHERE document_num = '158' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 09:18:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '158' , '2023-10-16' , '' , '3045' , '0' , '4679082' , 'VIA MAESTRI DEL LAVORO 17 85100 POTENZA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '64.50' , '64.50' , NOW() , NOW() ) 16/10/2023 09:18:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88308' 16/10/2023 09:18:48 am >> DELETE FROM ps_document_detail WHERE id_document = '88308' 16/10/2023 09:18:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88308' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.50' , '3.5' , '0' , '15' , '59.50' ) 16/10/2023 09:41:07 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 09:41:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '159' , '2023-10-16' , '' , '1429' , '0' , '4679117' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '245.00' , '245.00' , NOW() , NOW() ) 16/10/2023 09:41:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88309' 16/10/2023 09:41:07 am >> DELETE FROM ps_document_detail WHERE id_document = '88309' 16/10/2023 09:41:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88309' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '5' , '95.00' ) 16/10/2023 09:41:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88309' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '0' , '150.00' ) 16/10/2023 10:27:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3177' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 10:27:29 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' , '3177' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 16/10/2023 10:27:29 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 = '88310' 16/10/2023 10:27:29 am >> DELETE FROM ps_document_detail WHERE id_document = '88310' 16/10/2023 10:27:29 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 ( '88310' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 16/10/2023 11:05:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3178' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:05:02 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3178' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.83' , '51.26' , NOW() , NOW() ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88311' 16/10/2023 11:05:02 am >> DELETE FROM ps_document_detail WHERE id_document = '88311' 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '20946' , 'MIE PRIME STORIE DELLA BIBBIA' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '4310' , 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO - 8328' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '1713' , 'CARD DELLA GUARIGIONE SAN GERARDO' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '21630' , 'PAROLE E PREGHIERA DIC 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 16/10/2023 11:05:02 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88311' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 16/10/2023 11:06:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3170' AND id_document != '88297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-14') 16/10/2023 11:06:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3170', document_date = '2023-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '88297' 16/10/2023 11:06:29 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 = '88297' 16/10/2023 11:06:29 am >> DELETE FROM ps_document_detail WHERE id_document = '88297' 16/10/2023 11:06:29 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 ( '88297' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '49' , '40.16393442623' , '22' , '0' , '49.00' ) 16/10/2023 11:10:06 am >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '88309' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:10:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '109/A', document_date = '2023-10-16', document_letter = 'A', id_customer = '1429', id_supplier = '', id_address = '4679117', address1 = 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA', 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 = '245.00', price_tax_excluded = '245.00', date_upd = NOW() WHERE id_document = '88309' 16/10/2023 11:10:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88309' 16/10/2023 11:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88309' 16/10/2023 11:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88309' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '5' , '95.00' ) 16/10/2023 11:10:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88309' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 16/10/2023 11:10:11 am >> DELETE FROM ps_document WHERE id_document = '88309' 16/10/2023 11:10:11 am >> DELETE FROM ps_document_detail WHERE id_document = '88309' 16/10/2023 11:12:47 am >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:12:47 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '109/A' , '2023-10-16' , 'A' , '1429' , '0' , '4679117' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '245.00' , '245.00' , NOW() , NOW() ) 16/10/2023 11:12:47 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 = '88312' 16/10/2023 11:12:47 am >> DELETE FROM ps_document_detail WHERE id_document = '88312' 16/10/2023 11:12:47 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 ( '88312' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '50' , '-50' , '4' , '2.00' , '2' , '0' , '5' , '95.00' ) 16/10/2023 11:12:47 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 ( '88312' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '0' , '150.00' ) 16/10/2023 11:16:09 am >> SELECT document_num FROM ps_document WHERE document_num = '159' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:16:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '159' , '2023-10-16' , '' , '3927' , '0' , '4675446' , 'VIA DERADA 11 85030 SAN COSTANTINO ALBANESE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '90.27' , '90.27' , NOW() , NOW() ) 16/10/2023 11:16:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88313' 16/10/2023 11:16:09 am >> DELETE FROM ps_document_detail WHERE id_document = '88313' 16/10/2023 11:16:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88313' , '2679' , 'CONOSCERE GESU\'' , '4' , '-4' , '4' , '3.50' , '3.5' , '0' , '15' , '11.90' ) 16/10/2023 11:16:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88313' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '15' , '4.76' ) 16/10/2023 11:16:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88313' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '15' , '4.76' ) 16/10/2023 11:16:10 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 ( '88313' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '3' , '-3' , '4' , '9.00' , '9' , '0' , '15' , '22.95' ) 16/10/2023 11:16:10 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 ( '88313' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '3' , '-3' , '4' , '9.00' , '9' , '0' , '15' , '22.95' ) 16/10/2023 11:16:10 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 ( '88313' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '3' , '-3' , '4' , '9.00' , '9' , '0' , '15' , '22.95' ) 16/10/2023 11:32:56 am >> SELECT document_num FROM ps_document WHERE document_num = '160' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:32:56 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' , '160' , '2023-10-16' , '' , '84' , '0' , '4679076' , 'VIA MANFREDI 30 29122 PIACENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '178.50' , '178.50' , NOW() , NOW() ) 16/10/2023 11:32:56 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 = '88314' 16/10/2023 11:32:56 am >> DELETE FROM ps_document_detail WHERE id_document = '88314' 16/10/2023 11:32:56 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 ( '88314' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '-35' , '4' , '2.80' , '2.8' , '0' , '15' , '83.30' ) 16/10/2023 11:32:56 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 ( '88314' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 16/10/2023 11:32:56 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 ( '88314' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 16/10/2023 11:35:46 am >> SELECT document_num FROM ps_document WHERE document_num = '160' AND id_document != '88314' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:35:46 am >> UPDATE ps_document SET id_document_type = '21', document_num = '160', document_date = '2023-10-16', document_letter = '', id_customer = '84', id_supplier = '', id_address = '4679076', address1 = 'VIA MANFREDI 30 29122 PIACENZA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '249.90', price_tax_excluded = '249.90', date_upd = NOW() WHERE id_document = '88314' 16/10/2023 11:35:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88314' 16/10/2023 11:35:46 am >> DELETE FROM ps_document_detail WHERE id_document = '88314' 16/10/2023 11:35:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88314' , '11191' , 'VENITE CON ME 1 PARTE' , '35' , '-35' , '4' , '2.8000' , '2.8' , '0' , '15' , '83.30' ) 16/10/2023 11:35:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88314' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 16/10/2023 11:35:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88314' , '5458' , 'IO SONO CON VOI 2 PARTE' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 16/10/2023 11:35:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88314' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 16/10/2023 11:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '106/A' AND id_document != '88284' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 16/10/2023 11:41:33 am >> UPDATE ps_document SET id_document_type = '24', document_num = '106/A', document_date = '2023-10-13', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = '', 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 = '297.25', price_tax_excluded = '297.25', date_upd = NOW() WHERE id_document = '88284' 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88284' 16/10/2023 11:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '88284' 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '-23' , '4' , '3.4000' , '3.4' , '0' , '15' , '66.47' ) 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '29' , '-29' , '4' , '3.5000' , '3.5' , '0' , '15' , '86.28' ) 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4154' , 'FESTA DEL PERDONO' , '31' , '-31' , '4' , '3.00' , '3' , '0' , '15' , '79.05' ) 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 16/10/2023 11:41:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88284' , '8408' , 'PRENDETE E MANGIATE' , '24' , '-24' , '4' , '3.00' , '3' , '0' , '15' , '61.20' ) 16/10/2023 11:47:50 am >> SELECT document_num FROM ps_document WHERE document_num = '161' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:47: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 ( '21' , '161' , '2023-10-16' , '' , '371' , '0' , '4679091' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '354.46' , '354.46' , NOW() , NOW() ) 16/10/2023 11:47: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 = '88315' 16/10/2023 11:47:50 am >> DELETE FROM ps_document_detail WHERE id_document = '88315' 16/10/2023 11:47: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 ( '88315' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '30' , '-30' , '4' , '3.50' , '3.5' , '0' , '15' , '89.25' ) 16/10/2023 11:47: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 ( '88315' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 16/10/2023 11:47: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 ( '88315' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '37' , '-37' , '4' , '3.50' , '3.5' , '0' , '15' , '110.08' ) 16/10/2023 11:47: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 ( '88315' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 16/10/2023 11:47: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 ( '88315' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 16/10/2023 11:47: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 ( '88315' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 16/10/2023 11:50:26 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'IdEvUfAuYXDcIoRc' , NOW() , NOW() ) 16/10/2023 11:50:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4037' , '1' ) 16/10/2023 11:50:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4037' , '2' ) 16/10/2023 11:50:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4037' , '3' ) 16/10/2023 11:52:14 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4037' 16/10/2023 11:52:14 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 ( '4037' , '10' , '229' , '' , 'ZUMERLE' , 'ELISA ' , 'CONTRADA MONTE DI SOPRA 4' , '' , '37028' , 'SAN ROCCO ROVERE\' V.SE' , '' , '' , '3458247522' , '' , '' , NOW() , NOW() ) 16/10/2023 11:52:14 am >> UPDATE ps_customer SET email = 'zumerle.elisa@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4037' 16/10/2023 11:52:28 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4037' 16/10/2023 11:52:28 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 ( '4037' , '10' , '229' , '' , 'ZUMERLE' , 'ELISA ' , 'CONTRADA MONTE DI SOPRA 4' , '' , '37028' , 'SAN ROCCO ROVERE\' V.SE' , '' , '' , '3458247522' , '' , '' , NOW() , NOW() ) 16/10/2023 11:52:28 am >> UPDATE ps_customer SET email = 'zumerle.elisa@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4037' 16/10/2023 11:53:21 am >> SELECT document_num FROM ps_document WHERE document_num = '162' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:53: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 ( '21' , '162' , '2023-10-16' , '' , '4037' , '0' , '4679132' , 'CONTRADA MONTE DI SOPRA 4 37028 SAN ROCCO ROVERE\\\' V.SE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '33.50' , '33.50' , NOW() , NOW() ) 16/10/2023 11:53: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 = '88316' 16/10/2023 11:53:21 am >> DELETE FROM ps_document_detail WHERE id_document = '88316' 16/10/2023 11:53: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 ( '88316' , '8408' , 'PRENDETE E MANGIATE' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 16/10/2023 11:56:40 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'OomCuaaZ5Id6QYjD' , NOW() , NOW() ) 16/10/2023 11:56:40 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4038' , '1' ) 16/10/2023 11:56:40 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4038' , '2' ) 16/10/2023 11:56:40 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4038' , '3' ) 16/10/2023 11:58:23 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4038' 16/10/2023 11:58:23 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 ( '4038' , '10' , '137' , '' , 'MAROTTA' , 'ROBERTO' , 'VIA FAMATICCIA 1' , '' , '40034' , 'CASTEL D\'AIANO' , '' , '' , '3285756323' , '' , '' , NOW() , NOW() ) 16/10/2023 11:58:23 am >> UPDATE ps_customer SET email = 'robertoeugenio.marotta@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4038' 16/10/2023 11:59:03 am >> SELECT document_num FROM ps_document WHERE document_num = '163' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 11:59:03 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '163' , '2023-10-16' , '' , '4038' , '0' , '4679133' , 'VIA FAMATICCIA 1 40034 CASTEL D\\\'AIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '79.80' , '79.80' , NOW() , NOW() ) 16/10/2023 11:59:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88317' 16/10/2023 11:59:03 am >> DELETE FROM ps_document_detail WHERE id_document = '88317' 16/10/2023 11:59:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88317' , '12253' , 'MIO LIBRO DI PREGHIERE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '5' , '79.80' ) 16/10/2023 12:17:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '3179' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 12:17:53 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' , '3179' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.07' , NOW() , NOW() ) 16/10/2023 12:17:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88318' 16/10/2023 12:17:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '88318' 16/10/2023 12:17:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88318' , '4965' , 'IMMAGINE GIOVANNI XXIII' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 16/10/2023 12:17:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88318' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.50' ) 16/10/2023 12:25:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3180' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 12:25:35 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3180' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.00' , '60.95' , NOW() , NOW() ) 16/10/2023 12:25:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88319' 16/10/2023 12:25:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '88319' 16/10/2023 12:25:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88319' , '13313' , 'MARIA CHE SCIOGLIE I NODI - 401' , '3' , '-3' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '10.80' ) 16/10/2023 12:25:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88319' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 16/10/2023 12:25:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88319' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 16/10/2023 12:25:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88319' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' , '-1' , '1' , '11.7' , '9.5901639344262' , '22' , '0' , '11.70' ) 16/10/2023 12:29:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3181' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 12:29: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' , '3181' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.60' , '1.31' , NOW() , NOW() ) 16/10/2023 12:29: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 = '88320' 16/10/2023 12:29:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88320' 16/10/2023 12:29: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 ( '88320' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '2' , '-2' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '1.60' ) 16/10/2023 12:31:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 12:31:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3182' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.38' , NOW() , NOW() ) 16/10/2023 12:31:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88321' 16/10/2023 12:31:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '88321' 16/10/2023 12:31: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 ( '88321' , '12714' , 'IN COMPAGNIA DI UN RE - P. RISSO' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 16/10/2023 12:31: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 ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/10/2023 12:31: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 ( '88321' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/10/2023 03:40:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '164' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 03:40:02 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' , '164' , '2023-10-16' , '' , '364' , '0' , '4674529' , 'VIA LAGO LACENO 84098 PONTECAGNANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '297.65' , '295.94' , NOW() , NOW() ) 16/10/2023 03:40:02 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 = '88322' 16/10/2023 03:40:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '88322' 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '5457' , 'IO SONO CON VOI 1 PARTE' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '15' , '47.60' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '5458' , 'IO SONO CON VOI 2 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '11191' , 'VENITE CON ME 1 PARTE' , '30' , '-30' , '4' , '2.80' , '2.8' , '0' , '15' , '71.40' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '9.50' ) 16/10/2023 03:40:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88322' , '4120' , 'FEDE NELLO ZAINETTO' , '5' , '-5' , '4' , '6' , '6' , '0' , '15' , '25.50' ) 16/10/2023 04:01:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3183' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 04:01: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' , '3183' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '8.00' , NOW() , NOW() ) 16/10/2023 04:01: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 = '88323' 16/10/2023 04:01:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '88323' 16/10/2023 04:01: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 ( '88323' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 16/10/2023 04:51:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '88321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 04:51:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3182', document_date = '2023-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.00', price_tax_excluded = '9.38', date_upd = NOW() WHERE id_document = '88321' 16/10/2023 04:51: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 = '88321' 16/10/2023 04:51:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '88321' 16/10/2023 04:51: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 ( '88321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 16/10/2023 04:51: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 ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/10/2023 04:51: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 ( '88321' , '9137' , 'ROSARIO LEGNO CORDA - M14' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/10/2023 04:52:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '88321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 04:52:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3182', document_date = '2023-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '11.00', price_tax_excluded = '9.38', date_upd = NOW() WHERE id_document = '88321' 16/10/2023 04:52:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88321' 16/10/2023 04:52:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88321' 16/10/2023 04:52: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 ( '88321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 16/10/2023 04:52: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 ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/10/2023 04:52: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 ( '88321' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 16/10/2023 05:19:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3184' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 05:19:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3184' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.70' , '8.90' , NOW() , NOW() ) 16/10/2023 05:19:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88324' 16/10/2023 05:19:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88324' 16/10/2023 05:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88324' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/10/2023 05:19:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88324' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 16/10/2023 05:19:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '165' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 05:19:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '165' , '2023-10-16' , '' , '2312' , '0' , '4675584' , 'VIA SANT\\\'ANDREA 84081 ANTESSANO BARONISSI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '137.70' , '137.70' , NOW() , NOW() ) 16/10/2023 05:19: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 = '88325' 16/10/2023 05:19:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '88325' 16/10/2023 05:19: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 ( '88325' , '5457' , 'IO SONO CON VOI 1 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 16/10/2023 05:19: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 ( '88325' , '5458' , 'IO SONO CON VOI 2 PARTE' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 16/10/2023 05:19: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 ( '88325' , '4154' , 'FESTA DEL PERDONO' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '15' , '33.15' ) 16/10/2023 05:19: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 ( '88325' , '8408' , 'PRENDETE E MANGIATE' , '13' , '-13' , '4' , '3.00' , '3' , '0' , '15' , '33.15' ) 16/10/2023 05:24:51 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'XH0egzvEOz9xLf2H' , NOW() , NOW() ) 16/10/2023 05:24:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4039' , '1' ) 16/10/2023 05:24:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4039' , '2' ) 16/10/2023 05:24:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4039' , '3' ) 16/10/2023 05:26:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4039' 16/10/2023 05:26:23 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 ( '4039' , '10' , '174' , '' , 'GATTARI' , 'ARIANNA ' , 'VIA E. MATTEI 34' , '' , '62010' , 'MONTECOSARO' , '' , '' , '3281336376' , '' , '' , NOW() , NOW() ) 16/10/2023 05:26:23 pm >> UPDATE ps_customer SET email = 'a.gattari17@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4039' 16/10/2023 05:27:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '166' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 05:27:32 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' , '166' , '2023-10-16' , '' , '4039' , '0' , '4679134' , 'VIA E. MATTEI 34 62010 MONTECOSARO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '25.81' , '25.81' , NOW() , NOW() ) 16/10/2023 05:27:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88326' 16/10/2023 05:27:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88326' 16/10/2023 05:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88326' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/10/2023 05:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88326' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 16/10/2023 05:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88326' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '1' , '-1' , '4' , '3.40' , '3.4' , '0' , '5' , '3.23' ) 16/10/2023 05:27:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88326' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/10/2023 06:02:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '109/A' AND id_document != '88312' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 06:02:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '109/A', document_date = '2023-10-16', document_letter = 'A', id_customer = '1429', id_supplier = '', id_address = '4679117', address1 = 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '349.50', price_tax_excluded = '349.50', date_upd = NOW() WHERE id_document = '88312' 16/10/2023 06:02:22 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 = '88312' 16/10/2023 06:02:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88312' 16/10/2023 06:02: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 ( '88312' , '11540' , 'VOGLIAMO IL BATTESIMO PER NOSTRO FIGLIO' , '50' , '-50' , '4' , '2.0000' , '2' , '0' , '5' , '95.00' ) 16/10/2023 06:02: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 ( '88312' , '5757' , 'LEZIONARI KIT FERIALE' , '1' , '-1' , '4' , '150.0000' , '150' , '0' , '0' , '150.00' ) 16/10/2023 06:02: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 ( '88312' , '11193' , 'VENITE CON ME CAT.' , '20' , '-20' , '4' , '5.50' , '5.5' , '0' , '5' , '104.50' ) 16/10/2023 06:22:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3185' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 16/10/2023 06:22:38 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' , '3185' , '2023-10-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 16/10/2023 06:22:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88327' 16/10/2023 06:22:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88327' 16/10/2023 06:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88327' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/10/2023 06:22:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88327' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 16/10/2023 06:51:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 16/10/2023 06:51:32 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\n Franco portiere per corriere 3668670210 ' , '' , '3384440704' , '' , '92002190657' , NOW() , NOW() ) 16/10/2023 06:51:32 pm >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '0000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 16/10/2023 06:51:58 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3581' 16/10/2023 06:51:58 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 ( '3581' , '10' , '210' , 'DIOCESI DI TEGGIANO - POLICASTRO' , '' , '' , 'PIAZZA 4 NOVEMBRE' , '' , '84039' , 'TEGGIANO' , 'ordina don Antonio Calandriello\r\n Franco portiere per corriere 3668670210 ' , '' , '3384440704' , '' , '92002190657' , NOW() , NOW() ) 16/10/2023 06:51:58 pm >> UPDATE ps_customer SET email = 'economo@diocesiteggiano.it', sdi = '0000000', pec = 'diocesiteggiano@pec.it', date_upd = NOW() WHERE id_customer = '3581' 16/10/2023 06:52:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '47/E' AND id_document != '88275' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-13') 16/10/2023 06:52:03 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '47/E', document_date = '2023-10-13', document_letter = 'E', id_customer = '3581', id_supplier = '0', id_address = '4679135', address1 = 'PIAZZA 4 NOVEMBRE 84039 TEGGIANO', 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 = '1100.00', price_tax_excluded = '1100.00', date_upd = NOW() WHERE id_document = '88275' 16/10/2023 06:52:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '88275' 16/10/2023 06:52:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '88275' 16/10/2023 06:52:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88275' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '500' , '-500' , '4' , '2.2000' , '2.2' , '0' , '0' , '1100.00' ) 16/10/2023 06:55:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688740' AND id_product != '4120' AND ean13 != '' 16/10/2023 06:55:45 pm >> UPDATE ps_product SET id_supplier = '127', reference = '2/4', ean13 = '9788887688740', date_upd = NOW() WHERE id_product = '4120' 16/10/2023 06:55:45 pm >> UPDATE ps_product_lang SET name = 'FEDE NELLO ZAINETTO', description = '' WHERE id_product = '4120' 16/10/2023 06:55:45 pm >> UPDATE ps_product SET wholesale_price = '3.90', on_sale = '0', price = '6' WHERE id_product = '4120' 16/10/2023 06:55:45 pm >> UPDATE ps_product_shop SET wholesale_price = '3.90', price = '6', id_tax_rules_group = '4', id_category_default = '37', id_argoment_default = '21', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4120' 16/10/2023 06:55:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '4120'