DELETE
FROM jos_session
WHERE ( time < '1283988795' )
SELECT *
FROM jos_session
WHERE session_id = '56bd6df0b63537cb89e1d17e582fe11b'
UPDATE `jos_session`
SET `time`='1283989696',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0'
WHERE session_id='56bd6df0b63537cb89e1d17e582fe11b'
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 = 113)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
LEFT JOIN jos_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 26313
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-08 23:48:17' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 23:48:17' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='26313'
SELECT a.id, a.title, a.created, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid
FROM jos_content AS a
INNER JOIN jos_categories AS b
ON b.id=a.catid
INNER JOIN jos_sections AS u
ON u.id = a.sectionid
WHERE ( state = '1'
AND a.checked_out = 0 )
AND a.state = 1
AND u.published = 1
AND b.published = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-08 18:48:17' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-08 18:48:17' )
AND catid = 64
AND a.id < 26313
ORDER BY title DESC
LIMIT 10
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 = 113 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup, name
FROM jos_comprofiler_plugin
WHERE published = 1
AND access <= 0
AND type = 'user'
ORDER BY ordering
SELECT metakey
FROM jos_content
WHERE id = 26313
SELECT a.*, 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
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-08 23:48:17' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 23:48:17' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
+x(80))
Datoriile catre stat ale societatii de termoficare din Botosani ar putea fi sterse. Potrivit mediafax.ro, care il citeaza pe ministrul Administraţiei şi Internelor, Dan Nica, Guvernul va şterge datorii de 1,1 miliarde de lei ale unui număr de 35 de centrale electrotermice aflate în subordinea primăriilor, operaţiunea urmând să se încheie în cel mult trei luni.[...](2/7/2009.)
