SELECT *
FROM jos151_session
WHERE session_id = '8ntsbfr3trifqognn1m9klak10'
DELETE
FROM jos151_session
WHERE ( time < '1246730412' )
SELECT *
FROM jos151_session
WHERE session_id = '8ntsbfr3trifqognn1m9klak10'
INSERT INTO jos151_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '8ntsbfr3trifqognn1m9klak10','1246739412','','0','1','0' )
SELECT *
FROM jos151_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos151_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos151_menu AS m
LEFT JOIN jos151_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos151_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, 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.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos151_content AS a
INNER JOIN jos151_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos151_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos151_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos151_users AS u
ON u.id = a.created_by
LEFT JOIN jos151_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 20:30:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 20:30:13' )
ORDER BY f.ordering
LIMIT 0, 9
SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, 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.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos151_content AS a
INNER JOIN jos151_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos151_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos151_sections AS s
ON s.id = a.sectionid
LEFT JOIN jos151_users AS u
ON u.id = a.created_by
LEFT JOIN jos151_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 20:30:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 20:30:13' )
ORDER BY f.ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos151_modules AS m
LEFT JOIN jos151_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 = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos151_polls
WHERE id = 14
AND published = 1
SELECT guest, usertype, client_id
FROM jos151_session
WHERE client_id = 0
SELECT *
FROM jos151_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 14
ORDER BY sticky DESC, ordering
LIMIT 0, 4
UPDATE jos151_banner
SET impmade = impmade + 1
WHERE bid = 3
UPDATE jos151_banner
SET impmade = impmade + 1
WHERE bid = 4
UPDATE jos151_banner
SET impmade = impmade + 1
WHERE bid = 5
UPDATE jos151_banner
SET impmade = impmade + 1
WHERE bid = 6
SELECT *, RAND() AS ordering
FROM jos151_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos151_banner
SET impmade = impmade + 1
WHERE bid = 8
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 jos151_content AS a
LEFT JOIN jos151_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN jos151_categories AS cc
ON cc.id = a.catid
INNER JOIN jos151_sections AS s
ON s.id = a.sectionid
WHERE ( a.state = 1
AND s.id > 0 )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 20:30:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 20:30:13' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.hits DESC
LIMIT 0, 5
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 jos151_content AS a
INNER JOIN jos151_categories AS cc
ON cc.id = a.catid
INNER JOIN jos151_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 <= '2009-07-04 20:30:13' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 20:30:13' )
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
SELECT COUNT( id ) AS count_users
FROM jos151_users
SELECT COUNT( id ) AS count_items
FROM jos151_content
WHERE state = "1"
SELECT COUNT( id ) AS count_links
FROM jos151_weblinks
WHERE published = "1"
SELECT SUM( hits ) AS count_hits
FROM jos151_content
WHERE state = "1"
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 jos151_content AS a
INNER JOIN jos151_categories AS cc
ON cc.id = a.catid
INNER JOIN jos151_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-04 20:30:13' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-04 20:30:13' )
AND cc.id = 3
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
Joomla! provides an easy-to-use graphical user interface that simplifies the management and publishing of large volumes of content including HTML, documents, and rich media. Joomla! is used by organisations of all sizes for Public Web sites, Intranets, and Extranets and is supported by a community of thousands of users. 