SELECT *
FROM jos_session
WHERE session_id = 'cf8884d9c48cf2156153718c6be27b68'
DELETE
FROM jos_session
WHERE ( TIME < '1657032335' )
SELECT *
FROM jos_session
WHERE session_id = 'cf8884d9c48cf2156153718c6be27b68'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'cf8884d9c48cf2156153718c6be27b68','1657034135','','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-131'
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-131'
SELECT *
FROM jos_toc_magazines
WHERE id = '138'
SELECT *
FROM jos_toc_volumes
WHERE id = '8'
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '620'
SELECT *
FROM jos_users
WHERE id = '2074'
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 = 138
AND id_error = 11
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 10
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 12
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 14
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 13
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 9
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 7
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 4
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 5
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 3
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 1
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 8
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 6
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
AND id_error = 2
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 138
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 = 138
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 = 21539 ) 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 = 21540 ) 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 = 21541 ) 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 = 21542 ) 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 = 21543 ) 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 = 21544 ) 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 = 21545 ) 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 = 21546 ) 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 = 21547 ) 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 = 21548 ) 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 = 21549 ) 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 = 21550 ) 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 = 21551 ) 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 = 21552 ) 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 = 21553 ) 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 = 21554 ) 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 = 21555 ) 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 = 21556 ) 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 = 21557 ) 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 = 21558 ) 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 = 21559 ) 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 = 21560 ) 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 = 21561 ) 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 = 21562 ) 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