37 consultas registradas

1. SELECT `data`
  FROM `eduba_session`
  WHERE `session_id` = '5971172283d682b72392c26c359394ab'
2. DELETE
  FROM `eduba_session`
  WHERE `time` < '1524295967'
3. SELECT `session_id`
  FROM `eduba_session`
  WHERE `session_id` = '5971172283d682b72392c26c359394ab'
  LIMIT 0, 1
4. INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('5971172283d682b72392c26c359394ab', 0, '1524296867')
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 language,id
  FROM `eduba_menu`
  WHERE home = 1
  AND published = 1
  AND client_id = 0
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 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
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
14. 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
15. SELECT a.rules
  FROM eduba_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
16. 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')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
17. SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
  FROM eduba_contact_details AS contact
  WHERE contact.published = 1
  AND contact.user_id = a.created_by
  AND (contact.language in ('es-ES','*') OR contact.language IS NULL)) 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
  FROM eduba_content AS a
  LEFT JOIN eduba_categories AS c
  on c.id = a.catid
  LEFT JOIN eduba_users AS u
  on u.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 <= 0
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE a.language in ('es-ES','*')
  AND a.id = 83
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-21 07:47:47')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-21 07:47:47')
  AND (a.state = 1 OR a.state =2)
18. 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=78
  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
19. 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.article.83')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
20. SELECT a.id, a.language,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM eduba_content AS a
  LEFT JOIN eduba_categories AS cc
  ON cc.id = a.catid
  WHERE a.catid = 78
  AND a.state = 1
  AND a.access = 1
  AND (a.state = 1 OR a.state = -1)
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2018-04-21 07:47:47')
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2018-04-21 07:47:47')
  AND a.language in ('es-ES','*')
  ORDER BY a.created DESC
21. UPDATE eduba_content
  SET hits = hits + 1
  WHERE id = 83
22. 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=472
23. 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 <= '2018-04-21 07:47:47')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-21 07:47:47')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 472 OR mm.menuid <= 0)
  AND m.language IN ('es-ES','*')
  ORDER BY m.position, m.ordering
24. 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
25. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '2'
26. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '2'
27. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
28. SELECT `rules`
  FROM eduba_viewlevels
  WHERE id = '1'
29. 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 = '23.20.245.192'
  ORDER BY sv.`date` DESC
  LIMIT 1
30. 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 = '23.20.245.192'
  ORDER BY sv.`date` DESC
  LIMIT 1
31. 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
32. SELECT *
  FROM eduba_banners
  WHERE '2018-04-21 07:47:47' >= `reset`
  AND `reset` != '0000-00-00 00:00:00'
  AND `reset`!=NULL
  AND (`checked_out` = 0 OR `checked_out` = 0)
33. SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_banners'
34. 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('legislacion eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('legislacion eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]') 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('barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('resoluciones',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('resoluciones',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]resoluciones[[:>:]]' OR cl.metakey REGEXP '[[:<:]]resoluciones[[:>:]]' OR cat.metakey REGEXP '[[:<:]]resoluciones[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('ever jimenez',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('ever jimenez',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]' OR cl.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]' OR cat.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('normograma',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('normograma',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cl.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cat.metakey REGEXP '[[:<:]]normograma[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo Número 003 de 1994',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo Número 003 de 1994',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 089 de 1995',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 089 de 1995',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo 096 del 2000',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo 096 del 2000',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 266 de 2004',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 266 de 2004',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo 008 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo 008 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 093 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 093 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Ley 1537 de 2012',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Ley 1537 de 2012',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Ley 594 de 2000 - Ley General de Archivos',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Ley 594 de 2000 - Ley General de Archivos',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 1563 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 1563 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 0935',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 0935',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 280 del 21 de Julio de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 280 del 21 de Julio de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 331 del 15 de Septiembre de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 331 del 15 de Septiembre de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 334 del 19 de Septiembre de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 334 del 19 de Septiembre de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 355 de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 355 de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 1077 del 26 de Mayo de 2015',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 1077 del 26 de Mayo de 2015',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('normograma',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('normograma',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cl.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cat.metakey REGEXP '[[:<:]]normograma[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 055 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 055 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 057 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 057 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('comisión de personal',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('comisión de personal',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]' OR cl.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]' OR cat.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('representantes',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('representantes',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]representantes[[:>:]]' OR cl.metakey REGEXP '[[:<:]]representantes[[:>:]]' OR cat.metakey REGEXP '[[:<:]]representantes[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 201 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 201 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('administracion',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('administracion',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]administracion[[:>:]]' OR cl.metakey REGEXP '[[:<:]]administracion[[:>:]]' OR cat.metakey REGEXP '[[:<:]]administracion[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('postulacion y asignacion del subsidio municipal de vivienda',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('postulacion y asignacion del subsidio municipal de vivienda',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]' OR cl.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]' OR cat.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
35. 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('legislacion eduba',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('legislacion eduba',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]' OR cl.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]' OR cat.metakey REGEXP '[[:<:]]legislacion eduba[[:>:]]') 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('barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]barrancabermeja[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('resoluciones',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('resoluciones',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]resoluciones[[:>:]]' OR cl.metakey REGEXP '[[:<:]]resoluciones[[:>:]]' OR cat.metakey REGEXP '[[:<:]]resoluciones[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('ever jimenez',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('ever jimenez',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]' OR cl.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]' OR cat.metakey REGEXP '[[:<:]]ever jimenez[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('normograma',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('normograma',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cl.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cat.metakey REGEXP '[[:<:]]normograma[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo Número 003 de 1994',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo Número 003 de 1994',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo Número 003 de 1994[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 089 de 1995',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 089 de 1995',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 089 de 1995[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo 096 del 2000',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo 096 del 2000',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo 096 del 2000[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 266 de 2004',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 266 de 2004',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 266 de 2004[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Acuerdo 008 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Acuerdo 008 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Acuerdo 008 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 093 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 093 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 093 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Ley 1537 de 2012',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Ley 1537 de 2012',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Ley 1537 de 2012[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Ley 594 de 2000 - Ley General de Archivos',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Ley 594 de 2000 - Ley General de Archivos',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Ley 594 de 2000 - Ley General de Archivos[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 1563 de 2005',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 1563 de 2005',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 1563 de 2005[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 0935',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 0935',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 0935[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 280 del 21 de Julio de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 280 del 21 de Julio de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 280 del 21 de Julio de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 331 del 15 de Septiembre de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 331 del 15 de Septiembre de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 331 del 15 de Septiembre de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 334 del 19 de Septiembre de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 334 del 19 de Septiembre de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 334 del 19 de Septiembre de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 355 de 2014',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 355 de 2014',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 355 de 2014[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 1077 del 26 de Mayo de 2015',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 1077 del 26 de Mayo de 2015',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 1077 del 26 de Mayo de 2015[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('normograma',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('normograma',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cl.metakey REGEXP '[[:<:]]normograma[[:>:]]' OR cat.metakey REGEXP '[[:<:]]normograma[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 055 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 055 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 055 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Resolución 057 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Resolución 057 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Resolución 057 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('comisión de personal',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('comisión de personal',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]' OR cl.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]' OR cat.metakey REGEXP '[[:<:]]comisión de personal[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('representantes',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('representantes',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]representantes[[:>:]]' OR cl.metakey REGEXP '[[:<:]]representantes[[:>:]]' OR cat.metakey REGEXP '[[:<:]]representantes[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 201 de 2017',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 201 de 2017',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 201 de 2017[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('administracion',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('administracion',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]administracion[[:>:]]' OR cl.metakey REGEXP '[[:<:]]administracion[[:>:]]' OR cat.metakey REGEXP '[[:<:]]administracion[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('postulacion y asignacion del subsidio municipal de vivienda',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('postulacion y asignacion del subsidio municipal de vivienda',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]' OR cl.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]' OR cat.metakey REGEXP '[[:<:]]postulacion y asignacion del subsidio municipal de vivienda[[:>:]]') OR (a.own_prefix=1
  AND a.metakey_prefix=SUBSTRING('Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja',1,LENGTH( a.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=1
  AND cl.metakey_prefix=SUBSTRING('Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja',1,LENGTH(cl.metakey_prefix)) OR a.own_prefix=0
  AND cl.own_prefix=0
  AND 1)
  AND (a.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]' OR cl.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]' OR cat.metakey REGEXP '[[:<:]]Decreto 214 - Del 15 de Junio de 2017 - Municipio de Barrancabermeja[[:>:]]'))
  AND a.language in ('es-ES','*')
  ORDER BY a.sticky DESC,a.ordering
  LIMIT 0, 1
36. 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=472
37. UPDATE `eduba_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524296867;s:18:\"session.timer.last\";i:1524296867;s:17:\"session.timer.now\";i:1524296867;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:16:\"com_mailto.links\";a:1:{s:40:\"0ccd43804e0d924c29aa1d65502d4532ddb0c127\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"http://eduba.gov.co/index.php?option=com_content&view=article&id=83:legislacionynormograma&catid=78&Itemid=530&lang=es\";s:6:\"expiry\";i:1524296867;}}s:13:\"session.token\";s:32:\"4494bfa920792dc0b53d4a9cb85baded\";}' , `time` = '1524296867'
  WHERE `session_id` = '5971172283d682b72392c26c359394ab'

27 tipo de consultas registradas, ordenadas por la ocurrencia

Tablas SELECCIONADAS:

1. 4 × SELECT `rules`
  FROM eduba_viewlevels
2. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM eduba_extensions
3. 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
4. 2 × SELECT sv.`ip`,sv.`date`
  FROM eduba_sexy_votes sv JOIN eduba_sexy_answers sa
  ON sa.id_poll = '1'
5. 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
6. 2 × SELECT b.rules
  FROM eduba_assets AS a
  LEFT JOIN eduba_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
7. 1 × SELECT id, rules
  FROM `eduba_viewlevels
8. 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
9. 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
10. 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
11. 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'
12. 1 × SELECT `session_id`
  FROM `eduba_session`
13. 1 × SELECT *
  FROM eduba_banners
14. 1 × SELECT folder AS type, element AS name, params
  FROM eduba_extensions
15. 1 × SELECT a.id, a.language,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
  FROM eduba_content AS a
  LEFT JOIN eduba_categories AS cc
  ON cc.id = a.catid
16. 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
17. 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
18. 1 × SELECT language,id
  FROM `eduba_menu`
19. 1 × SELECT a.rules
  FROM eduba_assets AS a
20. 1 × SELECT `data`
  FROM `eduba_session`
21. 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
22. 1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, 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, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
  FROM eduba_contact_details AS contact
23. 1 × SELECT *
  FROM eduba_languages

OTRAS tablas:

1. 1 × UPDATE `eduba_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524296867;s:18:\"session.timer.last\";i:1524296867;s:17:\"session.timer.now\";i:1524296867;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:16:\"com_mailto.links\";a:1:{s:40:\"0ccd43804e0d924c29aa1d65502d4532ddb0c127\";O:8:\"stdClass\":2:{s:4:\"link\";s:118:\"http://eduba.gov.co/index.php?option=com_content&view=article&id=83:legislacionynormograma&catid=78&Itemid=530&lang=es\";s:6:\"expiry\";i:1524296867;}}s:13:\"session.token\";s:32:\"4494bfa920792dc0b53d4a9cb85baded\";}' , `time` = '1524296867'
2. 1 × UPDATE eduba_content
  SET hits = hits + 1
3. 1 × INSERT INTO `eduba_session` (`session_id`, `client_id`, `time`)
  VALUES ('5971172283d682b72392c26c359394ab', 0, '1524296867'
4. 1 × DELETE
  FROM `eduba_session`