49 Registro Consultas

1. SELECT `data`
  FROM `eduba_session`
  WHERE `session_id` = 'a32ab11520538d4fb63d8bef9a394f54'
2. DELETE
  FROM `eduba_session`
  WHERE `time` < '1506415423'
3. SELECT `session_id`
  FROM `eduba_session`
  WHERE `session_id` = 'a32ab11520538d4fb63d8bef9a394f54'
  LIMIT 0, 1
4. INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('a32ab11520538d4fb63d8bef9a394f54', 0, '1506416323')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM eduba_usergroups AS a
  LEFT JOIN eduba_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `eduba_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM eduba_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT *
  FROM eduba_languages
  WHERE published=1
  ORDER BY ordering ASC
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
11. 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 eduba_menu AS m
  LEFT JOIN eduba_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
12. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
13. SELECT id, home, template, s.params
  FROM eduba_template_styles as s
  LEFT JOIN eduba_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
14. SELECT a.rules
  FROM eduba_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
15. SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
16. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 eduba_content AS a
  LEFT JOIN eduba_categories AS c
  ON c.id = a.catid
  LEFT JOIN eduba_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eduba_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM eduba_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN eduba_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eduba_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_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
  INNER JOIN eduba_content_frontpage AS fp
  ON fp.content_id = a.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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-26 08:58:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-26 08:58:43')
  AND a.language in ('es-ES','*')
  AND (contact.language in ('es-ES','*') OR contact.language IS NULL)
  AND a.catid IN (79,80)
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  ORDER BY c.lft, a.created DESC , a.created DESC
  LIMIT 0, 10
17. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 eduba_content AS a
  LEFT JOIN eduba_categories AS c
  ON c.id = a.catid
  LEFT JOIN eduba_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eduba_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM eduba_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN eduba_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN eduba_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_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
  INNER JOIN eduba_content_frontpage AS fp
  ON fp.content_id = a.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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-09-26 08:58:43')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-09-26 08:58:43')
  AND a.language in ('es-ES','*')
  AND (contact.language in ('es-ES','*') OR contact.language IS NULL)
  AND a.catid IN (79,80)
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  ORDER BY c.lft, a.created DESC , a.created DESC
18. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
19. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
20. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_jvotesystem'
21. SELECT u.*
  FROM `eduba_jvotesystem_users` AS u
  LEFT JOIN `eduba_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  WHERE `ip`="54.81.197.127"
  AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) < `lastVisitDate`
22. SELECT u.*, s.`id` AS session_id, s.`jsession_id`, s.`cookie`, s.`lastVisitDate`, s.`rights`
  FROM `eduba_jvotesystem_users` AS u
  LEFT JOIN `eduba_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
  WHERE s.`jsession_id`='a32ab11520538d4fb63d8bef9a394f54'
  ORDER BY s.`lastVisitDate` DESC
23. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
24. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
25. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
26. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
27. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
28. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
29. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
30. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
31. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
32. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM eduba_categories as c
  LEFT JOIN eduba_categories AS s
  ON (s.lft < c.lft
  AND s.rgt > c.rgt
  AND c.language in ('es-ES','*')) OR (s.lft >= c.lft
  AND s.rgt <= c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_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=79
  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
33. SELECT m2.language, m2.id
  FROM eduba_menu as m
  INNER JOIN eduba_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN eduba_associations as a2
  ON a.key=a2.key
  INNER JOIN eduba_menu as m2
  ON a2.id=m2.id
  WHERE m.id=435
34. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eduba_modules AS m
  LEFT JOIN eduba_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eduba_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 <= '2017-09-26 08:58:43')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-26 08:58:43')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  AND m.language IN ('es-ES','*')
  ORDER BY m.position, m.ordering
35. SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
  FROM `eduba_sexy_polls` sp JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = sp.id
  AND sa.published = '1'
  LEFT JOIN `eduba_sexy_templates` st
  ON st.id = sp.id_template
  WHERE sp.published = '1'
  AND sp.id = 1
  ORDER BY sp.ordering,sp.name,sa.ordering,sa.name
36. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
37. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
38. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
39. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
40. SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
  AND sv.ip = '54.81.197.127'
  ORDER BY sv.`date` DESC
  LIMIT 1
41. SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
  AND sv.ip = '54.81.197.127'
  ORDER BY sv.`date` DESC
  LIMIT 1
42. SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date
  FROM `eduba_sexy_votes` sv JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = '1'
  WHERE sv.id_answer = sa.id
43. SELECT *
  FROM eduba_banners
  WHERE '2017-09-26 08:58:43' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
44. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_banners'
45. 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 eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
  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.cid = 2
  AND cl.state = 1
  AND a.catid IN (15)
  AND ((a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cl.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cat.metakey REGEXP '[[:<:]]EDUBA[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
46. 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 eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
  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.cid = 2
  AND cl.state = 1
  AND a.catid IN (15)
  AND ((a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Eduba Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Eduba Barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('eduba barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]eduba barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('EDUBA',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cl.metakey REGEXP '[[:<:]]EDUBA[[:>:]]' OR cat.metakey REGEXP '[[:<:]]EDUBA[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('empresa de desarrollo urbano de barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]empresa de desarrollo urbano de barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
47. SELECT m2.language, m2.id
  FROM eduba_menu as m
  INNER JOIN eduba_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN eduba_associations as a2
  ON a.key=a2.key
  INNER JOIN eduba_menu as m2
  ON a2.id=m2.id
  WHERE m.id=435
48. SELECT `enabled`
  FROM `eduba_extensions`
  WHERE `element` = "com_jvotesystem"
  AND `type` = "component"
49. UPDATE `eduba_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506416323;s:18:\"session.timer.last\";i:1506416323;s:17:\"session.timer.now\";i:1506416323;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"session.token\";s:32:\"eed4630580336cf27138f69c73f96f0d\";}__joomessLibrary|a:1:{s:5:\"files\";a:0:{}}' , `time` = '1506416323'
  WHERE `session_id` = 'a32ab11520538d4fb63d8bef9a394f54'

27 Tipos de consultas del registro, Ordenado por acontecimientos.

SELECCIONAR Tablas:

1. 12 × SELECT `enabled`
  FROM `eduba_extensions`
2. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
3. 4 × SELECT `rules`
  FROM eduba_viewlevels
4. 2 × SELECT m2.language, m2.id
  FROM eduba_menu as m
  INNER JOIN eduba_associations as a
  ON a.id=m.id
  AND a.context='com_menus.item'
  INNER JOIN eduba_associations as a2
  ON a.key=a2.key
  INNER JOIN eduba_menu as m2
  ON a2.id=m2.id
5. 2 × SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
6. 2 × 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 eduba_banners as a
  LEFT JOIN eduba_banner_clients AS cl
  ON cl.id = a.cid
  LEFT JOIN eduba_categories as cat
  ON a.catid = cat.id
7. 2 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, 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,contact.id 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 eduba_content AS a
  LEFT JOIN eduba_categories AS c
  ON c.id = a.catid
  LEFT JOIN eduba_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN eduba_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM eduba_contact_details AS contact
8. 1 × SELECT id, rules
  FROM `eduba_viewlevels
9. 1 × SELECT sp.id polling_id, sp.id_template id_template, sp.date_start date_start, sp.date_end date_end, sp.showresultsduringpoll showresultsduringpoll, sp.multiple_answers multiple_answers, sp.voting_period voting_period, sp.number_answers number_answers, sp.voting_permission voting_permission, sp.answerpermission answerpermission, sp.autopublish autopublish, sp.baranimationtype baranimationtype, sp.coloranimationtype coloranimationtype, sp.reorderinganimationtype reorderinganimationtype, sp.dateformat dateformat, sp.autoopentimeline autoopentimeline, sp.autoanimate autoanimate, sp.showresultbutton showresultbutton, sp.showvotesperiod showvotesperiod, sp.stringdateformat stringdateformat, sp.votescountformat votescountformat, sp.scaledefault scaledefault, sp.showaddanswericon showaddanswericon, sp.showscaleicon showscaleicon, sp.showbackicon showbackicon, sp.showtimelineicon showtimelineicon, sp.showtimeline showtimeline, sp.showvotescountinfo showvotescountinfo, sp.poll_width poll_width, sp.pollalign pollalign, sp.addclearboth addclearboth, sp.poll_margintop poll_margintop, sp.poll_marginbottom poll_marginbottom, sp.poll_marginleft poll_marginleft, sp.poll_marginright poll_marginright, sp.classsuffix classsuffix, sp.checktoken checktoken, sp.ipcount ipcount, sp.checkacl checkacl, sp.votechecks votechecks, st.styles styles, sp.name polling_name, sp.question polling_question, sa.id answer_id, sa.show_name show_name, sa.img_name img_name, sa.img_url img_url, sa.img_width img_width, sa.embed embed, sa.name answer_name
  FROM `eduba_sexy_polls` sp JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = sp.id
  AND sa.published = '1'
  LEFT JOIN `eduba_sexy_templates` st
  ON st.id = sp.id_template
10. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM eduba_modules AS m
  LEFT JOIN eduba_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN eduba_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
11. 1 × SELECT b.id
  FROM eduba_usergroups AS a
  LEFT JOIN eduba_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
12. 1 × SELECT COUNT(sv.`id_answer`) total_count, MAX(sv.`date`) max_date,MIN(sv.`date`) min_date
  FROM `eduba_sexy_votes` sv JOIN `eduba_sexy_answers` sa
  ON sa.id_poll = '1'
13. 1 × SELECT `session_id`
  FROM `eduba_session`
14. 1 × SELECT *
  FROM eduba_banners
15. 1 × SELECT folder AS type, element AS name, params
  FROM eduba_extensions
16. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM eduba_categories as c
  LEFT JOIN eduba_categories AS s
  ON (s.lft < c.lft
  AND s.rgt > c.rgt
  AND c.language in ('es-ES','*')) OR (s.lft >= c.lft
  AND s.rgt <= c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM eduba_categories AS cat JOIN eduba_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
17. 1 × SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
18. 1 × SELECT a.rules
  FROM eduba_assets AS a
19. 1 × SELECT id, home, template, s.params
  FROM eduba_template_styles as s
  LEFT JOIN eduba_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
20. 1 × SELECT `data`
  FROM `eduba_session`
21. 1 × SELECT *
  FROM eduba_languages
22. 1 × SELECT u.*, s.`id` AS session_id, s.`jsession_id`, s.`cookie`, s.`lastVisitDate`, s.`rights`
  FROM `eduba_jvotesystem_users` AS u
  LEFT JOIN `eduba_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
23. 1 × SELECT u.*
  FROM `eduba_jvotesystem_users` AS u
  LEFT JOIN `eduba_jvotesystem_sessions` AS s
  ON( u.`id`=s.`user_id`)
24. 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 eduba_menu AS m
  LEFT JOIN eduba_extensions AS e
  ON m.component_id = e.extension_id

OTRAS Tablas:

1. 1 × UPDATE `eduba_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506416323;s:18:\"session.timer.last\";i:1506416323;s:17:\"session.timer.now\";i:1506416323;s:22:\"session.client.browser\";s:39:\"CCBot/2.0 (http://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{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:13:\"session.token\";s:32:\"eed4630580336cf27138f69c73f96f0d\";}__joomessLibrary|a:1:{s:5:\"files\";a:0:{}}' , `time` = '1506416323'
2. 1 × INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('a32ab11520538d4fb63d8bef9a394f54', 0, '1506416323'
3. 1 × DELETE
  FROM `eduba_session`