Определены победители хакатона, проведенного в рамках Astana Mining & Metallurgy Congress

Tech Garden и оргкомитет АММ 2019 впервые провели в рамках Международного горно-металлургического конгресса Хакатон Mining Challenge 2019 для начинающих предпринимателей, программистов и стартаперов.

Задачи были непростыми и очень разными: блокчейн и коммуникационная платформа между компанией и гражданами, Web-приложение на основе Rest API платформы EcoDomus и потоковый конвейер (data pipeline) обработки данных.

Команды-решатели были очень хороши, и дали нетривиальные и креативные решения. Каждый победитель получил денежный приз в размере 500 тысяч тенге и возможность пройти акселерацию по программам АКФ Tech Garden.

Читать материал полностью

ID	(3,28)	Class	SQL
0	0,28	DB	SELECT * FROM ru_mass_medias WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC SELECT * FROM ru_mass_medias WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,33	DB	SELECT * FROM ru_rubrics WHERE 1=1 AND (ru_rubrics.furl='mass_medias') AND active = :active AND a SELECT * FROM ru_rubrics WHERE 1 = 1 AND (ru_rubrics.furl = 'mass_medias') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,46	DB	SELECT * FROM ru_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM ru_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,17	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
4	0,12	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
5	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,11	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,11	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,11	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,1	DB	SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM ru_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(3,28)

Class

SQL

0,28

SELECT * FROM ru_mass_medias WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC

SELECT 
  * 
FROM 
  ru_mass_medias 
WHERE 
  id = :id 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,33

SELECT * FROM ru_rubrics WHERE 1=1 AND (ru_rubrics.furl='mass_medias') AND active = :active AND a

SELECT 
  * 
FROM 
  ru_rubrics 
WHERE 
  1 = 1 
  AND (ru_rubrics.furl = 'mass_medias') 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,46

SELECT * FROM ru_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1

SELECT 
  * 
FROM 
  ru_rubrics 
WHERE 
  1 = 1 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,17