+ ~ -
 

Results 1 - 20 of 20 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.

The Wayside Well

30/3/1850

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subject Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 2698

Article icon.

The Lady Alice

20/4/1850

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
Attachments: 0 · Links: 0 · Hits: 1501

Allingham noted in his diary for Sunday, 7 April 1850: 'A guinea from Household Words for "Lady Alice," with a compliment from Dickens—indicating that at this stage in its publishing history, the magazine paid at least some contributors in advance of publication: in this instance almost as soon as the make-up of the number was decided. Also that the some brief editorial acknowledgement accompanied the payment.

Source: H. Allingham and D. Radford, eds, William Allingham. A Diary (London: Macmillan, 1907), p. 58.

Article icon.

A Cottage Memory

14/9/1850

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1229

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Prose: Travel-writing i
Subjects Ireland—Description and Travel
Religion; Religion and Culture
Religion—Christianity—Catholic Church
Religion—Christianity—General
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1409

Article icon.

Wayconnell Tower

16/11/1850

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Architecture; Building; Housing; Property; Landlord and Tenant;
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1233

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genres Cross-genre i
Prose: Digest; Review i
Prose: Essay i
Prose: Leading Article i
Subjects Ireland—Social Life and Customs
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Music; Musical Instruments; Songs; Singing; Opera
Attachments: 0 · Links: 0 · Hits: 1524

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Prose: Sketch i
Subject Ireland—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1177

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subject Other
Attachments: 0 · Links: 0 · Hits: 1344

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subject Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1132

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Marriage; Courtship; Love; Sex
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1142

Article icon.

Express

25/6/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Railroads
Attachments: 0 · Links: 0 · Hits: 1256

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Myth; Legends; Epic Literature; Fables; Allegory; Folklore
Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
Attachments: 0 · Links: 0 · Hits: 1314

Article icon.

Windlass Song

16/7/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subject Ships; Boats; Shipwrecks; Salvage; Merchant Marine; Sailors; Sailing; Submarines (Ships)
Attachments: 0 · Links: 0 · Hits: 1226

Article icon.

Saint Patrick

5/4/1856

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genres Cross-genre i
Prose: History i
Prose: Sketch i
Subjects Christmas; New Year; Holidays and Seasonal Celebrations
Ireland—Description and Travel
Ireland—Social Life and Customs
Religion; Religion and Culture
Religion—Christianity—Catholic Church
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1178

Article icon.

Our Coachman

1/4/1854

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Other i
Subject Transportation; Horse-Drawn Vehicles; Cab and Omnibus Service; Ballooning
Attachments: 0 · Links: 0 · Hits: 1206

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subjects Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Weather; Meteorology; Climate; Seasons
Attachments: 0 · Links: 0 · Hits: 1091

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative i
Subjects Marriage; Courtship; Love; Sex
Ships; Boats; Shipwrecks; Salvage; Merchant Marine; Sailors; Sailing; Submarines (Ships)
Attachments: 0 · Links: 0 · Hits: 1176

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Narrative 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
Education—Great Britain; Universities and Colleges; Schools
Friendship
Marriage; Courtship; Love; Sex
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1200

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subjects Beauty, Personal; Grooming; Appearance (Philosophy); Physiognomy
Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Gender Identity; Women; Men; Femininity; Masculinity
Attachments: 0 · Links: 0 · Hits: 1105

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Allingham
Genre Poetry: Lyric i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Nature; Nature (Aesthetics); Nature in Literature; Landscapes
Attachments: 0 · Links: 0 · Hits: 1045

Who's Online

We have 659 guests and 2 robots online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.028 seconds, 1.00 MB
Application afterRoute: 0.033 seconds, 2.05 MB
Application afterDispatch: 0.509 seconds, 4.92 MB
Application afterRender: 0.573 seconds, 5.39 MB

Memory Usage

5681448

119 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '3af6e8a77cc9f9fdd5e10731dc052c40'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1634839443' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '3af6e8a77cc9f9fdd5e10731dc052c40'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '3af6e8a77cc9f9fdd5e10731dc052c40','1634841243','','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 ( 50 )  
      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 ( 50 )  
      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 = '3'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '7'
  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 = 92
      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 = 92
      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 = 92
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  26. SELECT *
      FROM jos_toc_magazines
      WHERE id = '10'
  27. 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
  28. 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
  29. 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
  30. SELECT *
      FROM jos_toc_magazines
      WHERE id = '31'
  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
  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 = 307
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  33. 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
  34. SELECT *
      FROM jos_toc_volumes
      WHERE id = '4'
  35. SELECT *
      FROM jos_toc_magazines
      WHERE id = '34'
  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 = 332
      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 = 332
      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 = 332
      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 = '40'
  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
  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 = 367
      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 = 367
      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 = '6'
  44. SELECT *
      FROM jos_toc_magazines
      WHERE id = '100'
  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 = 1201
      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 = 1201
      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 = 1201
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  48. SELECT *
      FROM jos_toc_volumes
      WHERE id = '7'
  49. SELECT *
      FROM jos_toc_magazines
      WHERE id = '128'
  50. 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
  51. 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
  52. 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
  53. SELECT *
      FROM jos_toc_volumes
      WHERE id = '8'
  54. SELECT *
      FROM jos_toc_magazines
      WHERE id = '153'
  55. 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
  56. 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
  57. 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
  58. SELECT *
      FROM jos_toc_volumes
      WHERE id = '9'
  59. SELECT *
      FROM jos_toc_magazines
      WHERE id = '175'
  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 = 2298
      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 = 2298
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  62. 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
  63. SELECT *
      FROM jos_toc_magazines
      WHERE id = '177'
  64. 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
  65. 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
  66. 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
  67. SELECT *
      FROM jos_toc_magazines
      WHERE id = '178'
  68. 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
  69. 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
  70. 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
  71. SELECT *
      FROM jos_toc_magazines
      WHERE id = '180'
  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 = 2223
      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 = 2223
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  74. 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
  75. SELECT *
      FROM jos_toc_magazines
      WHERE id = '181'
  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 = 2323
      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 = 2323
      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 = 2323
      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 = '14'
  80. SELECT *
      FROM jos_toc_magazines
      WHERE id = '275'
  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 = 3214
      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 = 3214
      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 = 3214
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  84. SELECT *
      FROM jos_toc_volumes
      WHERE id = '16'
  85. SELECT *
      FROM jos_toc_magazines
      WHERE id = '321'
  86. 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
  87. 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
  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
      WHERE id_estate = 1800
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  89. SELECT *
      FROM jos_toc_magazines
      WHERE id = '322'
  90. 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
  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
      WHERE id_estate = 1811
      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
      WHERE id_estate = 1811
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  93. SELECT *
      FROM jos_toc_magazines
      WHERE id = '331'
  94. 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
  95. 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
  96. 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
  97. SELECT *
      FROM jos_toc_volumes
      WHERE id = '18'
  98. SELECT *
      FROM jos_toc_magazines
      WHERE id = '390'
  99. 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
  100. 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
  101. 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
  102. SELECT *
      FROM jos_toc_volumes
      WHERE id = '44'
  103. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1173'
  104. 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
  105. 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
  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
      WHERE id_estate = 2449
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  107. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1183'
  108. 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
  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
      WHERE id_estate = 2546
      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
      WHERE id_estate = 2546
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  111. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  112. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  113. 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
  114. 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
  115. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  116. 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
  117. 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
  118. 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
  119. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None