Home
	Home La SEdeM Concursos y Olimpiadas Próximos Eventos Boletines Contactos Regístrate Usuario clave Recordarme ¿Recuperar clave? ¿Quiere registrarse? Regístrese aquí Popular Soluciones 2008 Resultados Etapa Clasificatoria OMPP 2009 Formularios de Inscripción Resultados Finales OMPP Soluciones OMPP 2009 Etapa Clasificatoria		Historia de la SEdeM Conozca sobre la historia de la Sociedad Ecuatoriana de Matemática en este artículo. Modificado el ( miércoles, 17 de junio de 2009 ) Leer más...   EMALCA Amazonía 2009 EMALCA Amazonía 2009  Escuela de Matemática de América Latina y el Caribe Universidade Federal do Amazonas, Manaus, del 03/08  al 14/08   Modificado el ( sábado, 27 de junio de 2009 ) Leer más...		En Linea Hay 2 invitados en línea Ultimas Noticias test EMALCA Amazonía 2009 Historia de la SEdeM II concurso intercolegial de Matemáticas Ramiro Andrade Cruz Soluciones OMPP 2009 Etapa Final
Friday, July 03 2009

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
 LIMIT 1
4
DELETE FROM jos_session
 WHERE ( time < '1246665111' )
5
SELECT * FROM jos_session WHERE session_id='14ee4eb6005da5437dbd58f5fbabb26e'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = MD5( 'c20227e0e79e19a10472c910336e5a6b' )
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0c30efffb2c5b452714f937035802a9e','1246666011','','0','1' )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'editors-xtd'
 ORDER BY ordering
15
SELECT access
 FROM jos_menu
 WHERE id = 1
16
SELECT * FROM jos_menu WHERE id='1'
17
SELECT a.id, a.title, a.introtext, 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.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore,
 ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER 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
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND a.access <= 0
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-03 19:06'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-03 19:06' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
18
SELECT COUNT( m.id )
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
19
SELECT COUNT( m.id )
 FROM jos_content AS i
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS m ON m.componentid = c.id 
 WHERE m.type = 'content_blog_category'
 AND m.published = 1
20
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
21
SELECT a.id
 FROM jos_components AS a
 WHERE a.name = 'Syndicate'
22
SELECT * FROM jos_components WHERE id='17'
23
SELECT id, name, link, parent, type
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
 LIMIT 1
24
SELECT id, name, link, parent, type
 FROM jos_menu
 WHERE published = 1
 ORDER BY parent, ordering
25
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m, jos_modules_menu AS mm
 WHERE m.published = 1
 AND m.access <= '0'
 AND m.client_id != 1
 AND mm.moduleid = m.id
 AND ( mm.menuid = '1' OR mm.menuid = 0 )
 ORDER BY ordering
26
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
27
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1
28
SELECT COUNT( session_id ) AS guest_online
 FROM jos_session
 WHERE guest = 1
 AND ( usertype is NULL OR usertype = '' )
29
SELECT COUNT( DISTINCT( username ) ) AS user_online
 FROM jos_session
 WHERE guest = 0
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.checked_out = 0 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-03 19:06:51' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-03 19:06:51' )
 AND a.access <= '0'
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
 LIMIT 5
31
SELECT COUNT( m.id )
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_blog_section'
 AND m.published = 1
32
SELECT COUNT( m.id )
 FROM jos_content AS i
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS m ON m.componentid = c.id 
 WHERE m.type = 'content_blog_category'
 AND m.published = 1
33
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
34
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 47
35
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 46
36
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 44
37
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 43
38
SELECT m.id 
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS m ON m.componentid = s.id 
 WHERE m.type = 'content_section'
 AND m.published = 1
 AND i.id = 42