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 = 177)
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 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 = 177 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,35,267,260,268,296,199,205,43,167,196,287,286,136,302)
AND jf_content.reference_table='modules'
SELECT *
FROM jos_komento_configs
WHERE component = 'com_content'
SELECT *
FROM jos_komento_configs
WHERE component = 'com_komento'
SELECT activities.*, comments.component, comments.cid, comments.comment, comments.name, comments.created_by, comments.parent_id
FROM `jos_komento_activities` AS activities
LEFT JOIN `jos_komento_comments` AS comments
ON activities.comment_id = comments.id
WHERE activities.published = '1'
AND comments.published = 1
AND comments.component IS NOT NULL
AND comments.cid IS NOT NULL
AND activities.TYPE IN ('reply')
ORDER BY activities.created DESC
LIMIT 0,5
SELECT *
FROM jos_komento_comments
WHERE id = '60'
SELECT *
FROM jos_komento_configs
WHERE component = 'com_k2'
SELECT *
FROM jos_komento_comments
WHERE id = '60'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '12'
AND '13'
AND `lft` != '12'
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` = '65'
AND `node`.`id` = '60'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='65'
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(65)
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(65)
AND jf_content.reference_table='k2_categories'
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 COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '60'
SELECT *
FROM jos_komento_comments
WHERE id = '54'
SELECT *
FROM jos_komento_comments
WHERE id = '54'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '1'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
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` = '1'
AND `node`.`id` = '54'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='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(1)
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(1)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '54'
SELECT *
FROM jos_komento_comments
WHERE id = '53'
SELECT *
FROM jos_komento_comments
WHERE id = '53'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '16'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
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` = '16'
AND `node`.`id` = '53'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='16'
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(16)
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(16)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '53'
SELECT *
FROM jos_komento_comments
WHERE id = '52'
SELECT *
FROM jos_komento_comments
WHERE id = '52'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '32'
AND '33'
AND `lft` != '32'
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` = '11'
AND `node`.`id` = '52'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='11'
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(11)
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(11)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '52'
SELECT *
FROM jos_komento_comments
WHERE id = '51'
SELECT *
FROM jos_komento_comments
WHERE id = '51'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '26'
AND '27'
AND `lft` != '26'
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` = '11'
AND `node`.`id` = '51'
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` = '51'
SELECT DISTINCT `component`
FROM `jos_komento_comments`
ORDER BY `component`
SELECT `id`
FROM `jos_k2_items`
ORDER BY `id`
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(1,2,3,4,5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,42,46,51,53,54,55,57,60,61,62,65,66,67,68,69,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,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,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234)
AND jf_content.reference_table='k2_items'
SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.cid IN (1,2,3,4,5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,32,33,34,35,36,37,38,39,42,46,51,53,54,55,57,60,61,62,65,66,67,68,69,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,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,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234)
AND x.published = '1'
ORDER BY x.created DESC
LIMIT 0,50
SELECT *
FROM jos_komento_comments
WHERE id = '281'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '223'
AND `lft` BETWEEN '9'
AND '10'
AND `lft` != '9'
SELECT *
FROM jos_komento_comments
WHERE id = '281'
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` = '223'
AND `node`.`id` = '281'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='223'
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(223)
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(223)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '281'
SELECT *
FROM jos_komento_comments
WHERE id = '221'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '230'
AND `lft` BETWEEN '7'
AND '8'
AND `lft` != '7'
SELECT *
FROM jos_komento_comments
WHERE id = '221'
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` = '230'
AND `node`.`id` = '221'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='230'
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(230)
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(230)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '221'
SELECT *
FROM jos_komento_comments
WHERE id = '170'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '21'
AND '22'
AND `lft` != '21'
SELECT *
FROM jos_komento_comments
WHERE id = '170'
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` = '206'
AND `node`.`id` = '170'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='206'
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(206)
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(206)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '170'
SELECT *
FROM jos_komento_comments
WHERE id = '150'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '209'
AND `lft` BETWEEN '9'
AND '10'
AND `lft` != '9'
SELECT *
FROM jos_komento_comments
WHERE id = '150'
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` = '209'
AND `node`.`id` = '150'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='209'
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(209)
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(209)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '150'
SELECT *
FROM jos_komento_comments
WHERE id = '149'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '170'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '149'
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` = '170'
AND `node`.`id` = '149'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='170'
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(170)
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(170)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '149'
SELECT *
FROM jos_komento_comments
WHERE id = '144'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '8'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '144'
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` = '8'
AND `node`.`id` = '144'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='8'
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(8)
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(8)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '144'
SELECT *
FROM jos_komento_comments
WHERE id = '97'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '13'
AND '14'
AND `lft` != '13'
SELECT *
FROM jos_komento_comments
WHERE id = '97'
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` = '206'
AND `node`.`id` = '97'
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` = '97'
SELECT *
FROM jos_komento_comments
WHERE id = '96'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '1'
AND `lft` BETWEEN '7'
AND '8'
AND `lft` != '7'
SELECT *
FROM jos_komento_comments
WHERE id = '96'
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` = '1'
AND `node`.`id` = '96'
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` = '96'
SELECT *
FROM jos_komento_comments
WHERE id = '95'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '21'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '95'
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` = '21'
AND `node`.`id` = '95'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='21'
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(21)
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(21)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '95'
SELECT *
FROM jos_komento_comments
WHERE id = '90'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '1'
AND `lft` BETWEEN '5'
AND '6'
AND `lft` != '5'
SELECT *
FROM jos_komento_comments
WHERE id = '90'
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` = '1'
AND `node`.`id` = '90'
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` = '90'
SELECT *
FROM jos_komento_comments
WHERE id = '88'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '11'
AND '12'
AND `lft` != '11'
SELECT *
FROM jos_komento_comments
WHERE id = '88'
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` = '206'
AND `node`.`id` = '88'
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` = '88'
SELECT *
FROM jos_komento_comments
WHERE id = '87'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '22'
AND `lft` BETWEEN '17'
AND '18'
AND `lft` != '17'
SELECT *
FROM jos_komento_comments
WHERE id = '87'
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` = '22'
AND `node`.`id` = '87'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='22'
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(22)
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(22)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '87'
SELECT *
FROM jos_komento_comments
WHERE id = '86'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '22'
AND `lft` BETWEEN '15'
AND '16'
AND `lft` != '15'
SELECT *
FROM jos_komento_comments
WHERE id = '86'
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` = '22'
AND `node`.`id` = '86'
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` = '86'
SELECT *
FROM jos_komento_comments
WHERE id = '85'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '43'
AND '44'
AND `lft` != '43'
SELECT *
FROM jos_komento_comments
WHERE id = '85'
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` = '11'
AND `node`.`id` = '85'
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` = '85'
SELECT *
FROM jos_komento_comments
WHERE id = '84'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '22'
AND `lft` BETWEEN '13'
AND '14'
AND `lft` != '13'
SELECT *
FROM jos_komento_comments
WHERE id = '84'
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` = '22'
AND `node`.`id` = '84'
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` = '84'
SELECT *
FROM jos_komento_comments
WHERE id = '83'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '22'
AND `lft` BETWEEN '11'
AND '12'
AND `lft` != '11'
SELECT *
FROM jos_komento_comments
WHERE id = '83'
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` = '22'
AND `node`.`id` = '83'
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` = '83'
SELECT *
FROM jos_komento_comments
WHERE id = '82'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '140'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
SELECT *
FROM jos_komento_comments
WHERE id = '82'
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` = '140'
AND `node`.`id` = '82'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='140'
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(140)
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(140)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '82'
SELECT *
FROM jos_komento_comments
WHERE id = '81'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '140'
AND `lft` BETWEEN '1'
AND '4'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '81'
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` = '140'
AND `node`.`id` = '81'
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` = '81'
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 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 COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '80'
SELECT *
FROM jos_komento_comments
WHERE id = '79'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '178'
AND `lft` BETWEEN '3'
AND '4'
AND `lft` != '3'
SELECT *
FROM jos_komento_comments
WHERE id = '79'
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` = '178'
AND `node`.`id` = '79'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='178'
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(178)
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(178)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '79'
SELECT *
FROM jos_komento_comments
WHERE id = '78'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '178'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '78'
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` = '178'
AND `node`.`id` = '78'
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` = '78'
SELECT *
FROM jos_komento_comments
WHERE id = '77'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '168'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '77'
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` = '168'
AND `node`.`id` = '77'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='168'
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(168)
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(168)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '77'
SELECT *
FROM jos_komento_comments
WHERE id = '76'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '208'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '76'
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` = '208'
AND `node`.`id` = '76'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='208'
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(208)
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(208)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '76'
SELECT *
FROM jos_komento_comments
WHERE id = '75'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '209'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '75'
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` = '209'
AND `node`.`id` = '75'
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` = '75'
SELECT *
FROM jos_komento_comments
WHERE id = '74'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '22'
AND `lft` BETWEEN '9'
AND '10'
AND `lft` != '9'
SELECT *
FROM jos_komento_comments
WHERE id = '74'
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` = '22'
AND `node`.`id` = '74'
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` = '74'
SELECT *
FROM jos_komento_comments
WHERE id = '73'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '9'
AND '10'
AND `lft` != '9'
SELECT *
FROM jos_komento_comments
WHERE id = '73'
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` = '206'
AND `node`.`id` = '73'
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` = '73'
SELECT *
FROM jos_komento_comments
WHERE id = '72'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '7'
AND '8'
AND `lft` != '7'
SELECT *
FROM jos_komento_comments
WHERE id = '72'
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` = '206'
AND `node`.`id` = '72'
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` = '72'
SELECT *
FROM jos_komento_comments
WHERE id = '71'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '5'
AND '6'
AND `lft` != '5'
SELECT *
FROM jos_komento_comments
WHERE id = '71'
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` = '206'
AND `node`.`id` = '71'
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` = '71'
SELECT *
FROM jos_komento_comments
WHERE id = '70'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '3'
AND '4'
AND `lft` != '3'
SELECT *
FROM jos_komento_comments
WHERE id = '70'
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` = '206'
AND `node`.`id` = '70'
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` = '70'
SELECT *
FROM jos_komento_comments
WHERE id = '69'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '206'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '69'
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` = '206'
AND `node`.`id` = '69'
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` = '69'
SELECT *
FROM jos_komento_comments
WHERE id = '68'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '141'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '68'
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` = '141'
AND `node`.`id` = '68'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='141'
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(141)
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(141)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '68'
SELECT *
FROM jos_komento_comments
WHERE id = '66'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '164'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '66'
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` = '164'
AND `node`.`id` = '66'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='164'
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(164)
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(164)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '66'
SELECT *
FROM jos_komento_comments
WHERE id = '64'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '5'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '64'
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` = '5'
AND `node`.`id` = '64'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='5'
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(5)
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(5)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '64'
SELECT *
FROM jos_komento_comments
WHERE id = '63'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '68'
AND `lft` BETWEEN '1'
AND '2'
AND `lft` != '1'
SELECT *
FROM jos_komento_comments
WHERE id = '63'
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` = '68'
AND `node`.`id` = '63'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='68'
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(68)
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(68)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '63'
SELECT *
FROM jos_komento_comments
WHERE id = '62'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '17'
AND '18'
AND `lft` != '17'
SELECT *
FROM jos_komento_comments
WHERE id = '62'
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` = '65'
AND `node`.`id` = '62'
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` = '62'
SELECT *
FROM jos_komento_comments
WHERE id = '60'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '12'
AND '13'
AND `lft` != '12'
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` = '65'
AND `node`.`id` = '60'
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` = '60'
SELECT *
FROM jos_komento_comments
WHERE id = '55'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '9'
AND '16'
AND `lft` != '9'
SELECT *
FROM jos_komento_comments
WHERE id = '55'
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` = '65'
AND `node`.`id` = '55'
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` = '55'
SELECT *
FROM jos_komento_comments
WHERE id = '54'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '1'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
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` = '1'
AND `node`.`id` = '54'
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` = '54'
SELECT *
FROM jos_komento_comments
WHERE id = '53'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '16'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
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` = '16'
AND `node`.`id` = '53'
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` = '53'
SELECT *
FROM jos_komento_comments
WHERE id = '52'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '32'
AND '33'
AND `lft` != '32'
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` = '11'
AND `node`.`id` = '52'
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` = '52'
SELECT *
FROM jos_komento_comments
WHERE id = '51'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '26'
AND '27'
AND `lft` != '26'
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` = '11'
AND `node`.`id` = '51'
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` = '51'
SELECT *
FROM jos_komento_comments
WHERE id = '50'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '11'
AND `lft` BETWEEN '22'
AND '23'
AND `lft` != '22'
SELECT *
FROM jos_komento_comments
WHERE id = '50'
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` = '11'
AND `node`.`id` = '50'
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` = '50'
SELECT *
FROM jos_komento_comments
WHERE id = '49'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '10'
AND `lft` BETWEEN '26'
AND '27'
AND `lft` != '26'
SELECT *
FROM jos_komento_comments
WHERE id = '49'
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` = '10'
AND `node`.`id` = '49'
AND `node`.`lft` BETWEEN `parent`.`lft`
AND `parent`.`rgt`
GROUP BY `node`.`id`
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='10'
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(10)
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(10)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM `jos_komento_actions`
WHERE `type` = 'likes'
AND `comment_id` = '49'
SELECT *
FROM jos_komento_comments
WHERE id = '48'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '10'
AND `lft` BETWEEN '20'
AND '21'
AND `lft` != '20'
SELECT *
FROM jos_komento_comments
WHERE id = '48'
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` = '10'
AND `node`.`id` = '48'
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` = '48'
SELECT *
FROM jos_komento_comments
WHERE id = '47'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '10'
AND `lft` BETWEEN '12'
AND '13'
AND `lft` != '12'
SELECT *
FROM jos_komento_comments
WHERE id = '47'
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` = '10'
AND `node`.`id` = '47'
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` = '47'
SELECT *
FROM jos_komento_comments
WHERE id = '46'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '10'
AND `lft` BETWEEN '4'
AND '5'
AND `lft` != '4'
SELECT *
FROM jos_komento_comments
WHERE id = '46'
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` = '10'
AND `node`.`id` = '46'
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` = '46'
SELECT *
FROM jos_komento_comments
WHERE id = '44'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '7'
AND '8'
AND `lft` != '7'
SELECT *
FROM jos_komento_comments
WHERE id = '44'
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` = '65'
AND `node`.`id` = '44'
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` = '44'
SELECT *
FROM jos_komento_comments
WHERE id = '43'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '2'
AND '3'
AND `lft` != '2'
SELECT *
FROM jos_komento_comments
WHERE id = '43'
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` = '65'
AND `node`.`id` = '43'
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` = '43'
SELECT *
FROM jos_komento_comments
WHERE id = '16'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '10'
AND `lft` BETWEEN '25'
AND '28'
AND `lft` != '25'
SELECT *
FROM jos_komento_comments
WHERE id = '16'
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` = '10'
AND `node`.`id` = '16'
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` = '16'
SELECT *
FROM jos_komento_comments
WHERE id = '42'
SELECT COUNT(1)
FROM `jos_komento_comments`
WHERE `component` = 'com_k2'
AND `cid` = '65'
AND `lft` BETWEEN '5'
AND '6'
AND `lft` != '5'
SELECT *
FROM jos_komento_comments
WHERE id = '42'
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` = '65'
AND `node`.`id` = '42'
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` = '42'
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=2
AND jf_content.published=1
AND jf_content.reference_id IN(177)
AND jf_content.reference_table='menu'