DELETE
FROM jos_session
WHERE ( time < '1283987323' )
SELECT *
FROM jos_session
WHERE session_id = '56bd6df0b63537cb89e1d17e582fe11b'
UPDATE `jos_session`
SET `time`='1283988223',`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 = 141)
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 = 8305
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:23:43' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 23:23:43' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='8305'
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:23:43' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-08 18:23:43' )
AND catid = 63
AND a.id < 8305
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 = 141 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 = 8305
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:23:43' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-08 23:23:43' )
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
Camerele video existente în holul DSP Suceava vor fi îndreptate înspre locul special de fumat, deoarece conducerea instituţiei vrea să vadă dacă fumătorii, pe care îi ştie drept „înrăiţi”, fumează acolo sau…
