Станом на 01 жовтня 2018 року до управління праці та соціального захисту населення виконкому Мукачівської міської ради (далі-УПСЗН) звернулося 24 організації надавачів-послуг, в тому числі 14 ОСББ міста Мукачева, які надають послуги, враховуючи пільги на оплату житлово-комунальних послуг деяким категоріям громадян відповідно до чинного законодавства України. Комунальні організації та ОСББ надали акти-звірки нарахованих пільг на оплату житлово-комунальних послуг за вересень 2018 року на суму 802 938,0 гривень. Повідомляємо, що з квітня 2018 року для ОСББ саморозрахунок пільг на квартплату проводиться спеціалістами УПСЗН за допомогою програмного забезпечення ЄДАРП.
У вересні 2018 року 4372 сімей пільгових категорій громадян скористалися пільгами на оплату житлово-комунальних послуг, в тому числі сім`ї ветеранів війни, учасників бойових дій – 1449 , чорнобильців – 219 сімей, ветеранів військової служби, військовослужбовців та члени їх сімей – 1022 сімей, багатодітних сімей -307, та дітей війни – 1260 сімей. Фінансування цих пільг організаціям, які надають комунальні послуги мешканцям міста Мукачева, проводиться з Державного бюджету України. Всього з початку 2018 року було нараховано пільг на оплату житлово-комунальних послуг на суму 13 349 271,0 грн.
Відділ персоніфікованого обліку отримувачів пільг, гарантій та компенсацій УПСЗН.
Всі права захищено! Всі права на статті, зображення, інші матеріали належать МУКАЧІВСЬКІЙ МІСЬКІЙ РАДІ та охороняються законом України «Про авторське право і суміжні права».
SELECT `session_id`
FROM `zq89x_session`
WHERE `session_id` = '24385748hohqehcsvki9f6brk7'
LIMIT 0, 1
INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('24385748hohqehcsvki9f6brk7', 0, '1550446900')
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\":\"4b7bea5f0a7233e4d57c6d411a5b14f8\"}'
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=11914
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `zq89x_k2_categories`
SELECT *
FROM zq89x_k2_categories
WHERE id = '246'
SELECT *
FROM zq89x_k2_categories
WHERE id = '99'
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 = 11914
ORDER BY xref.id ASC
SELECT *
FROM zq89x_k2_attachments
WHERE itemID=11914
SELECT *
FROM zq89x_k2_rating
WHERE itemID = 11914
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=11914
AND published=1
SHOW FULL COLUMNS
FROM `zq89x_k2_items`
UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '11914'
SELECT *
FROM zq89x_k2_items
WHERE id != 11914
AND catid=246
AND ordering > 23
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 23:41:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 23:41:41' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
SELECT *
FROM zq89x_k2_items
WHERE id != 11914
AND catid=246
AND ordering < 23
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 23:41:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 23:41:41' )
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-17 23:41:41')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-17 23:41:41')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 820 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM zq89x_banners
WHERE '2019-02-17 23:41:41' >= '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 (47)
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 (47)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 10
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 20
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 17
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 19
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 18
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 21
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 22
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 23
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 24
UPDATE zq89x_banners
SET impmade = (impmade + 1)
WHERE id = 25
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_k2_items
WHERE id=11914
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=246
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=238
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=99
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)
9 × SELECT *
FROM zq89x_k2_categories
4 × SELECT *
FROM zq89x_k2_items
3 × SELECT *
FROM zq89x_modules
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM zq89x_extensions
1 × SELECT *
FROM zq89x_k2_attachments
1 × SELECT tag.*
FROM zq89x_k2_tags AS tag JOIN zq89x_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SELECT *
FROM zq89x_k2_rating
1 × SELECT *
FROM zq89x_banners
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 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 COUNT(*)
FROM zq89x_k2_comments
1 × SELECT id
FROM zq89x_k2_categories
1 × SELECT folder AS type, element AS name, params
FROM zq89x_extensions
1 × SELECT id, rules
FROM `zq89x_viewlevels
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 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 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 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 a.rules
FROM zq89x_assets AS a
1 × SELECT *
FROM zq89x_languages
1 × SELECT `session_id`
FROM `zq89x_session`
9 × 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\":\"4b7bea5f0a7233e4d57c6d411a5b14f8\"}'
1 × INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('24385748hohqehcsvki9f6brk7', 0, '1550446900'