Untitled query #82100

SQL

# SELECT EXTRACT(YEAR FROM log_timestamp) AS year, CONCAT("('", CONCAT_WS("','", logging.log_type, logging.log_action, logging.log_timestamp, 1, logging.log_namespace, logging.log_title, 1, logging.log_params, 0, logging.log_page) CONCAT("')") FROM logging WHERE log_type = "gblblock" GROUP BY year;

SELECT * FROM
(SELECT EXTRACT(YEAR FROM log_timestamp) AS year,
	CONCAT("('", CONCAT_WS("','", logging.log_type, logging.log_action, logging.log_timestamp, 1, logging.log_namespace, logging.log_title, 1, logging.log_params, 0, logging.log_page), "')"),
	ROW_NUMBER() OVER(PARTITION BY year) AS part
FROM logging WHERE log_type = "gblblock") AS foo
WHERE foo.part < 5;
SQL

Checking query status...
