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 = 214)
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 a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 06:59:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 06:59:02' )
ORDER BY a.ordering
LIMIT 0, 4
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(84,116)
AND jf_content.reference_table='content'
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(84,116)
AND jf_content.reference_table='users'
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 06:59:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 06:59:02' )
ORDER BY a.ordering
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_content'
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 = 214 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,313,312,317,314,199,205,43,167,196,310,309,136,302)
AND jf_content.reference_table='modules'
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 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-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.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(171)
AND jf_content.reference_table='k2_categories'
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 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-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.id=67
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(67)
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(107)
AND jf_content.reference_table='k2_categories'
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 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-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.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(108)
AND jf_content.reference_table='k2_categories'
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 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-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.id=76
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(76)
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(114)
AND jf_content.reference_table='k2_categories'
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 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-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.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(105)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=2
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=76
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(3,7,12,16,20,24,28,123,32,36,40,44,48,77,97,118,131,135,140,144,149,155,162,169,175,176)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=3
AND 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(4,5,6,52,64,122)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=3
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(4,5,6,52,64,122)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=4
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=5
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=6
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=52
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=64
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=122
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=7
AND 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(8,9,10,53,65,107,109,111)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=7
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(8,9,10,53,65,107,109,111)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=8
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=9
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=10
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=53
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=65
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=107
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=109
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=111
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=12
AND 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(13,14,15,54,66)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=12
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(13,14,15,54,66)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=13
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=14
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=15
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=54
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=66
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=16
AND 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(17,18,19,55,67)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=16
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(17,18,19,55,67)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=17
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=18
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=19
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=55
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=67
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=20
AND 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(21,22,23,56,68)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=20
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(21,22,23,56,68)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=21
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=22
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=23
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=56
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=68
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=24
AND 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(25,26,27,57,69)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=24
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(25,26,27,57,69)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=25
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=26
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=27
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=57
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=69
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=28
AND 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(29,30,31,58,70)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=28
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(29,30,31,58,70)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=29
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=30
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=31
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=58
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=70
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=123
AND 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,125,126,127,128,129,124)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=123
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(124,125,126,127,128,129,130)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=124
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=125
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=126
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=127
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=128
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=129
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=130
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=32
AND 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(33,34,35,59,72)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=32
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(33,34,35,59,72)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=33
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=34
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=35
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=59
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=72
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=36
AND 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(37,38,39,60,73)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=36
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(37,38,39,60,73)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=37
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=38
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=39
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=60
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=73
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=40
AND 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(41,42,43,61,71)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=40
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(41,42,43,61,71)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=41
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=42
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=43
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=61
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=71
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=44
AND 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(45,46,47,62,74)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=44
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(45,46,47,62,74)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=45
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=46
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=47
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=62
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=74
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=48
AND 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(49,50,51,63,75)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=48
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(49,50,51,63,75)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=49
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=50
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=51
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=63
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=75
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=77
AND 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(78,79,80,81,82,168)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=77
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(78,79,80,81,82,168)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=78
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=79
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=80
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=81
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=82
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=168
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=97
AND 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(98,99,100,101,102)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=97
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(98,99,100,101,102)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=98
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=99
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=100
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=101
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=102
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=118
AND 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(119,120,121)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=118
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(119,120,121)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=119
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=120
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=121
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=131
AND 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(133,132,134,179)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=131
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(132,133,134,179)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=132
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=133
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=134
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=179
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=135
AND 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(136,137,138,139)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=135
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(136,137,138,139)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=136
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=137
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=138
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=139
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=140
AND 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(141,142,143)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=140
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(141,142,143)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=141
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=142
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=143
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=144
AND 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(145,146,147)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=144
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(145,146,147)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=145
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=146
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=147
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=149
AND 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(150,151,152,153,154)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=149
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(150,151,152,153,154)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=150
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=151
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=152
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=153
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=154
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=155
AND 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(156,157,158,159,160,161)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=155
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(156,157,158,159,160,161)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=156
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=157
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=158
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=159
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=160
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=161
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=162
AND 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(163,164,165,166,167)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=162
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(163,164,165,166,167)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=163
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=164
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=165
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=166
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=167
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=169
AND 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(170)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=169
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(170)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=170
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=175
AND 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(178)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=175
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(178)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=178
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=176
AND 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(177)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=176
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(177)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=177
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=3
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(4,5,6,52,64,122)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=4
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=5
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=6
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=52
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=64
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=122
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=4
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=5
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=6
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=52
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=64
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=122
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=7
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(8,9,10,53,65,107,109,111)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=8
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=9
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=10
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=53
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=65
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=107
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=109
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=111
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=8
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=9
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=10
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=53
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=65
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=107
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=109
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=111
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=12
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(13,14,15,54,66)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=13
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=14
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=15
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=54
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=66
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=13
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=14
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=15
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=54
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=66
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=16
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(17,18,19,55,67)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=17
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=18
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=19
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=55
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=67
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=17
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=18
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=19
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=55
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=67
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=20
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(21,22,23,56,68)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=21
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=22
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=23
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=56
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=68
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=21
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=22
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=23
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=56
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=68
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=24
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(25,26,27,57,69)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=25
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=26
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=27
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=57
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=69
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=25
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=26
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=27
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=57
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=69
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=28
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(29,30,31,58,70)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=29
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=30
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=31
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=58
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=70
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=29
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=30
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=31
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=58
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=70
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=123
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(124,125,126,127,128,129,130)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=124
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=125
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=126
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=127
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=128
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=129
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=130
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=124
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=125
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=126
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=127
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=128
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=129
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=130
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=32
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(33,34,35,59,72)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=33
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=34
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=35
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=59
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=72
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=33
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=34
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=35
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=59
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=72
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=36
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(37,38,39,60,73)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=37
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=38
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=39
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=60
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=73
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=37
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=38
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=39
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=60
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=73
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=40
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(41,42,43,61,71)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=41
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=42
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=43
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=61
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=71
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=41
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=42
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=43
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=61
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=71
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=44
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(45,46,47,62,74)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=45
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=46
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=47
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=62
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=74
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=45
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=46
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=47
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=62
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=74
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=48
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(49,50,51,63,75)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=49
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=50
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=51
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=63
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=75
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=49
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=50
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=51
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=63
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=75
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=77
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(78,79,80,81,82,168)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=78
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=79
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=80
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=81
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=82
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=168
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=78
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=79
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=80
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=81
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=82
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=168
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=97
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(98,99,100,101,102)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=98
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=99
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=100
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=101
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=102
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=98
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=99
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=100
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=101
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=102
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=118
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(119,120,121)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=119
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=120
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=121
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=119
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=120
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=121
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=131
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(132,133,134,179)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=132
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=133
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=134
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=179
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=132
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=133
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=134
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=135
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(136,137,138,139)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=136
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=137
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=138
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=139
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=136
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=137
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=138
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=139
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=140
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(141,142,143)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=141
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=142
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=143
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=141
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=142
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=143
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=144
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(145,146,147)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=145
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=146
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=147
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=145
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=146
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=147
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=149
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(150,151,152,153,154)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=150
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=151
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=152
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=153
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=154
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=150
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=151
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=152
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=153
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=154
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=155
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(156,157,158,159,160,161)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=156
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=157
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=158
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=159
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=160
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=161
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=156
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=157
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=158
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=159
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=160
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=161
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=162
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(163,164,165,166,167)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=163
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=164
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=165
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=166
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=167
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=163
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=164
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=165
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=166
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=167
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=169
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(170)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=170
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=170
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=83
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=84
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=91
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=92
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(93,94)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=93
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=94
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=93
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=94
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=95
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=103
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(104,106,105,114)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=104
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=106
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=105
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=114
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=104
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=106
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=105
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=114
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=108
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=115
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(171)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=171
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=171
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=116
AND published=1
AND trash=0
AND access<=0
ORDER BY 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(117)
AND jf_content.reference_table='k2_categories'
SELECT *
FROM jos_k2_categories
WHERE parent=117
AND published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_categories
WHERE parent=117
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT *
FROM jos_k2_categories
WHERE parent=148
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT t.name, t.id
FROM jos_k2_tags AS t
LEFT JOIN jos_k2_tags_xref tags_xref
ON tags_xref.tagID = t.id
LEFT JOIN jos_k2_items i
ON tags_xref.itemID = i.id
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE t.published=1
AND i.published=1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-01-17 06:59:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-01-17 06:59:02' )
AND i.trash=0
AND i.access <= 0
AND c.published=1
AND c.trash=0
AND c.access <= 0
AND i.catid IN(2,76,3,4,5,6,52,64,122,7,8,9,10,53,65,107,109,111,12,13,14,15,54,66,16,17,18,19,55,67,20,21,22,23,56,68,24,25,26,27,57,69,28,29,30,31,58,70,123,124,125,126,127,128,129,130,32,33,34,35,59,72,36,37,38,39,60,73,40,41,42,43,61,71,44,45,46,47,62,74,48,49,50,51,63,75,77,78,79,80,81,82,168,97,98,99,100,101,102,118,119,120,121,131,132,133,134,179,135,136,137,138,139,140,141,142,143,144,145,146,147,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,169,170,175,178,176,177,83,84,91,92,93,94,95,103,104,106,105,114,108,115,171,116,117,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=2
AND jf_content.published=1
AND jf_content.reference_id IN(37,12,28,27,29,30,2,1,15,8,16,42,33,26,35,19,50,49,54,40,39,38,3,46,60,9,36,34,18,41,14,43,44,13,25,21,32,31,45,20,48,47,59,51,58,17,57,55,56)
AND jf_content.reference_table='k2_tags'
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(214)
AND jf_content.reference_table='menu'