DELETE
FROM jos_session
WHERE ( time < '1337548625' )
SELECT *
FROM jos_session
WHERE session_id = 'odjjr3ad8mm7v758q6t90nvk86'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'odjjr3ad8mm7v758q6t90nvk86','1337549525','','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 = 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 jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.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 <= '2012-05-20 21:32:05' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:32:05' )
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 jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = a.sectionid
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.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 <= '2012-05-20 21:32:05' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:32:05' )
ORDER BY f.ordering
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 = 1 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_content
WHERE title = 'Impressum' OR alias = 'impressum'
SELECT *
FROM jos_content
WHERE title = 'Impressum' OR alias = 'impressum'
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.fulltext AS ftext,
content.created AS date,
content.images AS images,
content.id AS IID,
tabs.name AS TNAME,
tabs.type AS type,
tabs.position AS position,
tabs.content AS content,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", `content`.`id`, `content`.`alias`)
ELSE `content`.`id` END AS ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", `cats`.`id`, `cats`.`alias`)
ELSE `cats`.`id` END AS CID
FROM
jos_gk2_tabs_manager_tabs AS `tabs`
LEFT JOIN
jos_content AS `content`
ON `tabs`.`art` = `content`.`id`
LEFT JOIN
jos_categories AS `categories`
ON `categories`.`id` = `content`.`catid`
LEFT JOIN
jos_sections AS `sections`
ON `sections`.`id` = `content`.`sectionid`
LEFT JOIN
jos_menu AS `menu`
ON `menu`.`componentid` = `content`.`id`
LEFT JOIN
jos_users AS `users`
ON `users`.`id` = `content`.`created_by`
LEFT JOIN
jos_categories AS `cats`
ON `content`.`catid` = `cats`.`id`
WHERE
`tabs`.`group_id` = 4
AND
`tabs`.`published` = 1
AND
`tabs`.`access` <= 0
ORDER BY
`tabs`.`order` ASC
;
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
content.fulltext AS ftext,
content.created AS date,
content.images AS images,
content.id AS IID,
tabs.name AS TNAME,
tabs.type AS type,
tabs.position AS position,
tabs.content AS content,
CASE WHEN CHAR_LENGTH(content.alias)
THEN CONCAT_WS(":", `content`.`id`, `content`.`alias`)
ELSE `content`.`id` END AS ID,
CASE WHEN CHAR_LENGTH(cats.alias)
THEN CONCAT_WS(":", `cats`.`id`, `cats`.`alias`)
ELSE `cats`.`id` END AS CID
FROM
jos_gk2_tabs_manager_tabs AS `tabs`
LEFT JOIN
jos_content AS `content`
ON `tabs`.`art` = `content`.`id`
LEFT JOIN
jos_categories AS `categories`
ON `categories`.`id` = `content`.`catid`
LEFT JOIN
jos_sections AS `sections`
ON `sections`.`id` = `content`.`sectionid`
LEFT JOIN
jos_menu AS `menu`
ON `menu`.`componentid` = `content`.`id`
LEFT JOIN
jos_users AS `users`
ON `users`.`id` = `content`.`created_by`
LEFT JOIN
jos_categories AS `cats`
ON `content`.`catid` = `cats`.`id`
WHERE
`tabs`.`group_id` = 4
AND
`tabs`.`published` = 1
AND
`tabs`.`access` <= 0
ORDER BY
`tabs`.`order` ASC
;
SELECT *
FROM jos_BcaRssSyndicator_feeds
WHERE published = 1
ORDER BY feed_name
Herzlich willkommen auf der Homepage der Jusos im Rems-Murr-Kreis. Wir Jusos sind die politische Jugendorganisation der SPD. Jusos steht für JungsozialistInnen. Wir verstehen uns als politische Jugendorganisation, die sich aktiv für die Interessen junger Menschen einsetzt. Jeder kann etwas dazu beitragen. Deswegen laden wir Dich herzlich dazu ein, bei uns mitzumachen oder einfach mal vorbei zu schauen. Wir beschäftigen uns mit politischen Inhalten und Aktionen, aber natürlich kommt auch der Spaß nicht zu kurz. Wir sind ein offener Verband, der auch für die kurzfristige Mitarbeit offen steht. Wer sich bei den Jusos engagiert, muss nicht gleich ein Parteibuch beantragen. Die Juso-Mitgliedschaft macht es möglich: Kostenfrei und ohne Bindungen. Denn bei uns steht die Politik im Vordergrund! - also melde Dich. 
