SELECT *
FROM jos_session
WHERE session_id = 'fikjgia6p9nmkffiq5bhcpokt0'
DELETE
FROM jos_session
WHERE ( time < '1782199382' )
SELECT *
FROM jos_session
WHERE session_id = 'fikjgia6p9nmkffiq5bhcpokt0'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'fikjgia6p9nmkffiq5bhcpokt0','1782200282','','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 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 = 175)
ORDER BY menuid DESC
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.images, a.attribs, a.urls, 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, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT 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 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-23 07:38:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-23 07:38:02' )
ORDER BY f.ordering
LIMIT 21, 6
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.images, a.attribs, a.urls, 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, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f
ON f.content_id = a.id
LEFT 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 1
AND a.access <= 0
AND a.state = 1
AND (( cc.published = 1
AND s.published = 1 ) OR ( a.catid = 0
AND a.sectionid = 0 ) )
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-23 07:38:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-23 07:38:02' )
ORDER BY f.ordering
SELECT name
FROM jos_users
WHERE id = 62
SELECT a.*, cc.title AS category_name, a.image, 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_contact_details AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_users AS u
ON u.id = a.user_id
WHERE u.name = 'Administrator'
AND u.block = 0
AND a.published = 1
AND cc.published = 1
AND a.access <= 0
AND cc.access <= 0
SELECT name
FROM jos_users
WHERE id = 62
SELECT a.*, cc.title AS category_name, a.image, 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_contact_details AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_users AS u
ON u.id = a.user_id
WHERE u.name = 'Administrator'
AND u.block = 0
AND a.published = 1
AND cc.published = 1
AND a.access <= 0
AND cc.access <= 0
SELECT a.*, cc.title AS category_name, a.image, 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_contact_details AS a
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_users AS u
ON u.id = a.user_id
WHERE u.name = 'Elma Eclarin'
AND u.block = 0
AND a.published = 1
AND cc.published = 1
AND a.access <= 0
AND cc.access <= 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 = 175 OR mm.menuid = 0 )
ORDER BY position, ordering
CREATE TABLE IF NOT EXISTS `jos_vcnt` (`tm` int NOT NULL, ip varchar(16) NOT NULL DEFAULT '0.0.0.0')
SELECT count(*)
FROM `jos_vcnt`
WHERE `ip` = '216.73.217.126'
AND (`tm` + '86400') > '1782200282'
SELECT count(*)
FROM `jos_vcnt`
WHERE `ip` = '216.73.217.126'
AND (`tm` + '86400') > '1782200282'
CREATE TABLE IF NOT EXISTS `jos_vcnt_pc` (`cnt` int NOT NULL NOT NULL DEFAULT '0')
SELECT count(*)
FROM `jos_vcnt_pc`
SELECT count(*)
FROM `jos_vcnt_pc`
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`<'1779606000'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`<'1779606000'
SELECT `guest`, `usertype`, `client_id` , `username`, `userid`
FROM `jos_session`
WHERE `client_id` = 0
AND `time` > '1782199682'
SELECT cnt
FROM `jos_vcnt_pc`
SELECT cnt
FROM `jos_vcnt_pc`
SELECT count(*)
FROM `jos_vcnt`
SELECT count(*)
FROM `jos_vcnt`
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782198000'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782198000'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782111600'
AND `tm`<'1782198000'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782111600'
AND `tm`<'1782198000'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>='1782111600'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>='1782111600'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>='1780297200'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>='1780297200'
SELECT a.*, 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
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-23 07:38:02' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-23 07:38:02' )
AND cc.id = 24
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
LIMIT 0, 1
SELECT a.*, 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
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-23 07:38:02' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-23 07:38:02' )
AND cc.id = 59
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT a.*, 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
INNER JOIN jos_categories AS cc
ON cc.id = a.catid
INNER JOIN jos_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-23 07:38:02' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-23 07:38:02' )
AND cc.id = 60
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
The USL College Library conducted an activity entitled "BOOK SPINE POETRY" held on March 26, 2025, at the Bishop Constant Jurgens Campus (BCJC) Library. The participants explore their creativity through literature, focusing on the visual aspect of book spines and combining them into poetic form. The activity's objectives are to encourage students to think creatively by arranging book titles in a way that forms meaningful and poetic expressions and help students discover the diversity of books and authors. It involved selecting books across genres. Encouraging curiosity and reading. The activity was spearheaded by Ms. Elma S. Eclarin, SECAP Librarian, and participated by college students from the BCJ Campus.
Winners received Certificates of Recognition, prizes, and a three-day borrowing extension, while non-winners were awarded Certificates of Participation and a one-day borrowing extension. The participants generally evaluated the activity as "Strongly Agree." Based on their comments and suggestions, they found the activity enjoyable and considered it a great new experience.
The following is the list of winners: