Всі права захищено! Всі права на статті, зображення, інші матеріали належать МУКАЧІВСЬКІЙ МІСЬКІЙ РАДІ та охороняються законом України «Про авторське право і суміжні права».
SELECT `session_id`
FROM `zq89x_session`
WHERE `session_id` = 'p1m914klfm0p8t8akrhh754hq7'
LIMIT 0, 1
INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('p1m914klfm0p8t8akrhh754hq7', 0, '1550294010')
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\":\"3aa99164963c146a63595bf468843989\"}'
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=8455
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `zq89x_k2_categories`
SELECT *
FROM zq89x_k2_categories
WHERE id = '265'
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 = 8455
ORDER BY xref.id ASC
SELECT *
FROM zq89x_k2_attachments
WHERE itemID=8455
SELECT *
FROM zq89x_k2_rating
WHERE itemID = 8455
SHOW FULL COLUMNS
FROM `zq89x_users`
SELECT *
FROM `zq89x_users`
WHERE `id` = 435
SELECT `g`.`id`,`g`.`title`
FROM `zq89x_usergroups` AS g
INNER JOIN `zq89x_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 435
SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
WHERE userID=435
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=8455
AND published=1
SHOW FULL COLUMNS
FROM `zq89x_k2_items`
UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '8455'
SELECT *
FROM zq89x_k2_comments
WHERE itemID=8455
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10
SELECT i.*, c.alias as categoryalias
FROM zq89x_k2_items as i
LEFT JOIN zq89x_k2_categories c
ON c.id = i.catid
WHERE i.id != 8455
AND i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-02-16 05:13:31' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-16 05:13:31' )
AND i.access IN(1,1)
AND i.trash = 0
AND i.created_by = 435
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5
SELECT DISTINCT itemID
FROM zq89x_k2_tags_xref
WHERE tagID IN (57,122,58)
AND itemID!=8455
SELECT i.*, c.alias as categoryalias
FROM zq89x_k2_items as i
LEFT JOIN zq89x_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-02-16 05:13:31' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-16 05:13:31' )
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND (i.id) IN (428,359,538,537,602,641,717,726,738,740,752,759,768,789,793,801,802,811,839,852,866,867,868,878,880,929,931,941,955,1019,1023,1025,1096,1121,1258,1290,1293,1296,1297,1300,1317,1336,1364,1374,1375,1376,1381,1382,1384,1438,1441,1476,1488,1522,1670,1741,1746,1774,1786,1808,1810,1836,1894,1906,1914,1923,1937,1943,1959,1960,1964,1999,2092,2117,2146,2164,2194,2215,2225,2241,2262,2310,2321,2343,2350,2401,2411,2426,2469,2478,2529,2536,2540,2564,2582,2645,2654,2655,2676,2683,2708,2717,2742,2750,2784,2839,3761,2951,2999,3019,3037,3075,3101,3129,3173,3181,3335,3380,3382,3396,3420,3426,3438,3452,3541,3528,3581,3629,3632,3649,3650,3655,3658,3675,3682,3691,3708,3722,3748,3766,3798,3821,3826,3828,3829,3924,3958,3997,4017,4019,4027,4045,4083,4112,4114,4191,4193,4204,4246,4260,4278,4292,4362,4372,4449,4645,4729,4745,4764,4775,4796,4832,4839,4900,4905,4922,4975,4977,4990,5063,5173,5194,5231,5239,5242,5309,5310,5312,5336,5337,5347,5348,5371,5382,5402,5424,5433,5477,5482,5485,5491,5501,5517,5525,5526,5549,5560,5567,5571,5576,5616,5626,5652,5659,5666,5679,5681,5693,5700,5719,5721,5734,5743,5812,5837,5841,5846,5856,5857,5903,5906,5916,5925,5931,5935,5937,5946,5977,5982,5988,5995,6014,6032,6049,6055,6056,6087,6088,6094,6104,6118,6124,6132,6142,6152,6155,6162,6171,6178,6179,6184,6186,6187,6189,6223,6255,6256,6264,6287,6312,6319,6320,6334,6387,6472,6473,6475,6518,6579,6584,6646,6654,6656,6663,6678,6694,6714,6725,6735,6738,6772,6775,6817,6818,6892,6893,6894,6902,6907,6917,6922,6932,6945,6959,6962,6963,6965,6984,7028,7029,7030,7033,7110,7131,7143,7197,7226,7245,7246,7283,7285,7288,7292,7369,7384,7493,7560,7581,7582,7611,7651,7740,7768,7794,7828,7895,7952,8005,8015,8016,8025,8033,8070,8095,8098,8099,8100,8111,8170,8189,8226,8251,8276,8301,8302,8307,8318,8319,8348,8376,8379,8381,8393,8395,8427,8433,8438,8440,8467,8470,8482,8500,8509,8517,8536,8573,8579,8594,8593,8596,8628,8643,8690,8701,8748,8751,8840,8841,8855,8876,8879,8981,9076,9094,9108,9109,9172,9230,9232,9261,9305,9306,9325,9353,9354,9456,9461,9466,9490,9514,9516,9547,9555,9591,9611,9615,9739,9757,9758,9820,9859,9860,9892,9867,9900,9904,9905,9933,9990,9993,10010,10030,10045,10089,10091,10096,10105,10131,10137,10147,10181,10184,10212,10217,10218,10228,10233,10253,10274,10282,10291,10293,10306,10328,10363,10364,10397,10398,10411,10437,10460,10469,10478,10479,10482,10503,10526,10533,10537,10538,10539,10540,10541,10558,10559,10607,10610,10611,10612,10656,10662,10675,10684,10686,10737,10738,10774,10782,10793,10846,10868,10902,10945,10947,10962,10970,10979,11017,11027,11038,11042,11053,11061,11078,11102,11105,11139,11143,11168,11173,11177,11182,11202,11265,11285,11287,11300,11318,11325,11332,11341,11342,11381,11383,11448,11452,11453,11474,11490,11548,11549,11552,11569,11573,11595,11605,11615,11623,11635,11663,11670,11687,11732,11733,11743,11747,11748,11784,11856,11877,11885,11895,11896,11919,11920,11939,11961,11974,11981,12028,12032,12033,12078,12095,12121,12184,12185,12186,12187,12195,12209,12237,12250,12251,12252,12265,12303,12320,12346,12355,12375,12377,12410,12414,12452,12470,12491,12517,12540,12542,12585,12586,12606,12621,12623,12705,12726,12729,12761,12762,12824,12825,12830,12864,12891,12905,12932,12983,12997,13002,13012,13042,13051,13052,13119,13120,13121,13122,13193,13208,13224,13249,13290,13311,13354,13355,13356,13357,13378,13388,13421,13422,13423,13424,13429,13431,13434,13464,13488,13492,13528,13586,13587,13624,13625,13659,13701,13714,13767,13807,13809,13810,13818,13833,13848,13851,13852,13904,13909,13941,13947,13954,13957,13960,13962,13981,13988,14025,14059,14073,14074,300,362,378,377,331,352,339,304,393,366,365,367,455,364,474,475,478,481,290,483,489,490,493,384,495,497,499,508,510,511,512,513,518,556,557,606,303,633,634,652,694,693,697,700,718,735,763,767,815,613,445,805,834,851,861,891,896,914,919,920,938,964,967,989,991,1047,1082,1165,1178,1217,1241,1287,1288,1307,1338,1358,1377,1394,1399,1413,1463,1475,1520,1524,1537,1551,1559,1625,1638,1655,1663,1711,1731,1767,1775,1787,1797,1798,1832,1861,1862,1893,1898,1927,1944,1950,1980,1987,2049,2062,2083,2108,2111,2138,2152,2204,2216,2223,2229,2236,2274,2278,2281,2300,2304,2320,2352,2403,2434,2463,2512,2543,2563,2565,2622,2639,2703,2716,2735,2737,2744,2757,2814,2817,2830,2844,2929,2941,2942,2943,2970,2985,3000,3001,3012,3017,3033,3036,3055,3061,3063,3074,3083,3084,3099,3100,3105,3116,3123,3141,3143,3144,3145,3167,3172,3203,3204,3207,3209,3222,3268,3276,3286,3294,3296,3355,3357,3359,3394,3423,3424,3432,3434,3445,3474,3485,3486,3506,3507,3540,3530,3583,3593,3595,3599,3603,3607,3610,3613,3614,3615,3623,3624,3661,3664,3665,3521,3470,3392,2440,2505,2551,2609,2657,2724,2764,2822,2855,2906,2989,3174,3077,3666,3674,3681,3692,3702,3715,3721,3740,3747,3762,3763,3787,3801,3817,3820,3848,3860,3870,3890,3891,3892,3899,3901,3903,3920,3955,3963,3980,3981,3994,3998,3999,4000,4001,4015,4016,4037,4049,4056,4065,4073,4080,4081,4089,4090,4096,4119,4120,4154,4188,4189,4211,4214,4231,4232,4244,4245,4279,4306,4320,4321,4322,4340,4344,4357,4359,4383,4394,4395,4410,4426,4427,4433,4448,419,4473,4474,4475,4500,4505,4542,4543,4544,4578,4583,4596,4601,4602,4610,4618,4620,4634,4636,4657,4680,4681,4683,4689,4699,4707,4711,4730,4731,4732,4762,4777,4799,4812,4819,4822,4823,4825,4826,4862,4883,4899,4914,4923,4931,4932,4933,4934,4942,4945,4946,4959,4960,4974,4976,4979,4981,4989,4991,4993,5009,5027,5029,5031,5034,5038,5040,5053,5059,5067,5068,5095,5096,5109,5120,5130,5141,5146,5147,5167,5202,5203,5206,5253,5275,5285,5297,5330,5350,5354,5360,5400,5403,5406,5414,5476,5488,5500,5512,5513,5528,5545,5551,5559,5596,5610,5611,5614,5615,5632,5634,5645,5647,5648,5676,5688,5723,5751,5785,5793,5796,5811,5817,5821,5831,5833,5836,5842,5844,5850,5867,5875,5895,5912,5914,5915,5936,5956,5994,5996,6005,6016,6017,6027,6031,6033,6046,6047,6034,6080,6091,6110,6125,6140,6150,6157,6163,6174,6180,6204,6222,6240,6252,6254,6259,6262,6263,6292,6296,6304,6311,6314,6368,6383,6385,6435,6450,6455,6515,6523,6530,6554,6561,6566,6578,6582,6593,6637,6649,6650,6651,6652,6655,6657,6675,6719,6724,6751,6761,6784,6800,6813,6822,6839,6845,6847,6852,6879,6881,6921,6923,6935,6944,6950,6951,6957,6973,7010,7011,7022,7043,7062,7083,7084,7103,7104,7105,7121,7123,7139,7149,7156,7191,7195,7214,7251,7253,7281,7282,7355,7363,7367,7380,7396,7440,7476,7483,7490,7491,7518,7522,7590,7593,7598,7626,7631,7648,7660,7682,7689,7690,7715,7730,7735,7745,7769,7849,7864,7886,7890,7913,7915,7927,7930,7941,7945,7967,7986,8001,8002,8007,8035,8038,8044,8094,8108,8164,8175,8182,8198,8210,8221,8224,8243,8267,8272,8299,8303,8331,8365,8367,8375,8434,8436,8445,8456,8463,8464,8471,8472,8489,8510,8511,8512,8559,8563,8575,8576,8612,8613,8622,8660,8661,8662,8663,8664,8665,8666,8667,8668,8669,8670,8679,8688,8693,8694,8700,8757,8758,8759,8760,8762,8763,8764,8768,8769,8770,8771,8798,8811,8821,8822,8829,8863,8872,8873,8968,8972,8973,9035,9068,9078,9086,9114,9207,9217,9218,9226,9228,9272,9284,9286,9343,9382,9451,9458,9545,9649,9650,9651,9652,9669,9745,9750,9851,9955,9967,9972,10014,10024,10033,10043,10075,10090,10093,10130,10159,10168,10174,10206,10207,10234,10243,10294,10341,10368,10380,10402,10499,10500,10502,10529,10579,10592,10888,11015,11159,11160,11161,11162,11181,11238,11468,11534,11542,11554,11570,11601,11606,11667,11683,11688,11696,11699,11765,11835,11837,11838,11874,11910,11929,11955,11970,12015,12030,12031,12071,12079,12100,12155,12162,12196,12197,12268,12292,12293,12321,12403,12404,12439,12440,12513,12539,12569,12630,12862,12863,12867,12887,12902,12908,12922,13017,13065,13092,13093,13162,13163,13248,13250,13252,13286,13291,13330,13332,13333,13366,13374,13458,13490,13560,13564,13630,13631,13634,13688,13730,13742,13788,13907,13918,13919,13920,13982,14037,1212,1214,1291,1301,1330,1447,1454,1487,1489,1548,1592,1611,1645,1759,2082,2153,2197,2649,3073,4013,4130,4131,4352,4725,6117,6316,6487,6559,6580,6757,6814,6914,7055,7086,7102,7144,7155,7174,7182,7249,7322,7332,7387,7435,7437,7507,7508,7564,7576,7612,7747,7774,7775,7782,7827,7850,7855,7969,8096,8121,8216,8219,8238,8325,8336,8347,8368,8401,8414,8425,8421,8479,8513,8543,8585,8641,8642,8730,8828,8842,8848,8853,8865,8866,8868,8874,8886,8892,8907,8908,8910,8911,8914,8918,8920,8921,8924,8987,8990,8991,9022,9028,9116,9131,9145,9176,9188,9189,9190,9201,9222,9247,9248,9259,9276,9277,9303,9352,9384,9387,9449,9483,9491,9522,9549,9579,9587,9603,9646,9673,9674,9696,9705,9706,9707,9709,9723,9728,9755,9767,9771,9787,9858,9907,9878,9890,9948,9956,9995,10016,10058,10070,10071,10087,10099,10127,10145,10161,10182,10187,10189,10210,10211,10229,10260,10267,10298,10350,10351,10441,10446,10463,10477,10481,10510,10532,10599,10600,10602,10606,10632,10651,10677,10697,10706,10739,10747,10773,10775,10776,10779,10798,10870,10889,10954,10971,10974,10987,10988,10989,10990,11010,11011,11026,11036,11057,11060,11088,11097,11098,11114,11142,11187,11197,11224,11295,11354,11362,11368,11375,11376,11382,11386,11391,11394,11466,11477,11527,11572,11628,11632,11680,11689,11706,11741,11762,11763,11778,11780,11862,11901,11911,11913,11941,12007,12038,12039,12075,12133,12169,12170,12208,12306,12333,12338,12341,12342,12343,12350,12351,12352,12353,12357,12469,12482,12500,12570,12647,12670,12671,12672,12789,12813,12848,12870,12895,12898,12929,12934,12959,12965,12966,13013,13038,13039,13047,13066,13067,13088,13089,13091,13106,13112,13188,13239,13240,13312,13377,13391,13392,13445,13480,13521,13554,13602,13610,13689,13697,13709,13745,13766,13815,13816,13841,13842,13843,13853,13857,13890,13891,13900,13906,13961,13979,13980,13995,14001)
ORDER BY i.created DESC
LIMIT 0, 5
SELECT *
FROM zq89x_k2_categories
WHERE id = '159'
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14074
AND published=1
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14073
AND published=1
SELECT *
FROM zq89x_k2_categories
WHERE id = '194'
SELECT *
FROM zq89x_k2_categories
WHERE id = '76'
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14059
AND published=1
SELECT *
FROM zq89x_k2_categories
WHERE id = '85'
SELECT *
FROM `zq89x_users`
WHERE `id` = 431
SELECT `g`.`id`,`g`.`title`
FROM `zq89x_usergroups` AS g
INNER JOIN `zq89x_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 431
SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
WHERE userID=431
SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
WHERE userID=431
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14037
AND published=1
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14025
AND published=1
SELECT *
FROM zq89x_k2_items
WHERE id != 8455
AND catid=265
AND ordering > 44
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-16 05:13:31' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-16 05:13:31' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
SELECT *
FROM zq89x_k2_items
WHERE id != 8455
AND catid=265
AND ordering < 44
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-16 05:13:31' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-16 05:13: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 05:13:31')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-16 05:13:31')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 989 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_modules
WHERE published=1
ORDER BY id ;
SELECT *
FROM zq89x_banners
WHERE '2019-02-16 05:13: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