SELECT *
FROM jos_session
WHERE session_id = '2l36at0kdcakd2sva4v5tobgc4'
DELETE
FROM jos_session
WHERE ( TIME < '1368994438' )
SELECT *
FROM jos_session
WHERE session_id = '2l36at0kdcakd2sva4v5tobgc4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '2l36at0kdcakd2sva4v5tobgc4','1368996238','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 5)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.event_id, a.chipNumber, a.distance_id, b.distance_desc, b.routename, a.chipTime, a.phase, a.phasename, a.sequenceid, a.phaseTime, a.phaseTimeMillis, a.phaseSpeed, a.timeMillis, b.gender, b.names, b.city, b.category_id, b.category_desc, b.equipoName, b.resultado, b.posicionChip, b.ramaChip, b.generalChip, b.oficial, b.posicionOficial, b.ramaOficial, b.generalOficial, c.image, c.title ,c.tiempoChip ,b.resultadoMillis, b.oficialMillis ,patrocinadores
FROM jos_events_results_details AS a
LEFT
OUTER JOIN jos_events_results AS b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
LEFT
OUTER JOIN jos_events AS c
ON (a.event_id = c.id)
WHERE a.event_id = 231
AND a.chipNumber = 2011
ORDER BY a.sequenceid
LIMIT 0, 50
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND b.phase = "F50"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.category_id = "VV"
AND b.phase = "F50"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.gender = "M"
AND b.phase = "F50"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND b.phase = "F1"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.category_id = "VV"
AND b.phase = "F1"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.gender = "M"
AND b.phase = "F1"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND b.phase = "F7"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.category_id = "VV"
AND b.phase = "F7"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT b.phaseTimeMillis
FROM jos_events_results a
LEFT
OUTER JOIN jos_events_results_details b
ON (a.event_id = b.event_id
AND a.chipNumber = b.chipNumber)
WHERE a.generalOficial <> 0
AND b.phaseTimeMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.gender = "M"
AND b.phase = "F7"
ORDER BY b.phaseTimeMillis ASC
LIMIT 1
SELECT a.oficialMillis
FROM jos_events_results a
WHERE a.generalOficial <> 0
AND a.oficialMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
ORDER BY a.oficialMillis ASC
LIMIT 1
SELECT a.oficialMillis
FROM jos_events_results a
WHERE a.generalOficial <> 0
AND a.oficialMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.category_id = "VV"
ORDER BY a.oficialMillis ASC
LIMIT 1
SELECT a.oficialMillis
FROM jos_events_results a
WHERE a.generalOficial <> 0
AND a.oficialMillis <> 0
AND a.event_id = 231
AND a.distance_id = 1
AND a.gender = "M"
ORDER BY a.oficialMillis ASC
LIMIT 1
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 5 OR mm.menuid = 0 )
ORDER BY POSITION, ordering