+ ~ -
 

Results 1 - 20 of 82 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.

Old Echoes

5/2/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subject Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1129

Article icon.

Friend Sorrow

5/3/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subject Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Attachments: 0 · Links: 0 · Hits: 1292

Article icon.

Hush!

14/5/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subject Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Attachments: 0 · Links: 0 · Hits: 1189

Article icon.

The Settlers

21/5/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Emigration; Immigration; Expatriation
Marriage; Courtship; Love; Sex
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1000

Article icon.

Listening Angels

30/7/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1085

Article icon.

Hidden Light

26/8/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Charles Dickens
Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1392

Dickens was probably speaking of 'Hidden Light' when he wrote as follows to Wills on 12 August 1854: 'I have bothered and worried at the Poem (which is neither English, nor verse) hoping to make something of it, but have not succeeded after all. Strike it out. If I can fuse into it an idea I have of its natural end, you shall have it in the next parcel. If you hear no more of it, give it up as unmendable.'
According to the Office Book, 'Hidden Light' is the only Household Words poem with Dickens as joint author. Perhaps the last three stanzas are by him.

Harry Stone; © Bloomington and Indiana University Press, 1968. DJO gratefully acknowledges permission to reproduce this material.

Article icon.

Waiting

14/10/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subject Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1093

Article icon.

My Picture

21/10/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Art; Design; Painting; Sculpture; Photography; Interior Decoration;
Health; Diseases; Personal Injuries; Hygiene; Cleanliness—Fiction
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1111

Article icon.

A Vision

11/11/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Dreams; Visions; Sleep
Attachments: 0 · Links: 0 · Hits: 1147

Article icon.

Give

18/11/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Charity; Philanthropists; Philanthropists—Fiction; Benevolence
Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1152

Article icon.

The Two Spirits

13/1/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Crimean War, 1853-1856
Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Gender Identity; Women; Men; Femininity; Masculinity
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
War; Battles; Peace; Military History; Weapons; Soldiers
Attachments: 0 · Links: 0 · Hits: 1111

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Great Britain—Social Conditions—Nineteenth Century
Poverty; Poor Laws—Great Britain; Workhouses—Great Britain
Religion; Religion and Culture
Attachments: 0 · Links: 0 · Hits: 1134

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genres Poetry: Occasional (Christmas, &c.) i
Prose: Occasional (Christmas Story; article in Christmas or New Year Number, &c) i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Health; Diseases; Personal Injuries; Hygiene; Cleanliness—Fiction
Marriage; Courtship; Love; Sex
Medical care; Nursing; Hospitals; Hospital Care; Surgery; Medicine; Physicians
Myth; Legends; Epic Literature; Fables; Allegory; Folklore
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 970

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Prose: Occasional (Christmas Story; article in Christmas or New Year Number, &c) i
Subjects Gender Identity; Women; Men; Femininity; Masculinity
Myth; Legends; Epic Literature; Fables; Allegory; Folklore
Switzerland—Description and Travel
War; Battles; Peace; Military History; Weapons; Soldiers
Attachments: 0 · Links: 0 · Hits: 1186

The interpolated story (in the form of a narrative poem) told in 'The Seventh Poor Traveller' is by Adelaide Anne Procter. The Introduction to 'The Seventh Poor Traveller', however, is part of the framework of The Seven Poor Travellers - part, that is, of the linking and bridging sections that Dickens usually wrote himself. See note to The Seven Poor Travellers.

Harry Stone; © Bloomington and Indiana University Press, 1968. DJO gratefully acknowledges permission to reproduce this material.

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Other i
Subjects Crimean War, 1853-1856
War; Battles; Peace; Military History; Weapons; Soldiers
Attachments: 0 · Links: 0 · Hits: 1245

Article icon.

Passing Clouds

10/3/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Religion; Religion and Culture
Weather; Meteorology; Climate; Seasons
Attachments: 0 · Links: 0 · Hits: 1029

Article icon.

One by One

17/3/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Lyric i
Subjects Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1041

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Elegy i
Subject Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Attachments: 0 · Links: 0 · Hits: 1073

Article icon.

A False Genius

14/4/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1030

Article icon.

God's Gift

5/5/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Adelaide Anne Procter
Genre Poetry: Narrative i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1145


Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 90

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 96

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 90

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 96

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 90

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 96

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 90

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 96

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 90

Warning: Illegal string offset 'active' in /home/buckjard/public_html/djo/website-main/templates/tmp_djo_andy/html/pagination.php on line 96
«StartPrev12345NextEnd»

Page 1 of 5

Who's Online

We have 291 guests and 2 robots online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.020 seconds, 1.00 MB
Application afterRoute: 0.025 seconds, 2.05 MB
Application afterDispatch: 0.493 seconds, 4.76 MB
Application afterRender: 0.547 seconds, 5.22 MB

Memory Usage

5508488

112 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '6fabfa31d7dc7c94b4625d7e9dabfd38'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1659919318' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '6fabfa31d7dc7c94b4625d7e9dabfd38'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '6fabfa31d7dc7c94b4625d7e9dabfd38','1659921118','','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 ( 148 )  
      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 ( 148 )  
      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 = '1'
  21. SELECT *
      FROM jos_toc_volumes
      WHERE id = '8'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '157'
  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 = 2137
      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 = 2137
      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 = 2137
      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 = '9'
  27. SELECT *
      FROM jos_toc_magazines
      WHERE id = '162'
  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 = 2154
      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 = 2154
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  30. 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 = 2154
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  31. SELECT *
      FROM jos_toc_magazines
      WHERE id = '172'
  32. 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 = 2191
      ORDER BY r.surname ASC
  33. 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 = 2191
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  34. 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 = 2191
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  35. SELECT *
      FROM jos_toc_magazines
      WHERE id = '173'
  36. 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 = 2291
      ORDER BY r.surname ASC
  37. 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 = 2291
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  38. 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 = 2291
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  39. SELECT *
      FROM jos_toc_magazines
      WHERE id = '183'
  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 = 2333
      ORDER BY r.surname ASC
  41. 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 = 2333
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  42. 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 = 2333
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  43. SELECT *
      FROM jos_toc_volumes
      WHERE id = '10'
  44. SELECT *
      FROM jos_toc_magazines
      WHERE id = '189'
  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 = 2561
      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 = 2561
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  47. 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 = 2561
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  48. SELECT *
      FROM jos_toc_magazines
      WHERE id = '196'
  49. 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 = 2644
      ORDER BY r.surname ASC
  50. 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 = 2644
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  51. 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 = 2644
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  52. SELECT *
      FROM jos_toc_magazines
      WHERE id = '197'
  53. 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 = 2621
      ORDER BY r.surname ASC
  54. 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 = 2621
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  55. 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 = 2621
      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 = '200'
  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 = 2668
      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 = 2668
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  59. 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 = 2668
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  60. SELECT *
      FROM jos_toc_magazines
      WHERE id = '201'
  61. 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 = 2642
      ORDER BY r.surname ASC
  62. 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 = 2642
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  63. 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 = 2642
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  64. SELECT *
      FROM jos_toc_magazines
      WHERE id = '209'
  65. 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 = 2698
      ORDER BY r.surname ASC
  66. 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 = 2698
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  67. 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 = 2698
      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 = '211'
  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 = 2705
      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 = 2705
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  71. 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 = 2705
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  72. SELECT *
      FROM jos_toc_magazines
      WHERE id = '212'
  73. 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 = 2727
      ORDER BY r.surname ASC
  74. 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 = 2727
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  75. 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 = 2727
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  76. 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 = 2731
      ORDER BY r.surname ASC
  77. 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 = 2731
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  78. 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 = 2731
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  79. SELECT *
      FROM jos_toc_volumes
      WHERE id = '12'
  80. SELECT *
      FROM jos_toc_magazines
      WHERE id = '213'
  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 = 2765
      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 = 2765
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  83. 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 = 2765
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  84. SELECT *
      FROM jos_toc_magazines
      WHERE id = '218'
  85. 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 = 2749
      ORDER BY r.surname ASC
  86. 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 = 2749
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  87. 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 = 2749
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  88. SELECT *
      FROM jos_toc_magazines
      WHERE id = '219'
  89. 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 = 2796
      ORDER BY r.surname ASC
  90. 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 = 2796
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  91. 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 = 2796
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  92. SELECT *
      FROM jos_toc_magazines
      WHERE id = '222'
  93. 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 = 2777
      ORDER BY r.surname ASC
  94. 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 = 2777
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  95. 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 = 2777
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  96. SELECT *
      FROM jos_toc_magazines
      WHERE id = '223'
  97. 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 = 2817
      ORDER BY r.surname ASC
  98. 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 = 2817
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  99. 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 = 2817
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  100. SELECT *
      FROM jos_toc_magazines
      WHERE id = '226'
  101. 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 = 2838
      ORDER BY r.surname ASC
  102. 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 = 2838
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  103. 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 = 2838
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  104. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  105. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  106. 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
  107. 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
  108. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  109. 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
  110. 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
  111. 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
  112. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None