SELECT MAX(TIME)
FROM jos_vvcounter_logs
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(20,51,173,1,52,178,24,172,174,166,175,214,186,215,177,219,225,185,179,217,202,218,171,216,220,221,223,222,151,153,154,155,156,157,158,159,160,161,162,163,147,187,189,196,148,208,193,213,206,207,203,149,205,191,165,180,182,190,224)
AND jf_content.reference_table='menu'
SELECT *
FROM jos_rokcandy
WHERE published=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 219)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
SELECT *
FROM jos_k2_categories
WHERE published=1
AND trash=0
AND access<=0
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(130,2,3,4,5,6,7,8,9,10,131,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,133,132,125,126,127,128,91,92,93,94,95,134,97,98,99,100,101,102,103,104,105,106,107,108,109,129,111,136,114,135,115,116,117,118,119,120,121,122,123,124,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,179,175,176,177,178)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_items
WHERE id=156
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(156)
AND jf_content.reference_table='k2_items'
SELECT *
FROM jos_k2_categories
WHERE id=108
LIMIT 0, 1
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(108)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_tags AS tags
WHERE tags.published=1
AND tags.id IN (SELECT tagID
FROM jos_k2_tags_xref
WHERE itemID=156)
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(41)
AND jf_content.reference_table='k2_tags'
SELECT *
FROM jos_k2_extra_fields
WHERE published=1
AND id IN (20,19,4,5,6,17,18,7)
ORDER BY ordering ASC
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(20,19,4,5,6,17,18,7)
AND jf_content.reference_table='k2_extra_fields'
SELECT *
FROM jos_k2_attachments
WHERE itemID=156
SELECT *
FROM jos_k2_rating
WHERE itemID = 156
SELECT *
FROM jos_k2_rating
WHERE itemID = 156
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=156
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='62'
ORDER BY g.id
SELECT *
FROM jos_komento_configs
WHERE component = 'com_k2'
UPDATE jos_k2_items
SET hits = ( hits + 1 )
WHERE id='156'
SELECT a.*, c.alias AS category_alias
FROM `jos_k2_items` AS a
LEFT JOIN `jos_k2_categories` AS c
ON c.id = a.catid
WHERE a.id='156'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(156)
AND jf_content.reference_table='k2_items'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(156)
AND jf_content.reference_table='k2_categories'
SELECT `id`
FROM `jos_komento_mailq`
WHERE `status` = 0
ORDER BY `created` ASC
LIMIT 5
SELECT *
FROM jos_komento_configs
WHERE component = 'com_komento'
SELECT *
FROM `jos_komento_acl`
WHERE `cid`='29'
AND `type`='usergroup'
AND `component`='com_k2'
ORDER BY `id`
SELECT *
FROM `jos_komento_acl`
WHERE `cid`='0'
AND `type`='user'
AND `component`='com_k2'
ORDER BY `id`
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (156)
AND x.published = '1') AS x
SELECT x.*, COUNT(y.id) - 1 AS depth
FROM `jos_komento_comments` AS x
INNER JOIN `jos_komento_comments` AS y
ON x.component = y.component
AND x.cid = y.cid
AND x.lft BETWEEN y.lft
AND y.rgt
WHERE x.component = 'com_k2'
AND x.cid IN (156)
AND x.published = '1'
GROUP BY x.id
ORDER BY x.lft ASC
LIMIT 0,10
INSERT INTO `jos_komento_captcha` ( `created` )
VALUES ( '2021-04-13 11:28:25' )
SELECT `name`, `created_by`
FROM (SELECT `name`, `created_by`, `created`
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '156'
AND `created_by` <> '0'
AND `created_by` <> ''
GROUP BY `created_by`
ORDER BY `created` DESC
LIMIT 10) AS x
ORDER BY `created` DESC
LIMIT 10
SELECT *
FROM jos_komento_comments
WHERE id = '80'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '156'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '80'
SELECT COUNT(`parent`.`id`)-1 AS `depth`
FROM `jos_komento_comments` AS `node`
INNER JOIN `jos_komento_comments` AS `parent`
ON parent.component = node.component
AND node.cid = parent.cid
WHERE `node`.`component` = 'com_k2'
AND `node`.`cid` = '156'
AND `node`.`id` = '80'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '80'
SELECT *
FROM `jos_komento_uploads`
WHERE `uid` = '80'
ORDER BY `created`
SELECT *
FROM jos_users
WHERE id = '62'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(62)
AND jf_content.reference_table='users'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(62)
AND jf_content.reference_table='users'
SELECT *
FROM jos_users
WHERE id = '62'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(62)
AND jf_content.reference_table='users'
SELECT x.*, COUNT(y.id) - 1 AS depth
FROM `jos_komento_comments` AS x
INNER JOIN `jos_komento_comments` AS y
ON x.component = y.component
AND x.cid = y.cid
AND x.lft BETWEEN y.lft
AND y.rgt
WHERE x.component = 'com_k2'
AND x.cid IN (156)
AND x.published = '1'
GROUP BY x.id
ORDER BY x.lft ASC
LIMIT 0,10
INSERT INTO `jos_komento_captcha` ( `created` )
VALUES ( '2021-04-13 11:28:25' )
SELECT `name`, `created_by`
FROM (SELECT `name`, `created_by`, `created`
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '156'
AND `created_by` <> '0'
AND `created_by` <> ''
GROUP BY `created_by`
ORDER BY `created` DESC
LIMIT 10) AS x
ORDER BY `created` DESC
LIMIT 10
SELECT *
FROM jos_komento_comments
WHERE id = '80'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '156'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT COUNT(`parent`.`id`)-1 AS `depth`
FROM `jos_komento_comments` AS `node`
INNER JOIN `jos_komento_comments` AS `parent`
ON parent.component = node.component
AND node.cid = parent.cid
WHERE `node`.`component` = 'com_k2'
AND `node`.`cid` = '156'
AND `node`.`id` = '80'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '80'
SELECT *
FROM `jos_komento_uploads`
WHERE `uid` = '80'
ORDER BY `created`
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 219 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(195,199,205,43,167,196,136,302)
AND jf_content.reference_table='modules'
SELECT *
FROM jos_languages
WHERE active=1
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=2
AND jf_content.published=1
AND jf_content.reference_id IN(20,51,173,1,52,178,24,172,174,166,175,214,186,215,177,219,225,185,179,217,202,218,171,216,220,221,223,222,151,153,154,155,156,157,158,159,160,161,162,163,147,187,189,196,148,208,193,213,206,207,203,149,205,191,165,180,182,190,224)
AND jf_content.reference_table='menu'
SELECT jf_content.reference_field, jf_content.VALUE, jf_content.reference_id, jf_content.original_value
FROM jos_jf_content AS jf_content
WHERE jf_content.language_id=1
AND jf_content.published=1
AND jf_content.reference_id IN(219)
AND jf_content.reference_table='menu'
Leave your comments