Joomla! es Software Libre distribuido bajo licencia GNU/GPL.
<iframe><noscript><xmp><pre><!-- 1283702468 -->31 preguntas ejecutadas<pre>1
SET sql_mode = 'MYSQL40'<hr />2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering<hr />3
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 2 )
ORDER BY menuid DESC
LIMIT 1<hr />4
DELETE FROM jos_session
WHERE (
( time < '1283701565' )
AND guest = 0
AND gid > 0
) OR (
( time < '1283701565' )
AND guest = 1
AND userid = 0
)<hr />5
SELECT *
FROM jos_session
WHERE session_id = 'a7173ea8bd4f8d4972c41dfbd61f983d'<hr />6
SELECT session_id
FROM jos_session
WHERE session_id = 'dc7b321c95358ed131675f85f9560e46'<hr />7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'dc7b321c95358ed131675f85f9560e46','1283702466','','0','1' )<hr />8
SELECT *
FROM jos_menu
WHERE id = 2<hr />9
SELECT *
FROM jos_sections
WHERE id = '1'<hr />10
SELECT a.*, COUNT( b.id ) AS numitems
FROM jos_categories AS a
LEFT JOIN jos_content AS b ON b.catid = a.id
AND b.state = 1
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-09-05 11:01' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-09-05 11:01' )
WHERE a.section = '1'
AND a.published = 1
AND a.access <= 0
AND b.access <= 0
GROUP BY a.id
HAVING numitems > 0
ORDER BY a.ordering<hr />11
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'<hr />12
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 2 )
ORDER BY ordering<hr />13
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering<hr />14
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 1<hr />15
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
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.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 11:01' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 11:01' )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering<hr />16
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering<hr />17
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering<hr />18
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'Fotos'
AND published = 1
AND access <= 0
ORDER BY parent, ordering<hr />19
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'Videos'
AND published = 1
AND access <= 0
ORDER BY parent, ordering<hr />20
SELECT *
FROM jos_banner
WHERE showBanner=1<hr />21
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 3<hr />22
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 11:01' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 11:01' )
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 5<hr />23
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 15
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id<hr />24
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 14
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id<hr />25
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0<hr />26
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0<hr />27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 13
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id<hr />28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 12
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id<hr />29
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 1
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id<hr />30
SELECT a.id, a.title, a.sectionid, a.catid
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
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.sectionid > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 11:01' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 11:01' )
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 5<hr />31
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering<hr /></pre>
Noticias 
Selecciona el título de una noticia de la lista siguiente para leerla.