SELECT *
FROM jos_session
WHERE session_id = '73db171f0216ae7e74d603b95d78f159'
DELETE
FROM jos_session
WHERE ( time < '1327710608' )
SELECT *
FROM jos_session
WHERE session_id = '73db171f0216ae7e74d603b95d78f159'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '73db171f0216ae7e74d603b95d78f159','1327711508','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_rokcandy
WHERE published=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
ORDER BY a.created DESC
LIMIT 0, 10
SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
ORDER BY a.created DESC
SELECT id
FROM jos_users
WHERE username = 'prueba'
LIMIT 0, 1
SELECT (parentid) AS Expr1
FROM jos_content
WHERE (id=826)
SELECT *
FROM jos_content
WHERE id = '826'
SELECT (Count(*)) AS Expr1
FROM (jos_yvcomment AS c)
INNER JOIN jos_content AS ar
ON c.parentid=ar.id
WHERE ((c.parentid<>0)
AND c.access <= 0
AND ar.access <= 0
AND c.parentid=826
AND ar.state = 1
AND c.state = 1)
SELECT a.sectionid, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state IN(-1, 1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND a.id = 826
AND a.access <= 0
AND ((cc.access <= 0) OR cc.id IS NULL)
AND ((s.access <= 0) OR s.id IS NULL)
AND ((s.published = 1) OR (s.id IS NULL))
AND ((cc.published = 1) OR (cc.id IS NULL))
SELECT (parentid) AS Expr1
FROM jos_content
WHERE (id=825)
SELECT *
FROM jos_content
WHERE id = '825'
SELECT (Count(*)) AS Expr1
FROM (jos_yvcomment AS c)
INNER JOIN jos_content AS ar
ON c.parentid=ar.id
WHERE ((c.parentid<>0)
AND c.access <= 0
AND ar.access <= 0
AND c.parentid=825
AND ar.state = 1
AND c.state = 1)
SELECT a.sectionid, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state IN(-1, 1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND a.id = 825
AND a.access <= 0
AND ((cc.access <= 0) OR cc.id IS NULL)
AND ((s.access <= 0) OR s.id IS NULL)
AND ((s.published = 1) OR (s.id IS NULL))
AND ((cc.published = 1) OR (cc.id IS NULL))
SELECT (parentid) AS Expr1
FROM jos_content
WHERE (id=824)
SELECT *
FROM jos_content
WHERE id = '824'
SELECT (Count(*)) AS Expr1
FROM (jos_yvcomment AS c)
INNER JOIN jos_content AS ar
ON c.parentid=ar.id
WHERE ((c.parentid<>0)
AND c.access <= 0
AND ar.access <= 0
AND c.parentid=824
AND ar.state = 1
AND c.state = 1)
SELECT a.sectionid, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state IN(-1, 1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND a.id = 824
AND a.access <= 0
AND ((cc.access <= 0) OR cc.id IS NULL)
AND ((s.access <= 0) OR s.id IS NULL)
AND ((s.published = 1) OR (s.id IS NULL))
AND ((cc.published = 1) OR (cc.id IS NULL))
SELECT (parentid) AS Expr1
FROM jos_content
WHERE (id=823)
SELECT *
FROM jos_content
WHERE id = '823'
SELECT (Count(*)) AS Expr1
FROM (jos_yvcomment AS c)
INNER JOIN jos_content AS ar
ON c.parentid=ar.id
WHERE ((c.parentid<>0)
AND c.access <= 0
AND ar.access <= 0
AND c.parentid=823
AND ar.state = 1
AND c.state = 1)
SELECT a.sectionid, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state IN(-1, 1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND a.id = 823
AND a.access <= 0
AND ((cc.access <= 0) OR cc.id IS NULL)
AND ((s.access <= 0) OR s.id IS NULL)
AND ((s.published = 1) OR (s.id IS NULL))
AND ((cc.published = 1) OR (cc.id IS NULL))
SELECT (parentid) AS Expr1
FROM jos_content
WHERE (id=822)
SELECT *
FROM jos_content
WHERE id = '822'
SELECT (Count(*)) AS Expr1
FROM (jos_yvcomment AS c)
INNER JOIN jos_content AS ar
ON c.parentid=ar.id
WHERE ((c.parentid<>0)
AND c.access <= 0
AND ar.access <= 0
AND c.parentid=822
AND ar.state = 1
AND c.state = 1)
SELECT a.sectionid, 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 jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state IN(-1, 1)
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND a.id = 822
AND a.access <= 0
AND ((cc.access <= 0) OR cc.id IS NULL)
AND ((s.access <= 0) OR s.id IS NULL)
AND ((s.published = 1) OR (s.id IS NULL))
AND ((cc.published = 1) OR (cc.id IS NULL))
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=47)
AND (s.id=7)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT count(a.id)
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=47)
AND (s.id=7)
AND s.published = 1
AND cc.published = 1
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 26
AND published = 1
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=70)
AND (s.id=11)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 8
SELECT count(a.id)
FROM jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=70)
AND (s.id=11)
AND s.published = 1
AND cc.published = 1
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 10
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 0
AND published = 1
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=128)
AND (s.id=23)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 3
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (s.id=15)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 3
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=38)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 3
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-27 19:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 19:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=65)
AND (s.id=8)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 10
SELECT a.*, 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 jos_content AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 00:45:08' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 00:45:08' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=42)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 4
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
Santafe de Bogota, enero 20 de 2012..La intención de dilatar el proceso que contra Iván Moreno Rojas cursaba en la Procuraduría salió costosa. La defensa de Moreno, en cabeza del ex magistrado Jaime Araújo, no se hizo presente ni en Bogotá ni en el consulado de Colombia en Miami, donde dijo encontrarse, con lo cual creyó que lograría torpedear el proceso.
Santiago de cali, Enero 18 de 2012. Con la presencia del Alcalde de Cali y el gabinete municipal, acompañados por autoridades de la Policía Metropolitana y de la Tercera Brigada, se llevó a cabo el segundo Consejo Comunitario de la Administración liderada por el médico Rodrigo Guerrero Velasco, en la comuna 15, al suroriente de la ciudad.
Cali, miercoles 17 de enero de 2012. Con el objeto de unir esfuerzos, seguir reverdeciendo a Cali como Capital Deportiva de América y continuar con la recuperación del civismo y cultura ciudadana, el Alcalde Rodrigo Guerrero Velasco, empieza a movilizar y a liderar a la ciudad hacia la realización de los Juegos Mundiales – World Games – en el 2013.
