SELECT *
FROM jos_session
WHERE session_id = '0m2dcmai24g5498v9kir3nink7'
DELETE
FROM jos_session
WHERE ( time < '1762131640' )
SELECT *
FROM jos_session
WHERE session_id = '0m2dcmai24g5498v9kir3nink7'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '0m2dcmai24g5498v9kir3nink7','1762132540','','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 MAX(time)
FROM jos_vvcounter_logs
SELECT session_id, time, guest, DATA
FROM jos_session
WHERE '1=1'
AND time >= 1762131601
INSERT INTO jos_vvcounter_logs (time, visits, guests, members, bots)
VALUES ( 1762132540, 14, 14, 0, 0 )
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 = 53)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_pistudies
WHERE jos_pistudies.published = 1
AND jos_pistudies.studylist = 1
ORDER BY study_date DESC
SELECT *
FROM jos_pistudies
WHERE jos_pistudies.published = 1
AND jos_pistudies.studylist = 1
ORDER BY study_date DESC
LIMIT 0, 10
SELECT id AS value, book_name AS text
FROM jos_pibooks
SELECT id AS value, teacher_name AS text
FROM jos_piteachers
SELECT id AS value, series_name AS text
FROM jos_piseries
ORDER BY series_name
SELECT id AS value, ministry_name AS text
FROM jos_piministry
ORDER BY ministry_name
SELECT DISTINCT date_format(study_date, '%Y') AS value, date_format(study_date, '%Y') AS text
FROM jos_pistudies
ORDER BY value DESC
SELECT DISTINCT date_format(study_date, '%Y') AS value, date_format(study_date, '%Y') AS text
FROM jos_pistudies
ORDER BY value DESC
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1476';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1476';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1476';
SELECT *
FROM jos_pistudies
WHERE id = '1476'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1476
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1476'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1476'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1477';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1477';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1477';
SELECT *
FROM jos_pistudies
WHERE id = '1477'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1477
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1477'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1477'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1475';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1475';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1475';
SELECT *
FROM jos_pistudies
WHERE id = '1475'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1475
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT *
FROM jos_pistudies
WHERE id = '1475'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1475'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1474';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1474';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1474';
SELECT *
FROM jos_pistudies
WHERE id = '1474'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1474
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '11';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '11';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT *
FROM jos_pistudies
WHERE id = '1474'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1474'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1472';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1472';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1472';
SELECT *
FROM jos_pistudies
WHERE id = '1472'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1472
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1472'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1472'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1473';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1473';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1473';
SELECT *
FROM jos_pistudies
WHERE id = '1473'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1473
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1473'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1473'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1471';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1471';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1471';
SELECT *
FROM jos_pistudies
WHERE id = '1471'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1471
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1471'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1471'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1469';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1469';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1469';
SELECT *
FROM jos_pistudies
WHERE id = '1469'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1469
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1469'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1469'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1470';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1470';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1470';
SELECT *
FROM jos_pistudies
WHERE id = '1470'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1470
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '0';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '2';
SELECT *
FROM jos_pistudies
WHERE id = '1470'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1470'
SELECT `video`
FROM `jos_pistudies`
WHERE `id` = '1468';
SELECT `audio`
FROM `jos_pistudies`
WHERE `id` = '1468';
SELECT `text`
FROM `jos_pistudies`
WHERE `id` = '1468';
SELECT *
FROM jos_pistudies
WHERE id = '1468'
SELECT COUNT(*)
FROM jos_pistudies
WHERE asmedia =1468
SELECT `teacher_name`
FROM `jos_piteachers`
WHERE `id` = '19';
SELECT `teacher_alias`
FROM `jos_piteachers`
WHERE `id` = '19';
SELECT `series_name`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT `series_alias`
FROM `jos_piseries`
WHERE `id` = '4';
SELECT *
FROM jos_pistudies
WHERE id = '1468'
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT `book_name`
FROM `jos_pibooks`
WHERE `id` = '0';
SELECT *
FROM jos_pistudies
WHERE id = '1468'
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 = 53 OR mm.menuid = 0 )
ORDER BY position, 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 <= '2025-11-03 01:15:40' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-11-03 01:15:40' )
AND cc.id = 34
AND cc.section = s.id
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering
SELECT id, title, CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END AS slug
FROM jos_polls
WHERE id = 16
AND published = 1
SELECT id, text
FROM jos_poll_data
WHERE pollid = 16
AND text <> ""
ORDER BY id