SELECT *
FROM jos_session
WHERE session_id = '2cfed4f5d6944049444602083d29dfc0'
DELETE
FROM jos_session
WHERE ( TIME < '1329949900' )
SELECT *
FROM jos_session
WHERE session_id = '2cfed4f5d6944049444602083d29dfc0'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '2cfed4f5d6944049444602083d29dfc0','1329950800','','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 = 75)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_rokcandy
WHERE published=1
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 = 75 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT a.*, cr.rating_sum/cr.rating_count AS rating, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
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_content_rating AS cr
ON a.id = cr.content_id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-22 23:46:40' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-22 23:46:40' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=40)
AND (s.id=8)
AND s.published = 1
AND cc.published = 1
ORDER BY a.id DESC
LIMIT 0, 3
SELECT COUNT(a.id)
FROM jos_content AS a
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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-22 23:46:41' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-22 23:46:41' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (cc.id=40)
AND (s.id=8)
AND s.published = 1
AND cc.published = 1
Guantes de neopreno GRATIS!!!_Invierno sin frío con Alder Para que no te aprete el neopreno este invierno, ni te aprete el frío, con la compra de un traje de surf Alder llévate unos guantes de neopreno de 3mm mod. EDGE. [Promoción válida...Lee más...
LONGSKATES En nuestro local te ofrecemos el mejor surtido de las mejores marcas del mundo del Longskate. Tablas completas o por piezas, recambios de lija, bushings, ruedas... guantes, protecciones... Información...Lee más...