+ ~ -
 

Results 121 - 140 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: Snippet i
Subject Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
Attachments: 0 · Links: 0 · Hits: 978

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: Report i
Subjects Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Great Britain—Social Conditions—Nineteenth Century
London (England)—Description and Travel
Police; Detectives; Mystery and Detective Stories; Mystery; Mystery Fiction; Forensic Sciences
Ships; Boats; Shipwrecks; Salvage; Merchant Marine; Sailors; Sailing; Submarines (Ships)
Urbanization; Urban Life and Landscapes
Attachments: 0 · Links: 0 · Hits: 1413

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Essay i
Prose: Leading Article i
Subjects Great Britain—History
Great Britain—Social Conditions—Nineteenth Century
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Attachments: 0 · Links: 0 · Hits: 1051

In this article, as in 'Gone to the Dogs' [HW, Vol. XI, 10 March 1855] (article 36 [in the Dent Uniform Edition of Dickens' Journalism Vol. 3, pp. 283–91]), Dickens uses a device that enables him to string together a number of disparate satirical points he wishes to make. The contrast between the money spent in honouring Nelson and that spent in honouring Wellington connects with his earlier condemnation of the costly and ostentatious State Funeral given to the latter [see 'Trading in Death', HW, Vol. VI. 27 November 1852]. The allusion to a 'pauper provision' for Nelson's daughter concerns Horatia, his daughter by Lady Hamilton, officially known as his 'adopted' daughter until his paternity became public knowledge in 1849. In his will Nelson famously left Lady Hamilton as 'a legacy to my King and Country'; also Horatia, to 'the beneficence of my country'. But the death of Pitt meant that no public provision was arranged for the women.

Read more...

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subjects Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Great Britain—History
Great Britain—Politics and Government
Monarchy
Religion; Religion and Culture
Religion—Christianity—Catholic Church
Religion—Christianity—Church of England
Attachments: 0 · Links: 0 · Hits: 889

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.
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 Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Christmas; New Year; Holidays and Seasonal Celebrations
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
London (England)—Description and Travel
Poverty; Poor Laws—Great Britain; Workhouses—Great Britain
Attachments: 0 · Links: 0 · Hits: 2229

Article icon.

The Child's Story

25/12/1852

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 Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Progress; Memory; Commemoration; Nostaliga; Time—Social Aspects; Time—Psychological Aspects; Time perception;
Travel; Tourism; Hotels; Resorts; Seaside Resorts—Fiction; Passports;
Attachments: 0 · Links: 0 · Hits: 1477

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 1188

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.
Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Charles Dickens
W[illiam] H[enry] Wills
Genres Prose: Leading Article i
Prose: Report i
Subjects Charity; Philanthropists; Philanthropists—Fiction; Benevolence
Children; Childhood; Pregnancy; Childbirth; Child Rearing; Adoption; Child Labor
Family Life; Families; Domestic Relations; Sibling Relations; Kinship; Home;
Great Britain—Social Conditions—Nineteenth Century
Medical care; Nursing; Hospitals; Hospital Care; Surgery; Medicine; Physicians
Attachments: 0 · Links: 0 · Hits: 3432

Dickens probably wrote the following portions of 'Received, a Blank Child': from 'Proceeding to visit' (p. 51) to 'sensation at all' (p. 52); from 'But, as we were leaving' (p. 52) to 'Joe ... £500' (p. 53).
Dickens may also have written or added substantially to the following passages: from the beginning to 'at this day' (p. 49); from 'Such is the home' (p. 53) to the conclusion.
In addition, Dickens seems to have gone over and emended the following section: from 'One end' to 'with the hospital' (p. 52).
Finally, Dickens seems to have added touches to passages primarily by Wills - for example, he may have added the sentence beginning, 'But, though shipwrecked' (p. 50). For a discussion of the Dickens-Wills attributions, see note to 'Valentine's Day at the Post-Office'.
'Received, a Blank Child' gives an account of the history and methods of the famous London Foundling Hospital. Dickens had long been interested in 'the Foundling.' He mentioned 'the Foundling' in such early works as 'The Boarding-House' (Sketches by Boz, 1836) and Barnaby Rudge (1841), and he made the Hospital figure significantly in such later works as Little Dorrit (1855-1857) and No Thoroughfare (1867).

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

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 967

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.

H.W.

16/4/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Charles Dickens
Henry Morley
Genres Prose: Essay i
Prose: Leading Article i
Subjects Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Newspapers; Periodicals; Journalism
Attachments: 0 · Links: 0 · Hits: 1137

Dickens probably wrote the following portions of 'H. W.': from the beginning to 'undergone or seen' (p. 146); from 'The copies' (p. 149) to the conclusion.
Dickens seems also to have added touches to passages primarily by Morley. For example, Dickens probably interpolated such sentences as the following: the sentence beginning 'H. W. is in this form' (p. 147); the sentence beginning 'In other respects' (p. 147).
The latter sentence is built up of imagery from the melodrama The Miller and His Men (1813) by Isaac Pocock (1782-1835). The Miller and His Men captured Dickens' imagination in his boyhood and early teens when he helped stage the play in elaborate toy-theatre productions. The play is the source of scores of allusions in Dickens' writings.

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

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Essay i
Prose: Leading Article i
Subjects Associations; Institutions; Clubs; Labor Unions
Charity; Philanthropists; Philanthropists—Fiction; Benevolence
Education—Great Britain; Universities and Colleges; Schools
Emigration; Immigration; Expatriation
Gender Identity; Women; Men; Femininity; Masculinity
Attachments: 0 · Links: 0 · Hits: 1350

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Digest; Review i
Prose: Leading Article i
Subjects Newspapers; Periodicals; Journalism
Supernatural; Superstition; Spiritualism; Clairvoyance; Mesmerism; Ghosts; Fairies; Witches; Magic; Occultism
United States—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 1430

Excerpts from the New York Spiritual Telegraph.

Article icon.

In and Out of Jail

14/5/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Charles Dickens
Henry Morley
W[illiam] H[enry] Wills
Genres Prose: Digest; Review i
Prose: Leading Article i
Prose: Short Fiction i
Subjects Crime; Criminals; Punishment; Capital Punishment; Prisons; Penal Transportation; Penal Colonies
Literature; Writing; Authorship; Reading; Books; Poetry; Storytelling; Letter Writing
Attachments: 0 · Links: 0 · Hits: 1278

Dickens probably wrote the following portion of 'In and Out of Jail': from 'I go further still' (p. 244) to the conclusion.
Dickens may also have written or added to the following passage: from 'Thus far' to 'Mr. Hill proposes' (p. 244).
In addition, Dickens seems to have added touches to the following passage: from the beginning to ''without mercy'' (p. 242).
Finally, Dickens seems to have interpolated brief comments elsewhere in the essay.
This article, a review of Frederic Hill's Crime: Its Amount, Causes, and Remedies (1853), was originally written by Morley under the title of 'A Doctor of Morals.' Dickens was dissatisfied and instructed Wills to make changes (see letter of 10 March 1853 below), but apparently was still dissatisfied when he saw Wills' revision, and finally reworked the piece himself, editing it and adding the passages listed above.
Dickens' letter to Wills gives some indication of how strictly he controlled the editorial policies of Household Words, how closely those policies followed his own ideas, and how pervasively he colored articles not his own, by his known predilections and editorial assignments, as well as by interpolating phrases, comments, and sometimes long passages. In this instance, portions of Morley's piece ran counter to Dickens' published views. Dickens writes:

A Doctor of Morals, impossible of insertion as it stands. A mere puff for Hill, with all the difficult parts of the question blinked, and many statements utterly at variance with what I am known to have written. It is exactly because the great bulk of offences in a great number of places are committed by professed thieves, that it will not do to have Pet Prisoning advocated, without grave remonstrance and great care [see 'Pet Prisoners' by Dickens, Household Words, 27 April 1850; see also 'Cain in the Fields', Household Words, 10 May 1851]. That class of prisoner is not to be reformed. We must begin at the beginning and prevent by stringent education and supervision of wicked parents, that class of prisoner from being regularly supplied as if he were a human necessity.
Do they teach trades in workhouses, and try to fit their people (the worst part of them) for Society? Come with me to Tothill Fields Bridewell, or to Shepherd's Bush [the former was a prison for petty offenders, the latter a home for "fallen women" founded by Angela Burdett-Coutts with Dickens' very active participation], and I will show you what a workhouse girl is. Or look to my Walk in a Workhouse (in H. W . [25 May 1850]) and to the glance at the youths I saw in one place, positively kept like wolves.
Mr. Hill thinks prisons could be made nearly self-supporting. Have you any idea of the difficulty that is found in disposing of Prison-Work? Or does he know that the Treadmills didn't grind the air because the State or the Magistracy objected to the competition of prison labour with free labour, but because the work could not be got?
I never can have any kind of prison discipline disquisition in H. W. that does not start with the first great principle I have laid down, and that does not protest against prisons being considered per se. Whatever chance is given to a man in a prison, must be given to a man in a refuge for distress.
The article in itself is very good, but it must have these points in it; otherwise I am not only compromising opinions I am known to hold, but the journal itself is blowing hot and cold and playing fast and loose, in a ridiculous way ...
Let me see a revise when you have got it together ...

Dickens saw the 'revise' and then reworked the article himself.

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

Based largely on Frederic Hill, Crime: Its Amount, Causes, and Remedies (1853).

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 888

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.

Idiots

4/6/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Authors Charles Dickens
W[illiam] H[enry] Wills
Genres Prose: Leading Article i
Prose: Report i
Subjects Medical care; Nursing; Hospitals; Hospital Care; Surgery; Medicine; Physicians
People with Disabilities; Human Body—Social Aspects; Human Bodies in Literature
Psychology; Psychiatry; Mental Health; Mind-Body Relations (Metaphysics)
Attachments: 0 · Links: 0 · Hits: 1206

Dickens probably wrote the following portions of 'Idiots': the opening paragraph; from 'To this establishment' (p. 316) to the conclusion.
In addition, Dickens seems to have added touches elsewhere - for example, the interjection beginning '- whose name has a peculiar attraction' (p. 314). For a discussion of the Dickens-Wills attributions, see note to 'Valentine's Day at the Post-Office'.
'Idiots' grew out of a visit to Park House Asylum, Highgate. Park House and its sister institution, Essex Hall Asylum, near Colchester, were closely associated with Dickens' friend, Dr. John Conolly (1794-1866), a pioneer in the humane treatment of the insane. Dickens and Wills planned the visit and the article with a view to helping these new institutions. In an unpublished letter to Wills (14 April 1853), now in the Huntington Library, Dickens discussed with Wills the arrangements then being concluded with Conolly for visits to Highgate and Colchester. The plan was to tour Highgate (probably on 21 April) and to decide on the basis of that visit whether it would be advisable to tour Colchester as well. Apparently the latter visit was not deemed necessary.
The treatment of the insane, like the treatment of the blind, the deaf, the poor, the sick, and the criminal, always interested Dickens. He often visited insane asylums, and his writings - from Nicholas Nickleby (1838-1839) to Little Dorrit (1855-1857), and from American Notes (1842) to All the Year Round (1859-1870) - attest to his lifelong interest in the nature and treatment of insanity. For another article by Dickens and Wills on an institution for the mentally ill, see 'A Curious Dance Round a Curious Tree'.

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

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 905

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.

The Noble Savage

11/6/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Prose: Essay i
Prose: Leading Article i
Subjects Africa—Social Life and Customs
Myth; Legends; Epic Literature; Fables; Allegory; Folklore
Race; Racism; Ethnicity; Anthropology; Ethnography
United States—Social Life and Customs
Attachments: 0 · Links: 0 · Hits: 9160

Dickens was provoked into writing this article by the renewed public enthusiasm for the eighteenth-century concept of 'the noble savage', of a 'purer' moral nature to be found in dark-skinned races who had not been 'corrupted' by civilisation. This enthusiasm was given a focus by the latest show presenting native Africans to be staged in London, a party of 'Zulu Kaffirs' brought over by A. T. Caldecott, a merchant from Natal, which had been annexed to Cape Colony by the British in 1843. The troupe consisting of eleven men, one woman and a child, appeared at the fashionable St George's Gallery, Hyde Park Corner, and performed scenes illustrative of daily life in their native environment enlivened with 'characteristic dances'. The Times announced the event (18 May 1853) as 'a novel and most interesting exhibition with appropriate scenery and moving panorama painted expressly by Mr Charles Marshall'. 

Read more...

Article icon.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 989

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.
Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genre Prose: History i
Subject Great Britain—History
Attachments: 0 · Links: 0 · Hits: 3620

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.

A Haunted House

23/7/1853

Read me now! Export to PDF, including full article record, author information, and annotation.
Author Charles Dickens
Genres Cross-genre i
Prose: Essay i
Prose: Leading Article i
Prose: Short Fiction i
Subject Great Britain—Politics and Government
Attachments: 0 · Links: 0 · Hits: 1169

Dickens begins this exercise in satirical allegory by alluding to the slow progress and ever-rising expense of the rebuilding of the Houses of Parliament after their destruction by fire in 1834, two years after the Reform Bill had increased the number of MPs. There was much public debate in the autumn of 1845, as to whether a statue of Cromwell should be included in a series of statues of the kings and queens of England (see, for example, The Times leader of 16 September 1845). The 'Cartoons' were designs for frescoes illustrative of the nation's history submitted by artists competing for the commission to decorate the walls of the new building. They were shown in a series of public exhibitions in Westminster Hall (see ['The Spirit of Chivalry: in Westminster Hall', Douglas Jerrold's Shilling Magazine (August 1845),] Vol. 2 of [the Dent Uniform Edition of Dickens' Journalism], p. 74) – Dickens had already mocked British artists' enthusiasm for 'the German taste' with their fondness for beards in 'The Ghost of Art' (HW, [Vol. I,] 20 July 1850; see Vol. 2 of [the Dent Uniform Edition of Dickens' Journalism], pp. 257–64). His description of MPs' rowdiness and verbosity echoes much similar satire in his writings, most notably in David Copperfield, Chap. 34.

Read more...


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 7 of 22

Who's Online

We have 128 guests and 1 robot online.

Profile Information

Application afterLoad: 0.000 seconds, 0.28 MB
Application afterInitialise: 0.011 seconds, 1.00 MB
Application afterRoute: 0.014 seconds, 2.05 MB
Application afterDispatch: 0.377 seconds, 4.82 MB
Application afterRender: 0.423 seconds, 5.31 MB

Memory Usage

5599672

107 queries logged

  1. SELECT *
      FROM jos_session
      WHERE session_id = '14a0266a319dfc2370bec4281ea4ae68'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1635019443' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '14a0266a319dfc2370bec4281ea4ae68'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '14a0266a319dfc2370bec4281ea4ae68','1635021243','','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 120, 20
  20. SELECT *
      FROM jos_toc_periodicals
      WHERE id = '1'
  21. SELECT *
      FROM jos_toc_volumes
      WHERE id = '8'
  22. SELECT *
      FROM jos_toc_magazines
      WHERE id = '154'
  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 = 2121
      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 = 2121
      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 = 2121
      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 = '157'
  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 = 2135
      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 = 2135
      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 = 2135
      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 = '158'
  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 = 2534
      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 = 2534
      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 = 2534
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  34. 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 = 2545
      ORDER BY r.surname ASC
  35. 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 = 2545
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  36. 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 = 2545
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  37. SELECT *
      FROM jos_toc_magazines
      WHERE id = '161'
  38. 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 = 2074
      ORDER BY r.surname ASC
  39. 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 = 2074
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  40. 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 = 2074
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  41. 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 = 2082
      ORDER BY r.surname ASC
  42. 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 = 2082
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  43. 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 = 2082
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  44. SELECT *
      FROM jos_toc_volumes
      WHERE id = '9'
  45. SELECT *
      FROM jos_toc_magazines
      WHERE id = '163'
  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 = 2258
      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 = 2258
      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 = 2258
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  49. SELECT *
      FROM jos_toc_magazines
      WHERE id = '164'
  50. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 2160
      ORDER BY r.surname ASC
  51. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 2160
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  52. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp  
      FROM jos_toc_blocks_subjects AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_subjects_links
      WHERE id_estate = 2160
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  53. SELECT *
      FROM jos_toc_magazines
      WHERE id = '167'
  54. 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 = 2273
      ORDER BY r.surname ASC
  55. 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 = 2273
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  56. 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 = 2273
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  57. SELECT *
      FROM jos_toc_magazines
      WHERE id = '168'
  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 = 2175
      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 = 2175
      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 = 2175
      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 = '169'
  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 = 2275
      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 = 2275
      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 = 2275
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  65. SELECT *
      FROM jos_toc_magazines
      WHERE id = '171'
  66. 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 = 2281
      ORDER BY r.surname ASC
  67. 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 = 2281
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  68. 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 = 2281
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  69. SELECT *
      FROM jos_toc_magazines
      WHERE id = '172'
  70. 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 = 2188
      ORDER BY r.surname ASC
  71. 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 = 2188
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  72. 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 = 2188
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  73. SELECT r.id, r.id, r.alias, r.title, r.names, r.surname
      FROM jos_toc_authors AS r  RIGHT JOIN jos_toc_blocks_authors AS l
      ON  r.id = l.id_author  
      WHERE l.id_block = 2194
      ORDER BY r.surname ASC
  74. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp , insignia.definition
      FROM jos_toc_blocks_genres AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_genres_links
      WHERE id_estate = 2194
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  75. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp  
      FROM jos_toc_blocks_subjects AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_subjects_links
      WHERE id_estate = 2194
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  76. SELECT *
      FROM jos_toc_magazines
      WHERE id = '175'
  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 = 2296
      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 = 2296
      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 = 2296
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  80. 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 = 2301
      ORDER BY r.surname ASC
  81. 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 = 2301
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  82. 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 = 2301
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  83. SELECT *
      FROM jos_toc_magazines
      WHERE id = '176'
  84. 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 = 2204
      ORDER BY r.surname 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
      WHERE id_estate = 2204
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  86. 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 = 2204
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  87. SELECT *
      FROM jos_toc_magazines
      WHERE id = '177'
  88. 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 = 2310
      ORDER BY r.surname ASC
  89. 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 = 2310
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  90. 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 = 2310
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  91. SELECT *
      FROM jos_toc_magazines
      WHERE id = '181'
  92. 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 = 2327
      ORDER BY r.surname ASC
  93. 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 = 2327
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  94. 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 = 2327
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  95. SELECT *
      FROM jos_toc_magazines
      WHERE id = '182'
  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 = 2229
      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 = 2229
      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 = 2229
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  99. SELECT id AS VALUE, title AS text
      FROM jos_toc_periodicals
      WHERE published = 1
      ORDER BY title
  100. SELECT id AS VALUE, surname AS text
      FROM jos_toc_authors
      WHERE published = 1
      ORDER BY surname
  101. SELECT insignia.id, insignia.title, IFNULL(link.stamp, 0) AS stamp  
      FROM jos_toc_blocks_subjects AS insignia  
      LEFT JOIN ( SELECT id_insignia, COUNT(id_insignia) AS stamp
      FROM jos_toc_blocks_subjects_links
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title 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
      GROUP BY id_insignia) AS link
      ON insignia.id = link.id_insignia
      ORDER BY insignia.title ASC
  103. SELECT id, surname, names
      FROM jos_toc_authors
      ORDER BY surname
  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 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
  106. 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
  107. SELECT guest, usertype, client_id, DATA
      FROM jos_session
      WHERE client_id = 0

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None