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 Jackson Martínez en la mira del Liverpool inglés Jonathan dos Santos confía en que el 2012 sea su gran momento con el Barça Por cuarta vez Iker Casillas el mejor portero del mundo Mourinho no quiere refuerzos La Copa del Rey abre el año nuevo en España Bielsa podria reemplazar a guardiola en barcelona en 2013 Saviola renovó con el Benfica hasta el 2013 El portero José Manuel Pinto renovó con el Barcelona una Temporada más leer más... Cruz Azul anuncia acuerdo verbal con el brasileño 'Maranhao' El Cruz Azul mexicano anunció hoy un acuerdo verbal con el volante brasileño Fracinilson Santos Meirelles 'Maranhao' para firmar por tre... leer más... Concacaf tiene nuevo secretario Luego de la renuncia que hace algunos meses presentó Chuck Blazer como Secretario General de la CONCACAF, este sábado, al culminar el 20... leer más... Chivas comienza el año con nuevos bríos El Club Deportivo Guadalajara comenzó el año 2012 con nuevos bríos y rutina distinta en el Club Deportivo de la Primavera, donde ... leer más... 'Chepo' de la Torre, undécimo mejor seleccionador del 2011 Óscar Washington Tabárez, técnico de Uruguay, fue elegido como el mejor seleccionador de 2011 por delante del español Vice... leer más... Arranca el Clausura 2012 Terminaron las fiestas decembrinas y la resaca se debe sacudir pronto. El futbol está a la vuelta de la esquina y todo está listo para q... 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...   Toluca debuta con victoria con doblete de Alonso Fútbol México - Noticias El uruguayo Iván Alonso marcó dos goles y el Toluca arrancó con el pie derecho el torneo torneo Clausura 2012 del fútbol mexicano al superar el domingo 3-1 a los Estudiantes de Guadalajara. Leer más...   Los equipos Mexicanos se arman para buscar el titulo Fútbol México - Noticias Otra cosa que no sea estar en la Final por el título, no sirve. Son equipos confeccionados para ganar y que tienen la mente puesta en el campeonato para corresponder a la historia, a la afición y sobre todo al plantel que diseñan para cada Torneo. Leer más...   Atlante buscará sacarse la espina con Chivas Fútbol México - Noticias Los Potros de Hierro del Atlante ya se preparan para hacer su debut en el torneo Clausura 2012 cuando visiten en el estadio Omnilife a las Chivas del Guadalajara, quienes en la apertura del torneo pasado los derrotaron por 2-0. Leer más...   Guille Franco, cerca de Pachuca Fútbol México - Noticias Guillermo Franco está cerca de volver al futbol mexicano. El delantero de Vélez Sarsfield de Argentina interesa a los Tuzos del Pachuca, equipo al que podría reforzar en el Clausura 2012. Leer más...   Galindo buscara que Santos sea protagonista Fútbol México - Noticias El director técnico de Santos Laguna, Benajmín Galindo, declaró hoy que la meta principal de su equipo para el Torneo Clausura 2012 es comenzar con triunfos y conforme avancen las fechas, ser uno de los protagonistas de la competición que inicia el próximo viernes. Leer más...   Waldo Ponce estará ausente en la Jornada 1 Fútbol México - Noticias Daniel Ipata, Preparador Físico de Cruz Azul, informó que Waldo Ponce no estaría listo para la Jornada 1 del Clausura 2012 porque todavía no trabaja al ritmo de sus compañeros. Leer más...   Suazo sigue sin reportarse con el Monterrey Fútbol México - Noticias Este lunes arranco la segunda semana de trabajo para el Monterrey con miras al torneo Clausura 2012 este próximo sábado donde debutará frente a los Jaguares de Chiapas en la cancha del estadio Tecnológico y el gran ausente fue su delantero estrella Humberto Suazo. Leer más...   Eddie Johnson no jugará con el Puebla Fútbol México - Noticias Eddie Johnson está fuera del Puebla. El delantero estadounidense que hace unos días fue anunciado como refuerzo de La Franja, finalmente no cumplió con las expectativas físicas del equipo y no formará parte de la plantilla de cara al Clausura 2012. Leer más...   Corinthians, cerca de contratar a chino Chen Zizhao Suramerica - Brazil Corinthians, campeón del futbol brasileño, está cerca de contratar al atacante chino Chen Zizhao, en lo que sería la primera vez que un jugador del país asiático juega en el torneo local. Leer más...   Santos llega a tomar ventaja Fútbol México - Noticias Santos se declara listo para abrir el fuego ante Monarcas este miércoles a las 20:30 horas en el estadio Morelos, con la firme intención de no dejar que su rival se sublime como lo hizo ante Cruz Azul en el partido de ida cuando prácticamente decidió la serie al sacar ventaja. Leer más...   Más... Bravo no jugará en México en receso Consideran en Diablos Rojos un exito temporada 2011 Tigres trabaja por dejar atrás 29 años sin título << Inicio < Anterior 1 2 3 4 5 6 7 8 9 10 Siguiente > Final >> Resultados 1 - 15 de 1953 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 06, 2012 20:10 MOR 1 TIJ 1 Sat, January 07, 2012 17:00 Que 0 Ame 2 17:00 CRU 1 TIG 1 17:00 MON 2 JAG 1 19:00 CHI 0 ATL 1 19:00 SAN 0 PAC 0 20:45 SnL 1 PUM 0 Sun, January 08, 2012 12:00 PUE 0 ATS 0 12:00 TOL 3 EST 1 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 < '1327718787' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1327718787' )
 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-01-27 21:01' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 21:01' )
 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-01-27 21:01' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 21:01' )
 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 = 1
 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 = 10
 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 = 13
 ORDER BY type DESC, ordering
21
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
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 * 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
26
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
27
SHOW TABLES LIKE 'jos_comprofiler';
28
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
29
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
30
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
31
SHOW TABLES LIKE 'jos_comprofiler';
32
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
33
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
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 * 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
38
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
39
SHOW TABLES LIKE 'jos_comprofiler';
40
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
41
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
42
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
43
SHOW TABLES LIKE 'jos_comprofiler';
44
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
45
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
46
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
47
SHOW TABLES LIKE 'jos_comprofiler';
48
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
49
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
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 * 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
54
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
55
SHOW TABLES LIKE 'jos_comprofiler';
56
SELECT * FROM jos_comment WHERE id='0' LIMIT 1
57
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
58
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
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 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'
68
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
69
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
70
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
71
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
72
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-01-27 21:01' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-27 21:01' )
 AND ( a.sectionid=18 )
 AND f.content_id IS NULL
 ORDER BY a.created DESC
LIMIT 8
73
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
74
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
75
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
76
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 = 4302
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
77
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 = 4301
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
78
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 = 4297
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
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 = 4296
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
80
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 = 4295
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
81
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 = 4290
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
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 = 4285
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
83
SELECT * FROM jos_content WHERE (state=1) AND (catid=32)  ORDER by ordering LIMIT 0,5
84
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
85
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
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 = 0
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
87
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'tribuna'
 AND published = 1
 ORDER BY parent, ordering
88
SELECT *
 FROM jos_joomleague
 WHERE id = '30'
89
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 = 1 AND matches.published = 1 ORDER BY matches.match_date ASC, matches.match_number
90
SELECT *
 FROM jos_joomleague
 WHERE id = '30'
91
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-01-27 21:01:27' ORDER by m.match_date, datum
92
SELECT *
 FROM jos_users
 WHERE id = '0'
93
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_letterman'
94
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
95
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
96
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 1
 AND text != ''
 ORDER BY id