SELECT *
FROM jos_session
WHERE session_id = '0lndbrhmf9200k8bhcg8hf3ea3'
DELETE
FROM jos_session
WHERE ( time < '1782258393' )
SELECT *
FROM jos_session
WHERE session_id = '0lndbrhmf9200k8bhcg8hf3ea3'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0lndbrhmf9200k8bhcg8hf3ea3','1782259293','','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-24 00:01:33' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 00:01:33' )
ORDER BY f.ordering
LIMIT 180, 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-24 00:01:33' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 00:01:33' )
ORDER BY f.ordering
SELECT name
FROM jos_users
WHERE id = 78
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 = 'DANOLEENE MARIE P. TUGADE'
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 = 77
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 = 'Venus P. Ibarra-Guyos'
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 = 81
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 = 'Onofre Unciano'
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') > '1782259293'
SELECT count(*)
FROM `jos_vcnt`
WHERE `ip` = '216.73.217.126'
AND (`tm` + '86400') > '1782259293'
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` > '1782258693'
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`>'1782284400'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782284400'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782198000'
AND `tm`<'1782284400'
SELECT count(*)
FROM `jos_vcnt`
WHERE `tm`>'1782198000'
AND `tm`<'1782284400'
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-24 00:01:33' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 00:01:33' )
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-24 00:01:33' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 00:01:33' )
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-24 00:01:33' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-24 00:01:33' )
AND cc.id = 60
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
On April 8, 2015, the University Libraries sponsored a one-day training on the newly subscribed ProQuest Thesis and Dissertations Database with the inclusion of two other free databases namely E-brary and K-12 Databases. Among the participants were the library staff and heads, research teachers and coordinators from the different college departments, URC staff and Elementary and High School principals and coordinators. The trainer was Mr. Bonneth Suguisabal, Sales & Marketing Representative of LibTech Solutions.
On the auspicious day of February 11, 2015, the University Libraries, with glee and pride, launched yet another innovation: the USL e-Yearbooks! This is a 7-year long and laborious project that passed through the hands of three men who took charge of digitizing the print collection of yearbooks from 1968-2013.The project has been conceptualized in 2008. Reverend Father Eugene A. Arco, University President, led the crowd in the Untying of the Ribbon during the launching, a new tradition embraced by the University.
One fruitful activity to intensify the campaign for love for books, reading and libraries was the Speed Reading Activity that was conducted by the USL College Library at the 2nd floor, College Library on January 26, 2015.