mhyst

select iver_title, iver_content
from evo_items__version as a
where a.iver_edit_datetime = (select max(iver_edit_datetime) from evo_items__version as b where b.iver_itm_ID = a.iver_itm_ID)
order by a.iver_edit_datetime

mhyst

CREATE TABLE `evo_items__version` (
  `iver_ID` int(10) NOT NULL,
  `iver_itm_ID` int(10) NOT NULL,
  `iver_edit_user_ID` int(10) DEFAULT NULL,
  `iver_edit_datetime` datetime NOT NULL,
  `iver_status`  DEFAULT NULL,
  `iver_title` text,
  `iver_content` mediumtext
);

mhyst

CREATE TABLE IF NOT EXISTS `evo_items__version` (
  `iver_ID` int(10) unsigned NOT NULL,
  `iver_itm_ID` int(10) unsigned NOT NULL,
  `iver_edit_user_ID` int(10) unsigned DEFAULT NULL,
  `iver_edit_datetime` datetime NOT NULL,
  `iver_status` enum('published','community','deprecated','protected','private','review','draft','redirected') DEFAULT NULL,
  `iver_title` text,
  `iver_content` mediumtext,
  KEY `iver_ID_itm_ID` (`iver_ID`,`iver_itm_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

mhyst

#!/bin/bash
#Subir articulos antiguos de la base de datos a blogger

source /home/mhyst/bin/scripts/blogger/database

declare -A ARTICULO

#@ film.parse datos (Formato: (id|titulo|fichero|torrent|esserie|esvisto|esdescargado))
function parse() {
	local datos="$1"

mhyst

Keybase proof

I hereby claim:

• I am mhyst on github.
• I am mhyst (https://keybase.io/mhyst) on keybase.
• I have a public key ASCfCYFiUfxiAVELqMRHSXcWKzLXdqwL5Q1J3st8DrmISQo

To claim this, I am signing this object: