SELECT *
FROM jos_session
WHERE session_id = '0b5rqj28ri8rbq9olqfbbq6ev7'
DELETE
FROM jos_session
WHERE ( TIME < '1778734701' )
SELECT *
FROM jos_session
WHERE session_id = '0b5rqj28ri8rbq9olqfbbq6ev7'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0b5rqj28ri8rbq9olqfbbq6ev7','1778735601','','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 *
FROM jos_migration_backlinks
WHERE url LIKE 'searchphrase=exact&searchword=Trials+of+Passion+II%' OR sefurl LIKE 'searchphrase=exact&searchword=Trials+of+Passion+II%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'component/search/?searchphrase=exact&searchword=Trials+of+Passion+II%' OR sefurl LIKE 'component/search/?searchphrase=exact&searchword=Trials+of+Passion+II%'
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 = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) AS text, CONCAT_WS( "/", u.title, b.title ) AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, "2" AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b
ON b.id=a.catid
INNER JOIN jos_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%Trials of Passion II%') OR (a.introtext LIKE '%Trials of Passion II%') OR (a.fulltext LIKE '%Trials of Passion II%') OR (a.metakey LIKE '%Trials of Passion II%') OR (a.metadesc LIKE '%Trials of Passion II%') )
AND a.state = 1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-14 05:13:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-14 05:13:21' )
GROUP BY a.id
ORDER BY a.created DESC
LIMIT 0, 50
SELECT id, a.title AS title, a.created AS created, a.metadesc, a.metakey, CONCAT(a.introtext, a.fulltext) AS text, "2" AS browsernav, "•Uncategorised Content•" AS SECTION
FROM jos_content AS a
WHERE ((a.title LIKE '%Trials of Passion II%') OR (a.introtext LIKE '%Trials of Passion II%') OR (a.fulltext LIKE '%Trials of Passion II%') OR (a.metakey LIKE '%Trials of Passion II%') OR (a.metadesc LIKE '%Trials of Passion II%'))
AND a.state = 1
AND a.access <= 0
AND a.sectionid = 0
AND a.catid = 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-14 05:13:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-14 05:13:21' )
ORDER BY a.created DESC
LIMIT 0, 44
SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext, a.fulltext) AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(":", b.id, b.alias) ELSE b.id END AS catslug, u.id AS sectionid, CONCAT_WS( "/", u.title, b.title ) AS SECTION, "2" AS browsernav
FROM jos_content AS a
INNER JOIN jos_categories AS b
ON b.id=a.catid
AND b.access <= 0
INNER JOIN jos_sections AS u
ON u.id = a.sectionid
WHERE ( (a.title LIKE '%Trials of Passion II%') OR (a.introtext LIKE '%Trials of Passion II%') OR (a.fulltext LIKE '%Trials of Passion II%') OR (a.metakey LIKE '%Trials of Passion II%') OR (a.metadesc LIKE '%Trials of Passion II%') )
AND a.state = -1
AND u.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
AND u.access <= 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-14 05:13:21' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-14 05:13:21' )
ORDER BY a.created DESC
LIMIT 0, 44
SELECT a.title AS title, a.description AS text, a.DATE AS created, a.url, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( " / ", '•Web Links•', b.title ) AS SECTION, "1" AS browsernav
FROM jos_weblinks AS a
INNER JOIN jos_categories AS b
ON b.id = a.catid
WHERE ((a.url LIKE '%Trials of Passion II%') OR (a.description LIKE '%Trials of Passion II%') OR (a.title LIKE '%Trials of Passion II%'))
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.DATE DESC
LIMIT 0, 50
SELECT a.name AS title, "" AS created, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( ", ", a.name, a.con_position, a.misc ) AS text, CONCAT_WS( " / ", '•Contact•', b.title ) AS SECTION, "2" AS browsernav
FROM jos_contact_details AS a
INNER JOIN jos_categories AS b
ON b.id = a.catid
WHERE ( a.name LIKE '%Trials of Passion II%' OR a.misc LIKE '%Trials of Passion II%' OR a.con_position LIKE '%Trials of Passion II%' OR a.address LIKE '%Trials of Passion II%' OR a.suburb LIKE '%Trials of Passion II%' OR a.state LIKE '%Trials of Passion II%' OR a.country LIKE '%Trials of Passion II%' OR a.postcode LIKE '%Trials of Passion II%' OR a.telephone LIKE '%Trials of Passion II%' OR a.fax LIKE '%Trials of Passion II%' )
AND a.published = 1
AND b.published = 1
AND a.access <= 0
AND b.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.title, a.description AS text, "" AS created, a.name, "2" AS browsernav, s.id AS secid, a.id AS catid, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug
FROM jos_categories AS a
INNER JOIN jos_sections AS s
ON s.id = a.SECTION
WHERE ( a.name LIKE '%Trials of Passion II%' OR a.title LIKE '%Trials of Passion II%' OR a.description LIKE '%Trials of Passion II%' )
AND a.published = 1
AND s.published = 1
AND a.access <= 0
AND s.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.title AS title, a.description AS text, a.name, "" AS created, "2" AS browsernav, a.id AS secid
FROM jos_sections AS a
WHERE ( a.name LIKE '%Trials of Passion II%' OR a.title LIKE '%Trials of Passion II%' OR a.description LIKE '%Trials of Passion II%' )
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
ORDER BY a.name DESC
LIMIT 0, 50
SELECT a.name AS title, "" AS created, a.link AS text, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(b.alias) THEN CONCAT_WS(':', b.id, b.alias) ELSE b.id END AS catslug, CONCAT_WS( " / ", '•News Feeds•', b.title )AS SECTION, "1" AS browsernav
FROM jos_newsfeeds AS a
INNER JOIN jos_categories AS b
ON b.id = a.catid
WHERE ( (a.name LIKE '%Trials of Passion II%') OR (a.link LIKE '%Trials of Passion II%') )
AND a.published = 1
AND b.published = 1
AND b.access <= 0
ORDER BY a.name ASC
LIMIT 0, 50
SELECT
comment AS text
, DATE AS created
, '2' AS browsernav
, '•Comments•' AS SECTION
, '' AS href
, id
, object_id
, object_group
FROM jos_jcomments
WHERE published='1'
AND (LOWER(comment) LIKE '%Trials of Passion II%' OR LOWER(title) LIKE '%Trials of Passion II%')
ORDER BY object_id, DATE DESC
LIMIT 0, 50
SELECT params
FROM jos_menu
WHERE id='0'
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 = 0 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT m.*, SUM(CASE WHEN p.published=1 THEN 1 ELSE 0 END) AS cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p
ON p.parent = m.id
WHERE m.menutype='mainmenu'
AND m.published='1'
AND m.access <= '0'
GROUP BY m.id
ORDER BY m.parent, m.ordering
SELECT m.*
FROM jos_menu AS m
WHERE menutype='mainmenu'
AND m.published='1'
SELECT *
FROM jos_jcomments_settings
SELECT cc.id, cc.userid, cc.comment, cc.name, cc.username, cc.email, cc.DATE, cc.object_id, cc.object_group, '' AS avatar
FROM jos_jcomments AS cc
LEFT JOIN jos_content AS c
ON c.id = cc.object_id
WHERE cc.published = 1
AND c.access <= '0'
AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2026-05-14 05:13:21')
AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2026-05-14 05:13:21')
AND cc.object_group = 'com_content'
ORDER BY cc.DATE DESC
LIMIT 7
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 555
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 591
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 575
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 483
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 306
SELECT a.id, a.sectionid, 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
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.id = 386