1. La fila de la base de datos está vacía.
   

   Call stack
   #	Function	Location
   1	JSite->render()	JROOT/index.php:48
   2	JDocumentHTML->render()	JROOT/includes/application.php:268
   3	JDocumentHTML->_renderTemplate()	JROOT/libraries/joomla/document/html/html.php:433
   4	JDocumentHTML->getBuffer()	JROOT/libraries/joomla/document/html/html.php:652
   5	JDocumentRendererModules->render()	JROOT/libraries/joomla/document/html/html.php:371
   6	JDocumentRendererModule->render()	JROOT/libraries/joomla/document/html/renderer/modules.php:39
   7	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/html/renderer/module.php:107
   8	include()	JROOT/libraries/joomla/application/module/helper.php:173
   9	require()	JROOT/modules/mod_joomdoc/mod_joomdoc.php:61
   10	JoomDOCAccessHelper->__construct()	JROOT/modules/mod_joomdoc/tmpl/default.php:18
   11	JoomDOCAccessFileSystem::viewFileInfo()	JROOT/administrator/components/com_joomdoc/libraries/joomdoc/access/helper.php:113
   12	JoomDOCAccessDocument::authorise()	JROOT/administrator/components/com_joomdoc/libraries/joomdoc/access/filesystem.php:67
   13	JModel::getInstance()	JROOT/administrator/components/com_joomdoc/libraries/joomdoc/access/document.php:117
   14	JoomDOCModelDocument->__construct()	JROOT/libraries/joomla/application/component/model.php:201
   15	JModelAdmin->checkin()	JROOT/administrator/components/com_joomdoc/models/document.php:30
   16	JTable->load()	JROOT/libraries/joomla/application/component/modeladmin.php:589

2. La fila de la base de datos está vacía.
   

   Call stack
   #	Function	Location
   1	JSite->render()	JROOT/index.php:48
   2	JDocumentHTML->render()	JROOT/includes/application.php:268
   3	JDocumentHTML->_renderTemplate()	JROOT/libraries/joomla/document/html/html.php:433
   4	JDocumentHTML->getBuffer()	JROOT/libraries/joomla/document/html/html.php:652
   5	JDocumentRendererModules->render()	JROOT/libraries/joomla/document/html/html.php:371
   6	JDocumentRendererModule->render()	JROOT/libraries/joomla/document/html/renderer/modules.php:39
   7	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/html/renderer/module.php:107
   8	include()	JROOT/libraries/joomla/application/module/helper.php:173
   9	require()	JROOT/modules/mod_joomdoc/mod_joomdoc.php:61
   10	JoomDOCAccessHelper->__construct()	JROOT/modules/mod_joomdoc/tmpl/default.php:18
   11	JoomDOCHelper->license()	JROOT/administrator/components/com_joomdoc/libraries/joomdoc/access/helper.php:144
   12	JModel::getInstance()	JROOT/administrator/components/com_joomdoc/libraries/joomdoc/utilities/helper.php:413
   13	JoomDOCModelLicense->__construct()	JROOT/libraries/joomla/application/component/model.php:201
   14	JModelAdmin->checkin()	JROOT/administrator/components/com_joomdoc/models/license.php:28
   15	JTable->load()	JROOT/libraries/joomla/application/component/modeladmin.php:589

233 consultas registradas

1. SELECT `data`
  FROM `jp_session`
  WHERE `session_id` = 'rp58t22dfc9kr956f3kmhpis26'
2. DELETE
  FROM `jp_session`
  WHERE `time` < '1628087437'
3. SELECT `session_id`
  FROM `jp_session`
  WHERE `session_id` = 'rp58t22dfc9kr956f3kmhpis26'
  LIMIT 0, 1
4. INSERT INTO `jp_session` (`session_id`, `client_id`, `time`)
  VALUES ('rp58t22dfc9kr956f3kmhpis26', 0, '1628088337')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM jp_usergroups AS a
  LEFT JOIN jp_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `jp_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM jp_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT config
  FROM jp_fua_config
  WHERE id='fua'
  LIMIT 1
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
12. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM jp_menu AS m
  LEFT JOIN jp_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
13. SELECT *
  FROM jp_languages
  WHERE published=1
  ORDER BY ordering ASC
14. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
15. SELECT id, home, template, s.params
  FROM jp_template_styles as s
  LEFT JOIN jp_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
16. SELECT a.rules
  FROM jp_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
17. SELECT b.rules
  FROM jp_assets AS a
  LEFT JOIN jp_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT id
  FROM jp_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
19. SHOW FULL COLUMNS
  FROM `jp_users`
20. SELECT *
  FROM `jp_users`
  WHERE `id` = 59
21. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 59
22. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=59
23. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=59
24. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=59
  AND i.created_by_alias=''
  ORDER BY i.id DESC
  LIMIT 0, 10
25. SELECT COUNT(*)
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=59
  AND i.created_by_alias=''
26. SHOW FULL COLUMNS
  FROM `jp_k2_categories`
27. SELECT *
  FROM jp_k2_categories
  WHERE id = '9'
28. SELECT id, name, parent
  FROM jp_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
  ORDER BY parent
29. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 61
  ORDER BY xref.id ASC
30. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=61
  AND published=1
31. SELECT *
  FROM jp_k2_categories
  WHERE id = '12'
32. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 60
  ORDER BY xref.id ASC
33. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=60
  AND published=1
34. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 59
  ORDER BY xref.id ASC
35. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=59
  AND published=1
36. SELECT *
  FROM jp_k2_categories
  WHERE id = '3'
37. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 58
  ORDER BY xref.id ASC
38. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=58
  AND published=1
39. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 54
  ORDER BY xref.id ASC
40. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=54
  AND published=1
41. SELECT *
  FROM jp_k2_categories
  WHERE id = '10'
42. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 53
  ORDER BY xref.id ASC
43. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=53
  AND published=1
44. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 52
  ORDER BY xref.id ASC
45. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=52
  AND published=1
46. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 51
  ORDER BY xref.id ASC
47. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=51
  AND published=1
48. SELECT *
  FROM jp_k2_categories
  WHERE id = '13'
49. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 50
  ORDER BY xref.id ASC
50. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=50
  AND published=1
51. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 49
  ORDER BY xref.id ASC
52. SELECT COUNT(*)
  FROM jp_k2_comments
  WHERE itemID=49
  AND published=1
53. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jp_modules AS m
  LEFT JOIN jp_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jp_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-08-04 14:45:38')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-08-04 14:45:38')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 0 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
54. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_weblinks'
55. SELECT a.*, c.published AS c_published,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
  FROM `jp_weblinks` AS a
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  WHERE a.access IN (1,1)
  AND a.catid = 6
  AND c.access IN (1,1)
  AND c.published = 1
  AND a.state = 1
  AND a.state != -2
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY title asc
56. SELECT a.*, c.published AS c_published,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
  FROM `jp_weblinks` AS a
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  WHERE a.access IN (1,1)
  AND a.catid = 6
  AND c.access IN (1,1)
  AND c.published = 1
  AND a.state = 1
  AND a.state != -2
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY title asc
  LIMIT 0, 5
57. SELECT a.*, c.published AS c_published,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
  FROM `jp_weblinks` AS a
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  WHERE a.access IN (1,1)
  AND a.catid = 13
  AND c.access IN (1,1)
  AND c.published = 1
  AND a.state = 1
  AND a.state != -2
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY title asc
58. SELECT a.*, c.published AS c_published,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
  FROM `jp_weblinks` AS a
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  WHERE a.access IN (1,1)
  AND a.catid = 13
  AND c.access IN (1,1)
  AND c.published = 1
  AND a.state = 1
  AND a.state != -2
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY title asc
  LIMIT 0, 5
59. SELECT *
  FROM jp_banners
  WHERE '2021-08-04 14:45:38' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
60. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (20)
  ORDER BY a.sticky DESC,a.ordering
61. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (20)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
62. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 9
63. SELECT *
  FROM jp_banners
  WHERE '2021-08-04 14:45:38' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
64. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (11)
  ORDER BY a.sticky DESC,a.ordering
65. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (11)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 7
66. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 19
67. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 18
68. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=18
  AND track_date='2021-08-04 14'
69. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=18
  AND track_date='2021-08-04 14'
70. UPDATE jp_banner_tracks
  SET `count` = (`count` + 1)
  WHERE track_type=1
  AND banner_id=18
  AND track_date='2021-08-04 14'
71. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 16
72. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=16
  AND track_date='2021-08-04 14'
73. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=16
  AND track_date='2021-08-04 14'
74. UPDATE jp_banner_tracks
  SET `count` = (`count` + 1)
  WHERE track_type=1
  AND banner_id=16
  AND track_date='2021-08-04 14'
75. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 23
76. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 22
77. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=22
  AND track_date='2021-08-04 14'
78. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=22
  AND track_date='2021-08-04 14'
79. UPDATE jp_banner_tracks
  SET `count` = (`count` + 1)
  WHERE track_type=1
  AND banner_id=22
  AND track_date='2021-08-04 14'
80. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 21
81. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 17
82. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=17
  AND track_date='2021-08-04 14'
83. SELECT `count`
  FROM jp_banner_tracks
  WHERE track_type=1
  AND banner_id=17
  AND track_date='2021-08-04 14'
84. UPDATE jp_banner_tracks
  SET `count` = (`count` + 1)
  WHERE track_type=1
  AND banner_id=17
  AND track_date='2021-08-04 14'
85. SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.catid IN(3)
  ORDER BY i.id DESC
  LIMIT 0, 5
86. SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.catid IN(16,17,18)
  ORDER BY i.id DESC
  LIMIT 0, 5
87. SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.catid IN(10,12)
  ORDER BY i.id DESC
  LIMIT 0, 5
88. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=60
89. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=59
90. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=53
91. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=52
92. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=51
93. SELECT *
  FROM jp_banners
  WHERE '2021-08-04 14:45:38' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
94. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (12)
  ORDER BY a.sticky DESC,a.ordering
95. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (12)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
96. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 4
97. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 10
98. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 5
99. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 12
100. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
101. SELECT b.rules
  FROM jp_assets AS a
  LEFT JOIN jp_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
102. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM jp_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM jp_content AS a
  LEFT JOIN jp_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN jp_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jp_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  WHERE a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid IN (8)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY a.created DESC
  LIMIT 0, 1
103. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jp_categories as c
  LEFT JOIN jp_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=8
  AND badcats.id is null
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
  ORDER BY c.lft
104. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_joomdle'
105. SELECT session_id
  FROM jp_session
  WHERE userid ='0'
106. SELECT *
  FROM jp_banners
  WHERE '2021-08-04 14:45:38' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
107. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (21)
  ORDER BY a.sticky DESC,a.ordering
108. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (21)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
109. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 8
110. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 15
111. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 7
112. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 14
113. SELECT users.name,users.email,users.id AS UID, profiles.*
  FROM jp_users AS users
  LEFT JOIN jp_k2_users AS profiles
  ON users.id=profiles.userID
  WHERE users.block=0
  AND profiles.`
  group`=3
  ORDER BY RAND()
  LIMIT 0, 10
114. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=2024
115. SELECT *
  FROM `jp_users`
  WHERE `id` = 2024
116. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 2024
117. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=2024
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
118. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=306
119. SELECT *
  FROM `jp_users`
  WHERE `id` = 306
120. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 306
121. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=306
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
122. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=1252
123. SELECT *
  FROM `jp_users`
  WHERE `id` = 1252
124. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 1252
125. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=1252
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
126. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=2136
127. SELECT *
  FROM `jp_users`
  WHERE `id` = 2136
128. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 2136
129. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=2136
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
130. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=2143
131. SELECT *
  FROM `jp_users`
  WHERE `id` = 2143
132. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 2143
133. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=2143
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
134. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=2142
135. SELECT *
  FROM `jp_users`
  WHERE `id` = 2142
136. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 2142
137. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=2142
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
138. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=225
139. SELECT *
  FROM `jp_users`
  WHERE `id` = 225
140. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 225
141. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=225
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
142. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=1266
143. SELECT *
  FROM `jp_users`
  WHERE `id` = 1266
144. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 1266
145. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=1266
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
146. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=1259
147. SELECT *
  FROM `jp_users`
  WHERE `id` = 1259
148. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 1259
149. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=1259
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
150. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
  WHERE userID=1258
151. SELECT *
  FROM `jp_users`
  WHERE `id` = 1258
152. SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 1258
153. SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.created_by=1258
  AND i.created_by_alias=''
  ORDER BY i.created DESC
  LIMIT 0, 1
154. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_phocagallery'
155. SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM jp_phocagallery_categories AS cc
  WHERE cc.published = 1
  AND cc.access <= 0
  ORDER BY cc.ordering
156. SELECT cc.id AS idcat, a.id AS idimage
  FROM jp_phocagallery_categories AS cc
  LEFT JOIN jp_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.published = 1
  AND a.approved = 1
  AND cc.published = 1
  AND cc.id IN (10)
  ORDER BY a.ordering ASC
  LIMIT 0,1
157. SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM jp_phocagallery_categories AS cc
  LEFT JOIN jp_phocagallery AS a
  ON a.catid = cc.id
  WHERE a.id in (154)
  ORDER BY a.ordering ASC
158. SELECT guest, usertype, client_id
  FROM jp_session
  WHERE client_id = 0
159. SELECT DISTINCT a.username, a.userid, u.name
  FROM jp_session AS a, jp_users AS u
  WHERE (a.userid = u.id)
  AND (a.guest = 0)
  AND (a.client_id = 0)
  ORDER BY a.username ASC
160. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM jp_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM jp_content AS a
  LEFT JOIN jp_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN jp_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jp_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  WHERE a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid IN (15)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY a.created DESC
  LIMIT 0, 5
161. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jp_categories as c
  LEFT JOIN jp_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=15
  AND badcats.id is null
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
  ORDER BY c.lft
162. SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
  WHERE i.published = 1
  AND i.access IN(1,1)
  AND i.trash = 0
  AND c.published = 1
  AND c.access IN(1,1)
  AND c.trash = 0
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2021-08-04 14:45:38' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2021-08-04 14:45:38' )
  AND i.catid IN(13,8)
  ORDER BY i.id DESC
  LIMIT 0, 5
163. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=50
164. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 16
  ORDER BY xref.id ASC
165. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=16
166. SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 14
  ORDER BY xref.id ASC
167. SELECT *
  FROM jp_k2_attachments
  WHERE itemID=14
168. SELECT *
  FROM jp_banners
  WHERE '2021-08-04 14:45:38' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
169. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (12)
  ORDER BY a.sticky DESC,a.ordering
170. SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
  WHERE a.state=1
  AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
  AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
  AND a.catid IN (12)
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 5
171. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 4
172. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 10
173. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 5
174. UPDATE jp_banners
  SET impmade = (impmade + 1)
  WHERE id = 12
175. SELECT `url`
  FROM jp_m4j_sef
  WHERE `cid`=''
  AND `jid` = '0'
176. SELECT `url`
  FROM jp_m4j_sef
  WHERE `cid`=''
  AND `jid` = '0'
177. SELECT `url`
  FROM jp_m4j_sef
  WHERE `cid`=''
  AND `jid` = '0'
178. SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_joomdoc'
179. SELECT MIN(`id`)
  FROM `jp_joomdoc`
  WHERE `path` IN ('Escolaridad inconclusa/EcuadorEPJA 2008.pdf', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil 2016-2017.doc', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil.doc', 'Escolaridad inconclusa/RegistroEstudiantil2016-2017.doc', 'Escolaridad inconclusa/RegistroEstudiantil20162017.pdf', 'Escolaridad inconclusa/registro estudiantil 2017-2018 ok.pdf', 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf', 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf', 'Reglamentos/RegistroEstudiantil20162017.doc', 'Reglamentos/registro estudiantil 2017-2018 ok.pdf')
  GROUP BY `path`
180. SELECT MAX(`id`)
  FROM `jp_joomdoc_file`
  WHERE `path` IN ('Escolaridad inconclusa/EcuadorEPJA 2008.pdf', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil 2016-2017.doc', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil.doc', 'Escolaridad inconclusa/RegistroEstudiantil2016-2017.doc', 'Escolaridad inconclusa/RegistroEstudiantil20162017.pdf', 'Escolaridad inconclusa/registro estudiantil 2017-2018 ok.pdf', 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf', 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf', 'Reglamentos/RegistroEstudiantil20162017.doc', 'Reglamentos/registro estudiantil 2017-2018 ok.pdf')
  GROUP BY `path`
181. SELECT `path`, SUM(`hits`) AS `hits`
  FROM `jp_joomdoc_file`
  WHERE `path` IN ('Escolaridad inconclusa/EcuadorEPJA 2008.pdf', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil 2016-2017.doc', 'Escolaridad inconclusa/Eol3Ec JePe - Registro estudiantil.doc', 'Escolaridad inconclusa/RegistroEstudiantil2016-2017.doc', 'Escolaridad inconclusa/RegistroEstudiantil20162017.pdf', 'Escolaridad inconclusa/registro estudiantil 2017-2018 ok.pdf', 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf', 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf', 'Reglamentos/RegistroEstudiantil20162017.doc', 'Reglamentos/registro estudiantil 2017-2018 ok.pdf')
  GROUP BY `path`
182. SELECT `document`.`id`, `document`.`title`, `document`.`description`, `document`.`full_alias`, `document`.`modified`, `document`.`created`, `document`.`created_by`, `document`.`state`, `document`.`params`, `document`.`favorite`, `document`.`ordering`, `document`.`publish_up`, ((`document`.`state` = 1
  AND (`document`.`publish_up` = '0000-00-00 00:00:00' OR `document`.`publish_up` <= '2021-08-04 14:45:38')
  AND (`document`.`publish_down` = '0000-00-00 00:00:00' OR `document`.`publish_down` >= '2021-08-04 14:45:38')
  AND `document`.`access` IN (1,1)) OR `document`.`created_by` = 0) AS `published`, `file`.`upload`, `file`.`path`, `file`.`state` AS `file_state`, `document`.`checked_out`, `license`.`id` AS `license_id`, `license`.`title` AS `license_title`, `license`.`alias` AS `license_alias`, `license`.`state` AS `license_state`
  FROM `jp_joomdoc_file` AS `file`
  LEFT JOIN `jp_joomdoc` AS `document`
  ON `file`.`path` = `document`.`path`
  LEFT JOIN `jp_users` AS `editor`
  ON `editor`.`id` = `document`.`checked_out`
  LEFT JOIN `jp_viewlevels` AS `access`
  ON `access`.`id` = `document`.`access`
  LEFT JOIN `jp_joomdoc_license` AS `license`
  ON `license`.`id` = `document`.`license`
  WHERE (`file`.`id` IN (3, 11, 10, 6, 7) OR `file`.`id` IS NULL)
  AND `file`.`state` = 1
  ORDER BY `title` ASC
183. SHOW FULL COLUMNS
  FROM `jp_joomdoc`
184. SELECT *
  FROM jp_joomdoc
  WHERE `id` = '59'
185. SELECT `id`, `path`
  FROM `jp_joomdoc`
  WHERE (`path` = 'Reglamentos')
  AND `id` IN (SELECT MIN(`id`)
  FROM `jp_joomdoc`
  GROUP BY `path`)
186. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
187. SELECT b.rules
  FROM jp_assets AS a
  LEFT JOIN jp_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_joomdoc')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
188. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
189. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
190. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
191. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
192. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
193. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
194. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
195. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
196. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
197. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
198. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
199. SHOW FULL COLUMNS
  FROM `jp_joomdoc_license`
200. SELECT *
  FROM jp_joomdoc_license
  WHERE `id` = '59'
201. SELECT `document`.`id`, `document`.`license`, `license`.`state`
  FROM `jp_joomdoc` AS `document`
  LEFT JOIN `jp_joomdoc_license` AS `license`
  ON `license`.`id` = `document`.`license`
  WHERE `path` = 'Reglamentos'
202. SELECT *
  FROM `jp_joomdoc_license`
  WHERE `default` = 1
  AND `state` = 1
203. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO-MINEDUC-ME-2014-00034-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
204. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
205. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
206. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
207. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
208. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
209. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
210. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
211. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
212. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
213. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
214. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
215. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
216. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Reglamentos/ACUERDO Nro. MINEDUC-ME-2014-00065-A.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
217. SELECT `id`, `path`
  FROM `jp_joomdoc`
  WHERE (`path` = 'Escolaridad inconclusa')
  AND `id` IN (SELECT MIN(`id`)
  FROM `jp_joomdoc`
  GROUP BY `path`)
218. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
219. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
220. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
221. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
222. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
223. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
224. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
225. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
226. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
227. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
228. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
229. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = ''
  ORDER BY `version` DESC
  LIMIT 0, 1
230. SELECT `document`.`id`, `document`.`license`, `license`.`state`
  FROM `jp_joomdoc` AS `document`
  LEFT JOIN `jp_joomdoc_license` AS `license`
  ON `license`.`id` = `document`.`license`
  WHERE `path` = 'Escolaridad inconclusa'
231. SELECT `id`
  FROM `jp_joomdoc`
  WHERE `path` = 'Escolaridad inconclusa/EcuadorEPJA 2008.pdf'
  ORDER BY `version` DESC
  LIMIT 0, 1
232. SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM jp_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM jp_content AS a
  LEFT JOIN jp_content_frontpage AS fp
  ON fp.content_id = a.id
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN jp_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN jp_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  WHERE a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND a.catid IN (15)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-08-04 14:45:38')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-08-04 14:45:38')
  ORDER BY a.publish_up DESC
  LIMIT 0, 1
233. UPDATE `jp_session`
  SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1628088337;s:18:\"session.timer.last\";i:1628088337;s:17:\"session.timer.now\";i:1628088337;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:10;}}}}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}}' , `time` = '1628088344'
  WHERE `session_id` = 'rp58t22dfc9kr956f3kmhpis26'

60 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 39 × SELECT `id`
  FROM `jp_joomdoc`
2. 12 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM jp_k2_users
3. 12 × SELECT tag.*
  FROM jp_k2_tags AS tag JOIN jp_k2_tags_xref AS xref
  ON tag.id = xref.tagID
4. 11 × SELECT `g`.`id`,`g`.`title`
  FROM `jp_usergroups` AS g
  INNER JOIN `jp_user_usergroup_map` AS m
  ON m.group_id = g.id
5. 11 × SELECT *
  FROM `jp_users`
6. 10 × SELECT COUNT(*)
  FROM jp_k2_comments
7. 10 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i
  LEFT JOIN jp_k2_categories AS c
  ON c.id = i.catid
8. 10 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
  FROM jp_banners as a
  LEFT JOIN jp_banner_clients AS cl
  ON cl.id = a.cid
9. 9 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM jp_extensions
10. 8 × SELECT `count`
  FROM jp_banner_tracks
11. 8 × SELECT *
  FROM jp_k2_attachments
12. 5 × SELECT *
  FROM jp_banners
13. 5 × SELECT *
  FROM jp_k2_categories
14. 4 × SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
15. 4 × SELECT a.*, c.published AS c_published,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.date, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email
  FROM `jp_weblinks` AS a
  LEFT JOIN jp_categories AS c
  ON c.id = a.catid
  LEFT JOIN jp_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN jp_users AS uam
  ON uam.id = a.modified_by
16. 3 × SELECT `url`
  FROM jp_m4j_sef
17. 3 × SELECT b.rules
  FROM jp_assets AS a
  LEFT JOIN jp_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
18. 2 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM jp_categories as c
  LEFT JOIN jp_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM jp_categories AS cat JOIN jp_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
19. 2 × SELECT `id`, `path`
  FROM `jp_joomdoc`
20. 2 × SELECT `document`.`id`, `document`.`license`, `license`.`state`
  FROM `jp_joomdoc` AS `document`
  LEFT JOIN `jp_joomdoc_license` AS `license`
  ON `license`.`id` = `document`.`license`
21. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.language, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM jp_contact_details AS contact
22. 1 × SELECT MAX(`id`)
  FROM `jp_joomdoc_file`
23. 1 × SELECT `path`, SUM(`hits`) AS `hits`
  FROM `jp_joomdoc_file`
24. 1 × SELECT MIN(`id`)
  FROM `jp_joomdoc`
25. 1 × SELECT id
  FROM jp_k2_categories
26. 1 × SELECT guest, usertype, client_id
  FROM jp_session
27. 1 × SELECT DISTINCT a.username, a.userid, u.name
  FROM jp_session AS a, jp_users AS u
28. 1 × SELECT `document`.`id`, `document`.`title`, `document`.`description`, `document`.`full_alias`, `document`.`modified`, `document`.`created`, `document`.`created_by`, `document`.`state`, `document`.`params`, `document`.`favorite`, `document`.`ordering`, `document`.`publish_up`, ((`document`.`state` = 1
  AND (`document`.`publish_up` = '0000-00-00 00:00:00' OR `document`.`publish_up` <= '2021-08-04 14:45:38')
  AND (`document`.`publish_down` = '0000-00-00 00:00:00' OR `document`.`publish_down` >= '2021-08-04 14:45:38')
  AND `document`.`access` IN (1,1)) OR `document`.`created_by` = 0) AS `published`, `file`.`upload`, `file`.`path`, `file`.`state` AS `file_state`, `document`.`checked_out`, `license`.`id` AS `license_id`, `license`.`title` AS `license_title`, `license`.`alias` AS `license_alias`, `license`.`state` AS `license_state`
  FROM `jp_joomdoc_file` AS `file`
  LEFT JOIN `jp_joomdoc` AS `document`
  ON `file`.`path` = `document`.`path`
  LEFT JOIN `jp_users` AS `editor`
  ON `editor`.`id` = `document`.`checked_out`
  LEFT JOIN `jp_viewlevels` AS `access`
  ON `access`.`id` = `document`.`access`
  LEFT JOIN `jp_joomdoc_license` AS `license`
  ON `license`.`id` = `document`.`license`
29. 1 × SELECT *
  FROM jp_joomdoc
30. 1 × SELECT *
  FROM `jp_joomdoc_license`
31. 1 × SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id
  FROM jp_contact_details AS contact
32. 1 × SELECT id, home, template, s.params
  FROM jp_template_styles as s
  LEFT JOIN jp_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
33. 1 × SELECT *
  FROM jp_joomdoc_license
34. 1 × SELECT a.rules
  FROM jp_assets AS a
35. 1 × SELECT `session_id`
  FROM `jp_session`
36. 1 × SELECT cc.id, cc.alias as catalias, a.id, a.catid, a.title, a.alias, a.filename, a.description, a.extm, a.exts,a.extl, a.exto, a.extw, a.exth, a.extid,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM jp_phocagallery_categories AS cc
  LEFT JOIN jp_phocagallery AS a
  ON a.catid = cc.id
37. 1 × SELECT cc.id AS idcat, a.id AS idimage
  FROM jp_phocagallery_categories AS cc
  LEFT JOIN jp_phocagallery AS a
  ON a.catid = cc.id
38. 1 × SELECT COUNT(*)
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories c
  ON c.id = i.catid
39. 1 × SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams
  FROM jp_k2_items as i RIGHT JOIN jp_k2_categories AS c
  ON c.id = i.catid
40. 1 × SELECT `data`
  FROM `jp_session`
41. 1 × SELECT id, name, parent
  FROM jp_k2_categories
42. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM jp_modules AS m
  LEFT JOIN jp_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN jp_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
43. 1 × SELECT id, rules
  FROM `jp_viewlevels
44. 1 × SELECT folder AS type, element AS name, params
  FROM jp_extensions
45. 1 × SELECT *
  FROM jp_languages
46. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM jp_menu AS m
  LEFT JOIN jp_extensions AS e
  ON m.component_id = e.extension_id
47. 1 × SELECT cc.title AS text, cc.id AS id, cc.parent_id as parentid, cc.alias as alias, cc.access as access, cc.accessuserid as accessuserid
  FROM jp_phocagallery_categories AS cc
48. 1 × SELECT users.name,users.email,users.id AS UID, profiles.*
  FROM jp_users AS users
  LEFT JOIN jp_k2_users AS profiles
  ON users.id=profiles.userID
49. 1 × SELECT session_id
  FROM jp_session
50. 1 × SELECT config
  FROM jp_fua_config
51. 1 × SELECT b.id
  FROM jp_usergroups AS a
  LEFT JOIN jp_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt