{"id":854,"date":"2020-04-17T00:06:42","date_gmt":"2020-04-16T22:06:42","guid":{"rendered":"http:\/\/www.joanillo.org\/?p=854"},"modified":"2020-10-14T00:07:20","modified_gmt":"2020-10-13T22:07:20","slug":"actividad-en-la-wiki-y-en-blog-durante-la-covid-19","status":"publish","type":"post","link":"https:\/\/www.joanillo.org\/?p=854&lang=es","title":{"rendered":"Actividad en la wiki y en blog durante la COVID-19"},"content":{"rendered":"<p><a href=\"http:\/\/www.joanillo.org\/wp-content\/uploads\/2020\/04\/covid19_confinement1.jpg\"><img loading=\"lazy\" src=\"http:\/\/www.joanillo.org\/wp-content\/uploads\/2020\/04\/covid19_confinement1-300x164.jpg\" alt=\"\" title=\"covid19_confinement\" width=\"300\" height=\"164\" class=\"alignright size-medium wp-image-2311\"><\/a>Durante este tiempo de confinamiento se ha trabajado mucho en casa con el teletrabajo, cosas del instituto y cosas m\u00edas. Haciendo una consulta mysql a la <strong>wiki<\/strong> y al <strong>wordpress<\/strong> se puede saber f\u00e1cilmente en qu\u00e9 he estado trabajando durante estos d\u00edas.<\/p>\n<p>En la wiki, <a href=\"http:\/\/wiki.joanillo.org\" title=\"wikijoan\" target=\"_blank\" rel=\"noopener noreferrer\">wiki.joanillo.org<\/a>:<\/p>\n<pre>mysql&gt; select distinct page_title 'COVID-19 editons' from page, revision where page_id=rev_page and rev_timestamp &gt;= '20200313%' and page_namespace=0;\n+--------------------------------------------------------------------+\n| COVID-19 editons                                                   |\n+--------------------------------------------------------------------+\n| Llibres_electr\u00f2nics_i_l'editor_Sublime_Text2._Convertir_pdf_a_txt |\n| Esgl\u00e9sies_rom\u00e0niques_de_Catalunya                                |\n| Aplicaci\u00f3_web_amb_motor_Python                                    |\n| P\u00e0gina_principal                                                  |\n| Mapes_medievals,_mapes_ficticis,_mapes_de_fantasia                 |\n| Fusionar_GeoJSON                                                   |\n| Opendata-barcelona                                                 |\n| Openlayers:_ol_package._Exemple_Casa_de_Papel                      |\n| DAW-M06-WEC                                                        |\n| React:_A_JavaScript_library_for_building_user_interfaces           |\n| JQuery:_Tablesorter                                                |\n| React_Native                                                       |\n| Github_pr\u00e0ctic:_control_de_versions                               |\n| Desplegar_un_projecte_web_amb_Express_i_Heroku                     |\n| Aplicaci\u00f3_Reactjs_a_trav\u00e9s_del_servidor_web_Express              |\n| Openlayers_amb_ReactJS                                             |\n| ReactJS._Curs_EdX._Introduction_to_ReactJS._Microsoft:_DEV281x     |\n| Curriculum_Vitae_Joan_Quintana_Compte                              |\n| Introducci\u00f3_als_frameworks_de_Javascript                          |\n| React_CRUD_tutorial                                                |\n| Exemples_Openlayers_(ol_package)                                   |\n+--------------------------------------------------------------------+\n21 rows in set (0.00 sec)\n<\/pre>\n<p>En el blog, a <a href=\"http:\/\/www.joanillo.org\" title=\"bloc joanillo.org\" target=\"_blank\" rel=\"noopener noreferrer\">www.joanillo.org<\/a>:<\/p>\n<pre>select post_title from wp_posts where post_modified &gt;= '2020-03-13%' and post_type='post' and post_parent=0\n\nGeovisualitzaci\u00f3 de la COVID-19\nEsgl\u00e9sies rom\u00e0niques\nVegueries\/regions de Catalunya. Densitat de poblaci\u00f3\nLa Casa de Papel: aplicaci\u00f3 web\nJohn H. Conway. Joc de la Vida\nIntroducci\u00f3 a ReactJS: DEV281x\n<\/pre>\n<p>De momento es esto, porque desgraciadamente el confinamiento contin\u00faa.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Durante este tiempo de confinamiento se ha trabajado mucho en casa con el teletrabajo, cosas del instituto y cosas m\u00edas. Haciendo una consulta mysql a la wiki y al wordpress se puede saber f\u00e1cilmente en qu\u00e9 he estado trabajando durante estos d\u00edas. En la wiki, wiki.joanillo.org: mysql&gt; select distinct page_title &#8216;COVID-19 editons&#8217; from page, revision [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[304,314,324,320],"tags":[],"_links":{"self":[{"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/posts\/854"}],"collection":[{"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=854"}],"version-history":[{"count":1,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":855,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=\/wp\/v2\/posts\/854\/revisions\/855"}],"wp:attachment":[{"href":"https:\/\/www.joanillo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.joanillo.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}