SELECT *
FROM jos_session
WHERE session_id = '056996451f0ef556bbb281c7b3ee18f4'
DELETE
FROM jos_session
WHERE ( TIME < '1659917427' )
SELECT *
FROM jos_session
WHERE session_id = '056996451f0ef556bbb281c7b3ee18f4'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '056996451f0ef556bbb281c7b3ee18f4','1659919227','','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-135'
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-135'
SELECT *
FROM jos_toc_magazines
WHERE id = '142'
SELECT *
FROM jos_toc_volumes
WHERE id = '8'
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '2282'
SELECT *
FROM jos_users
WHERE id = '775'
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 = 142
AND id_error = 11
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 10
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 12
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 14
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 13
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 9
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 7
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 4
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 5
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 3
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 1
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 8
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 6
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
AND id_error = 2
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 142
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 = 142
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 = 21635 ) 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 = 21636 ) 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 = 21637 ) 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 = 21638 ) 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 = 21639 ) 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 = 21640 ) 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 = 21641 ) 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 = 21642 ) 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 = 21643 ) 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 = 21644 ) 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 = 21645 ) 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 = 21646 ) 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 = 21647 ) 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 = 21648 ) 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 = 21649 ) 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 = 21650 ) 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 = 21651 ) 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 = 21652 ) 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 = 21653 ) 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 = 21654 ) 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 = 21655 ) 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 = 21656 ) 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 = 21657 ) 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 = 21658 ) 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