SELECT *
FROM jos_session
WHERE session_id = 'nuj8ceb2mckim6h028lpa3irm2'
DELETE
FROM jos_session
WHERE ( TIME < '1778948414' )
SELECT *
FROM jos_session
WHERE session_id = 'nuj8ceb2mckim6h028lpa3irm2'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'nuj8ceb2mckim6h028lpa3irm2','1778949314','','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=The+Blues+Kingdom%' OR sefurl LIKE 'searchphrase=exact&searchword=The+Blues+Kingdom%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'component/search/?searchphrase=exact&searchword=The+Blues+Kingdom%' OR sefurl LIKE 'component/search/?searchphrase=exact&searchword=The+Blues+Kingdom%'
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 '%The Blues Kingdom%') OR (a.introtext LIKE '%The Blues Kingdom%') OR (a.fulltext LIKE '%The Blues Kingdom%') OR (a.metakey LIKE '%The Blues Kingdom%') OR (a.metadesc LIKE '%The Blues Kingdom%') )
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-16 16:35:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-16 16:35:14' )
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 '%The Blues Kingdom%') OR (a.introtext LIKE '%The Blues Kingdom%') OR (a.fulltext LIKE '%The Blues Kingdom%') OR (a.metakey LIKE '%The Blues Kingdom%') OR (a.metadesc LIKE '%The Blues Kingdom%'))
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-16 16:35:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-16 16:35:14' )
ORDER BY a.created DESC
LIMIT 0, 39
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 '%The Blues Kingdom%') OR (a.introtext LIKE '%The Blues Kingdom%') OR (a.fulltext LIKE '%The Blues Kingdom%') OR (a.metakey LIKE '%The Blues Kingdom%') OR (a.metadesc LIKE '%The Blues Kingdom%') )
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-16 16:35:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-16 16:35:14' )
ORDER BY a.created DESC
LIMIT 0, 39
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 '%The Blues Kingdom%') OR (a.description LIKE '%The Blues Kingdom%') OR (a.title LIKE '%The Blues Kingdom%'))
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 '%The Blues Kingdom%' OR a.misc LIKE '%The Blues Kingdom%' OR a.con_position LIKE '%The Blues Kingdom%' OR a.address LIKE '%The Blues Kingdom%' OR a.suburb LIKE '%The Blues Kingdom%' OR a.state LIKE '%The Blues Kingdom%' OR a.country LIKE '%The Blues Kingdom%' OR a.postcode LIKE '%The Blues Kingdom%' OR a.telephone LIKE '%The Blues Kingdom%' OR a.fax LIKE '%The Blues Kingdom%' )
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 '%The Blues Kingdom%' OR a.title LIKE '%The Blues Kingdom%' OR a.description LIKE '%The Blues Kingdom%' )
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 '%The Blues Kingdom%' OR a.title LIKE '%The Blues Kingdom%' OR a.description LIKE '%The Blues Kingdom%' )
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 '%The Blues Kingdom%') OR (a.link LIKE '%The Blues Kingdom%') )
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 '%The Blues Kingdom%' OR LOWER(title) LIKE '%The Blues Kingdom%')
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-16 16:35:14')
AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2026-05-16 16:35:14')
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