SELECT *
FROM jos_session
WHERE session_id = '142bdff66102b09b3c66635d2d045da9'
DELETE
FROM jos_session
WHERE ( time < '1280406682' )
SELECT *
FROM jos_session
WHERE session_id = '142bdff66102b09b3c66635d2d045da9'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '142bdff66102b09b3c66635d2d045da9','1280410282','','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 name,player_id,ripper_id,postreplace
FROM jos_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
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 DISTINCT
cats.title AS cat,
users.name AS author,
cats.section AS SID,
content.title AS title,
content.introtext AS text,
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` = 2
AND
`tabs`.`published` = 1
AND
`tabs`.`access` <= 0
ORDER BY
`tabs`.`order` ASC
;
SELECT *
FROM jos_gk2_photoslide_groups
WHERE id = 1
LIMIT 1;
SELECT
i.file AS name,
i.title AS title,
i.text AS text,
i.linktype AS linktype,
i.linkvalue AS linkvalue,
i.article AS article,
i.wordcount AS wordcount,
c.title AS ctitle,
c.introtext AS introtext,
c.id AS cid,
c.sectionid AS sid
FROM
jos_gk2_photoslide_slides AS i
LEFT JOIN
jos_content AS c
ON
i.article = c.id
WHERE
group_id = 1
AND
`i`.`published` = 1
AND
`i`.`access` <= 0
ORDER BY
i.
ORDER ASC
LIMIT
6;
SELECT code,minw,minh
FROM jos_avr_player
WHERE id = 1
SELECT code,minw,minh
FROM jos_avr_player
WHERE id = 1
