Por el cual se reforma y reestructura la empresa de desarrollo urbano de Barrancabermeja -EDUBA- y se establece su marco jurídico de conformidad con las normas legales vigentes.
Por el cual se autoriza al alcalde municipal para reglamentar y asignar subsidios municipales de vivienda a los hogares beneficiarios de los proyectos de vivienda de interés social contemplados en el Plan de Desarrollo Municipal
Por medio del cual se autoriza la participación de entidades publicas municipales para la constitución y conformación del capital accionario en empresas de servicios públicos.
Por medio del cual se reglamenta el articulo 7 del acuerdo 003 de 1994, y se nombran los miembros de la junta directiva de EDUBA y se establece el procedimiento para elegir y posesionar los tres representantes de las organizaciones populares de vivienda.
Por la cual se ajusta el Manual especifico de funciones y competencias laborales para los empleos de la Planta de personal de la Empresa de Desarrollo Urbano y Vivienda de Interés Social de Barrancabermeja - Eduba
Por medio del cual se hace convocatoria para la elección de los representantes de las organizaciones populares de vivienda que integraran la junta directiva de la empresa de desarrollo urbano y vivienda de interés social - EDUBA
Por medio de la cual se establece el Sistema Integrado de Gestión de la Empresa de Desarrollo Urbano y Fondo de Vivienda de Interés Social de Barrancabermeja y se crean los equipos de Trabajo institucional para su implementación
Por medio de la cual se implementan los procedimientos del Área de Sistemas y Tecnologías de la Información y las Comunicaciones de la Empresa de Desarrollo Urbano y Fondo de Vivienda de Interés Social de Barrancabermeja - EDUBA.
Por la cual se modifica la Resolución No. 280 del 21 de julio de 2014, incorporando en las funciones del Comité de dirección del sistema de Gestión de Calidad, la coordinación de la Implementación de la Estrategia de Gobierno en Linea y Antitramites, así como la representación de alguna(s) dependencia(s) de las establecidas para el Comité de Gobierno en Linea.
Por medio de la cual se adopta la actualización del Modelo Estándar de control Interno - MECI - en la Empresa de Desarrollo Urbano y Fondo de Vivienda de Interés Social de Barrancabermeja - EDUBA.
Por la cual se nombran los representantes de los empleados a la Comisión de Personal Periodo 2017 - 2019, de la Empresa de Desarrollo Urbano y Vivienda de Interés Social de Barrancabermeja - eduba
Por la cual se nombran los representantes de la entidad en la Comisión de Personal Periodo 2017 - 2019, de la Empresa de Desarrollo Urbano y Vivienda de Interés Social de Barrancabermeja - eduba
SELECT extension_id AS id, element AS "option", params, enabled
FROMeduba_extensions WHERE `type` = 'component' AND `element` = 'com_users'
SELECT b.id
FROMeduba_usergroupsAS a
LEFTJOINeduba_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `eduba_viewlevels`
SELECT folder AS type, element AS name, params
FROMeduba_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1)
ORDERBY ordering
SELECT* FROMeduba_languages WHERE published=1
ORDERBY ordering ASC
SELECT extension_id AS id, element AS "option", params, enabled
FROMeduba_extensions WHERE `type` = 'component' AND `element` = 'com_languages'
SELECT language,id
FROM `eduba_menu`
WHERE home = 1 AND published = 1 AND client_id = 0
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
FROMeduba_menuAS m
LEFTJOINeduba_extensionsAS e ON m.component_id = e.extension_id
WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0
ORDERBY m.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROMeduba_extensions WHERE `type` = 'component' AND `element` = 'com_content'
SELECT id, home, template, s.params
FROMeduba_template_styles as s
LEFTJOINeduba_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
SELECT a.rules
FROMeduba_assetsAS a
WHERE (a.id = 1)
GROUPBY a.id, a.rules, a.lft
SELECT b.rules
FROMeduba_assetsAS a
LEFTJOINeduba_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN 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,(
SELECTMAX(contact.id) AS id
FROMeduba_contact_detailsAS contact
WHERE contact.published = 1 AND contact.user_id = a.created_by AND (contact.language in ('es-ES','*') OR contact.language ISNULL)) 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
FROMeduba_contentAS a
LEFTJOINeduba_categoriesAS c on c.id = a.catid
LEFTJOINeduba_usersAS u on u.id = a.created_by
LEFTJOINeduba_categories as parent ON parent.id = c.parent_id
LEFTJOINeduba_content_ratingAS v ON a.id = v.content_id
LEFT OUTERJOIN (SELECT cat.id as id FROMeduba_categoriesAS cat JOINeduba_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUPBY 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 <= '2019-02-17 15:43:14') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-17 15:43:14') AND (a.state = 1 OR a.state =2)
SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROMeduba_categories as c
LEFTJOINeduba_categoriesAS 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)
LEFTJOIN (SELECT cat.id as id FROMeduba_categoriesAS cat JOINeduba_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUPBY 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
GROUPBY 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
ORDERBY c.lft
SELECT b.rules
FROMeduba_assetsAS a
LEFTJOINeduba_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.83')
GROUPBY b.id, b.rules, b.lft
ORDERBY b.lft
SELECT a.id, a.language, CASEWHENCHAR_LENGTH(a.alias) THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(cc.alias) THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROMeduba_contentAS a
LEFTJOINeduba_categoriesAS 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 <= '2019-02-17 15:43:14') AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-17 15:43:14') AND a.language in ('es-ES','*')
ORDERBY a.created DESC
UPDATEeduba_content SET hits = hits + 1 WHERE id = 83
SELECT m2.language, m2.id
FROMeduba_menu as m
INNERJOINeduba_associations as a ON a.id=m.id AND a.context='com_menus.item'
INNERJOINeduba_associations as a2 ON a.key=a2.key
INNERJOINeduba_menu as m2 ON a2.id=m2.id
WHERE m.id=472
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMeduba_modulesAS m
LEFTJOINeduba_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINeduba_extensionsAS 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 <= '2019-02-17 15:43:14') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-17 15:43:14') 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','*')
ORDERBY m.position, m.ordering
SELECT `rules` FROMeduba_viewlevels WHERE id = '2'
SELECT `rules` FROMeduba_viewlevels WHERE id = '2'
SELECT `rules` FROMeduba_viewlevels WHERE id = '1'
SELECT `rules` FROMeduba_viewlevels WHERE id = '1'
SELECT sv.`ip`,sv.`date` FROMeduba_sexy_votes sv JOINeduba_sexy_answers sa ON sa.id_poll = '1' WHERE sv.id_answer = sa.id AND sv.ip = '18.212.222.217' ORDERBY sv.`date` DESC LIMIT 1
SELECT sv.`ip`,sv.`date` FROMeduba_sexy_votes sv JOINeduba_sexy_answers sa ON sa.id_poll = '1' WHERE sv.id_answer = sa.id AND sv.ip = '18.212.222.217' ORDERBY sv.`date` DESC LIMIT 1
SELECTCOUNT(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
SELECT* FROMeduba_banners WHERE '2019-02-17 15:43:14' >= `reset` AND `reset` != '0000-00-00 00:00:00' AND `reset`!=NULL AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT extension_id AS id, element AS "option", params, enabled
FROMeduba_extensions WHERE `type` = 'component' AND `element` = 'com_banners'
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
FROMeduba_banners as a
LEFTJOINeduba_banner_clientsAS cl ON cl.id = a.cid
LEFTJOINeduba_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','*')
ORDERBY a.sticky DESC,a.ordering
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
FROMeduba_banners as a
LEFTJOINeduba_banner_clientsAS cl ON cl.id = a.cid
LEFTJOINeduba_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','*')
ORDERBY a.sticky DESC,a.ordering LIMIT 0, 1
SELECT m2.language, m2.id
FROMeduba_menu as m
INNERJOINeduba_associations as a ON a.id=m.id AND a.context='com_menus.item'
INNERJOINeduba_associations as a2 ON a.key=a2.key
INNERJOINeduba_menu as m2 ON a2.id=m2.id
WHERE m.id=472
UPDATE `eduba_session`
SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550418194;s:18:\"session.timer.last\";i:1550418194;s:17:\"session.timer.now\";i:1550418194;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://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:1550418194;}}s:13:\"session.token\";s:32:\"52d37c75671bb5333bc9b2ef28cc5d2c\";}'
, `time` = '1550418194'
WHERE `session_id` = '91be1e3997ec21e3db4956a33aa3dc98'
26 tipo de consultas registradas, ordenadas por la ocurrencia
Tablas SELECCIONADAS:
4 × SELECT `rules` FROMeduba_viewlevels
4 × SELECT extension_id AS id, element AS "option", params, enabled FROMeduba_extensions
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 FROMeduba_banners as a LEFTJOINeduba_banner_clientsAS cl ON cl.id = a.cid LEFTJOINeduba_categories as cat ON a.catid = cat.id
2 × SELECT sv.`ip`,sv.`date` FROMeduba_sexy_votes sv JOINeduba_sexy_answers sa ON sa.id_poll = '1'
2 × SELECT m2.language, m2.id FROMeduba_menu as m INNERJOINeduba_associations as a ON a.id=m.id AND a.context='com_menus.item' INNERJOINeduba_associations as a2 ON a.key=a2.key INNERJOINeduba_menu as m2 ON a2.id=m2.id
2 × SELECT b.rules FROMeduba_assetsAS a LEFTJOINeduba_assetsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMeduba_modulesAS m LEFTJOINeduba_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINeduba_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT b.id FROMeduba_usergroupsAS a LEFTJOINeduba_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECTCOUNT(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'
1 × SELECT `session_id` FROM `eduba_session`
1 × SELECT* FROMeduba_banners
1 × SELECT folder AS type, element AS name, params FROMeduba_extensions
1 × SELECT a.id, a.language, CASEWHENCHAR_LENGTH(a.alias) THENCONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASEWHENCHAR_LENGTH(cc.alias) THENCONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug FROMeduba_contentAS a LEFTJOINeduba_categoriesAS cc ON cc.id = a.catid
1 × SELECT id, home, template, s.params FROMeduba_template_styles as s LEFTJOINeduba_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
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 FROMeduba_menuAS m LEFTJOINeduba_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT language,id FROM `eduba_menu`
1 × SELECT a.rules FROMeduba_assetsAS a
1 × SELECT `data` FROM `eduba_session`
1 × SELECT c.*, CASEWHENCHAR_LENGTH(c.alias) THENCONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROMeduba_categories as c LEFTJOINeduba_categoriesAS 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) LEFTJOIN (SELECT cat.id as id FROMeduba_categoriesAS cat JOINeduba_categoriesAS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, CASEWHEN badcats.id is null THEN a.state ELSE 0 ENDAS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias, CASEWHEN 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,( SELECTMAX(contact.id) AS id FROMeduba_contact_detailsAS contact