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=1
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 = 221)
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=1
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_categories
WHERE id = '148'
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(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id = '114'
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(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_komento_configs
WHERE component = 'com_k2'
SELECT *
FROM jos_k2_categories
WHERE parent=148
AND published=1
AND trash=0
AND access<=0
ORDER BY id ASC
SELECT *
FROM jos_k2_categories
WHERE id = '148'
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(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id = '114'
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(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=148
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-13 10:52:34' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-13 10:52:34' )
AND c.id IN (148)
ORDER BY i.created DESC
LIMIT 0, 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=1
AND jf_content.published=1
AND jf_content.reference_id IN(203,163,162,161)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id = '148'
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(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id = '114'
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(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=148
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT COUNT(*)
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-04-13 10:52:34' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-04-13 10:52:34' )
AND c.id IN (148)
SELECT *
FROM jos_k2_categories
WHERE id=148
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id=114
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_extra_fields
WHERE published=1
AND id IN (21)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(21)
AND jf_content.reference_table='k2_extra_fields'
SELECT *
FROM jos_k2_rating
WHERE itemID = 203
SELECT *
FROM jos_k2_rating
WHERE itemID = 203
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=203
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 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='203'
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(203)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(203)
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 (203)
AND x.published = '1') AS x
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (203)
AND x.published = '1') AS x
SELECT *
FROM jos_k2_categories
WHERE id=148
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id=114
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_extra_fields
WHERE published=1
AND id IN (21)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(21)
AND jf_content.reference_table='k2_extra_fields'
SELECT *
FROM jos_k2_rating
WHERE itemID = 163
SELECT *
FROM jos_k2_rating
WHERE itemID = 163
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=163
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='163'
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(163)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(163)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (163)
AND x.published = '1') AS x
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (163)
AND x.published = '1') AS x
SELECT *
FROM jos_k2_categories
WHERE id=148
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id=114
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_extra_fields
WHERE published=1
AND id IN (21)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(21)
AND jf_content.reference_table='k2_extra_fields'
SELECT *
FROM jos_k2_rating
WHERE itemID = 162
SELECT *
FROM jos_k2_rating
WHERE itemID = 162
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=162
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='162'
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(162)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(162)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (162)
AND x.published = '1') AS x
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (162)
AND x.published = '1') AS x
SELECT *
FROM jos_k2_categories
WHERE id=148
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE id=114
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_extra_fields
WHERE published=1
AND id IN (21)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(21)
AND jf_content.reference_table='k2_extra_fields'
SELECT *
FROM jos_k2_rating
WHERE itemID = 161
SELECT *
FROM jos_k2_rating
WHERE itemID = 161
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=161
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='161'
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(161)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(161)
AND jf_content.reference_table='k2_categories'
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (161)
AND x.published = '1') AS x
SELECT COUNT(1)
FROM (SELECT x.*, 0 AS depth
FROM `jos_komento_comments` AS x
WHERE x.component = 'com_k2'
AND x.cid IN (161)
AND x.published = '1') AS x
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 = 221 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=1
AND jf_content.published=1
AND jf_content.reference_id IN(195,300,199,205,43,167,196,136,302)
AND jf_content.reference_table='modules'
SELECT a.*, cr.rating_sum/cr.rating_count AS rating, c.name AS categoryname,
c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, cc.commentcount AS commentcount
FROM jos_k2_items AS a
LEFT JOIN jos_k2_categories c
ON c.id = a.catid
LEFT JOIN jos_k2_rating AS cr
ON a.id = cr.itemid
LEFT JOIN (SELECT cm.itemid AS id, COUNT(cm.id) AS commentcount
FROM jos_k2_comments AS cm
WHERE cm.published=1
GROUP BY cm.itemid) AS cc
ON a.id = cc.id
WHERE a.published = 1
AND a.access <= 0
AND a.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND a.catid IN( 148 )
ORDER BY created ASC
LIMIT 3
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(161,162,163)
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=1
AND jf_content.published=1
AND jf_content.reference_id IN(148)
AND jf_content.reference_table='k2_categories'
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(221)
AND jf_content.reference_table='menu'