SELECT *
FROM jos_session
WHERE session_id = 's3b7dpmec9ridtmflmjcbem065'
DELETE
FROM jos_session
WHERE ( TIME < '1777168943' )
SELECT *
FROM jos_session
WHERE session_id = 's3b7dpmec9ridtmflmjcbem065'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 's3b7dpmec9ridtmflmjcbem065','1777169843','','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=+Forsaken+Rose%' OR sefurl LIKE 'searchphrase=exact&searchword=+Forsaken+Rose%'
SELECT *
FROM jos_migration_backlinks
WHERE url LIKE 'component/search/?searchphrase=exact&searchword=+Forsaken+Rose%' OR sefurl LIKE 'component/search/?searchphrase=exact&searchword=+Forsaken+Rose%'
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 '%Forsaken Rose%') OR (a.introtext LIKE '%Forsaken Rose%') OR (a.fulltext LIKE '%Forsaken Rose%') OR (a.metakey LIKE '%Forsaken Rose%') OR (a.metadesc LIKE '%Forsaken Rose%') )
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-04-26 02:17:23' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-26 02:17:23' )
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 '%Forsaken Rose%') OR (a.introtext LIKE '%Forsaken Rose%') OR (a.fulltext LIKE '%Forsaken Rose%') OR (a.metakey LIKE '%Forsaken Rose%') OR (a.metadesc LIKE '%Forsaken Rose%'))
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-04-26 02:17:23' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-26 02:17:23' )
ORDER BY a.created DESC
LIMIT 0, 45
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 '%Forsaken Rose%') OR (a.introtext LIKE '%Forsaken Rose%') OR (a.fulltext LIKE '%Forsaken Rose%') OR (a.metakey LIKE '%Forsaken Rose%') OR (a.metadesc LIKE '%Forsaken Rose%') )
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-04-26 02:17:23' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-04-26 02:17:23' )
ORDER BY a.created DESC
LIMIT 0, 45
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 '%Forsaken Rose%') OR (a.description LIKE '%Forsaken Rose%') OR (a.title LIKE '%Forsaken Rose%'))
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 '%Forsaken Rose%' OR a.misc LIKE '%Forsaken Rose%' OR a.con_position LIKE '%Forsaken Rose%' OR a.address LIKE '%Forsaken Rose%' OR a.suburb LIKE '%Forsaken Rose%' OR a.state LIKE '%Forsaken Rose%' OR a.country LIKE '%Forsaken Rose%' OR a.postcode LIKE '%Forsaken Rose%' OR a.telephone LIKE '%Forsaken Rose%' OR a.fax LIKE '%Forsaken Rose%' )
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 '%Forsaken Rose%' OR a.title LIKE '%Forsaken Rose%' OR a.description LIKE '%Forsaken Rose%' )
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 '%Forsaken Rose%' OR a.title LIKE '%Forsaken Rose%' OR a.description LIKE '%Forsaken Rose%' )
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 '%Forsaken Rose%') OR (a.link LIKE '%Forsaken Rose%') )
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 '%Forsaken Rose%' OR LOWER(title) LIKE '%Forsaken Rose%')
ORDER BY object_id, DATE DESC
LIMIT 0, 50
SELECT *
FROM jos_jcomments_settings
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 = 193
SELECT title, id
FROM jos_content
WHERE id = 193
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 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-04-26 02:17:23')
AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2026-04-26 02:17:23')
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
Well, I think the CEA was a very shallow and misgu... More...
This is creativity we are talking about, this are ... More...
Lovelyn,your pre-selection criterias are ok but i'... More...
camhood 4 the better More...
CONGRATULATION. THANK GOD FOR YOU GUYS. CAMEROON S... More...
cool girls dat was great but this year we the cons... More...