First Oil&Gas Day in 2023!

The first Oil&Gas Day of the year will take place on 29 March! We have selected 2 challenges from major hydrocarbon production and processing companies on the Smart Industry Management Platform (SIMP).

Date of the event:

29 march

Kazakhstan, Almaty city

Goals and objectives

Where you can find tasks?

The tasks can be viewed by clicking on this link: https://simp.gov.kz/ru/store/tasks

Apply

To apply for Oil&Gas Day, go to: https://simp.gov.kz/ru/store/marathon/22

Application for participation

ID	(7,34)	Class	SQL
0	0,43	DB	SELECT * FROM en_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT SELECT * FROM en_events WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,26	DB	SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='event') AND active = :active AND active SELECT * FROM en_rubrics WHERE 1 = 1 AND (en_rubrics.furl = 'event') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	3,44	DB	SELECT * FROM en_gallery_items WHERE 1=1 AND (en_gallery_items.type='eventorganizers_photo') AND SELECT * FROM en_gallery_items WHERE 1 = 1 AND ( en_gallery_items.type = 'eventorganizers_photo' ) AND (en_gallery_items.gallery_id = 38) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,53	DB	SELECT * FROM en_event_programs WHERE 1=1 AND (en_event_programs.event_id=38) AND active = :activ SELECT * FROM en_event_programs WHERE 1 = 1 AND (en_event_programs.event_id = 38) AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
4	0,36	DB	SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
5	0,21	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,17	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,13	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,1	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,1	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,1	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,1	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
24	0,1	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
25	0,09	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(7,34)

Class

SQL

0,43

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

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

0,26

SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='event') AND active = :active AND active

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

3,44

SELECT * FROM en_gallery_items WHERE 1=1 AND (en_gallery_items.type='eventorganizers_photo') AND

SELECT 
  * 
FROM 
  en_gallery_items 
WHERE 
  1 = 1 
  AND (
    en_gallery_items.type = 'eventorganizers_photo'
  ) 
  AND (en_gallery_items.gallery_id = 38) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,53

SELECT * FROM en_event_programs WHERE 1=1 AND (en_event_programs.event_id=38) AND active = :activ

SELECT 
  * 
FROM 
  en_event_programs 
WHERE 
  1 = 1 
  AND (en_event_programs.event_id = 38) 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,36

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

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

0,21