SELECT *
FROM jos_session
WHERE session_id = 'e4be6ebf9794881d319853af108d7f74'
DELETE
FROM jos_session
WHERE ( TIME < '1659918541' )
SELECT *
FROM jos_session
WHERE session_id = 'e4be6ebf9794881d319853af108d7f74'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'e4be6ebf9794881d319853af108d7f74','1659920341','','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 template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 69)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT is_moderator
FROM jos_toc_users
WHERE id_user = 0
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-188'
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-188'
SELECT *
FROM jos_toc_magazines
WHERE id = '1168'
SELECT *
FROM jos_toc_volumes
WHERE id = '44'
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '741'
SELECT *
FROM jos_users
WHERE id = '156'
SELECT id
FROM jos_toc_magazines
WHERE otc_volunteer = '0'
AND otc_state != 'uncorrected'
AND otc_state != 'corrected'
SELECT id
FROM jos_toc_magazines
WHERE otc_moderator = '0'
AND otc_state = 'approval_in_progress'
SELECT *
FROM jos_toc_errors
ORDER BY `order`
SELECT *
FROM jos_toc_errors
ORDER BY `order`
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 11
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 10
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 12
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 14
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 13
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 9
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 7
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 4
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 5
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 3
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 1
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 8
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 6
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 2
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 1168
AND id_error = 15
AND state = 'problem_persist'
SELECT id,alias,title,version,otc_volunteer_modified,otc_moderator_modified,thumbnail,id_volume
FROM jos_toc_pages
WHERE id_magazine = 1168
ORDER BY ordering ASC
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28608 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28609 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28610 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28611 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28612 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28613 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28614 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28615 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28616 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28617 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28618 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28619 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28620 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28621 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28622 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28623 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28624 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28625 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28626 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28627 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28628 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28629 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28630 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *, !ISNULL(b.id_error) AS flag, IFNULL(b.state, 'not_applicable') AS state
FROM jos_toc_errors AS a
LEFT JOIN ( SELECT id_error, state
FROM jos_toc_pages_errors
WHERE id_page = 28631 ) AS b
ON a.id = b.id_error
ORDER BY a.
ORDER
SELECT *
FROM jos_content
WHERE id = '29030'
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 = 69 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT guest, usertype, client_id, DATA
FROM jos_session
WHERE client_id = 0