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 *
FROM jos_jcomments_settings
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 27)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_sections
WHERE id = 5
LIMIT 0, 1
SELECT 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, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER 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 a.access <= 0
AND s.id = 5
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 00:45:15' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 00:45:15' )
ORDER BY a.created DESC
LIMIT 0, 9
SELECT 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, cc.title AS category, g.name AS groups, u.email AS author_email
FROM jos_content AS a
INNER 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 a.access <= 0
AND s.id = 5
AND s.access <= 0
AND cc.access <= 0
AND s.published = 1
AND cc.published = 1
AND a.state = 1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2012-02-23 00:45:15' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2012-02-23 00:45:15' )
ORDER BY a.created DESC
SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug
FROM jos_categories AS a
LEFT JOIN jos_content AS b
ON b.catid = a.id
AND b.state = 1
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2012-02-23 00:45' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2012-02-23 00:45' )
AND b.access <= 0
WHERE a.section = 5
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING numitems > 0
ORDER BY a.ordering
SELECT count(*)
FROM jos_jcomments
WHERE object_id = 51
AND object_group = 'com_content'
AND published = 1
SELECT count(*)
FROM jos_jcomments
WHERE object_id = 50
AND object_group = 'com_content'
AND published = 1
SELECT count(*)
FROM jos_jcomments
WHERE object_id = 47
AND object_group = 'com_content'
AND published = 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 = 27 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.content AS content,
tabs.id AS TID,
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_gk3_tabs_manager_tabs AS `tabs`
LEFT JOIN
jos_content AS `content`
ON `tabs`.`content` = `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` = 1
AND
`tabs`.`published` = 1
AND
`tabs`.`access` <= 0
ORDER BY
`tabs`.`order` ASC
;
SELECT
*
FROM
jos_gk3_photoslide_groups
WHERE
`id` = 1
LIMIT 1;
SELECT
`c`.`sectionid` AS `sid`,
`c`.`catid` AS `cid`,
`c`.`title` AS `ctitle`,
`c`.`introtext` AS `introtext`,
`i`.`name` AS `name`,
`i`.`filename` AS `filename`,
`i`.`article` AS `article`,
`i`.`title` AS `title`,
`i`.`link_type` AS `link_type`,
`i`.`link` AS `link`,
`i`.`content` AS `content`
FROM
jos_gk3_photoslide_slides AS `i`
LEFT JOIN
jos_content AS `c`
ON
`i`.`article` = `c`.`id`
WHERE
`i`.`group_id` = 1
AND
`i`.`published` = 1
AND
`i`.`access` <= 0
ORDER BY
`i`.`order`,
`i`.`access` ASC;
