#Handle: Resource id #6 #Path: /data/project/templatetiger/public_html/dumps/

#.


#Date: # DB: sk:
# DB: sk:

#..


#Date: # DB: sk:
# DB: sk:

#arzwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `arzwiki_old`; DROP TABLE IF EXISTS `arzwiki_sum_old`; DROP TABLE IF EXISTS `arzwiki_para_old`;
DROP TABLE IF EXISTS `arzwiki_neu`; DROP TABLE IF EXISTS `arzwiki_sum_neu`; DROP TABLE IF EXISTS `arzwiki_para_neu`;

CREATE TABLE `arzwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/arzwiki-2018-12-01.txt' IGNORE INTO TABLE `arzwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `arzwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `arzwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `arzwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `arzwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `arzwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `arzwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `arzwiki` to `arzwiki_old`, `arzwiki_sum` to `arzwiki_sum_old`,`arzwiki_para` to `arzwiki_para_old`;RENAME TABLE `arzwiki_neu` to `arzwiki`, `arzwiki_sum_neu` to `arzwiki_sum`,`arzwiki_para_neu` to `arzwiki_para`;

DROP TABLE IF EXISTS `arzwiki_old`; DROP TABLE IF EXISTS `arzwiki_sum_old`; DROP TABLE IF EXISTS `arzwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'arzwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('arzwiki', '20181201',(SELECT sum(`sum`) FROM `arzwiki_sum` ),'20170501');
SELECT "arzwiki",current_date,current_time;

#arwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `arwiki_old`; DROP TABLE IF EXISTS `arwiki_sum_old`; DROP TABLE IF EXISTS `arwiki_para_old`;
DROP TABLE IF EXISTS `arwiki_neu`; DROP TABLE IF EXISTS `arwiki_sum_neu`; DROP TABLE IF EXISTS `arwiki_para_neu`;

CREATE TABLE `arwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/arwiki-2018-12-01.txt' IGNORE INTO TABLE `arwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `arwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `arwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `arwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `arwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `arwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `arwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `arwiki` to `arwiki_old`, `arwiki_sum` to `arwiki_sum_old`,`arwiki_para` to `arwiki_para_old`;RENAME TABLE `arwiki_neu` to `arwiki`, `arwiki_sum_neu` to `arwiki_sum`,`arwiki_para_neu` to `arwiki_para`;

DROP TABLE IF EXISTS `arwiki_old`; DROP TABLE IF EXISTS `arwiki_sum_old`; DROP TABLE IF EXISTS `arwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'arwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('arwiki', '20181201',(SELECT sum(`sum`) FROM `arwiki_sum` ),'20170501');
SELECT "arwiki",current_date,current_time;

#skwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `skwiki_old`; DROP TABLE IF EXISTS `skwiki_sum_old`; DROP TABLE IF EXISTS `skwiki_para_old`;
DROP TABLE IF EXISTS `skwiki_neu`; DROP TABLE IF EXISTS `skwiki_sum_neu`; DROP TABLE IF EXISTS `skwiki_para_neu`;

CREATE TABLE `skwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/skwiki-2018-12-01.txt' IGNORE INTO TABLE `skwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `skwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `skwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `skwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `skwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `skwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `skwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `skwiki` to `skwiki_old`, `skwiki_sum` to `skwiki_sum_old`,`skwiki_para` to `skwiki_para_old`;RENAME TABLE `skwiki_neu` to `skwiki`, `skwiki_sum_neu` to `skwiki_sum`,`skwiki_para_neu` to `skwiki_para`;

DROP TABLE IF EXISTS `skwiki_old`; DROP TABLE IF EXISTS `skwiki_sum_old`; DROP TABLE IF EXISTS `skwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'skwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('skwiki', '20181201',(SELECT sum(`sum`) FROM `skwiki_sum` ),'20170501');
SELECT "skwiki",current_date,current_time;

#jawiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `jawiki_old`; DROP TABLE IF EXISTS `jawiki_sum_old`; DROP TABLE IF EXISTS `jawiki_para_old`;
DROP TABLE IF EXISTS `jawiki_neu`; DROP TABLE IF EXISTS `jawiki_sum_neu`; DROP TABLE IF EXISTS `jawiki_para_neu`;

CREATE TABLE `jawiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/jawiki-2018-12-01.txt' IGNORE INTO TABLE `jawiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `jawiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `jawiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `jawiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `jawiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `jawiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `jawiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `jawiki` to `jawiki_old`, `jawiki_sum` to `jawiki_sum_old`,`jawiki_para` to `jawiki_para_old`;RENAME TABLE `jawiki_neu` to `jawiki`, `jawiki_sum_neu` to `jawiki_sum`,`jawiki_para_neu` to `jawiki_para`;

DROP TABLE IF EXISTS `jawiki_old`; DROP TABLE IF EXISTS `jawiki_sum_old`; DROP TABLE IF EXISTS `jawiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'jawiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('jawiki', '20181201',(SELECT sum(`sum`) FROM `jawiki_sum` ),'20170901');
SELECT "jawiki",current_date,current_time;

#ruwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `ruwiki_old`; DROP TABLE IF EXISTS `ruwiki_sum_old`; DROP TABLE IF EXISTS `ruwiki_para_old`;
DROP TABLE IF EXISTS `ruwiki_neu`; DROP TABLE IF EXISTS `ruwiki_sum_neu`; DROP TABLE IF EXISTS `ruwiki_para_neu`;

CREATE TABLE `ruwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/ruwiki-2018-12-01.txt' IGNORE INTO TABLE `ruwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `ruwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `ruwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `ruwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `ruwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `ruwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `ruwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `ruwiki` to `ruwiki_old`, `ruwiki_sum` to `ruwiki_sum_old`,`ruwiki_para` to `ruwiki_para_old`;RENAME TABLE `ruwiki_neu` to `ruwiki`, `ruwiki_sum_neu` to `ruwiki_sum`,`ruwiki_para_neu` to `ruwiki_para`;

DROP TABLE IF EXISTS `ruwiki_old`; DROP TABLE IF EXISTS `ruwiki_sum_old`; DROP TABLE IF EXISTS `ruwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'ruwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('ruwiki', '20181201',(SELECT sum(`sum`) FROM `ruwiki_sum` ),'20170501');
SELECT "ruwiki",current_date,current_time;

#frwikiversity-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `frwikiversity_old`; DROP TABLE IF EXISTS `frwikiversity_sum_old`; DROP TABLE IF EXISTS `frwikiversity_para_old`;
DROP TABLE IF EXISTS `frwikiversity_neu`; DROP TABLE IF EXISTS `frwikiversity_sum_neu`; DROP TABLE IF EXISTS `frwikiversity_para_neu`;

CREATE TABLE `frwikiversity_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/frwikiversity-2018-12-01.txt' IGNORE INTO TABLE `frwikiversity_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `frwikiversity_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `frwikiversity_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `frwikiversity_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `frwikiversity_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `frwikiversity_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `frwikiversity_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `frwikiversity` to `frwikiversity_old`, `frwikiversity_sum` to `frwikiversity_sum_old`,`frwikiversity_para` to `frwikiversity_para_old`;RENAME TABLE `frwikiversity_neu` to `frwikiversity`, `frwikiversity_sum_neu` to `frwikiversity_sum`,`frwikiversity_para_neu` to `frwikiversity_para`;

DROP TABLE IF EXISTS `frwikiversity_old`; DROP TABLE IF EXISTS `frwikiversity_sum_old`; DROP TABLE IF EXISTS `frwikiversity_para_old`;

DELETE FROM `info` WHERE `lang` = 'frwikiversity' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('frwikiversity', '20181201',(SELECT sum(`sum`) FROM `frwikiversity_sum` ),'20170501');
SELECT "frwikiversity",current_date,current_time;

#urwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `urwiki_old`; DROP TABLE IF EXISTS `urwiki_sum_old`; DROP TABLE IF EXISTS `urwiki_para_old`;
DROP TABLE IF EXISTS `urwiki_neu`; DROP TABLE IF EXISTS `urwiki_sum_neu`; DROP TABLE IF EXISTS `urwiki_para_neu`;

CREATE TABLE `urwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/urwiki-2018-12-01.txt' IGNORE INTO TABLE `urwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `urwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `urwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `urwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `urwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `urwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `urwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `urwiki` to `urwiki_old`, `urwiki_sum` to `urwiki_sum_old`,`urwiki_para` to `urwiki_para_old`;RENAME TABLE `urwiki_neu` to `urwiki`, `urwiki_sum_neu` to `urwiki_sum`,`urwiki_para_neu` to `urwiki_para`;

DROP TABLE IF EXISTS `urwiki_old`; DROP TABLE IF EXISTS `urwiki_sum_old`; DROP TABLE IF EXISTS `urwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'urwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('urwiki', '20181201',(SELECT sum(`sum`) FROM `urwiki_sum` ),'20170501');
SELECT "urwiki",current_date,current_time;

#ptwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `ptwiki_old`; DROP TABLE IF EXISTS `ptwiki_sum_old`; DROP TABLE IF EXISTS `ptwiki_para_old`;
DROP TABLE IF EXISTS `ptwiki_neu`; DROP TABLE IF EXISTS `ptwiki_sum_neu`; DROP TABLE IF EXISTS `ptwiki_para_neu`;

CREATE TABLE `ptwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/ptwiki-2018-12-01.txt' IGNORE INTO TABLE `ptwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `ptwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `ptwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `ptwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `ptwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `ptwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `ptwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `ptwiki` to `ptwiki_old`, `ptwiki_sum` to `ptwiki_sum_old`,`ptwiki_para` to `ptwiki_para_old`;RENAME TABLE `ptwiki_neu` to `ptwiki`, `ptwiki_sum_neu` to `ptwiki_sum`,`ptwiki_para_neu` to `ptwiki_para`;

DROP TABLE IF EXISTS `ptwiki_old`; DROP TABLE IF EXISTS `ptwiki_sum_old`; DROP TABLE IF EXISTS `ptwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'ptwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('ptwiki', '20181201',(SELECT sum(`sum`) FROM `ptwiki_sum` ),'20170501');
SELECT "ptwiki",current_date,current_time;

#eswiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `eswiki_old`; DROP TABLE IF EXISTS `eswiki_sum_old`; DROP TABLE IF EXISTS `eswiki_para_old`;
DROP TABLE IF EXISTS `eswiki_neu`; DROP TABLE IF EXISTS `eswiki_sum_neu`; DROP TABLE IF EXISTS `eswiki_para_neu`;

CREATE TABLE `eswiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/eswiki-2018-12-01.txt' IGNORE INTO TABLE `eswiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `eswiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `eswiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `eswiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `eswiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `eswiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `eswiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `eswiki` to `eswiki_old`, `eswiki_sum` to `eswiki_sum_old`,`eswiki_para` to `eswiki_para_old`;RENAME TABLE `eswiki_neu` to `eswiki`, `eswiki_sum_neu` to `eswiki_sum`,`eswiki_para_neu` to `eswiki_para`;

DROP TABLE IF EXISTS `eswiki_old`; DROP TABLE IF EXISTS `eswiki_sum_old`; DROP TABLE IF EXISTS `eswiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'eswiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('eswiki', '20181201',(SELECT sum(`sum`) FROM `eswiki_sum` ),'20170501');
SELECT "eswiki",current_date,current_time;

#hrwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `hrwiki_old`; DROP TABLE IF EXISTS `hrwiki_sum_old`; DROP TABLE IF EXISTS `hrwiki_para_old`;
DROP TABLE IF EXISTS `hrwiki_neu`; DROP TABLE IF EXISTS `hrwiki_sum_neu`; DROP TABLE IF EXISTS `hrwiki_para_neu`;

CREATE TABLE `hrwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/hrwiki-2018-12-01.txt' IGNORE INTO TABLE `hrwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `hrwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `hrwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `hrwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `hrwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `hrwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `hrwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `hrwiki` to `hrwiki_old`, `hrwiki_sum` to `hrwiki_sum_old`,`hrwiki_para` to `hrwiki_para_old`;RENAME TABLE `hrwiki_neu` to `hrwiki`, `hrwiki_sum_neu` to `hrwiki_sum`,`hrwiki_para_neu` to `hrwiki_para`;

DROP TABLE IF EXISTS `hrwiki_old`; DROP TABLE IF EXISTS `hrwiki_sum_old`; DROP TABLE IF EXISTS `hrwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'hrwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('hrwiki', '20181201',(SELECT sum(`sum`) FROM `hrwiki_sum` ),'20170501');
SELECT "hrwiki",current_date,current_time;

#pdcwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `pdcwiki_old`; DROP TABLE IF EXISTS `pdcwiki_sum_old`; DROP TABLE IF EXISTS `pdcwiki_para_old`;
DROP TABLE IF EXISTS `pdcwiki_neu`; DROP TABLE IF EXISTS `pdcwiki_sum_neu`; DROP TABLE IF EXISTS `pdcwiki_para_neu`;

CREATE TABLE `pdcwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/pdcwiki-2018-12-01.txt' IGNORE INTO TABLE `pdcwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `pdcwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `pdcwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `pdcwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `pdcwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `pdcwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `pdcwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `pdcwiki` to `pdcwiki_old`, `pdcwiki_sum` to `pdcwiki_sum_old`,`pdcwiki_para` to `pdcwiki_para_old`;RENAME TABLE `pdcwiki_neu` to `pdcwiki`, `pdcwiki_sum_neu` to `pdcwiki_sum`,`pdcwiki_para_neu` to `pdcwiki_para`;

DROP TABLE IF EXISTS `pdcwiki_old`; DROP TABLE IF EXISTS `pdcwiki_sum_old`; DROP TABLE IF EXISTS `pdcwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'pdcwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('pdcwiki', '20181201',(SELECT sum(`sum`) FROM `pdcwiki_sum` ),'20170501');
SELECT "pdcwiki",current_date,current_time;

#plwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `plwiki_old`; DROP TABLE IF EXISTS `plwiki_sum_old`; DROP TABLE IF EXISTS `plwiki_para_old`;
DROP TABLE IF EXISTS `plwiki_neu`; DROP TABLE IF EXISTS `plwiki_sum_neu`; DROP TABLE IF EXISTS `plwiki_para_neu`;

CREATE TABLE `plwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/plwiki-2018-12-01.txt' IGNORE INTO TABLE `plwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `plwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `plwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `plwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `plwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `plwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `plwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `plwiki` to `plwiki_old`, `plwiki_sum` to `plwiki_sum_old`,`plwiki_para` to `plwiki_para_old`;RENAME TABLE `plwiki_neu` to `plwiki`, `plwiki_sum_neu` to `plwiki_sum`,`plwiki_para_neu` to `plwiki_para`;

DROP TABLE IF EXISTS `plwiki_old`; DROP TABLE IF EXISTS `plwiki_sum_old`; DROP TABLE IF EXISTS `plwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'plwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('plwiki', '20181201',(SELECT sum(`sum`) FROM `plwiki_sum` ),'20170501');
SELECT "plwiki",current_date,current_time;

#cswiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `cswiki_old`; DROP TABLE IF EXISTS `cswiki_sum_old`; DROP TABLE IF EXISTS `cswiki_para_old`;
DROP TABLE IF EXISTS `cswiki_neu`; DROP TABLE IF EXISTS `cswiki_sum_neu`; DROP TABLE IF EXISTS `cswiki_para_neu`;

CREATE TABLE `cswiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/cswiki-2018-12-01.txt' IGNORE INTO TABLE `cswiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `cswiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `cswiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `cswiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `cswiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `cswiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `cswiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `cswiki` to `cswiki_old`, `cswiki_sum` to `cswiki_sum_old`,`cswiki_para` to `cswiki_para_old`;RENAME TABLE `cswiki_neu` to `cswiki`, `cswiki_sum_neu` to `cswiki_sum`,`cswiki_para_neu` to `cswiki_para`;

DROP TABLE IF EXISTS `cswiki_old`; DROP TABLE IF EXISTS `cswiki_sum_old`; DROP TABLE IF EXISTS `cswiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'cswiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('cswiki', '20181201',(SELECT sum(`sum`) FROM `cswiki_sum` ),'20170901');
SELECT "cswiki",current_date,current_time;

#dewikisource-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `dewikisource_old`; DROP TABLE IF EXISTS `dewikisource_sum_old`; DROP TABLE IF EXISTS `dewikisource_para_old`;
DROP TABLE IF EXISTS `dewikisource_neu`; DROP TABLE IF EXISTS `dewikisource_sum_neu`; DROP TABLE IF EXISTS `dewikisource_para_neu`;

CREATE TABLE `dewikisource_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/dewikisource-2018-12-01.txt' IGNORE INTO TABLE `dewikisource_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `dewikisource_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `dewikisource_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `dewikisource_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `dewikisource_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `dewikisource_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `dewikisource_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `dewikisource` to `dewikisource_old`, `dewikisource_sum` to `dewikisource_sum_old`,`dewikisource_para` to `dewikisource_para_old`;RENAME TABLE `dewikisource_neu` to `dewikisource`, `dewikisource_sum_neu` to `dewikisource_sum`,`dewikisource_para_neu` to `dewikisource_para`;

DROP TABLE IF EXISTS `dewikisource_old`; DROP TABLE IF EXISTS `dewikisource_sum_old`; DROP TABLE IF EXISTS `dewikisource_para_old`;

DELETE FROM `info` WHERE `lang` = 'dewikisource' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('dewikisource', '20181201',(SELECT sum(`sum`) FROM `dewikisource_sum` ),'20170501');
SELECT "dewikisource",current_date,current_time;

#lawiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `lawiki_old`; DROP TABLE IF EXISTS `lawiki_sum_old`; DROP TABLE IF EXISTS `lawiki_para_old`;
DROP TABLE IF EXISTS `lawiki_neu`; DROP TABLE IF EXISTS `lawiki_sum_neu`; DROP TABLE IF EXISTS `lawiki_para_neu`;

CREATE TABLE `lawiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/lawiki-2018-12-01.txt' IGNORE INTO TABLE `lawiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `lawiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `lawiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `lawiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `lawiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `lawiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `lawiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `lawiki` to `lawiki_old`, `lawiki_sum` to `lawiki_sum_old`,`lawiki_para` to `lawiki_para_old`;RENAME TABLE `lawiki_neu` to `lawiki`, `lawiki_sum_neu` to `lawiki_sum`,`lawiki_para_neu` to `lawiki_para`;

DROP TABLE IF EXISTS `lawiki_old`; DROP TABLE IF EXISTS `lawiki_sum_old`; DROP TABLE IF EXISTS `lawiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'lawiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('lawiki', '20181201',(SELECT sum(`sum`) FROM `lawiki_sum` ),'20170501');
SELECT "lawiki",current_date,current_time;

#scowiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `scowiki_old`; DROP TABLE IF EXISTS `scowiki_sum_old`; DROP TABLE IF EXISTS `scowiki_para_old`;
DROP TABLE IF EXISTS `scowiki_neu`; DROP TABLE IF EXISTS `scowiki_sum_neu`; DROP TABLE IF EXISTS `scowiki_para_neu`;

CREATE TABLE `scowiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/scowiki-2018-12-01.txt' IGNORE INTO TABLE `scowiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `scowiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `scowiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `scowiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `scowiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `scowiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `scowiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `scowiki` to `scowiki_old`, `scowiki_sum` to `scowiki_sum_old`,`scowiki_para` to `scowiki_para_old`;RENAME TABLE `scowiki_neu` to `scowiki`, `scowiki_sum_neu` to `scowiki_sum`,`scowiki_para_neu` to `scowiki_para`;

DROP TABLE IF EXISTS `scowiki_old`; DROP TABLE IF EXISTS `scowiki_sum_old`; DROP TABLE IF EXISTS `scowiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'scowiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('scowiki', '20181201',(SELECT sum(`sum`) FROM `scowiki_sum` ),'20170501');
SELECT "scowiki",current_date,current_time;

#barwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `barwiki_old`; DROP TABLE IF EXISTS `barwiki_sum_old`; DROP TABLE IF EXISTS `barwiki_para_old`;
DROP TABLE IF EXISTS `barwiki_neu`; DROP TABLE IF EXISTS `barwiki_sum_neu`; DROP TABLE IF EXISTS `barwiki_para_neu`;

CREATE TABLE `barwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/barwiki-2018-12-01.txt' IGNORE INTO TABLE `barwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `barwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `barwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `barwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `barwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `barwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `barwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `barwiki` to `barwiki_old`, `barwiki_sum` to `barwiki_sum_old`,`barwiki_para` to `barwiki_para_old`;RENAME TABLE `barwiki_neu` to `barwiki`, `barwiki_sum_neu` to `barwiki_sum`,`barwiki_para_neu` to `barwiki_para`;

DROP TABLE IF EXISTS `barwiki_old`; DROP TABLE IF EXISTS `barwiki_sum_old`; DROP TABLE IF EXISTS `barwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'barwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('barwiki', '20181201',(SELECT sum(`sum`) FROM `barwiki_sum` ),'20170501');
SELECT "barwiki",current_date,current_time;

#idwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `idwiki_old`; DROP TABLE IF EXISTS `idwiki_sum_old`; DROP TABLE IF EXISTS `idwiki_para_old`;
DROP TABLE IF EXISTS `idwiki_neu`; DROP TABLE IF EXISTS `idwiki_sum_neu`; DROP TABLE IF EXISTS `idwiki_para_neu`;

CREATE TABLE `idwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/idwiki-2018-12-01.txt' IGNORE INTO TABLE `idwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `idwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `idwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `idwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `idwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `idwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `idwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `idwiki` to `idwiki_old`, `idwiki_sum` to `idwiki_sum_old`,`idwiki_para` to `idwiki_para_old`;RENAME TABLE `idwiki_neu` to `idwiki`, `idwiki_sum_neu` to `idwiki_sum`,`idwiki_para_neu` to `idwiki_para`;

DROP TABLE IF EXISTS `idwiki_old`; DROP TABLE IF EXISTS `idwiki_sum_old`; DROP TABLE IF EXISTS `idwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'idwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('idwiki', '20181201',(SELECT sum(`sum`) FROM `idwiki_sum` ),'20170501');
SELECT "idwiki",current_date,current_time;

#cywiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `cywiki_old`; DROP TABLE IF EXISTS `cywiki_sum_old`; DROP TABLE IF EXISTS `cywiki_para_old`;
DROP TABLE IF EXISTS `cywiki_neu`; DROP TABLE IF EXISTS `cywiki_sum_neu`; DROP TABLE IF EXISTS `cywiki_para_neu`;

CREATE TABLE `cywiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/cywiki-2018-12-01.txt' IGNORE INTO TABLE `cywiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `cywiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `cywiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `cywiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `cywiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `cywiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `cywiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `cywiki` to `cywiki_old`, `cywiki_sum` to `cywiki_sum_old`,`cywiki_para` to `cywiki_para_old`;RENAME TABLE `cywiki_neu` to `cywiki`, `cywiki_sum_neu` to `cywiki_sum`,`cywiki_para_neu` to `cywiki_para`;

DROP TABLE IF EXISTS `cywiki_old`; DROP TABLE IF EXISTS `cywiki_sum_old`; DROP TABLE IF EXISTS `cywiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'cywiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('cywiki', '20181201',(SELECT sum(`sum`) FROM `cywiki_sum` ),'20170501');
SELECT "cywiki",current_date,current_time;

#iswiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `iswiki_old`; DROP TABLE IF EXISTS `iswiki_sum_old`; DROP TABLE IF EXISTS `iswiki_para_old`;
DROP TABLE IF EXISTS `iswiki_neu`; DROP TABLE IF EXISTS `iswiki_sum_neu`; DROP TABLE IF EXISTS `iswiki_para_neu`;

CREATE TABLE `iswiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/iswiki-2018-12-01.txt' IGNORE INTO TABLE `iswiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `iswiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `iswiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `iswiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `iswiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `iswiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `iswiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `iswiki` to `iswiki_old`, `iswiki_sum` to `iswiki_sum_old`,`iswiki_para` to `iswiki_para_old`;RENAME TABLE `iswiki_neu` to `iswiki`, `iswiki_sum_neu` to `iswiki_sum`,`iswiki_para_neu` to `iswiki_para`;

DROP TABLE IF EXISTS `iswiki_old`; DROP TABLE IF EXISTS `iswiki_sum_old`; DROP TABLE IF EXISTS `iswiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'iswiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('iswiki', '20181201',(SELECT sum(`sum`) FROM `iswiki_sum` ),'20170501');
SELECT "iswiki",current_date,current_time;

#frwikivoyage-2018-12-01.txt


#Date: 20181201# DB: sk: 20181201
# DB: sk: 20181201
DROP TABLE IF EXISTS `frwikivoyage_old`; DROP TABLE IF EXISTS `frwikivoyage_sum_old`; DROP TABLE IF EXISTS `frwikivoyage_para_old`;
DROP TABLE IF EXISTS `frwikivoyage_neu`; DROP TABLE IF EXISTS `frwikivoyage_sum_neu`; DROP TABLE IF EXISTS `frwikivoyage_para_neu`;

CREATE TABLE `frwikivoyage_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/frwikivoyage-2018-12-01.txt' IGNORE INTO TABLE `frwikivoyage_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `frwikivoyage_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `frwikivoyage_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `frwikivoyage_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `frwikivoyage_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `frwikivoyage_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `frwikivoyage_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `frwikivoyage_neu` to `frwikivoyage`, `frwikivoyage_sum_neu` to `frwikivoyage_sum`,`frwikivoyage_para_neu` to `frwikivoyage_para`;

DROP TABLE IF EXISTS `frwikivoyage_old`; DROP TABLE IF EXISTS `frwikivoyage_sum_old`; DROP TABLE IF EXISTS `frwikivoyage_para_old`;

DELETE FROM `info` WHERE `lang` = 'frwikivoyage' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('frwikivoyage', '20181201',(SELECT sum(`sum`) FROM `frwikivoyage_sum` ),'');
SELECT "frwikivoyage",current_date,current_time;

#frwiktionary-2018-12-01.txt


#Date: 20181201# DB: sk: 20181201
# DB: sk: 20181201
DROP TABLE IF EXISTS `frwiktionary_old`; DROP TABLE IF EXISTS `frwiktionary_sum_old`; DROP TABLE IF EXISTS `frwiktionary_para_old`;
DROP TABLE IF EXISTS `frwiktionary_neu`; DROP TABLE IF EXISTS `frwiktionary_sum_neu`; DROP TABLE IF EXISTS `frwiktionary_para_neu`;

CREATE TABLE `frwiktionary_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/frwiktionary-2018-12-01.txt' IGNORE INTO TABLE `frwiktionary_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `frwiktionary_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `frwiktionary_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `frwiktionary_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `frwiktionary_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `frwiktionary_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `frwiktionary_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `frwiktionary_neu` to `frwiktionary`, `frwiktionary_sum_neu` to `frwiktionary_sum`,`frwiktionary_para_neu` to `frwiktionary_para`;

DROP TABLE IF EXISTS `frwiktionary_old`; DROP TABLE IF EXISTS `frwiktionary_sum_old`; DROP TABLE IF EXISTS `frwiktionary_para_old`;

DELETE FROM `info` WHERE `lang` = 'frwiktionary' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('frwiktionary', '20181201',(SELECT sum(`sum`) FROM `frwiktionary_sum` ),'');
SELECT "frwiktionary",current_date,current_time;

#fiwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `fiwiki_old`; DROP TABLE IF EXISTS `fiwiki_sum_old`; DROP TABLE IF EXISTS `fiwiki_para_old`;
DROP TABLE IF EXISTS `fiwiki_neu`; DROP TABLE IF EXISTS `fiwiki_sum_neu`; DROP TABLE IF EXISTS `fiwiki_para_neu`;

CREATE TABLE `fiwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/fiwiki-2018-12-01.txt' IGNORE INTO TABLE `fiwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `fiwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `fiwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `fiwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `fiwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `fiwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `fiwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `fiwiki` to `fiwiki_old`, `fiwiki_sum` to `fiwiki_sum_old`,`fiwiki_para` to `fiwiki_para_old`;RENAME TABLE `fiwiki_neu` to `fiwiki`, `fiwiki_sum_neu` to `fiwiki_sum`,`fiwiki_para_neu` to `fiwiki_para`;

DROP TABLE IF EXISTS `fiwiki_old`; DROP TABLE IF EXISTS `fiwiki_sum_old`; DROP TABLE IF EXISTS `fiwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'fiwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('fiwiki', '20181201',(SELECT sum(`sum`) FROM `fiwiki_sum` ),'20170501');
SELECT "fiwiki",current_date,current_time;

#dawiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `dawiki_old`; DROP TABLE IF EXISTS `dawiki_sum_old`; DROP TABLE IF EXISTS `dawiki_para_old`;
DROP TABLE IF EXISTS `dawiki_neu`; DROP TABLE IF EXISTS `dawiki_sum_neu`; DROP TABLE IF EXISTS `dawiki_para_neu`;

CREATE TABLE `dawiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/dawiki-2018-12-01.txt' IGNORE INTO TABLE `dawiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `dawiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `dawiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `dawiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `dawiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `dawiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `dawiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `dawiki` to `dawiki_old`, `dawiki_sum` to `dawiki_sum_old`,`dawiki_para` to `dawiki_para_old`;RENAME TABLE `dawiki_neu` to `dawiki`, `dawiki_sum_neu` to `dawiki_sum`,`dawiki_para_neu` to `dawiki_para`;

DROP TABLE IF EXISTS `dawiki_old`; DROP TABLE IF EXISTS `dawiki_sum_old`; DROP TABLE IF EXISTS `dawiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'dawiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('dawiki', '20181201',(SELECT sum(`sum`) FROM `dawiki_sum` ),'20170501');
SELECT "dawiki",current_date,current_time;

#svwiktionary-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `svwiktionary_old`; DROP TABLE IF EXISTS `svwiktionary_sum_old`; DROP TABLE IF EXISTS `svwiktionary_para_old`;
DROP TABLE IF EXISTS `svwiktionary_neu`; DROP TABLE IF EXISTS `svwiktionary_sum_neu`; DROP TABLE IF EXISTS `svwiktionary_para_neu`;

CREATE TABLE `svwiktionary_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/svwiktionary-2018-12-01.txt' IGNORE INTO TABLE `svwiktionary_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `svwiktionary_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `svwiktionary_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `svwiktionary_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `svwiktionary_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `svwiktionary_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `svwiktionary_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `svwiktionary` to `svwiktionary_old`, `svwiktionary_sum` to `svwiktionary_sum_old`,`svwiktionary_para` to `svwiktionary_para_old`;RENAME TABLE `svwiktionary_neu` to `svwiktionary`, `svwiktionary_sum_neu` to `svwiktionary_sum`,`svwiktionary_para_neu` to `svwiktionary_para`;

DROP TABLE IF EXISTS `svwiktionary_old`; DROP TABLE IF EXISTS `svwiktionary_sum_old`; DROP TABLE IF EXISTS `svwiktionary_para_old`;

DELETE FROM `info` WHERE `lang` = 'svwiktionary' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('svwiktionary', '20181201',(SELECT sum(`sum`) FROM `svwiktionary_sum` ),'20170501');
SELECT "svwiktionary",current_date,current_time;

#hewiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `hewiki_old`; DROP TABLE IF EXISTS `hewiki_sum_old`; DROP TABLE IF EXISTS `hewiki_para_old`;
DROP TABLE IF EXISTS `hewiki_neu`; DROP TABLE IF EXISTS `hewiki_sum_neu`; DROP TABLE IF EXISTS `hewiki_para_neu`;

CREATE TABLE `hewiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/hewiki-2018-12-01.txt' IGNORE INTO TABLE `hewiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `hewiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `hewiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `hewiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `hewiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `hewiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `hewiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `hewiki` to `hewiki_old`, `hewiki_sum` to `hewiki_sum_old`,`hewiki_para` to `hewiki_para_old`;RENAME TABLE `hewiki_neu` to `hewiki`, `hewiki_sum_neu` to `hewiki_sum`,`hewiki_para_neu` to `hewiki_para`;

DROP TABLE IF EXISTS `hewiki_old`; DROP TABLE IF EXISTS `hewiki_sum_old`; DROP TABLE IF EXISTS `hewiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'hewiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('hewiki', '20181201',(SELECT sum(`sum`) FROM `hewiki_sum` ),'20170501');
SELECT "hewiki",current_date,current_time;

#enwiktionary-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `enwiktionary_old`; DROP TABLE IF EXISTS `enwiktionary_sum_old`; DROP TABLE IF EXISTS `enwiktionary_para_old`;
DROP TABLE IF EXISTS `enwiktionary_neu`; DROP TABLE IF EXISTS `enwiktionary_sum_neu`; DROP TABLE IF EXISTS `enwiktionary_para_neu`;

CREATE TABLE `enwiktionary_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/enwiktionary-2018-12-01.txt' IGNORE INTO TABLE `enwiktionary_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `enwiktionary_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `enwiktionary_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `enwiktionary_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `enwiktionary_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `enwiktionary_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `enwiktionary_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `enwiktionary` to `enwiktionary_old`, `enwiktionary_sum` to `enwiktionary_sum_old`,`enwiktionary_para` to `enwiktionary_para_old`;RENAME TABLE `enwiktionary_neu` to `enwiktionary`, `enwiktionary_sum_neu` to `enwiktionary_sum`,`enwiktionary_para_neu` to `enwiktionary_para`;

DROP TABLE IF EXISTS `enwiktionary_old`; DROP TABLE IF EXISTS `enwiktionary_sum_old`; DROP TABLE IF EXISTS `enwiktionary_para_old`;

DELETE FROM `info` WHERE `lang` = 'enwiktionary' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('enwiktionary', '20181201',(SELECT sum(`sum`) FROM `enwiktionary_sum` ),'20170501');
SELECT "enwiktionary",current_date,current_time;

#frwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `frwiki_old`; DROP TABLE IF EXISTS `frwiki_sum_old`; DROP TABLE IF EXISTS `frwiki_para_old`;
DROP TABLE IF EXISTS `frwiki_neu`; DROP TABLE IF EXISTS `frwiki_sum_neu`; DROP TABLE IF EXISTS `frwiki_para_neu`;

CREATE TABLE `frwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/frwiki-2018-12-01.txt' IGNORE INTO TABLE `frwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `frwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `frwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `frwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `frwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `frwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `frwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `frwiki` to `frwiki_old`, `frwiki_sum` to `frwiki_sum_old`,`frwiki_para` to `frwiki_para_old`;RENAME TABLE `frwiki_neu` to `frwiki`, `frwiki_sum_neu` to `frwiki_sum`,`frwiki_para_neu` to `frwiki_para`;

DROP TABLE IF EXISTS `frwiki_old`; DROP TABLE IF EXISTS `frwiki_sum_old`; DROP TABLE IF EXISTS `frwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'frwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('frwiki', '20181201',(SELECT sum(`sum`) FROM `frwiki_sum` ),'20170501');
SELECT "frwiki",current_date,current_time;

#nowiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `nowiki_old`; DROP TABLE IF EXISTS `nowiki_sum_old`; DROP TABLE IF EXISTS `nowiki_para_old`;
DROP TABLE IF EXISTS `nowiki_neu`; DROP TABLE IF EXISTS `nowiki_sum_neu`; DROP TABLE IF EXISTS `nowiki_para_neu`;

CREATE TABLE `nowiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/nowiki-2018-12-01.txt' IGNORE INTO TABLE `nowiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `nowiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `nowiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `nowiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `nowiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `nowiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `nowiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `nowiki` to `nowiki_old`, `nowiki_sum` to `nowiki_sum_old`,`nowiki_para` to `nowiki_para_old`;RENAME TABLE `nowiki_neu` to `nowiki`, `nowiki_sum_neu` to `nowiki_sum`,`nowiki_para_neu` to `nowiki_para`;

DROP TABLE IF EXISTS `nowiki_old`; DROP TABLE IF EXISTS `nowiki_sum_old`; DROP TABLE IF EXISTS `nowiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'nowiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('nowiki', '20181201',(SELECT sum(`sum`) FROM `nowiki_sum` ),'20170901');
SELECT "nowiki",current_date,current_time;

#ndswiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `ndswiki_old`; DROP TABLE IF EXISTS `ndswiki_sum_old`; DROP TABLE IF EXISTS `ndswiki_para_old`;
DROP TABLE IF EXISTS `ndswiki_neu`; DROP TABLE IF EXISTS `ndswiki_sum_neu`; DROP TABLE IF EXISTS `ndswiki_para_neu`;

CREATE TABLE `ndswiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/ndswiki-2018-12-01.txt' IGNORE INTO TABLE `ndswiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `ndswiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `ndswiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `ndswiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `ndswiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `ndswiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `ndswiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `ndswiki` to `ndswiki_old`, `ndswiki_sum` to `ndswiki_sum_old`,`ndswiki_para` to `ndswiki_para_old`;RENAME TABLE `ndswiki_neu` to `ndswiki`, `ndswiki_sum_neu` to `ndswiki_sum`,`ndswiki_para_neu` to `ndswiki_para`;

DROP TABLE IF EXISTS `ndswiki_old`; DROP TABLE IF EXISTS `ndswiki_sum_old`; DROP TABLE IF EXISTS `ndswiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'ndswiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('ndswiki', '20181201',(SELECT sum(`sum`) FROM `ndswiki_sum` ),'20170901');
SELECT "ndswiki",current_date,current_time;

#huwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `huwiki_old`; DROP TABLE IF EXISTS `huwiki_sum_old`; DROP TABLE IF EXISTS `huwiki_para_old`;
DROP TABLE IF EXISTS `huwiki_neu`; DROP TABLE IF EXISTS `huwiki_sum_neu`; DROP TABLE IF EXISTS `huwiki_para_neu`;

CREATE TABLE `huwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/huwiki-2018-12-01.txt' IGNORE INTO TABLE `huwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `huwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `huwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `huwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `huwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `huwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `huwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `huwiki` to `huwiki_old`, `huwiki_sum` to `huwiki_sum_old`,`huwiki_para` to `huwiki_para_old`;RENAME TABLE `huwiki_neu` to `huwiki`, `huwiki_sum_neu` to `huwiki_sum`,`huwiki_para_neu` to `huwiki_para`;

DROP TABLE IF EXISTS `huwiki_old`; DROP TABLE IF EXISTS `huwiki_sum_old`; DROP TABLE IF EXISTS `huwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'huwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('huwiki', '20181201',(SELECT sum(`sum`) FROM `huwiki_sum` ),'20170501');
SELECT "huwiki",current_date,current_time;

#fywiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `fywiki_old`; DROP TABLE IF EXISTS `fywiki_sum_old`; DROP TABLE IF EXISTS `fywiki_para_old`;
DROP TABLE IF EXISTS `fywiki_neu`; DROP TABLE IF EXISTS `fywiki_sum_neu`; DROP TABLE IF EXISTS `fywiki_para_neu`;

CREATE TABLE `fywiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/fywiki-2018-12-01.txt' IGNORE INTO TABLE `fywiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `fywiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `fywiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `fywiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `fywiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `fywiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `fywiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `fywiki` to `fywiki_old`, `fywiki_sum` to `fywiki_sum_old`,`fywiki_para` to `fywiki_para_old`;RENAME TABLE `fywiki_neu` to `fywiki`, `fywiki_sum_neu` to `fywiki_sum`,`fywiki_para_neu` to `fywiki_para`;

DROP TABLE IF EXISTS `fywiki_old`; DROP TABLE IF EXISTS `fywiki_sum_old`; DROP TABLE IF EXISTS `fywiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'fywiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('fywiki', '20181201',(SELECT sum(`sum`) FROM `fywiki_sum` ),'20170501');
SELECT "fywiki",current_date,current_time;

#cawiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `cawiki_old`; DROP TABLE IF EXISTS `cawiki_sum_old`; DROP TABLE IF EXISTS `cawiki_para_old`;
DROP TABLE IF EXISTS `cawiki_neu`; DROP TABLE IF EXISTS `cawiki_sum_neu`; DROP TABLE IF EXISTS `cawiki_para_neu`;

CREATE TABLE `cawiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/cawiki-2018-12-01.txt' IGNORE INTO TABLE `cawiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `cawiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `cawiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `cawiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `cawiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `cawiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `cawiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `cawiki` to `cawiki_old`, `cawiki_sum` to `cawiki_sum_old`,`cawiki_para` to `cawiki_para_old`;RENAME TABLE `cawiki_neu` to `cawiki`, `cawiki_sum_neu` to `cawiki_sum`,`cawiki_para_neu` to `cawiki_para`;

DROP TABLE IF EXISTS `cawiki_old`; DROP TABLE IF EXISTS `cawiki_sum_old`; DROP TABLE IF EXISTS `cawiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'cawiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('cawiki', '20181201',(SELECT sum(`sum`) FROM `cawiki_sum` ),'20170501');
SELECT "cawiki",current_date,current_time;

#lvwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `lvwiki_old`; DROP TABLE IF EXISTS `lvwiki_sum_old`; DROP TABLE IF EXISTS `lvwiki_para_old`;
DROP TABLE IF EXISTS `lvwiki_neu`; DROP TABLE IF EXISTS `lvwiki_sum_neu`; DROP TABLE IF EXISTS `lvwiki_para_neu`;

CREATE TABLE `lvwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/lvwiki-2018-12-01.txt' IGNORE INTO TABLE `lvwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `lvwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `lvwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `lvwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `lvwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `lvwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `lvwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `lvwiki` to `lvwiki_old`, `lvwiki_sum` to `lvwiki_sum_old`,`lvwiki_para` to `lvwiki_para_old`;RENAME TABLE `lvwiki_neu` to `lvwiki`, `lvwiki_sum_neu` to `lvwiki_sum`,`lvwiki_para_neu` to `lvwiki_para`;

DROP TABLE IF EXISTS `lvwiki_old`; DROP TABLE IF EXISTS `lvwiki_sum_old`; DROP TABLE IF EXISTS `lvwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'lvwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('lvwiki', '20181201',(SELECT sum(`sum`) FROM `lvwiki_sum` ),'20170501');
SELECT "lvwiki",current_date,current_time;

#trwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `trwiki_old`; DROP TABLE IF EXISTS `trwiki_sum_old`; DROP TABLE IF EXISTS `trwiki_para_old`;
DROP TABLE IF EXISTS `trwiki_neu`; DROP TABLE IF EXISTS `trwiki_sum_neu`; DROP TABLE IF EXISTS `trwiki_para_neu`;

CREATE TABLE `trwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/trwiki-2018-12-01.txt' IGNORE INTO TABLE `trwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `trwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `trwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `trwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `trwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `trwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `trwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `trwiki` to `trwiki_old`, `trwiki_sum` to `trwiki_sum_old`,`trwiki_para` to `trwiki_para_old`;RENAME TABLE `trwiki_neu` to `trwiki`, `trwiki_sum_neu` to `trwiki_sum`,`trwiki_para_neu` to `trwiki_para`;

DROP TABLE IF EXISTS `trwiki_old`; DROP TABLE IF EXISTS `trwiki_sum_old`; DROP TABLE IF EXISTS `trwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'trwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('trwiki', '20181201',(SELECT sum(`sum`) FROM `trwiki_sum` ),'20170501');
SELECT "trwiki",current_date,current_time;

#fawiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `fawiki_old`; DROP TABLE IF EXISTS `fawiki_sum_old`; DROP TABLE IF EXISTS `fawiki_para_old`;
DROP TABLE IF EXISTS `fawiki_neu`; DROP TABLE IF EXISTS `fawiki_sum_neu`; DROP TABLE IF EXISTS `fawiki_para_neu`;

CREATE TABLE `fawiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/fawiki-2018-12-01.txt' IGNORE INTO TABLE `fawiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `fawiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `fawiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `fawiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `fawiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `fawiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `fawiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `fawiki` to `fawiki_old`, `fawiki_sum` to `fawiki_sum_old`,`fawiki_para` to `fawiki_para_old`;RENAME TABLE `fawiki_neu` to `fawiki`, `fawiki_sum_neu` to `fawiki_sum`,`fawiki_para_neu` to `fawiki_para`;

DROP TABLE IF EXISTS `fawiki_old`; DROP TABLE IF EXISTS `fawiki_sum_old`; DROP TABLE IF EXISTS `fawiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'fawiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('fawiki', '20181201',(SELECT sum(`sum`) FROM `fawiki_sum` ),'20170501');
SELECT "fawiki",current_date,current_time;

#bewiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `bewiki_old`; DROP TABLE IF EXISTS `bewiki_sum_old`; DROP TABLE IF EXISTS `bewiki_para_old`;
DROP TABLE IF EXISTS `bewiki_neu`; DROP TABLE IF EXISTS `bewiki_sum_neu`; DROP TABLE IF EXISTS `bewiki_para_neu`;

CREATE TABLE `bewiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/bewiki-2018-12-01.txt' IGNORE INTO TABLE `bewiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `bewiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `bewiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `bewiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `bewiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `bewiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `bewiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `bewiki` to `bewiki_old`, `bewiki_sum` to `bewiki_sum_old`,`bewiki_para` to `bewiki_para_old`;RENAME TABLE `bewiki_neu` to `bewiki`, `bewiki_sum_neu` to `bewiki_sum`,`bewiki_para_neu` to `bewiki_para`;

DROP TABLE IF EXISTS `bewiki_old`; DROP TABLE IF EXISTS `bewiki_sum_old`; DROP TABLE IF EXISTS `bewiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'bewiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('bewiki', '20181201',(SELECT sum(`sum`) FROM `bewiki_sum` ),'20170501');
SELECT "bewiki",current_date,current_time;

#rowiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `rowiki_old`; DROP TABLE IF EXISTS `rowiki_sum_old`; DROP TABLE IF EXISTS `rowiki_para_old`;
DROP TABLE IF EXISTS `rowiki_neu`; DROP TABLE IF EXISTS `rowiki_sum_neu`; DROP TABLE IF EXISTS `rowiki_para_neu`;

CREATE TABLE `rowiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/rowiki-2018-12-01.txt' IGNORE INTO TABLE `rowiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `rowiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `rowiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `rowiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `rowiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `rowiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `rowiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `rowiki` to `rowiki_old`, `rowiki_sum` to `rowiki_sum_old`,`rowiki_para` to `rowiki_para_old`;RENAME TABLE `rowiki_neu` to `rowiki`, `rowiki_sum_neu` to `rowiki_sum`,`rowiki_para_neu` to `rowiki_para`;

DROP TABLE IF EXISTS `rowiki_old`; DROP TABLE IF EXISTS `rowiki_sum_old`; DROP TABLE IF EXISTS `rowiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'rowiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('rowiki', '20181201',(SELECT sum(`sum`) FROM `rowiki_sum` ),'20170501');
SELECT "rowiki",current_date,current_time;

#sqwiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `sqwiki_old`; DROP TABLE IF EXISTS `sqwiki_sum_old`; DROP TABLE IF EXISTS `sqwiki_para_old`;
DROP TABLE IF EXISTS `sqwiki_neu`; DROP TABLE IF EXISTS `sqwiki_sum_neu`; DROP TABLE IF EXISTS `sqwiki_para_neu`;

CREATE TABLE `sqwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/sqwiki-2018-12-01.txt' IGNORE INTO TABLE `sqwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `sqwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `sqwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `sqwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `sqwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `sqwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `sqwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `sqwiki` to `sqwiki_old`, `sqwiki_sum` to `sqwiki_sum_old`,`sqwiki_para` to `sqwiki_para_old`;RENAME TABLE `sqwiki_neu` to `sqwiki`, `sqwiki_sum_neu` to `sqwiki_sum`,`sqwiki_para_neu` to `sqwiki_para`;

DROP TABLE IF EXISTS `sqwiki_old`; DROP TABLE IF EXISTS `sqwiki_sum_old`; DROP TABLE IF EXISTS `sqwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'sqwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('sqwiki', '20181201',(SELECT sum(`sum`) FROM `sqwiki_sum` ),'20170901');
SELECT "sqwiki",current_date,current_time;

#zhwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `zhwiki_old`; DROP TABLE IF EXISTS `zhwiki_sum_old`; DROP TABLE IF EXISTS `zhwiki_para_old`;
DROP TABLE IF EXISTS `zhwiki_neu`; DROP TABLE IF EXISTS `zhwiki_sum_neu`; DROP TABLE IF EXISTS `zhwiki_para_neu`;

CREATE TABLE `zhwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/zhwiki-2018-12-01.txt' IGNORE INTO TABLE `zhwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `zhwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `zhwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `zhwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `zhwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `zhwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `zhwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `zhwiki` to `zhwiki_old`, `zhwiki_sum` to `zhwiki_sum_old`,`zhwiki_para` to `zhwiki_para_old`;RENAME TABLE `zhwiki_neu` to `zhwiki`, `zhwiki_sum_neu` to `zhwiki_sum`,`zhwiki_para_neu` to `zhwiki_para`;

DROP TABLE IF EXISTS `zhwiki_old`; DROP TABLE IF EXISTS `zhwiki_sum_old`; DROP TABLE IF EXISTS `zhwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'zhwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('zhwiki', '20181201',(SELECT sum(`sum`) FROM `zhwiki_sum` ),'20170501');
SELECT "zhwiki",current_date,current_time;

#gdwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `gdwiki_old`; DROP TABLE IF EXISTS `gdwiki_sum_old`; DROP TABLE IF EXISTS `gdwiki_para_old`;
DROP TABLE IF EXISTS `gdwiki_neu`; DROP TABLE IF EXISTS `gdwiki_sum_neu`; DROP TABLE IF EXISTS `gdwiki_para_neu`;

CREATE TABLE `gdwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/gdwiki-2018-12-01.txt' IGNORE INTO TABLE `gdwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `gdwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `gdwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `gdwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `gdwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `gdwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `gdwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `gdwiki` to `gdwiki_old`, `gdwiki_sum` to `gdwiki_sum_old`,`gdwiki_para` to `gdwiki_para_old`;RENAME TABLE `gdwiki_neu` to `gdwiki`, `gdwiki_sum_neu` to `gdwiki_sum`,`gdwiki_para_neu` to `gdwiki_para`;

DROP TABLE IF EXISTS `gdwiki_old`; DROP TABLE IF EXISTS `gdwiki_sum_old`; DROP TABLE IF EXISTS `gdwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'gdwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('gdwiki', '20181201',(SELECT sum(`sum`) FROM `gdwiki_sum` ),'20170501');
SELECT "gdwiki",current_date,current_time;

#simplewiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `simplewiki_old`; DROP TABLE IF EXISTS `simplewiki_sum_old`; DROP TABLE IF EXISTS `simplewiki_para_old`;
DROP TABLE IF EXISTS `simplewiki_neu`; DROP TABLE IF EXISTS `simplewiki_sum_neu`; DROP TABLE IF EXISTS `simplewiki_para_neu`;

CREATE TABLE `simplewiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/simplewiki-2018-12-01.txt' IGNORE INTO TABLE `simplewiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `simplewiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `simplewiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `simplewiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `simplewiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `simplewiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `simplewiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `simplewiki` to `simplewiki_old`, `simplewiki_sum` to `simplewiki_sum_old`,`simplewiki_para` to `simplewiki_para_old`;RENAME TABLE `simplewiki_neu` to `simplewiki`, `simplewiki_sum_neu` to `simplewiki_sum`,`simplewiki_para_neu` to `simplewiki_para`;

DROP TABLE IF EXISTS `simplewiki_old`; DROP TABLE IF EXISTS `simplewiki_sum_old`; DROP TABLE IF EXISTS `simplewiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'simplewiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('simplewiki', '20181201',(SELECT sum(`sum`) FROM `simplewiki_sum` ),'20170501');
SELECT "simplewiki",current_date,current_time;

#alswiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `alswiki_old`; DROP TABLE IF EXISTS `alswiki_sum_old`; DROP TABLE IF EXISTS `alswiki_para_old`;
DROP TABLE IF EXISTS `alswiki_neu`; DROP TABLE IF EXISTS `alswiki_sum_neu`; DROP TABLE IF EXISTS `alswiki_para_neu`;

CREATE TABLE `alswiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/alswiki-2018-12-01.txt' IGNORE INTO TABLE `alswiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `alswiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `alswiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `alswiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `alswiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `alswiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `alswiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `alswiki` to `alswiki_old`, `alswiki_sum` to `alswiki_sum_old`,`alswiki_para` to `alswiki_para_old`;RENAME TABLE `alswiki_neu` to `alswiki`, `alswiki_sum_neu` to `alswiki_sum`,`alswiki_para_neu` to `alswiki_para`;

DROP TABLE IF EXISTS `alswiki_old`; DROP TABLE IF EXISTS `alswiki_sum_old`; DROP TABLE IF EXISTS `alswiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'alswiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('alswiki', '20181201',(SELECT sum(`sum`) FROM `alswiki_sum` ),'20170501');
SELECT "alswiki",current_date,current_time;

#yiwiki-2018-12-01.txt


#Date: 20181201# DB: 20170901 sk: 20181201
# DB: 20170901 sk: 20181201
DROP TABLE IF EXISTS `yiwiki_old`; DROP TABLE IF EXISTS `yiwiki_sum_old`; DROP TABLE IF EXISTS `yiwiki_para_old`;
DROP TABLE IF EXISTS `yiwiki_neu`; DROP TABLE IF EXISTS `yiwiki_sum_neu`; DROP TABLE IF EXISTS `yiwiki_para_neu`;

CREATE TABLE `yiwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/yiwiki-2018-12-01.txt' IGNORE INTO TABLE `yiwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `yiwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `yiwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `yiwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `yiwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `yiwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `yiwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `yiwiki` to `yiwiki_old`, `yiwiki_sum` to `yiwiki_sum_old`,`yiwiki_para` to `yiwiki_para_old`;RENAME TABLE `yiwiki_neu` to `yiwiki`, `yiwiki_sum_neu` to `yiwiki_sum`,`yiwiki_para_neu` to `yiwiki_para`;

DROP TABLE IF EXISTS `yiwiki_old`; DROP TABLE IF EXISTS `yiwiki_sum_old`; DROP TABLE IF EXISTS `yiwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'yiwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('yiwiki', '20181201',(SELECT sum(`sum`) FROM `yiwiki_sum` ),'20170901');
SELECT "yiwiki",current_date,current_time;

#itwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `itwiki_old`; DROP TABLE IF EXISTS `itwiki_sum_old`; DROP TABLE IF EXISTS `itwiki_para_old`;
DROP TABLE IF EXISTS `itwiki_neu`; DROP TABLE IF EXISTS `itwiki_sum_neu`; DROP TABLE IF EXISTS `itwiki_para_neu`;

CREATE TABLE `itwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/itwiki-2018-12-01.txt' IGNORE INTO TABLE `itwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `itwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `itwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `itwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `itwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `itwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `itwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `itwiki` to `itwiki_old`, `itwiki_sum` to `itwiki_sum_old`,`itwiki_para` to `itwiki_para_old`;RENAME TABLE `itwiki_neu` to `itwiki`, `itwiki_sum_neu` to `itwiki_sum`,`itwiki_para_neu` to `itwiki_para`;

DROP TABLE IF EXISTS `itwiki_old`; DROP TABLE IF EXISTS `itwiki_sum_old`; DROP TABLE IF EXISTS `itwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'itwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('itwiki', '20181201',(SELECT sum(`sum`) FROM `itwiki_sum` ),'20170501');
SELECT "itwiki",current_date,current_time;

#elwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `elwiki_old`; DROP TABLE IF EXISTS `elwiki_sum_old`; DROP TABLE IF EXISTS `elwiki_para_old`;
DROP TABLE IF EXISTS `elwiki_neu`; DROP TABLE IF EXISTS `elwiki_sum_neu`; DROP TABLE IF EXISTS `elwiki_para_neu`;

CREATE TABLE `elwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/elwiki-2018-12-01.txt' IGNORE INTO TABLE `elwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `elwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `elwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `elwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `elwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `elwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `elwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `elwiki` to `elwiki_old`, `elwiki_sum` to `elwiki_sum_old`,`elwiki_para` to `elwiki_para_old`;RENAME TABLE `elwiki_neu` to `elwiki`, `elwiki_sum_neu` to `elwiki_sum`,`elwiki_para_neu` to `elwiki_para`;

DROP TABLE IF EXISTS `elwiki_old`; DROP TABLE IF EXISTS `elwiki_sum_old`; DROP TABLE IF EXISTS `elwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'elwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('elwiki', '20181201',(SELECT sum(`sum`) FROM `elwiki_sum` ),'20170501');
SELECT "elwiki",current_date,current_time;

#nlwiki-2018-12-01.txt


#Date: 20181201# DB: 20180520 sk: 20181201
# DB: 20180520 sk: 20181201
DROP TABLE IF EXISTS `nlwiki_old`; DROP TABLE IF EXISTS `nlwiki_sum_old`; DROP TABLE IF EXISTS `nlwiki_para_old`;
DROP TABLE IF EXISTS `nlwiki_neu`; DROP TABLE IF EXISTS `nlwiki_sum_neu`; DROP TABLE IF EXISTS `nlwiki_para_neu`;

CREATE TABLE `nlwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/nlwiki-2018-12-01.txt' IGNORE INTO TABLE `nlwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `nlwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `nlwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `nlwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `nlwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `nlwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `nlwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `nlwiki` to `nlwiki_old`, `nlwiki_sum` to `nlwiki_sum_old`,`nlwiki_para` to `nlwiki_para_old`;RENAME TABLE `nlwiki_neu` to `nlwiki`, `nlwiki_sum_neu` to `nlwiki_sum`,`nlwiki_para_neu` to `nlwiki_para`;

DROP TABLE IF EXISTS `nlwiki_old`; DROP TABLE IF EXISTS `nlwiki_sum_old`; DROP TABLE IF EXISTS `nlwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'nlwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('nlwiki', '20181201',(SELECT sum(`sum`) FROM `nlwiki_sum` ),'20180520');
SELECT "nlwiki",current_date,current_time;

#ukwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `ukwiki_old`; DROP TABLE IF EXISTS `ukwiki_sum_old`; DROP TABLE IF EXISTS `ukwiki_para_old`;
DROP TABLE IF EXISTS `ukwiki_neu`; DROP TABLE IF EXISTS `ukwiki_sum_neu`; DROP TABLE IF EXISTS `ukwiki_para_neu`;

CREATE TABLE `ukwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/ukwiki-2018-12-01.txt' IGNORE INTO TABLE `ukwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `ukwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `ukwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `ukwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `ukwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `ukwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `ukwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `ukwiki` to `ukwiki_old`, `ukwiki_sum` to `ukwiki_sum_old`,`ukwiki_para` to `ukwiki_para_old`;RENAME TABLE `ukwiki_neu` to `ukwiki`, `ukwiki_sum_neu` to `ukwiki_sum`,`ukwiki_para_neu` to `ukwiki_para`;

DROP TABLE IF EXISTS `ukwiki_old`; DROP TABLE IF EXISTS `ukwiki_sum_old`; DROP TABLE IF EXISTS `ukwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'ukwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('ukwiki', '20181201',(SELECT sum(`sum`) FROM `ukwiki_sum` ),'20170501');
SELECT "ukwiki",current_date,current_time;

#slwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `slwiki_old`; DROP TABLE IF EXISTS `slwiki_sum_old`; DROP TABLE IF EXISTS `slwiki_para_old`;
DROP TABLE IF EXISTS `slwiki_neu`; DROP TABLE IF EXISTS `slwiki_sum_neu`; DROP TABLE IF EXISTS `slwiki_para_neu`;

CREATE TABLE `slwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/slwiki-2018-12-01.txt' IGNORE INTO TABLE `slwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `slwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `slwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `slwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `slwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `slwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `slwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `slwiki` to `slwiki_old`, `slwiki_sum` to `slwiki_sum_old`,`slwiki_para` to `slwiki_para_old`;RENAME TABLE `slwiki_neu` to `slwiki`, `slwiki_sum_neu` to `slwiki_sum`,`slwiki_para_neu` to `slwiki_para`;

DROP TABLE IF EXISTS `slwiki_old`; DROP TABLE IF EXISTS `slwiki_sum_old`; DROP TABLE IF EXISTS `slwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'slwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('slwiki', '20181201',(SELECT sum(`sum`) FROM `slwiki_sum` ),'20170501');
SELECT "slwiki",current_date,current_time;

#nds_nlwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `nds_nlwiki_old`; DROP TABLE IF EXISTS `nds_nlwiki_sum_old`; DROP TABLE IF EXISTS `nds_nlwiki_para_old`;
DROP TABLE IF EXISTS `nds_nlwiki_neu`; DROP TABLE IF EXISTS `nds_nlwiki_sum_neu`; DROP TABLE IF EXISTS `nds_nlwiki_para_neu`;

CREATE TABLE `nds_nlwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/nds_nlwiki-2018-12-01.txt' IGNORE INTO TABLE `nds_nlwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `nds_nlwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `nds_nlwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `nds_nlwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `nds_nlwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `nds_nlwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `nds_nlwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `nds_nlwiki` to `nds_nlwiki_old`, `nds_nlwiki_sum` to `nds_nlwiki_sum_old`,`nds_nlwiki_para` to `nds_nlwiki_para_old`;RENAME TABLE `nds_nlwiki_neu` to `nds_nlwiki`, `nds_nlwiki_sum_neu` to `nds_nlwiki_sum`,`nds_nlwiki_para_neu` to `nds_nlwiki_para`;

DROP TABLE IF EXISTS `nds_nlwiki_old`; DROP TABLE IF EXISTS `nds_nlwiki_sum_old`; DROP TABLE IF EXISTS `nds_nlwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'nds_nlwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('nds_nlwiki', '20181201',(SELECT sum(`sum`) FROM `nds_nlwiki_sum` ),'20170501');
SELECT "nds_nlwiki",current_date,current_time;

#afwiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `afwiki_old`; DROP TABLE IF EXISTS `afwiki_sum_old`; DROP TABLE IF EXISTS `afwiki_para_old`;
DROP TABLE IF EXISTS `afwiki_neu`; DROP TABLE IF EXISTS `afwiki_sum_neu`; DROP TABLE IF EXISTS `afwiki_para_neu`;

CREATE TABLE `afwiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/afwiki-2018-12-01.txt' IGNORE INTO TABLE `afwiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `afwiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `afwiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `afwiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `afwiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `afwiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `afwiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `afwiki` to `afwiki_old`, `afwiki_sum` to `afwiki_sum_old`,`afwiki_para` to `afwiki_para_old`;RENAME TABLE `afwiki_neu` to `afwiki`, `afwiki_sum_neu` to `afwiki_sum`,`afwiki_para_neu` to `afwiki_para`;

DROP TABLE IF EXISTS `afwiki_old`; DROP TABLE IF EXISTS `afwiki_sum_old`; DROP TABLE IF EXISTS `afwiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'afwiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('afwiki', '20181201',(SELECT sum(`sum`) FROM `afwiki_sum` ),'20170501');
SELECT "afwiki",current_date,current_time;

#eowiki-2018-12-01.txt


#Date: 20181201# DB: 20170501 sk: 20181201
# DB: 20170501 sk: 20181201
DROP TABLE IF EXISTS `eowiki_old`; DROP TABLE IF EXISTS `eowiki_sum_old`; DROP TABLE IF EXISTS `eowiki_para_old`;
DROP TABLE IF EXISTS `eowiki_neu`; DROP TABLE IF EXISTS `eowiki_sum_neu`; DROP TABLE IF EXISTS `eowiki_para_neu`;

CREATE TABLE `eowiki_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/eowiki-2018-12-01.txt' IGNORE INTO TABLE `eowiki_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `eowiki_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `eowiki_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `eowiki_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `eowiki_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `eowiki_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `eowiki_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `eowiki` to `eowiki_old`, `eowiki_sum` to `eowiki_sum_old`,`eowiki_para` to `eowiki_para_old`;RENAME TABLE `eowiki_neu` to `eowiki`, `eowiki_sum_neu` to `eowiki_sum`,`eowiki_para_neu` to `eowiki_para`;

DROP TABLE IF EXISTS `eowiki_old`; DROP TABLE IF EXISTS `eowiki_sum_old`; DROP TABLE IF EXISTS `eowiki_para_old`;

DELETE FROM `info` WHERE `lang` = 'eowiki' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('eowiki', '20181201',(SELECT sum(`sum`) FROM `eowiki_sum` ),'20170501');
SELECT "eowiki",current_date,current_time;

#frwiktionary-2018-11-01-ffJg.txt


#Date: 20181101# DB: sk: 20181101
# DB: sk: 20181101
DROP TABLE IF EXISTS `frwiktionary_old`; DROP TABLE IF EXISTS `frwiktionary_sum_old`; DROP TABLE IF EXISTS `frwiktionary_para_old`;
DROP TABLE IF EXISTS `frwiktionary_neu`; DROP TABLE IF EXISTS `frwiktionary_sum_neu`; DROP TABLE IF EXISTS `frwiktionary_para_neu`;

CREATE TABLE `frwiktionary_neu` ( `name_id` bigint( 20 ) NOT NULL , `name` varchar( 180 ) NOT NULL , `tp_nr` bigint( 20 ) NOT NULL , `tp_name` varchar( 100 ) NOT NULL , `entry_nr` bigint( 20 ) NOT NULL , `entry_name` varchar( 200 ) NOT NULL , `Value` varchar( 900 ) NOT NULL ,
KEY `tp_name` (`tp_name`(30)), KEY `name` ( `name` (15)) , KEY `name_id` ( `name_id`) , KEY `entry_name` ( `entry_name`(15) ) , KEY `Value` ( `Value` (15) ) ) ENGINE = ARIA DEFAULT CHARSET = utf8;

LOAD /* SLOW_OK */ DATA LOCAL INFILE '/data/project/templatetiger/public_html/dumps/frwiktionary-2018-11-01-ffJg.txt' IGNORE INTO TABLE `frwiktionary_neu` FIELDS TERMINATED BY '\t' ESCAPED BY '\\' LINES TERMINATED BY '\n' ;

CREATE TABLE `frwiktionary_sum_neu` ( `tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL , `sum` bigint( 20 ) NOT NULL , PRIMARY KEY ( `tp_name` ) , KEY `sum` ( `sum` ) ) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;

INSERT INTO `frwiktionary_sum_neu` SELECT `tp_name` , COUNT( * ) FROM `frwiktionary_neu` WHERE `entry_nr` = '1' GROUP BY `tp_name` ORDER BY COUNT( * ) DESC /* SLOW_OK */;
CREATE TABLE `frwiktionary_para_neu` (`tp_name` varchar( 100 ) COLLATE utf8_bin NOT NULL ,`entry_name` varchar( 200 ) COLLATE utf8_bin NOT NULL , `sum` BIGINT( 20 ) NOT NULL , KEY `tp_name` ( `tp_name` ) ,KEY `entry_name` ( `entry_name` )) ENGINE = ARIA DEFAULT CHARSET = utf8 COLLATE = utf8_bin;
INSERT INTO `frwiktionary_para_neu` SELECT `tp_name` , `entry_name`, COUNT( * ) FROM `frwiktionary_neu` GROUP BY `tp_name`,`entry_name`;

RENAME TABLE `frwiktionary_neu` to `frwiktionary`, `frwiktionary_sum_neu` to `frwiktionary_sum`,`frwiktionary_para_neu` to `frwiktionary_para`;

DROP TABLE IF EXISTS `frwiktionary_old`; DROP TABLE IF EXISTS `frwiktionary_sum_old`; DROP TABLE IF EXISTS `frwiktionary_para_old`;

DELETE FROM `info` WHERE `lang` = 'frwiktionary' ;INSERT INTO `info` ( `lang` , `date`, `sum`, `date_old` ) VALUES ('frwiktionary', '20181101',(SELECT sum(`sum`) FROM `frwiktionary_sum` ),'');
SELECT "frwiktionary",current_date,current_time;

sort /data/project/templatetiger/public_html/dumps/arzwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/arzwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/arwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/arwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/skwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/skwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/jawiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/jawiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/ruwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/ruwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/frwikiversity-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/frwikiversity-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/urwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/urwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/ptwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/ptwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/eswiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/eswiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/hrwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/hrwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/pdcwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/pdcwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/plwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/plwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/cswiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/cswiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/dewikisource-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/dewikisource-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/lawiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/lawiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/scowiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/scowiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/barwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/barwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/idwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/idwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/cywiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/cywiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/iswiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/iswiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/frwikivoyage-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/frwikivoyage-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/frwiktionary-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/frwiktionary-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/fiwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/fiwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/dawiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/dawiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/svwiktionary-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/svwiktionary-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/hewiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/hewiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/enwiktionary-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/enwiktionary-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/frwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/frwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/nowiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/nowiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/ndswiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/ndswiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/huwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/huwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/fywiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/fywiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/cawiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/cawiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/lvwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/lvwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/trwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/trwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/fawiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/fawiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/bewiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/bewiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/rowiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/rowiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/sqwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/sqwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/zhwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/zhwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/gdwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/gdwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/simplewiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/simplewiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/alswiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/alswiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/yiwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/yiwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/itwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/itwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/elwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/elwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/nlwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/nlwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/ukwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/ukwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/slwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/slwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/nds_nlwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/nds_nlwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/afwiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/afwiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/eowiki-2018-12-01.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/eowiki-2018-12-01.txt -T /tmp
sort /data/project/templatetiger/public_html/dumps/frwiktionary-2018-11-01-ffJg.txt -k4,4 -k2,2 -k3,3n -k5,5n -t$'\t' -o /data/project/templatetiger/public_html/dumps/sort/frwiktionary-2018-11-01-ffJg.txt -T /tmp