+ ~ -
 

Results 1 - 20 of 20 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Short Fiction i
Subjects Art; Design; Painting; Sculpture; Photography; Interior Decoration;
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Dreams; Visions; Sleep
Germany—Description and Travel; Austria—Description and Travel
Opium; Opium Abuse; Drugs; Poisons; Poisoning
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Violence; Torture; Violence in Literature; Violence—Moral and Ethical Aspects; Violence—Psychological Aspects
Attachments: 0 · Links: 0 · Hits: 1228

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1086

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1046

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1175

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1084

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1137

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1081

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1080

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1044

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1057

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1379

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1034

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1080

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1028

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1078

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1036

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1089

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1076

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1137

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Hamilton Aidé
Genre Prose: Serial Fiction i
Attachments: 0 · Links: 0 · Hits: 1060

Who's Online

We have 186 guests and 1 robot online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.085 seconds, 1.00 MB
Application afterRoute: 0.090 seconds, 2.05 MB
Application afterDispatch: 0.559 seconds, 4.65 MB
Application afterRender: 0.609 seconds, 5.11 MB

Memory Usage

5388232

94 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '5f3cae53fd2784a33d8f8fdd2b197ec5'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1635021051' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '5f3cae53fd2784a33d8f8fdd2b197ec5'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '5f3cae53fd2784a33d8f8fdd2b197ec5','1635022851','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 70)
      ORDER BY menuid DESC
      LIMIT 0, 1
  8. 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;
  9. 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;
  10. 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;
  11. 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;
  12. 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 ( 493 )  
      GROUP BY id_block;
  13. 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
  14. 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;
  15. 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;
  16. 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;
  17. 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;
  18. 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 ( 493 )  
      GROUP BY id_block;
  19. 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
  20. SELECT *
      FROM jos_toc_periodicals
      WHERE id = '2'
  21. SELECT *
      FROM jos_toc_volumes
      WHERE id = '36'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '879'
  23. 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 = 6637
      ORDER BY r.surname ASC
  24. 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 = 6637
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  25. 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 = 6637
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  26. SELECT *
      FROM jos_toc_volumes
      WHERE id = '40'
  27. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1065'
  28. 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 = 7474
      ORDER BY r.surname ASC
  29. 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 = 7474
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  30. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1066'
  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 = 7509
      ORDER BY r.surname ASC
  32. 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 = 7509
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  33. SELECT *
      FROM jos_toc_volumes
      WHERE id = '41'
  34. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1106'
  35. 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 = 8080
      ORDER BY r.surname ASC
  36. 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 = 8080
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  37. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1107'
  38. 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 = 8087
      ORDER BY r.surname ASC
  39. 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 = 8087
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  40. SELECT *
      FROM jos_toc_volumes
      WHERE id = '43'
  41. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1134'
  42. 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 = 7872
      ORDER BY r.surname ASC
  43. 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 = 7872
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  44. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1135'
  45. 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 = 7878
      ORDER BY r.surname ASC
  46. 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 = 7878
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  47. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1136'
  48. 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 = 7883
      ORDER BY r.surname ASC
  49. 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 = 7883
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  50. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1137'
  51. 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 = 7892
      ORDER BY r.surname ASC
  52. 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 = 7892
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  53. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1138'
  54. 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 = 7901
      ORDER BY r.surname ASC
  55. 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 = 7901
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  56. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1139'
  57. 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 = 7909
      ORDER BY r.surname ASC
  58. 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 = 7909
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  59. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1140'
  60. 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 = 7917
      ORDER BY r.surname ASC
  61. 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 = 7917
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  62. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1141'
  63. 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 = 7982
      ORDER BY r.surname ASC
  64. 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 = 7982
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  65. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1142'
  66. 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 = 7990
      ORDER BY r.surname ASC
  67. 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 = 7990
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  68. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1143'
  69. 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 = 7998
      ORDER BY r.surname ASC
  70. 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 = 7998
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  71. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1144'
  72. 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 = 8007
      ORDER BY r.surname ASC
  73. 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 = 8007
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  74. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1145'
  75. 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 = 8015
      ORDER BY r.surname ASC
  76. 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 = 8015
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  77. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1146'
  78. 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 = 8024
      ORDER BY r.surname ASC
  79. 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 = 8024
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  80. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1147'
  81. 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 = 8033
      ORDER BY r.surname ASC
  82. 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 = 8033
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  83. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1148'
  84. 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 = 8094
      ORDER BY r.surname ASC
  85. 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 = 8094
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  86. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  87. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  88. 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
  89. 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
  90. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  91. 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
  92. 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
  93. 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
  94. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None