Inicio México Noticias Estadísticas Torneos Copa Libertadores Copa Sudamericana Copa UNCAF Concacaf Copa Oro Copa Confederaciones Superliga de Campeones UEFA Champion League Copa UEFA MLS MUNDIAL SUB-20 Eliminatorias Sudamerica Centroamerica Europa FIFA Africa Asia Sudamerica Argentina Bolivia Brasil Chile Colombia Ecuador Paraguay Perú Uruguay Venezuela Centroamerica Costa Rica El Salvador Guatemala Honduras Panamá Sopa Futbolera QUE PASA CON...
		Inicio Otros Titulares Hugo Droguett busca triunfar en Corea del Sur La UEFA expresa sus mejores deseos hacia Abidal Barcelona puede estar sintiendo la presión, reconoce Guardiola Man United gana con gol del "Chicharito" y alcanza al City El Sporting de Gijón despidió al técnico Manuel Preciado El Barça asume que la Liga no está en sus manos Mourinho dejará el Real Madrid para volver a la Premier Crespo, el más cotizado en subasta para nueva liga india leer más... Llega Tri Preolímpico a San Francisco de la mano del 'Chepo' El Tricolor Sub-23 llegó a San Francisco la madrugada de este viernes en lo que será su última parada previo a su participaci&oac... leer más... Definidos los Cuartos de Final de la Champions League La suerte habló y fue para designar el futuro de los ocho equipos que se clasificaron a los Cuartos de Final de la UEFA Champions League. Los c... leer más... Héctor Hugo Eugui va a dirigir a Estudiantes contra la historia Confirmada la llegada de Héctor Hugo Eugui como nuevo estratega de Estudiantes, el cuadro de la UAG ha ingresado al grupo de aquellos equipos q... leer más... Despues de 20 años, Mondragon regresa al Deportivo Cali Tras una carrera de 20 años en el exterior, el arquero Farid Mondragón regresa al Deportivo Cali, anunció el nuevo Presidente del... leer más... Vuelve Suazo a entrenar con Rayados Humberto Suazo fue reintegrado con el plantel rayado, cerrando la posibilidad de salir de la institución al menos por este semestre. ... leer más... 'Garantiza' Luis Fernando Tena misma lista Fútbol México - Amistoso El DT de la Selección Sub-23, Luis Fernando Tena, explicó que no porque algún jugador tenga un mal desempeño este sábado contra Senegal en el último partido de preparación convocará a otro elemento. Leer más...   Será Pável Pardo el líder del Chicago Fire Otras Ligas - Noticias El mediocampista mexicano Pável Pardo será uno de los líderes del Chicago Fire para la temporada 2012 de la MLS de los Estados Unidos que apenas inició el pasado fin de semana. Leer más...   Pumas le puso las garras encima a Isidro Metapan Torneos - Concachampion Sin mayores problemas, los Pumas de la UNAM pasaron por encima del Isidro Metapán al son de 8-0, y sellaron su boleto a las Semifinales de la Liga de Campeones de la CONCACAF, donde se verán las caras con un viejo conocido, los Rayados del Monterrey. Leer más...   Ecuador y Honduras disputarán amistoso en Guayaquil Suramerica - Amistoso Ecuador se medirá con Honduras el 29 de febrero en un encuentro amistoso con miras a los duelos ante Argentina y Colombia por las eliminatorias de la Copa Mundial Brasil 2014. Leer más...   América de Cali ganó en su debut en Segunda División Suramerica - Colombia América de Cali, pese a jugar con inferioridad numérica durante los últimos 30 minutos, doblegó 1-0 al visitante Real Santander en su debut en la Segunda División del futbol colombiano. Leer más...   Los campeones definen su clasificación Torneos - Copa Libertadores Los campeones de Copa Libertadores de América, Once Caldas (2004) e Internacional de Brasil (2006 y 2010), definen mañana su clasificación a la fase de grupos de la edición 2012, cuando se dispute en Manizales el partido de vuelta de la primera fase del certamen continental. Leer más...   Llegó Unión Española confiado en ganar a Tigres Torneos - Copa Libertadores El equipo chileno Unión Española arribó esta mañana a la Sultana del Norte para el partido de vuelta del Repechaje frente a los Tigres y lo hizo confiado en ganar el duelo del jueves y avanzar a la fase de grupos de la Copa Libertadores. Leer más...   El Nacional sale con mínima ventaja ante Libertad Torneos - Copa Libertadores El Nacional de Ecuador tratará el martes de defender una mínima ventaja al visitar a Libertad de Paraguay en el choque de vuelta del duelo de la fase preliminar de la Copa Libertadores. Leer más...   Sport Huancayo se motiva para remontar ante Arsenal Torneos - Copa Libertadores Sport Huancayo tratará de aprovechar lo más de 3.000 metros de altura de su sede para darle la vuelta a una desventaja de tres goles ante Arsenal de Argentina y no quedar fuera de la fase de grupos de la Copa Libertadores. Leer más...   Mondragón, de 40 años, venía actuando en la MLS de Estados Unidos con el Philadelphia Union tras pas Fútbol México - Amistoso Emanuel Villa, delantero de Cruz Azul, dejó en claro que el gol anotado con la mano y que les dio el empate ante Atlante fue un acto involuntario, por lo que se declaró en desacuerdo con cualquier castigo que pudiera llegar de parte de la Comisión Disciplinaria. Leer más...   Roberto Carlos se retirará a fin de año Suramerica - Brazil Roberto Carlos planea retirarse del futbol profesional este año, aunque indicó que seguirá trabajando con el club ruso Anzhi. Leer más...   Edno no es otro Everton, asegura Juninho Fútbol México - Noticias La noticia de que Edno Roberto Cunha ha sido adquirido por Tigres provocó diferentes reacciones en las redes sociales, entre ellas destaca la duda en los aficionados de que este jugador brasileño resulte igual que la contratación realizada en el 2010 de Everton Cardoso. Leer más...   Más... Oscar Tabárez y Diego Lugano pidieron a Uruguay no relajarse Tecos sigue como último del Porcentaje en inicio del Clausura 2012 Firpo arranca como líder y el panameño Canales marca doblete << Inicio < Anterior 1 2 3 4 5 6 7 8 9 10 Siguiente > Final >> Resultados 1 - 15 de 1966 LA TRIBUNA DEPORTIVA BLACKBERRY DEVICES ANDROIDE DEVICES IPHONES/IPAD/IPODS QUICKTIME/MAC MICROSOFT SILVERLIGHT   Secciones Foros Escríbenos Boxeo www.fiestamart.com TORNEO CLAUSURA MX 2012 Fri, January 27, 2012 20:10 MOR 0 MON 0 Sat, January 28, 2012 17:00 JAG 0 PUE 1 19:00 PAC 1 Que 1 19:00 TIG 2 EST 1 20:45 SnL 1 Ame 3 20:45 ATS 1 TOL 0 21:00 ATL 2 CRU 2 Sun, January 29, 2012 12:00 PUM 0 CHI 0 14:00 TIJ 1 SAN 3 Próxima Jornada C-Mx-2012
		Formulario de acceso Formulario de acceso Usuario Clave Recordarme ¿Recuperar clave? ¿Quiere registrarse? Regístrese aquí Boletines de correo Reciba noticias en su correo electrónico Nombre E-Mail Suscribirse Desuscribirse Encuestas ¿Quién ganará la final de la concachampions? Atlante Cruz Azul
www.latribunadeportiva.net Copyright © 2010 | Todos los derechos reservados Diseño y desarrollo: Eduardo Cadena

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1337565362' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1337565362' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 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_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 21:11' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:11' )
 AND s.published = 1
 AND cc.published = 1
8
SELECT a.id, a.title, a.title_alias, 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, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 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_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 21:11' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:11' )
 AND s.published = 1
 AND cc.published = 1
 ORDER BY  f.ordering
LIMIT 15
9
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_section', 'content_blog_section' )
 AND componentid = 3
 ORDER BY type DESC, ordering
10
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 48
 ORDER BY type DESC, ordering
11
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
12
SELECT * FROM jos_comment_setting 
  WHERE  id=1 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
13
SELECT params
 FROM jos_mambots
 WHERE element LIKE 'joscomment%'
 AND folder = 'content'
 AND published = 1
14
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
15
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='3' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
16
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
17
SHOW TABLES LIKE 'jos_comprofiler';
18
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
19
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_section', 'content_blog_section' )
 AND componentid = 13
 ORDER BY type DESC, ordering
20
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 39
 ORDER BY type DESC, ordering
21
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='13' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
22
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
23
SHOW TABLES LIKE 'jos_comprofiler';
24
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
25
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_section', 'content_blog_section' )
 AND componentid = 12
 ORDER BY type DESC, ordering
26
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 20
 ORDER BY type DESC, ordering
27
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='12' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
28
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
29
SHOW TABLES LIKE 'jos_comprofiler';
30
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
31
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_section', 'content_blog_section' )
 AND componentid = 11
 ORDER BY type DESC, ordering
32
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 49
 ORDER BY type DESC, ordering
33
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='11' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
34
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
35
SHOW TABLES LIKE 'jos_comprofiler';
36
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
37
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 6
 ORDER BY type DESC, ordering
38
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='11' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
39
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
40
SHOW TABLES LIKE 'jos_comprofiler';
41
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
42
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 17
 ORDER BY type DESC, ordering
43
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='12' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
44
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
45
SHOW TABLES LIKE 'jos_comprofiler';
46
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
47
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='12' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
48
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
49
SHOW TABLES LIKE 'jos_comprofiler';
50
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
51
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='12' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
52
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
53
SHOW TABLES LIKE 'jos_comprofiler';
54
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
55
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='12' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
56
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
57
SHOW TABLES LIKE 'jos_comprofiler';
58
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
59
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='3' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
60
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
61
SHOW TABLES LIKE 'jos_comprofiler';
62
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
63
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 4
 ORDER BY type DESC, ordering
64
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='11' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
65
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
66
SHOW TABLES LIKE 'jos_comprofiler';
67
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
68
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 1
 ORDER BY type DESC, ordering
69
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='3' OR set_sectionid = '0' ) 
  ORDER BY set_component ASC,set_sectionid DESC LIMIT 1
70
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
71
SHOW TABLES LIKE 'jos_comprofiler';
72
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
73
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'
74
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 = 1 )
 ORDER BY ordering
75
SELECT m.*, count(p.parent) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1'
GROUP BY m.id ORDER BY m.parent, m.ordering
76
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
77
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
78
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
 FROM jos_content AS a
 LEFT 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
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 21:11' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:11' )
 AND ( a.sectionid=18 )
 AND f.content_id IS NULL
 ORDER BY a.created DESC
LIMIT 8
79
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 = 4334
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
80
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
81
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
82
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 = 4331
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
83
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 = 4326
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
84
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 = 4325
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
85
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 = 4322
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
86
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 = 4320
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
87
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 = 4317
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
88
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 = 4316
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
89
SELECT * FROM jos_content WHERE (state=1) AND (catid=32)  ORDER by ordering LIMIT 0,5
90
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
91
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
92
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 = 0
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
93
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'tribuna'
 AND published = 1
 ORDER BY parent, ordering
94
SELECT *
 FROM jos_joomleague
 WHERE id = '30'
95
SELECT matches.*, r.matchcode as roundcode, r.name as roundname, "dummy",  t1.name AS home_name, t1.short_name AS home_shortname,  t2.name AS away_name, t2.short_name AS away_shortname,  c1.logo_small AS home_icon,  c2.logo_small AS away_icon  FROM jos_joomleague_matches AS matches  INNER JOIN jos_joomleague_rounds AS r ON matches.round_id = r.id  INNER JOIN jos_joomleague_teams AS t1 ON matches.matchpart1 = t1.id  INNER JOIN jos_joomleague_teams AS t2 ON matches.matchpart2 = t2.id  INNER JOIN jos_joomleague_clubs AS c1 ON c1.id = t1.club_id  INNER JOIN jos_joomleague_clubs AS c2 ON c2.id = t2.club_id  WHERE  matches.project_id = 30 AND r.matchcode = 4 AND matches.published = 1 ORDER BY matches.match_date ASC, matches.match_number
96
SELECT *
 FROM jos_joomleague
 WHERE id = '30'
97
SELECT m.match_date AS datum,
                 m.matchpart1 AS home,
                 m.matchpart2 AS away,
                 m.*,
                 r.matchcode, r.name as round,
                 t1.short_name AS home_name,
                 t2.short_name AS away_name,
                 c1.logo_small AS home_logo,
                 c2.logo_small AS away_logo,
                 j.name AS project_name FROM jos_joomleague_matches AS m
            INNER JOIN jos_joomleague AS j ON m.project_id = j.id
            INNER JOIN jos_joomleague_rounds AS r ON m.round_id = r.id
            INNER JOIN jos_joomleague_teams AS t1 ON m.matchpart1 = t1.id
            INNER JOIN jos_joomleague_teams AS t2 ON m.matchpart2 = t2.id
            LEFT JOIN jos_joomleague_clubs AS c1 ON t1.club_id = c1.id
            LEFT JOIN jos_joomleague_clubs AS c2 ON t2.club_id = c2.id WHERE m.project_id IN (30)
            AND m.published
            AND DATE_ADD(m.match_date, INTERVAL '0' MINUTE) > '2012-05-20 21:11:02' ORDER by m.match_date, datum
98
SELECT *
 FROM jos_users
 WHERE id = '0'
99
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_letterman'
100
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
101
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
102
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 1
 AND text != ''
 ORDER BY id