Astana Mining & Metallurgy конгресі аясында өткен хакатонның жеңімпаздары анықталды

Tech Garden және AMM 2019 ұйымдастыру комитеті халықаралық тау-кен металлургиялық конгресі аясында алғаш рет кәсіпқойларға, бағдарламашыларға және стартапшыларға арналған хакатон Mining Challenge 2019 өткізді.

Тапсырмалар оңай болған жоқ және өте өзгеше болды: компания мен азаматтар арасындағы блокчейн және байланыс платформасы, EcoDomus платформасының Rest API негізіндегі веб-қосымшасы және деректерді өңдеуге арналған деректер құбыры.

Шешуші топтар өте жақсы болды және қарапайым емес шығармашылық шешімдер берді. Әр жеңімпазға 500 мың теңге көлемінде ақшалай сыйлық және АКҚ Tech Garden бағдарламалары бойынша акселерациядан өту мүмкіндігі берілді.

Толық материалды оқыңыз

Бөлісу:

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

(2,9)

Class

SQL

0,25

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

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

0,19

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

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

0,33

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

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

0,16