DELETE
FROM jos_session
WHERE ( TIME < '1369049821' )
SELECT *
FROM jos_session
WHERE session_id = 'otgahnucun3otdr94v63qc0if4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'otgahnucun3otdr94v63qc0if4','1369057021','','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 = 6)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT c.*, s.id AS sectionid, s.title AS sectiontitle, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
FROM jos_categories AS c
INNER JOIN jos_sections AS s
ON s.id = c.SECTION
WHERE c.id = 4
LIMIT 0, 1
SELECT cc.title AS category, a.id, a.title, a.alias, 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.attribs, a.hits, a.images, a.urls, a.ordering, 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, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 4
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-20 13:37:01' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-20 13:37:01' )
ORDER BY a.created DESC, a.created DESC
LIMIT 0, 17
SELECT cc.title AS category, a.id, a.title, a.alias, 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.attribs, a.hits, a.images, a.urls, a.ordering, 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, u.email AS author_email
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON a.catid = cc.id
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE 1
AND a.access <= 0
AND a.catid = 4
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2013-05-20 13:37:01' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2013-05-20 13:37:01' )
ORDER BY a.created DESC, a.created DESC
SELECT *
FROM `jos_rsform_config`
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 = 6 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT M.*
FROM jos_menu AS M
WHERE menutype = 'sidemenu'
AND published = 1
AND access < 1
ORDER BY parent, ordering
SELECT *
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND catid = 911
ORDER BY sticky DESC, ordering
LIMIT 0, 1
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 1
INSERT INTO jos_bannertrack ( track_type, banner_id, track_date )
VALUES ( 1, 1, '2013-05-20' )
Father Jim
The St. Rose Children's Choir will be singing at the 6:00 p.m. Christmas Eve Mass. Thanks to our teachers and parents who will be leading them as I, Fr. Jim, have another job to do at that Mass. Any past and present Children's Choir members are invited and encouraged to sing at this Mass. We will welcome back any veterans who are willing and able, as long as they will show up at the 2 practices. We are even willing to open the doors who have not joined, but would like to at this time. If that is the case, please come to our next two practices.