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 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 Giovani dos Santos se quedaría en el Tottenham Jackson Martínez en la mira del Liverpool inglés 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... Problema de arbitraje es mundial, no de México: Padilla Para Aarón Padilla, Presidente de la Comisión de Árbitros de la FMF, los errores de los colegiados son a nivel mundial y no s&oac... leer más... El lateral izquierdo de 38 años, Campeón Mundial con Brasil en 2002, tiene un contrato con el Anzhi Los Pumas de la UNAM infringieron el reglamento de la FIFA al pintar la letra U en el Estadio Olímpico Universitario durante el juego entre los... 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...   Oscar Tabárez y Diego Lugano pidieron a Uruguay no relajarse Suramerica - Uruguay El seleccionador uruguayo, Oscar Washington Tabárez, y el Capitán del equipo, Diego Lugano, coincidieron hoy en pedir a su formación que no se relaje pese a los buenos resultados cosechados en los tres primeros encuentros de las Eliminatorias Sudamericanas para el Mundial de Brasil 2014. Leer más...   Tecos sigue como último del Porcentaje en inicio del Clausura 2012 Fútbol México - Noticias Inició la carrera por el no descenso y Estudiantes Tecos, se confirmó como el equipo señalado a perder la categoría al mantenerse en el sótano de la Tabla de Porcentajes, luego de disputarse la fecha 1 del Torneo Clausura 2012 del futbol mexicano. Leer más...   Firpo arranca como líder y el panameño Canales marca doblete Centro America - El Salvador El Luis Ángel Firpo goleó hoy por 0-4 al Atlético Marte, con doblete incluido del panameño Anel Canales, y asumió el liderato del nuevo Torneo de Clausura salvadoreño. Leer más...   Más... Toluca debuta con victoria con doblete de Alonso Los equipos Mexicanos se arman para buscar el titulo Atlante buscará sacarse la espina con Chivas << Inicio < Anterior 1 2 3 4 5 6 7 8 9 10 Siguiente > Final >> Resultados 1 - 15 de 1963 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 Saturday, 04 February 2012 17:00 MON - SnL 17:00 Que - ATL 17:00 CRU - JAG 19:00 SAN - PUM 19:00 CHI - MOR Sunday, 05 February 2012 12:00 PUE - TIJ 12:00 TOL - PAC 16:00 Ame - TIG
		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 < '1328335642' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328335642' )
 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-02-04 00:22' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-04 00:22' )
 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-02-04 00:22' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-04 00:22' )
 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 = 11
 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 = 49
 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='11' 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_category', 'content_blog_category' )
 AND componentid = 6
 ORDER BY type DESC, ordering
20
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
21
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
22
SHOW TABLES LIKE 'jos_comprofiler';
23
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
24
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
25
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
26
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
27
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
28
SHOW TABLES LIKE 'jos_comprofiler';
29
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
30
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
31
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
32
SHOW TABLES LIKE 'jos_comprofiler';
33
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
34
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
35
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
36
SHOW TABLES LIKE 'jos_comprofiler';
37
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
38
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
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_section', 'content_blog_section' )
 AND componentid = 3
 ORDER BY type DESC, ordering
43
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
44
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
45
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
46
SHOW TABLES LIKE 'jos_comprofiler';
47
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
48
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
49
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
50
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
51
SHOW TABLES LIKE 'jos_comprofiler';
52
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
53
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
54
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
55
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
56
SHOW TABLES LIKE 'jos_comprofiler';
57
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
58
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 10
 ORDER BY type DESC, ordering
59
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
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 * 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
64
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
65
SHOW TABLES LIKE 'jos_comprofiler';
66
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
67
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_section', 'content_blog_section' )
 AND componentid = 10
 ORDER BY type DESC, ordering
68
SELECT id, link
 FROM jos_menu
 WHERE published = 1
 AND type IN ( 'content_category', 'content_blog_category' )
 AND componentid = 13
 ORDER BY type DESC, ordering
69
SELECT * FROM jos_comment_setting 
  WHERE set_component='' AND ( set_sectionid='10' 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-02-04 00:22' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-04 00:22' )
 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 = 4326
 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 = 4325
 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 = 4322
 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 = 4320
 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 = 4317
 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 = 4316
 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 = 4315
 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 = 4305
 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-02-04 00:22:22' 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