+ ~ -
 

Results 401 - 420 of 423 Article Index

    A?BCDEFGHIJKLMNOPRSTUVWY
Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: Travel-writing i
Subjects Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Italy—Description and Travel
Italy—History—War of 1859; Italy—History—War of 1860-1861 (Wars of Italian Unification); Italy—History—1849-70
Italy—Politics and Government
Italy—Social Life and Customs
Political Persecution; Authoritarianism; Despotism; Censorship; Political Prisoners; Refugees
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1308

Retitled 'The Italian Prisoner' in collected editions of the series

Giuseppe Mazzini (1805–72), the radical leader of the Young Italy movement and joint-leader of the short-lived 'Roman Republic' in 1849, spent much of his life in exile, including many years in London where he ran a school for the sons of Italian exiles in the Tottenham Court Road district (see William Roberts, Prophet in Exile: Joseph Mazzini in England, 1837–1868, 1989, pp. 6–7). Dickens, as Forster records, was 'brought into contact with the great Italian by having given money to a begging imposter who made unauthorised use of his name' (Foster, Book 6, Ch. 6), and their subsequent friendship strengthened Dickens's support for the Italians in their struggle for freedom from what he saw as the twin evils of tyranny and priestcraft. In August 1849, on learning of Mazzini's safe escape after the re-taking of Rome, Dickens drafted an 'Appeal to the English People on Behalf of the Italian Refugees' for the national Italian Appeal Committee, which was published in various newspapers, and The Examiner of 8 September (see The Dickensian, Vol. 10 [1914], p. 320ff.).

Read more...

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Death; Grief; Mourning; Mourning Customs in Literature; Funeral Rites and Ceremonies; Life Cycle, Human; Old Age; Mortality
Escapes; Fugitives from Justice—Fiction
Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Attachments: 0 · Links: 0 · Hits: 861

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Christmas; New Year; Holidays and Seasonal Celebrations
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Escapes; Fugitives from Justice—Fiction
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Attachments: 0 · Links: 0 · Hits: 842

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Escapes; Fugitives from Justice—Fiction
Attachments: 0 · Links: 0 · Hits: 827

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Christmas; New Year; Holidays and Seasonal Celebrations
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Education—Great Britain; Universities and Colleges; Schools
Escapes; Fugitives from Justice—Fiction
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 894

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Marriage; Courtship; Love; Sex
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 905

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Education—Great Britain; Universities and Colleges; Schools
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 845

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Marriage; Courtship; Love; Sex
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Violence; Torture; Violence in Literature; Violence—Moral and Ethical Aspects; Violence—Psychological Aspects
Attachments: 0 · Links: 0 · Hits: 920

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: Serial Fiction i
Subjects Character; Character Sketches; Caricature
Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Gender Identity; Women; Men; Femininity; Masculinity
Marriage; Courtship; Love; Sex
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Violence; Torture; Violence in Literature; Violence—Moral and Ethical Aspects; Violence—Psychological Aspects
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 807

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Health; Diseases; Personal Injuries; Hygiene; Cleanliness—Fiction
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Violence; Torture; Violence in Literature; Violence—Moral and Ethical Aspects; Violence—Psychological Aspects
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 897

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Character; Character Sketches; Caricature
Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Education—Great Britain; Universities and Colleges; Schools
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Gender Identity; Women; Men; Femininity; Masculinity
People with Disabilities; Human Body—Social Aspects; Human Bodies in Literature
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Violence; Torture; Violence in Literature; Violence—Moral and Ethical Aspects; Violence—Psychological Aspects
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 856

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
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: 806

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Fashion; Fashion History; Clothing and Dress; Millinery; Textile Crafts; Textile Design; Cotton; Cotton Manufacture
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;
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 859

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Law; Lawyers; Justice; Courts; Trials
London (England)—Description and Travel
Urbanization; Urban Life and Landscapes
Attachments: 0 · Links: 0 · Hits: 888

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Friendship
Great Britain—Social Life and Customs
London (England)—Description and Travel
Work; Work and Family; Occupations; Professions; Wages
Attachments: 0 · Links: 0 · Hits: 787

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Education—Great Britain; Universities and Colleges; Schools
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Law; Lawyers; Justice; Courts; Trials
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: 874

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Architecture; Building; Housing; Property; Landlord and Tenant;
Celebrations; Parties; Balls (Parties); Balls (Parties)—Fiction
Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Food; Cooking; Gastronomy; Alcohol; Bars (Drinking Establishments); Restaurants; Dinners and Dining
Law; Lawyers; Justice; Courts; Trials
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 808

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

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Leading Article i
Prose: Serial Fiction i
Subjects Ethics; Morals; Moral Development; Moral Education; Philosophy; Values
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Social classes; Class distinctions; Aristocracy (Social Class); Aristocracy (Social Class)—Fiction; Middle Class; Working Class; Servants;
Attachments: 0 · Links: 0 · Hits: 968

Article icon.

The Village

25/12/1860

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: Occasional (Christmas Story; article in Christmas or New Year Number, &c) i
Subjects Great Britain—Description and Travel
Ships; Boats; Shipwrecks; Salvage; Merchant Marine; Sailors; Sailing; Submarines (Ships)
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1041


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

Page 21 of 22

Who's Online

We have 1247 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.019 seconds, 2.05 MB
Application afterDispatch: 0.506 seconds, 4.83 MB
Application afterRender: 0.590 seconds, 5.30 MB

Memory Usage

5590064

109 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '9d1e1a0dec13e67cc7e3247a1fcba2fe'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1660488967' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '9d1e1a0dec13e67cc7e3247a1fcba2fe'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '9d1e1a0dec13e67cc7e3247a1fcba2fe','1660490767','','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 ( 1 )  
      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 ( 1 )  
      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 400, 20
  20. SELECT *
      FROM jos_toc_periodicals
      WHERE id = '2'
  21. SELECT *
      FROM jos_toc_volumes
      WHERE id = '46'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1211'
  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 = 4351
      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 = 4351
      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 = 4351
      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 = '1218'
  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 = 4391
      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 = 4391
      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 = 4391
      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 = '1219'
  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 = 4404
      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 = 4404
      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 = 4404
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  34. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1220'
  35. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 4412
      ORDER BY r.surname ASC
  36. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 4412
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  37. 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 = 4412
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  38. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1221'
  39. 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 = 4424
      ORDER BY r.surname ASC
  40. 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 = 4424
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  41. 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 = 4424
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  42. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1222'
  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 = 4425
      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 = 4425
      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 = 4425
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  46. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1223'
  47. 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 = 4437
      ORDER BY r.surname ASC
  48. 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 = 4437
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  49. 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 = 4437
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  50. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1224'
  51. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 4440
      ORDER BY r.surname ASC
  52. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 4440
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  53. 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 = 4440
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  54. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1225'
  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 = 4449
      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 = 4449
      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 = 4449
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  58. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1226'
  59. 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 = 4456
      ORDER BY r.surname ASC
  60. 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 = 4456
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  61. 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 = 4456
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  62. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1227'
  63. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 4467
      ORDER BY r.surname ASC
  64. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 4467
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  65. 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 = 4467
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  66. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1228'
  67. 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 = 4470
      ORDER BY r.surname ASC
  68. 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 = 4470
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  69. 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 = 4470
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  70. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1229'
  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 = 4482
      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 = 4482
      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 = 4482
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  74. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1230'
  75. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 4484
      ORDER BY r.surname ASC
  76. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 4484
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  77. 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 = 4484
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  78. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1231'
  79. 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 = 4498
      ORDER BY r.surname ASC
  80. 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 = 4498
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  81. 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 = 4498
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  82. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1232'
  83. 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 = 4500
      ORDER BY r.surname ASC
  84. 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 = 4500
      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  
      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 = 4500
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  86. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1233'
  87. 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 = 4511
      ORDER BY r.surname ASC
  88. 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 = 4511
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  89. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp  
      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 = 4511
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  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 = 4517
      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 = 4517
      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 = 4517
      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 = '1234'
  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 = 4516
      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 = 4516
      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 = 4516
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  97. SELECT *
      FROM jos_toc_magazines
      WHERE id = '1235'
  98. 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 = 4533
      ORDER BY r.surname ASC
  99. 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 = 4533
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  100. 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 = 4533
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  101. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  102. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  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
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  104. 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
  105. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  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
      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
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  108. 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
  109. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None