SELECT *
FROM jos_session
WHERE session_id = 'npttdk5e9n5toebhiiob65ofj5'
DELETE
FROM jos_session
WHERE ( TIME < '1780851559' )
SELECT *
FROM jos_session
WHERE session_id = 'npttdk5e9n5toebhiiob65ofj5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'npttdk5e9n5toebhiiob65ofj5','1780852459','','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 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
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( content.id = 52 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 11:14:19' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 11:14:19' )
AND ( content.id = 52 )
ORDER BY
content.created DESC
LIMIT
0,4;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( content.id = 53 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 11:14:19' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 11:14:19' )
AND ( content.id = 53 )
ORDER BY
content.created DESC
LIMIT
0,4;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( content.id = 51 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 11:14:19' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 11:14:19' )
AND ( content.id = 51 )
ORDER BY
content.created DESC
LIMIT
0,4;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( content.id = 50 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 16:14:19' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 16:14:19' )
AND ( content.id = 50 )
ORDER BY
content.created DESC
LIMIT
0,4;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.SECTION = 19 )
AND
c.published = 1
AND
c.access <= 0;
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
users.email AS author_email,
cats.SECTION AS SID,
content.title AS title,
content.introtext AS text,
content.created AS DATE,
content.publish_up AS date_publish,
content.images AS images,
content.id AS IID,
content.hits AS hits,
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_content AS content
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_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jos_categories AS cats
ON content.catid = cats.id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2026-06-07 17:14:20' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2026-06-07 17:14:20' )
AND ( content.catid = 51 )
ORDER BY
content.created DESC
LIMIT
0,3;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.id = 34 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 11:14:20' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 11:14:20' )
AND ( content.catid = 34 )
ORDER BY
RAND()
LIMIT
0,4;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.SECTION = 16 )
AND
c.published = 1
AND
c.access <= 0;
SELECT DISTINCT
cats.title AS cat,
users.name AS author,
users.email AS author_email,
cats.SECTION AS SID,
content.title AS title,
content.introtext AS text,
content.created AS DATE,
content.publish_up AS date_publish,
content.images AS images,
content.id AS IID,
content.hits AS hits,
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_content AS content
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_content_frontpage AS frontpage
ON content.id = frontpage.content_id
LEFT JOIN
jos_categories AS cats
ON content.catid = cats.id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2026-06-07 17:14:20' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2026-06-07 17:14:20' )
AND ( content.catid = 48 )
ORDER BY
content.created DESC
LIMIT
0,18;
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` = 1
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
`c`.`sectionid` AS `sid`,
`i`.`file` AS `file`,
`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`
FROM
jos_gk2_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;
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.id = 34 )
AND
c.published = 1
AND
c.access <= 0;
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,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 16:14:20' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 16:14:20' )
AND ( content.catid = 34 )
ORDER BY
content.created ASC
LIMIT
0,4;
SELECT
s.`file` AS filename,
s.`article` AS artID
FROM
jos_gk2_photoslide_slides AS s
LEFT JOIN
jos_gk2_photoslide_groups AS g
ON
s.group_id = g.id
WHERE
s.access <= 0
AND
s.published = 1
AND
g.plugin = "News Show GK3"
AND
( s.article = 46 OR s.article = 47 OR s.article = 48 OR s.article = 49 )
;
SELECT *, RAND() AS ordering
FROM jos_banner
WHERE showBanner = 1
AND (imptotal = 0 OR impmade < imptotal)
AND cid = 1
AND catid = 33
ORDER BY sticky DESC, ordering
LIMIT 0, 9
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 9
SELECT DISTINCT
c.id AS ID,
c.SECTION AS SID,
c.title AS name,
m.id AS MID
FROM
jos_categories AS c
LEFT JOIN
jos_menu AS m
ON
c.id = m.componentid
LEFT JOIN
jos_content AS content
ON
c.id = content.catid
WHERE
( c.id = 34 )
AND
c.published = 1
AND
c.access <= 0;
SELECT DISTINCT
cats.SECTION AS SID,
content.title AS title,
content.introtext AS text,
content.id AS IID,
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_content AS content
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
LEFT JOIN
jos_content_frontpage AS frontpage
ON content.id = frontpage.content_id
WHERE
content.state = 1
AND categories.access <= 0
AND content.access <= 0
AND categories.published = 1
AND ( content.publish_up = '0000-00-00 00:00:00'
OR content.publish_up <= '2026-06-07 11:14:20' )
AND ( content.publish_down = '0000-00-00 00:00:00'
OR content.publish_down >= '2026-06-07 11:14:20' )
AND ( content.catid = 34 )
ORDER BY
content.created DESC
LIMIT
0,10;
