Мукачівське міське комунальне підприємство «Міжнародний аеропорт Мукачево»
Комунальне підприємство Мукачівська міська друкарня
Комунальне підприємство «Мукачівське кар’єроуправління»
Комунальне підприємство «Мукачівське міське бюро технічної інвентаризації та експертної оцінки»
Мукачівське міське комунальне підприємство «Мукачевопроект»
Мукачівське міське комунальне підприємство «Мукачівводоканал»
Мукачівське міське комунальне підприємство «Муніціпальна поліція»
Мукачівське міське комунальне підприємство «Парк»
Мукачівське міське комунальне підприємство «Ремонтно-будівельне управління»
Мукачівське міське комунальне підприємство «Соціальна аптека»
Мукачівський міський туристично-інформаційний центр
Мукачівське міське комунальне підприємство «Центр контролю за тваринами»
Мукачівське міське комунальне підприємство «Чисте місто»
Всі права захищено! Всі права на статті, зображення, інші матеріали належать МУКАЧІВСЬКІЙ МІСЬКІЙ РАДІ та охороняються законом України «Про авторське право і суміжні права».
SELECT `session_id`
FROM `zq89x_session`
WHERE `session_id` = 'a1nfebs2p9ep5n94sbjnr3dj77'
LIMIT 0, 1
INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('a1nfebs2p9ep5n94sbjnr3dj77', 0, '1550324370')
SELECT extension_id AS id, element AS "option", params, enabled
FROM zq89x_extensions
WHERE `type` = 'component'
SELECT b.id
FROM zq89x_usergroups AS a
LEFT JOIN zq89x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `zq89x_viewlevels`
SELECT folder AS type, element AS name, params
FROM zq89x_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM zq89x_menu AS m
LEFT JOIN zq89x_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM zq89x_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
UPDATE `zq89x_extensions`
SET `params` = '{\"mediaversion\":\"d36d304c5c376c9a91a22d10b06af2d0\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
SELECT id, home, template, s.params
FROM zq89x_template_styles as s
LEFT JOIN zq89x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT *
FROM zq89x_languages
WHERE published=1
ORDER BY ordering ASC
SELECT a.rules
FROM zq89x_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM zq89x_assets AS a
LEFT JOIN zq89x_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_k2')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT id
FROM zq89x_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_items
WHERE id=2976
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `zq89x_k2_categories`
SELECT *
FROM zq89x_k2_categories
WHERE id = '296'
SELECT *
FROM zq89x_k2_categories
WHERE id = '97'
SELECT tag.*
FROM zq89x_k2_tags AS tag JOIN zq89x_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 2976
ORDER BY xref.id ASC
SELECT *
FROM zq89x_k2_attachments
WHERE itemID=2976
SELECT *
FROM zq89x_k2_rating
WHERE itemID = 2976
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=2976
AND published=1
SHOW FULL COLUMNS
FROM `zq89x_k2_items`
UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '2976'
SELECT *
FROM zq89x_k2_comments
WHERE itemID=2976
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10
SELECT *
FROM zq89x_k2_items
WHERE id != 2976
AND catid=296
AND ordering > 1
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-16 13:39:31' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-16 13:39:31' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
SELECT *
FROM zq89x_k2_items
WHERE id != 2976
AND catid=296
AND ordering < 1
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-16 13:39:31' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-16 13:39:31' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zq89x_modules AS m
LEFT JOIN zq89x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zq89x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-02-16 13:39:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-16 13:39:31')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 487 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_banners
WHERE '2019-02-16 13:39:31' >= 'reset'
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT COUNT(*)
FROM zq89x_banners as a
LEFT JOIN zq89x_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (37)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM zq89x_banners as a
LEFT JOIN zq89x_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
AND a.catid IN (37)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 10
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 9
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 8
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 4
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 5
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 7
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 6
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 16
SELECT *
FROM zq89x_k2_items
WHERE id=2976
AND published=1
AND trash=0
AND access IN(1,1)
AND EXISTS (SELECT *
FROM zq89x_k2_categories
WHERE zq89x_k2_categories.id= zq89x_k2_items.catid
AND published=1
AND access IN(1,1) )
SELECT *
FROM zq89x_k2_categories
WHERE id=296
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=97
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=77
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=70
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=67
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=0
AND published=1
AND trash=0
AND access IN(1,1)
8 × SELECT *
FROM zq89x_k2_categories
4 × SELECT *
FROM zq89x_k2_items
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM zq89x_extensions
1 × SELECT *
FROM zq89x_k2_comments
1 × SELECT COUNT(*)
FROM zq89x_k2_comments
1 × SELECT *
FROM zq89x_k2_rating
1 × SELECT *
FROM zq89x_k2_attachments
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM zq89x_modules AS m
LEFT JOIN zq89x_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN zq89x_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM zq89x_modules
1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM zq89x_banners as a
LEFT JOIN zq89x_banner_clients AS cl
ON cl.id = a.cid
1 × SELECT COUNT(*)
FROM zq89x_banners as a
LEFT JOIN zq89x_banner_clients AS cl
ON cl.id = a.cid
1 × SELECT *
FROM zq89x_banners
1 × SELECT tag.*
FROM zq89x_k2_tags AS tag JOIN zq89x_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SELECT b.id
FROM zq89x_usergroups AS a
LEFT JOIN zq89x_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, home, template, s.params
FROM zq89x_template_styles as s
LEFT JOIN zq89x_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM zq89x_menu AS m
LEFT JOIN zq89x_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM zq89x_extensions
1 × SELECT *
FROM zq89x_languages
1 × SELECT a.rules
FROM zq89x_assets AS a
1 × SELECT `session_id`
FROM `zq89x_session`
1 × SELECT id
FROM zq89x_k2_categories
1 × SELECT b.rules
FROM zq89x_assets AS a
LEFT JOIN zq89x_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `zq89x_viewlevels
7 × UPDATE zq89x_banners
SET impmade = (impmade + 1)
1 × UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `zq89x_k2_items
1 × SHOW FULL COLUMNS
FROM `zq89x_k2_categories
1 × UPDATE `zq89x_extensions`
SET `params` = '{\"mediaversion\":\"d36d304c5c376c9a91a22d10b06af2d0\"}'
1 × INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('a1nfebs2p9ep5n94sbjnr3dj77', 0, '1550324370'