Всі права захищено! Всі права на статті, зображення, інші матеріали належать МУКАЧІВСЬКІЙ МІСЬКІЙ РАДІ та охороняються законом України «Про авторське право і суміжні права».
DELETE
FROM `zq89x_session`
WHERE `time` < '1550445777'
SELECT `session_id`
FROM `zq89x_session`
WHERE `session_id` = '7lp0fgijdla5pulapm1su61lu1'
LIMIT 0, 1
INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('7lp0fgijdla5pulapm1su61lu1', 0, '1550446677')
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\":\"f356c8c5abd72cfe5492d136253ae2df\"}'
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=306
LIMIT 0, 1
SHOW FULL COLUMNS
FROM `zq89x_k2_categories`
SELECT *
FROM zq89x_k2_categories
WHERE id = '145'
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 = 306
ORDER BY xref.id ASC
SELECT *
FROM zq89x_k2_attachments
WHERE itemID=306
SELECT *
FROM zq89x_k2_rating
WHERE itemID = 306
SHOW FULL COLUMNS
FROM `zq89x_users`
SELECT *
FROM `zq89x_users`
WHERE `id` = 421
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` = 421
SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
WHERE userID=421
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=306
AND published=1
SHOW FULL COLUMNS
FROM `zq89x_k2_items`
UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '306'
SELECT *
FROM zq89x_k2_comments
WHERE itemID=306
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 != 306
AND i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-02-17 23:37:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-17 23:37:57' )
AND i.access IN(1,1)
AND i.trash = 0
AND i.created_by = 421
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, 4
SELECT DISTINCT itemID
FROM zq89x_k2_tags_xref
WHERE tagID IN (49)
AND itemID!=306
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-17 23:37:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-02-17 23:37:57' )
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 (394,373,457,375,362,340,516,374,421,427,403,412,356,360,313,312,311,310,309,308,307,471,472,473,514,515,543,544,547,548,552,554,571,570,615,616,623,624,625,626,627,628,629,630,631,638,639,644,645,649,672,677,678,780,781,785,789,613,614,850,886,893,973,1005,1031,1060,1078,1084,1105,1120,1159,1163,1184,1222,1223,1224,1298,1304,1312,1313,1332,1339,1352,1362,1380,1389,1400,1404,1407,1410,1414,1421,1437,1479,1487,1490,1532,1541,1544,1545,1547,1550,1555,1597,1640,1651,1678,1737,1765,1798,1804,1826,1830,1834,1852,1860,1885,1949,1978,2003,2007,2020,2036,2038,2058,2061,2068,2069,2070,2071,2102,2124,2130,2131,2202,2205,2208,2218,2233,2242,2248,2309,2311,2312,2338,2340,2354,2359,2383,2391,2398,2412,2423,2424,2432,2455,2456,2457,2465,2467,2477,2483,2486,2489,2508,2511,2516,2525,2531,2544,2546,2549,2560,2562,2583,2604,2605,2610,2614,2660,2674,2726,2761,2791,2812,2815,2817,2828,2829,2847,2853,2856,2864,2884,2898,2905,2907,2911,2912,2913,2914,2916,2917,2921,2922,2948,2961,3003,3014,3015,3031,3034,3049,3073,3098,3103,3106,3132,3138,3185,3186,3187,3223,3225,3232,3220,3235,3236,3249,3257,3259,3269,3274,3277,3289,3292,3293,3343,3344,3345,3353,3383,3395,3401,3416,3430,3433,3435,3436,3437,3446,3451,3460,3468,3469,3483,3492,3512,3522,3531,3549,3550,3553,3557,3561,3573,3574,3577,3603,3608,3609,3612,3628,3670,3711,3712,3719,3720,3737,3736,3743,3747,3764,3768,3776,3834,3837,3838,3859,3888,3901,3914,3915,3923,3940,3955,3966,3971,3979,4009,4040,4049,4054,4055,4091,4093,4094,4095,4113,4123,4124,4134,4141,4172,4176,4183,4185,4186,4187,4194,4202,4227,4239,4247,4249,4256,4258,4265,4284,4289,4295,4304,4313,4324,4325,4328,4329,4345,4355,4368,4370,4381,4402,4403,4408,4409,4417,4419,4441,4444,4452,4455,4459,4461,4464,4465,4479,4494,4503,4517,4518,4519,4535,4547,4572,4576,4577,4579,4581,4598,4599,4616,4624,4637,4638,4640,4662,4663,4664,4678,4688,4701,4767,4771,4774,4777,4784,4790,4797,4798,4804,4805,4808,4809,4819,4830,4836,4837,4850,4866,4867,4868,4869,4874,4888,4891,4893,4912,4914,4915,4925,4926,4940,4942,4947,4949,4953,4958,4971,4973,4980,4983,4984,4998,5015,5016,5017,5018,5025,5026,5041,5048,5049,5052,5076,5077,5078,5079,5092,5094,5113,5114,5124,5126,5132,5135,5144,5156,5157,5158,5159,5161,5184,5185,5186,5190,5192,5193,5195,5196,5197,5198,5199,5200,5209,5210,5216,5218,5222,5223,5224,5228,5230,5233,5240,5244,5246,5251,5255,5262,5264,5271,5272,5286,5287,5288,5289,5290,5293,5308,5316,5324,5325,5338,5356,5363,5370,5388,5389,5405,5408,5437,5446,5456,5457,5458,5473,5474,5504,5507,5508,5509,5518,5519,5520,5530,5531,5532,5542,5550,5551,5566,5580,5581,5582,5608,5617,5618,5621,5627,5638,5641,5642,5661,5662,5663,5665,5668,5670,5675,5680,5684,5702,5704,5715,5716,5724,5731,5735,5756,5789,5790,5791,5792,5794,5806,5807,5809,5838,5839,5868,5870,5885,5892,5913,5930,5932,5939,5950,5955,5965,5972,6006,6035,6037,6039,6040,6051,6052,6058,6084,6095,6113,6114,6121,6131,6147,6158,6177,6198,6201,6209,6265,6267,6270,6275,6288,6293,6300,6301,6313,6330,6332,6341,6370,6372,6392,6394,6395,6401,6410,6419,6420,6421,6427,6428,6429,6430,6437,6446,6449,6452,6462,6464,6476,6478,6491,6496,6504,6505,6506,6533,6537,6562,6595,6625,6670,6674,6679,6690,6700,6701,6703,6765,6766,6785,6786,6788,6805,6806,6807,6808,6820,6830,6835,6837,6838,6844,6853,6858,6859,6880,6930,6933,6934,6937,6968,6969,6977,6979,6983,7021,7023,7024,7061,7089,7093,7098,7114,7125,7130,7150,7151,7165,7173,7200,7204,7205,7224,7232,7237,7238,7239,7249,7304,7306,7307,7317,7318,7353,7354,7356,7375,7386,7388,7390,7401,7402,7403,7412,7470,7475,7477,7482,7495,7496,7501,7503,7504,7519,7579,7580,7600,7640,7655,7657,7662,7663,7683,7753,7755,7825,7826,7835,7836,7854,7861,7882,7883,7884,7885,7901,7908,7935,7936,7937,7938,7940,7946,7948,7949,7953,7960,7962,7972,7976,7987,7992,7993,7994,7996,8000,8012,8014,8042,8052,8056,8073,8113,8114,8143,8147,8163,8173,8192,8199,8217,8218,8220,8227,8242,8250,8273,8284,8289,8290,8300,8321,8328,8330,8332,8334,8362,8364,8375,8378,8390,8416,8424,8428,8444,8454,8475,8478,8486,8487,8499,8506,8513,8520,8521,8523,8529,8532,8533,8546,8554,8555,8559,8578,8587,8598,8626,8647,8654,8671,8672,8678,8689,8704,8705,8723,8724,8726,8755,8772,8790,8791,8793,8807,8808,8809,8815,8819,8831,8844,8847,8852,8859,8862,8867,8869,8897,8898,8899,8902,8913,8935,8936,8937,8938,8943,8944,8947,8965,8966,8967,8977,8979,8980,8984,8985,8993,8999,9006,9007,9008,9025,9029,9031,9034,9041,9048,9054,9061,9077,9083,9087,9088,9089,9092,9093,9101,9122,9167,9171,9175,9179,9180,9181,9186,9214,9215,9220,9221,9225,9229,9231,9236,9242,9243,9255,9256,9257,9258,9273,9274,9287,9317,9307,9366,9373,9374,9378,9426,9428,9429,9430,9431,9432,9473,9474,9475,9477,9509,9510,9526,9530,9532,9533,9534,9566,9570,9592,9610,9613,9619,9620,9621,9622,9623,9624,9625,9642,9643,9660,9665,9668,9681,9682,9683,9686,9689,9690,9695,9721,9725,9733,9734,9735,9736,9737,9738,9763,9765,9766,9769,9775,9781,9790,9792,9798,9799,9801,9802,9804,9805,9810,9862,9863,9869,9876,9879,9909,9911,9912,9913,9932,9985,9986,9987,9988,9989,10041,10042,10049,10060,10061,10066,10067,10068,10111,10116,10117,10118,10119,10120,10121,10138,10139,10140,10150,10152,10156,10157,10158,10171,10173,10177,10179,10203,10222,10255,10257,10258,10264,10275,10276,10292,10313,10314,10325,10326,10330,10331,10333,10334,10335,10336,10357,10358,10394,10395,10396,10410,10412,10413,10419,10420,10448,10511,10517,10527,10531,10555,10562,10563,10564,10565,10566,10576,10577,10617,10622,10638,10639,10663,10664,10665,10703,10722,10723,10724,10729,10730,10744,10745,10746,10763,10764,10772,10771,10800,10801,10815,10822,10841,10869,10922,10923,10930,10972,10976,10992,10993,11047,11048,11099,11104,11122,11123,11124,11147,11166,11183,11184,11240,11241,11272,11279,11292,11302,11303,11304,11305,11316,11317,11348,11417,11418,11431,11479,11481,11504,11505,11516,11517,11524,11528,11550,11582,11583,11584,11591,11602,11633,11640,11646,11672,11674,11679,11724,11725,11726,11761,11773,11774,11777,11781,11814,11817,11818,11819,11836,11851,11860,11861,11869,11889,11903,11904,11947,11975,11982,11988,11989,11992,11998,11999,12026,12092,12093,12110,12111,12130,12141,12144,12154,12164,12174,12175,12260,12282,12283,12313,12314,12315,12322,12325,12394,12395,12420,12421,12425,12426,12427,12507,12512,12488,12518,12519,12559,12560,12568,12583,12587,12588,12644,12649,12663,12674,12676,12711,12720,12721,12722,12742,12769,12771,12793,12839,12840,12843,12844,12845,12846,12859,12868,12874,12909,12911,12913,12926,12936,12937,12949,12979,12980,12988,13040,13075,13097,13098,13099,13118,13126,13186,13187,13195,13196,13197,13201,13202,13230,13231,13232,13233,13236,13237,13301,13303,13304,13306,13307,13308,13319,13320,13321,13337,13338,13341,13358,13380,13381,13382,13385,13402,13403,13404,13433,13466,13475,13476,13477,13481,13482,13483,13484,13511,13518,13523,13524,13555,13573,13574,13577,13633,13668,13675,13694,13697,13707,13708,13740,13755,13760,13792,13826,13827,13836,13858,13859,13874,13922,13936,13937,13946,13949,13959,13969,13973,14015,14016,14024,14043)
ORDER BY i.created DESC
LIMIT 0, 4
SELECT *
FROM zq89x_k2_categories
WHERE id = '90'
SELECT *
FROM zq89x_k2_categories
WHERE id = '76'
SELECT *
FROM `zq89x_users`
WHERE `id` = 424
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` = 424
SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
WHERE userID=424
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14043
AND published=1
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14024
AND published=1
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14016
AND published=1
SELECT COUNT(*)
FROM zq89x_k2_comments
WHERE itemID=14015
AND published=1
SELECT *
FROM zq89x_k2_items
WHERE id > 306
AND catid=145
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 23:37:57' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 23:37:57' )
AND access IN(1,1)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
SELECT *
FROM zq89x_k2_items
WHERE id < 306
AND catid=145
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-17 23:37:57' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 23:37:57' )
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:37:57')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-17 23:37:57')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 553 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_k2_items
WHERE id=306
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=145
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=196
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=90
AND published=1
AND trash=0
AND access IN(1,1)
SELECT *
FROM zq89x_k2_categories
WHERE id=76
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)
10 × SELECT *
FROM zq89x_k2_categories
5 × SELECT COUNT(*)
FROM zq89x_k2_comments
4 × SELECT *
FROM zq89x_k2_items
2 × SELECT *
FROM zq89x_modules
2 × SELECT `g`.`id`,`g`.`title`
FROM `zq89x_usergroups` AS g
INNER JOIN `zq89x_user_usergroup_map` AS m
ON m.group_id = g.id
2 × SELECT id, gender, description, image, url, `
group`, plugins
FROM zq89x_k2_users
2 × SELECT i.*, c.alias as categoryalias
FROM zq89x_k2_items as i
LEFT JOIN zq89x_k2_categories c
ON c.id = i.catid
2 × SELECT *
FROM `zq89x_users`
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM zq89x_extensions
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 DISTINCT itemID
FROM zq89x_k2_tags_xref
1 × SELECT *
FROM zq89x_k2_comments
1 × SELECT `session_id`
FROM `zq89x_session`
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 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 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 *
FROM zq89x_languages
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 a.rules
FROM zq89x_assets AS a
1 × SELECT tag.*
FROM zq89x_k2_tags AS tag JOIN zq89x_k2_tags_xref AS xref
ON tag.id = xref.tagID
1 × SHOW FULL COLUMNS
FROM `zq89x_k2_items
1 × UPDATE zq89x_k2_items
SET `hits` = (`hits` + 1)
1 × SHOW FULL COLUMNS
FROM `zq89x_users
1 × SHOW FULL COLUMNS
FROM `zq89x_k2_categories
1 × INSERT INTO `zq89x_session` (`session_id`, `client_id`, `time`)
VALUES ('7lp0fgijdla5pulapm1su61lu1', 0, '1550446677'
1 × UPDATE `zq89x_extensions`
SET `params` = '{\"mediaversion\":\"f356c8c5abd72cfe5492d136253ae2df\"}'
1 × DELETE
FROM `zq89x_session`