SELECT *
FROM jos_session
WHERE session_id = '27424c73229ba46f310f3dc09fda10eb'
DELETE
FROM jos_session
WHERE ( TIME < '1660107368' )
SELECT *
FROM jos_session
WHERE session_id = '27424c73229ba46f310f3dc09fda10eb'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '27424c73229ba46f310f3dc09fda10eb','1660109168','','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-138'
SELECT id
FROM jos_toc_magazines
WHERE alias = 'hw-no-138'
SELECT *
FROM jos_toc_magazines
WHERE id = '145'
SELECT *
FROM jos_toc_volumes
WHERE id = '8'
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_users
WHERE id = '1943'
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 = 145
AND id_error = 11
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 10
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 12
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 14
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 13
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 9
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 7
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 4
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 5
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 3
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 1
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 8
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 6
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
AND id_error = 2
AND state = 'problem_persist'
SELECT COUNT(*)
FROM jos_toc_pages_errors
WHERE id_magazine = 145
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 = 145
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 = 21707 ) 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 = 21708 ) 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 = 21709 ) 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 = 21710 ) 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 = 21711 ) 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 = 21712 ) 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 = 21713 ) 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 = 21714 ) 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 = 21715 ) 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 = 21716 ) 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 = 21717 ) 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 = 21718 ) 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 = 21719 ) 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 = 21720 ) 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 = 21721 ) 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 = 21722 ) 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 = 21723 ) 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 = 21724 ) 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 = 21725 ) 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 = 21726 ) 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 = 21727 ) 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 = 21728 ) 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 = 21729 ) 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 = 21730 ) 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