SELECT *
FROM jos_session
WHERE session_id = '4960698bdc6a1ba7cac534c0d52570b5'
DELETE
FROM jos_session
WHERE ( TIME < '1657185959' )
SELECT *
FROM jos_session
WHERE session_id = '4960698bdc6a1ba7cac534c0d52570b5'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '4960698bdc6a1ba7cac534c0d52570b5','1657187759','','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 = 70)
ORDER BY menuid DESC
LIMIT 0, 1
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_subjects_links (PRIMARY KEY pkey (id_estate)) SELECT id_estate, COUNT(*) AS cnt
FROM jos_toc_blocks_subjects_links
GROUP BY id_estate;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_genres_links (PRIMARY KEY pkey (id_estate)) SELECT id_estate, COUNT(*) AS cnt
FROM jos_toc_blocks_genres_links
GROUP BY id_estate;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_documents (PRIMARY KEY pkey (id)) SELECT block_id AS id, COUNT(block_id) AS cnt
FROM jos_toc_blocks_documents
GROUP BY block_id;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_links (PRIMARY KEY pkey (id)) SELECT block_id AS id, COUNT(block_id) AS cnt
FROM jos_toc_blocks_links
GROUP BY block_id;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_authors (PRIMARY KEY pkey (id)) SELECT id_block AS id, COUNT(id_block) AS cnt
FROM jos_toc_blocks_authors
WHERE id_author IN ( 50 )
GROUP BY id_block;
SELECT COUNT(*)
FROM jos_toc_blocks AS block
LEFT JOIN jos_toc_magazines AS magazine
ON block.id_magazine = magazine.id
LEFT JOIN jos_toc_volumes AS volume
ON block.id_volume = volume.id
LEFT JOIN jos_toc_periodicals AS periodical
ON block.id_periodical = periodical.id
LEFT JOIN tmp_table_blocks_subjects_links AS subject
ON block.id = subject.id_estate
LEFT JOIN tmp_table_blocks_genres_links AS genre
ON block.id = genre.id_estate
LEFT JOIN tmp_table_blocks_documents AS documents
ON block.id = documents.id
LEFT JOIN tmp_table_blocks_links AS links
ON block.id = links.id
LEFT JOIN tmp_table_blocks_authors AS authors
ON block.id = authors.id
WHERE (block.published = 1)
AND authors.cnt > 0
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_subjects_links (PRIMARY KEY pkey (id_estate)) SELECT id_estate, COUNT(*) AS cnt
FROM jos_toc_blocks_subjects_links
GROUP BY id_estate;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_genres_links (PRIMARY KEY pkey (id_estate)) SELECT id_estate, COUNT(*) AS cnt
FROM jos_toc_blocks_genres_links
GROUP BY id_estate;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_documents (PRIMARY KEY pkey (id)) SELECT block_id AS id, COUNT(block_id) AS cnt
FROM jos_toc_blocks_documents
GROUP BY block_id;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_links (PRIMARY KEY pkey (id)) SELECT block_id AS id, COUNT(block_id) AS cnt
FROM jos_toc_blocks_links
GROUP BY block_id;
CREATE TEMPORARY TABLE IF NOT EXISTS tmp_table_blocks_authors (PRIMARY KEY pkey (id)) SELECT id_block AS id, COUNT(id_block) AS cnt
FROM jos_toc_blocks_authors
WHERE id_author IN ( 50 )
GROUP BY id_block;
SELECT block.*, IFNULL(periodical.title, "NA") AS title_periodical, IFNULL(volume.title, "NA") AS title_volume, IFNULL(magazine.title, "NA") AS title_magazine, documents.cnt AS document_count, links.cnt AS link_count, subject.cnt AS subject_count, genre.cnt AS genre_count, authors.cnt AS author_count
FROM jos_toc_blocks AS block
LEFT JOIN jos_toc_magazines AS magazine
ON block.id_magazine = magazine.id
LEFT JOIN jos_toc_volumes AS volume
ON block.id_volume = volume.id
LEFT JOIN jos_toc_periodicals AS periodical
ON block.id_periodical = periodical.id
LEFT JOIN tmp_table_blocks_subjects_links AS subject
ON block.id = subject.id_estate
LEFT JOIN tmp_table_blocks_genres_links AS genre
ON block.id = genre.id_estate
LEFT JOIN tmp_table_blocks_documents AS documents
ON block.id = documents.id
LEFT JOIN tmp_table_blocks_links AS links
ON block.id = links.id
LEFT JOIN tmp_table_blocks_authors AS authors
ON block.id = authors.id
WHERE (block.published = 1)
AND authors.cnt > 0
ORDER BY id_magazine, id_page, ordering ASC
LIMIT 20
SELECT *
FROM jos_toc_periodicals
WHERE id = '1'
SELECT *
FROM jos_toc_volumes
WHERE id = '3'
SELECT *
FROM jos_toc_magazines
WHERE id = '7'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 92
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 92
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 92
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '10'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 124
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 124
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 124
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '31'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 307
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 307
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 307
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '4'
SELECT *
FROM jos_toc_magazines
WHERE id = '34'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 332
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 332
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 332
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '40'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 367
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 367
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 367
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '6'
SELECT *
FROM jos_toc_magazines
WHERE id = '100'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 1201
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 1201
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 1201
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '7'
SELECT *
FROM jos_toc_magazines
WHERE id = '128'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 1464
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 1464
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 1464
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '8'
SELECT *
FROM jos_toc_magazines
WHERE id = '153'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2123
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2123
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2123
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '9'
SELECT *
FROM jos_toc_magazines
WHERE id = '175'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2298
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2298
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2298
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '177'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2306
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2306
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2306
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '178'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2215
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2215
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2215
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '180'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2223
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2223
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2223
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '181'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2323
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2323
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2323
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '14'
SELECT *
FROM jos_toc_magazines
WHERE id = '275'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 3214
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 3214
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 3214
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '16'
SELECT *
FROM jos_toc_magazines
WHERE id = '321'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 1800
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 1800
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 1800
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '322'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 1811
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 1811
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 1811
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '331'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 1878
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 1878
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 1878
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '18'
SELECT *
FROM jos_toc_magazines
WHERE id = '390'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 3890
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 3890
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 3890
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_volumes
WHERE id = '44'
SELECT *
FROM jos_toc_magazines
WHERE id = '1173'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2449
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2449
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2449
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT *
FROM jos_toc_magazines
WHERE id = '1183'
SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
FROM jos_toc_authors AS r RIGHT JOIN jos_toc_blocks_authors AS l
ON r.id = l.id_author
WHERE l.id_block = 2546
ORDER BY r.surname ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
WHERE id_estate = 2546
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
WHERE id_estate = 2546
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT id AS VALUE, title AS text
FROM jos_toc_periodicals
WHERE published = 1
ORDER BY title
SELECT id AS VALUE, surname AS text
FROM jos_toc_authors
WHERE published = 1
ORDER BY surname
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT id, surname, names
FROM jos_toc_authors
ORDER BY surname
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
FROM jos_toc_blocks_genres AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_genres_links
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp
FROM jos_toc_blocks_subjects AS insignia
LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
FROM jos_toc_blocks_subjects_links
GROUP BY id_insignia) AS link
ON insignia.id = link.id_insignia
ORDER BY insignia.title ASC
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 = 70 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT guest, usertype, client_id, DATA
FROM jos_session
WHERE client_id = 0