+ ~ -
 

Results 21 - 40 of 194 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Eliza Griffiths
Genre Poetry: Narrative i
Subjects Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
France—History
War; Battles; Peace; Military History; Weapons; Soldiers
Attachments: 0 · Links: 0 · Hits: 1103

Article icon.

"Moving"

2/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Authors William Blanchard Jerrold
W[illiam] H[enry] Wills
Genre Prose: Essay i
Subjects Architecture; Building; Housing; Property; Landlord and Tenant;
Urbanization; Urban Life and Landscapes
Attachments: 0 · Links: 0 · Hits: 959

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Henry Morley
Genre Prose: Essay i
Subjects France—Description and Travel
France—Social Life and Customs
Money; Finance; Banking; Investments; Taxation; Insurance; Debt; Inheritance and Succession
Theatre; Performing Arts; Performing; Dance; Playwriting; Circus
Attachments: 0 · Links: 0 · Hits: 852

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Unknown
Genre Prose: Editorial i
Subject Newspapers; Periodicals; Journalism
Attachments: 0 · Links: 0 · Hits: 1031

Correction of statement made in "Underwriting", Household Words, Volume V, No. 128 (September 4 1852).

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Hugh Hislop Elliot
Unknown
Genre Prose: Snippet i
Subjects Animals; Domestic Animals; Pets; Working Animals; Birds; Insects
India—Description and Travel
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Attachments: 0 · Links: 0 · Hits: 1078

Article icon.

Belgian Briskness

2/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Howard Russell
Genre Prose: Travel-writing i
Subjects Communication; Telegraph; Postal Service
Europe—Description and Travel
Railroads
Attachments: 0 · Links: 0 · Hits: 967

Article icon.

Our Bore

9/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Sketch i
Subjects Character; Character Sketches; Caricature
Europe—Description and Travel
Health; Diseases; Personal Injuries; Hygiene; Cleanliness—Fiction
National Characteristics; Nationalism
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1299

The writing of 'sketches of character', descriptions of social, moral or occupational types, was a flourishing genre in the first half of the nineteenth century, both in France and in Britain. Notable practitioners were Charles Lamb and Leigh Hunt, and Dickens himself had supplied several specimens in his Sketches by Boz (see also his 1837 Bentley's piece, 'Some Particulars Concerning a Lion' in Vol. 1 of [the Dent Uniform Edition of Dickens' Journalism], pp. 508–12). A classic collection of such pieces was the artist Kenny Meadows's Heads of the People (1840), in which his 'portraits' accompanied essays by Douglas Jerrold, Leigh Hunt and others with such titles as 'The Diner-Out', 'The Spoilt Child', 'The Teetotaller', and so on.

Read more...

Article icon.

Wholesale Diving

9/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Edmund Saul Dixon
Genre Prose: Travel-writing i
Subjects Agriculture; Fishing; Forestry; Gardening; Horticulture
France—Description and Travel
Inventors; Inventions
Science; Science—History; Technology; Technological innovations; Discoveries in Science
Ships; Boats; Shipwrecks; Salvage; Merchant Marine; Sailors; Sailing; Submarines (Ships)
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 1249

Article icon.

Sunday Morning

9/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author George Augustus Sala
Genres Cross-genre i
Prose: Autobiography; Biography; Memoirs; Obituary; Anecdotes i
Prose: Essay i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Civilization—Classical
Education—Great Britain; Universities and Colleges; Schools
Great Britain—Social Life and Customs
London (England)—Description and Travel
Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1038

Article icon.

Speed the Plough

9/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Edmund Ollier
Genre Poetry: Narrative i
Subjects Agriculture; Fishing; Forestry; Gardening; Horticulture
Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
Attachments: 0 · Links: 0 · Hits: 1009

Article icon.

Blind Sight-Seeing

9/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Louisa Stuart Costello
Genre Prose: Travel-writing i
Subjects Architecture; Building; Housing; Property; Landlord and Tenant;
France—Description and Travel
France—History
Monarchy
National Characteristics; Nationalism
People with Disabilities; Human Body—Social Aspects; Human Bodies in Literature
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 983

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Henry Morley
Genres Prose: Digest; Review i
Prose: Travel-writing i
Subjects Animals; Domestic Animals; Pets; Working Animals; Birds; Insects
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Race; Racism; Ethnicity; Anthropology; Ethnography
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
United States—Description and Travel
United States—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 845

from Edward R. Sullivan, Rambles and Scrambles in North and South America, 1852.

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subjects Great Britain—History
Monarchy
War; Battles; Peace; Military History; Weapons; Soldiers
Attachments: 0 · Links: 0 · Hits: 1337

Compiled in large part from Thomas Keightley, The History of England, and from George L. Craik and Charles MacFarlane, The Pictorial History of England.

Article icon.

Advertisements

9/10/1852

Read me now!
Genre Advertisement(s) i
Subject Other
Attachments: 0 · Links: 0 · Hits: 876
Advertisement for the Second Volume of A Child's History of England
Article icon.

Penny Wisdom

16/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author George Dodd
Genres Prose: Essay i
Prose: Leading Article i
Subjects Manufacturing processes; Manufacturing; Factories; Factory Management; Industrial Waste
Physical Sciences (Chemistry / Earth Sciences / Geography / Mathematics / Metallurgy / Physics)
Attachments: 0 · Links: 0 · Hits: 1409

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author George Augustus Sala
Genre Prose: Sketch i
Subjects Great Britain—Social Life and Customs
London (England)—Description and Travel
Popular Culture; Amusements
Race; Racism; Ethnicity; Anthropology; Ethnography
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Urbanization; Urban Life and Landscapes
Attachments: 0 · Links: 0 · Hits: 944

Article icon.

Graves and Epitaphs

16/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author James Hannay
Genre Prose: Essay i
Subjects Health; Diseases; Personal Injuries; Hygiene; Cleanliness—Fiction
Historiography; Archaeology; Genealogy; Archives
Religion; Religion and Culture
Religion—Christianity—General
Attachments: 0 · Links: 0 · Hits: 1012

Article icon.

Hops

16/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author William Moy Thomas
Genre Prose: Report i
Subjects Agriculture; Fishing; Forestry; Gardening; Horticulture
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 1135

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Anne d'Archambault Grenville Murray
Genre Prose: Travel-writing i
Subjects Great Britain—Description and Travel
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Attachments: 0 · Links: 0 · Hits: 982

Article icon.

An Opium Factory

16/10/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author H. H. Maxwell
Genres Prose: Report i
Prose: Travel-writing i
Subjects Agriculture; Fishing; Forestry; Gardening; Horticulture
Great Britain—Colonies—Commerce
India—Description and Travel
Life Sciences (Physiology / Biology / Immunology / Medicine / Pharmacology / Anatomy / Ecology)
Manufacturing processes; Manufacturing; Factories; Factory Management; Industrial Waste
Attachments: 0 · Links: 0 · Hits: 991


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

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
«StartPrev12345678910NextEnd»

Page 2 of 10

Who's Online

We have 1022 guests, 1 member and 2 robots online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.016 seconds, 1.00 MB
Application afterRoute: 0.019 seconds, 2.06 MB
Application afterDispatch: 0.613 seconds, 4.59 MB
Application afterRender: 0.691 seconds, 5.06 MB

Memory Usage

5342104

90 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'b3195457d45c1328ae9e18a4cf4a262c'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1657208408' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'b3195457d45c1328ae9e18a4cf4a262c'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b3195457d45c1328ae9e18a4cf4a262c','1657210208','','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. 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  
      WHERE (block.published = 1)
      AND block.id_periodical = 1
      AND block.id_volume = 8
  9. 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;
  10. 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;
  11. 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;
  12. 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;
  13. 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  
      GROUP BY id_block;
  14. 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 block.id_periodical = 1
      AND block.id_volume = 8
      ORDER BY id_magazine, id_page, ordering ASC  
      LIMIT 20, 20
  15. SELECT *
      FROM jos_toc_periodicals
      WHERE id = '1'
  16. SELECT *
      FROM jos_toc_volumes
      WHERE id = '8'
  17. SELECT *
      FROM jos_toc_magazines
      WHERE id = '139'
  18. 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 = 2009
      ORDER BY r.surname ASC
  19. 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 = 2009
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  20. 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 = 2009
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  21. 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 = 2010
      ORDER BY r.surname ASC
  22. 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 = 2010
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  23. 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 = 2010
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  24. 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 = 2011
      ORDER BY r.surname ASC
  25. 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 = 2011
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  26. 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 = 2011
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 2015
      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 = 2015
      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 = 2015
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  30. 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 = 2013
      ORDER BY r.surname ASC
  31. 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 = 2013
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  32. 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 = 2013
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  33. 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 = 2016
      ORDER BY r.surname ASC
  34. 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 = 2016
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  35. 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 = 2016
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  36. SELECT *
      FROM jos_toc_magazines
      WHERE id = '140'
  37. 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 = 1992
      ORDER BY r.surname ASC
  38. 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 = 1992
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  39. 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 = 1992
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 1996
      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 = 1996
      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 = 1996
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  43. 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 = 1997
      ORDER BY r.surname ASC
  44. 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 = 1997
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  45. 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 = 1997
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  46. 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 = 1998
      ORDER BY r.surname ASC
  47. 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 = 1998
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  48. 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 = 1998
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 1999
      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 = 1999
      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 = 1999
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  52. 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 = 2001
      ORDER BY r.surname ASC
  53. 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 = 2001
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  54. 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 = 2001
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 2005
      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 = 2005
      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 = 2005
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  58. 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 = 2006
      ORDER BY r.surname ASC
  59. 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 = 2006
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  60. 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 = 2006
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  61. SELECT *
      FROM jos_toc_magazines
      WHERE id = '141'
  62. 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 = 2019
      ORDER BY r.surname ASC
  63. 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 = 2019
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  64. 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 = 2019
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 2020
      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 = 2020
      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 = 2020
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 2022
      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 = 2022
      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 = 2022
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  71. 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 = 2024
      ORDER BY r.surname ASC
  72. 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 = 2024
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  73. 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 = 2024
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  74. 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 = 2025
      ORDER BY r.surname ASC
  75. 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 = 2025
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  76. 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 = 2025
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  77. 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 = 2027
      ORDER BY r.surname ASC
  78. 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 = 2027
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  79. 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 = 2027
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  80. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  81. SELECT volume.id AS VALUE, volume.title AS text    
      FROM jos_toc_volumes AS volume
      LEFT JOIN jos_toc_periodicals AS periodical    
      ON volume.id_periodical = periodical.id
      WHERE  (periodical.published = 1
      AND volume.published = 1)
      AND (periodical.id = 1)
      ORDER BY volume.ordering
  82. SELECT magazine.id AS VALUE, magazine.title AS text  
      FROM jos_toc_magazines AS magazine  
      LEFT JOIN jos_toc_volumes AS volume
      ON (magazine.id_volume = volume.id)
      LEFT JOIN jos_toc_periodicals AS periodical
      ON (volume.id_periodical = periodical.id)
      WHERE  (periodical.published = 1
      AND volume.published = 1
      AND magazine.published = 1)
      AND (periodical.id = 1)
      AND (volume.id = 8)
      ORDER BY magazine.title
  83. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  84. 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
  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
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  86. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  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
      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
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  89. 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
  90. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None