+ ~ -
 

Results 1 - 20 of 29 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genres Cross-genre i
Prose: Autobiography; Biography; Memoirs; Obituary; Anecdotes i
Prose: Short Fiction i
Subject Money; Finance; Banking; Investments; Taxation; Insurance; Debt; Inheritance and Succession
Attachments: 0 · Links: 0 · Hits: 1459

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Travel-writing i
Subjects France—Description and Travel
France—Social Life and Customs
Popular Culture; Amusements
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1077

Article icon.

Painting the Lily

31/5/1851

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Short Fiction i
Subjects France—Description and Travel
Gender Identity; Women; Men; Femininity; Masculinity
Marriage; Courtship; Love; Sex
Attachments: 0 · Links: 0 · Hits: 1081

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Report i
Subjects Education—Europe; Universities and Colleges; Schools
France—Description and Travel
France—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1103

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Travel-writing i
Subjects Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
France—Description and Travel
France—Social Life and Customs
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1074

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Sidney Laman Blanchard
W[illiam] H[enry] Wills
Genre Prose: Report i
Subjects Commercial Products (Commodities); Material Culture; Shopping; Advertising
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
France—Description and Travel
France—History
France—Politics and Government
France—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1149

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Short Fiction i
Subjects France—Social Life and Customs
Marriage; Courtship; Love; Sex
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 1314

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Essay i
Subjects Associations; Institutions; Clubs; Labor Unions
France—Commerce
Music; Musical Instruments; Songs; Singing; Opera
Popular Culture; Amusements
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Theatre; Performing Arts; Performing; Dance; Playwriting; Circus
Attachments: 0 · Links: 0 · Hits: 1058

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Digest; Review i
Subjects Music; Musical Instruments; Songs; Singing; Opera
United States—Description and Travel
United States—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1226

Based on an account in a French newspaper by Monsieur Florentine of Henry Herz's experience in California.

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Sketch i
Subjects Art; Design; Painting; Sculpture; Photography; Interior Decoration;
France—Social Life and Customs
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Theatre; Performing Arts; Performing; Dance; Playwriting; Circus
Attachments: 0 · Links: 0 · Hits: 1142

Article icon.

French Horse-Racing

22/11/1851

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genres Prose: Report i
Prose: Travel-writing i
Subjects France—Description and Travel
Sports; Games; Leisure; Pleasure; Hunting; Horse Racing; Gambling; Duelling
Attachments: 0 · Links: 0 · Hits: 1115

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Sidney Laman Blanchard
W[illiam] H[enry] Wills
Genre Prose: Short Fiction i
Subjects Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Marriage; Courtship; Love; Sex
Money; Finance; Banking; Investments; Taxation; Insurance; Debt; Inheritance and Succession
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 1122

Article icon.

My Aunt in Paris

17/4/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genres Cross-genre i
Prose: Short Fiction i
Prose: Travel-writing i
Subjects France—Description and Travel
France—Social Conditions
France—Social Life and Customs
Money; Finance; Banking; Investments; Taxation; Insurance; Debt; Inheritance and Succession
Poverty; Poor Laws—Great Britain; Workhouses—Great Britain
Attachments: 0 · Links: 0 · Hits: 1104

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Essay i
Subjects Fraud; Forgery; Deception; Betrayal—Fiction
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Attachments: 0 · Links: 0 · Hits: 993

Article icon.

Printed Forgeries

24/7/1852

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Essay i
Subjects Art; Design; Painting; Sculpture; Photography; Interior Decoration;
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Fraud; Forgery; Deception; Betrayal—Fiction
Germany—Description and Travel; Austria—Description and Travel
Great Britain—History
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Newspapers; Periodicals; Journalism
Theatre; Performing Arts; Performing; Dance; Playwriting; Circus
Attachments: 0 · Links: 0 · Hits: 1007

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Travel-writing i
Subjects Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
France—Description and Travel
France—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1076

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Digest; Review i
Subjects Great Britain—Description and Travel
Great Britain—History
Great Britain—Politics and Government
Great Britain—Social Conditions—Nineteenth Century
Great Britain—Social Life and Customs
International relations; International trade; Diplomacy;
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Weather; Meteorology; Climate; Seasons
Attachments: 0 · Links: 0 · Hits: 996

Based on Edmond Texier, Lettres sur l'Angleterre (1851) and Stephen Perlin, A Description of the Kingdoms of England and Scotland (1558).

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genres Prose: Digest; Review i
Prose: Essay i
Subjects Great Britain—Social Life and Customs
International relations; International trade; Diplomacy;
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
National Characteristics; Nationalism
Attachments: 0 · Links: 0 · Hits: 963

Article icon.

The Santals

10/11/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genres Cross-genre i
Prose: Essay i
Prose: Report i
Subjects Great Britain—Colonies—General
India—Description and Travel
India—Politics and Government
India—Social Life and Customs
Race; Racism; Ethnicity; Anthropology; Ethnography
Revolutions; Revolutions—History; Riots; Riots—Fiction; Political Violence
Attachments: 0 · Links: 0 · Hits: 1135

Article icon.

The Road in India

29/12/1855

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Sidney Laman Blanchard
Genre Prose: Travel-writing i
Subjects Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
India—Description and Travel
Transportation; Horse-Drawn Vehicles; Cab and Omnibus Service; Ballooning
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 971


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

Page 1 of 2

Who's Online

We have 762 guests 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.021 seconds, 2.05 MB
Application afterDispatch: 0.510 seconds, 4.80 MB
Application afterRender: 0.583 seconds, 5.27 MB

Memory Usage

5555752

116 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '3392b8480f0600d9c1e75ac833140af2'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1660151385' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '3392b8480f0600d9c1e75ac833140af2'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '3392b8480f0600d9c1e75ac833140af2','1660153185','','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 ( 122 )  
      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 ( 122 )  
      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 = '4'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '50'
  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 = 460
      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 = 460
      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 = 460
      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 = '5'
  27. SELECT *
      FROM jos_toc_magazines
      WHERE id = '66'
  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 = 1048
      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 = 1048
      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 = 1048
      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 = '68'
  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 = 1065
      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 = 1065
      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 = 1065
      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 = '70'
  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 = 1080
      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 = 1080
      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 = 1080
      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 = '75'
  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 = 1121
      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 = 1121
      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 = 1121
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  43. SELECT *
      FROM jos_toc_magazines
      WHERE id = '83'
  44. 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 = 1302
      ORDER BY r.surname ASC
  45. 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 = 1302
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  46. 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 = 1302
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  47. SELECT *
      FROM jos_toc_volumes
      WHERE id = '6'
  48. SELECT *
      FROM jos_toc_magazines
      WHERE id = '85'
  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 = 903
      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 = 903
      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 = 903
      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 = '87'
  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 = 939
      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 = 939
      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 = 939
      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 = '88'
  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 = 967
      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 = 967
      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 = 967
      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 = '92'
  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 = 1019
      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 = 1019
      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 = 1019
      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 = '93'
  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 = 1030
      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 = 1030
      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 = 1030
      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 = '108'
  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 = 1297
      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 = 1297
      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 = 1297
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  72. SELECT *
      FROM jos_toc_volumes
      WHERE id = '7'
  73. SELECT *
      FROM jos_toc_magazines
      WHERE id = '115'
  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 = 1374
      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 = 1374
      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 = 1374
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  77. SELECT *
      FROM jos_toc_magazines
      WHERE id = '126'
  78. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 1454
      ORDER BY r.surname ASC
  79. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 1454
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  80. 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 = 1454
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  81. SELECT *
      FROM jos_toc_magazines
      WHERE id = '129'
  82. 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 = 1528
      ORDER BY r.surname ASC
  83. 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 = 1528
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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
      WHERE id_estate = 1528
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  85. SELECT *
      FROM jos_toc_magazines
      WHERE id = '131'
  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 = 1542
      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 = 1542
      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 = 1542
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  89. SELECT *
      FROM jos_toc_volumes
      WHERE id = '8'
  90. SELECT *
      FROM jos_toc_magazines
      WHERE id = '159'
  91. 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 = 2144
      ORDER BY r.surname ASC
  92. 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 = 2144
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  93. 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 = 2144
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  94. SELECT *
      FROM jos_toc_volumes
      WHERE id = '9'
  95. SELECT *
      FROM jos_toc_magazines
      WHERE id = '178'
  96. 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 = 2217
      ORDER BY r.surname ASC
  97. 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 = 2217
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  98. 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 = 2217
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  99. SELECT *
      FROM jos_toc_volumes
      WHERE id = '13'
  100. SELECT *
      FROM jos_toc_magazines
      WHERE id = '253'
  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 = 2978
      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 = 2978
      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 = 2978
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  104. SELECT *
      FROM jos_toc_magazines
      WHERE id = '260'
  105. 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 = 3108
      ORDER BY r.surname ASC
  106. 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 = 3108
      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  
      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 = 3108
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  108. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  109. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  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 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
  112. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  113. 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
  114. 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
  115. 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
  116. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None