SELECT *
FROM jos_session
WHERE session_id = 'ed651a3166781b88afa41d4d0d29403c'
DELETE
FROM jos_session
WHERE ( TIME < '1660103292' )
SELECT *
FROM jos_session
WHERE session_id = 'ed651a3166781b88afa41d4d0d29403c'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'ed651a3166781b88afa41d4d0d29403c','1660105092','','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-140'
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-140'
SELECT *
FROM jos_toc_magazines
WHERE id = '147'
SELECT *
FROM jos_toc_volumes
WHERE id = '8'
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '726'
SELECT *
FROM jos_users
WHERE id = '2081'
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 = 147
AND id_error = 11
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 10
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 12
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 14
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 13
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 9
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 7
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 4
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 5
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 3
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 1
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 8
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 6
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
AND id_error = 2
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 147
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 = 147
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 = 21755 ) 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 = 21756 ) 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 = 21757 ) 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 = 21758 ) 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 = 21759 ) 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 = 21760 ) 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 = 21761 ) 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 = 21762 ) 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 = 21763 ) 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 = 21764 ) 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 = 21765 ) 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 = 21766 ) 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 = 21767 ) 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 = 21768 ) 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 = 21769 ) 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 = 21770 ) 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 = 21771 ) 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 = 21772 ) 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 = 21773 ) 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 = 21774 ) 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 = 21775 ) 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 = 21776 ) 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 = 21777 ) 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 = 21778 ) 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