/home/smaacityalibrary/public_html/smaacitya/lib/SearchEngine/DefaultEngine.php:696 "Search Engine Debug 🔎 🪲"
Engine Type ⚙️: "SLiMS\SearchEngine\DefaultEngine"
SQL ⚙️: array:2 [ "count" => "select count(distinct b.biblio_id) from biblio as b left join mst_publisher as mp on b.publisher_id=mp.publisher_id left join mst_place as mpl on b.publish_place_id=mpl.place_id left join mst_gmd as mg on b.gmd_id=mg.gmd_id left join biblio_author AS ba ON ba.biblio_id=b.biblio_id left join mst_author AS ma ON ba.author_id=ma.author_id left join biblio_topic AS bt ON bt.biblio_id=b.biblio_id left join mst_topic AS mt ON bt.topic_id=mt.topic_id where b.opac_hide=0 and (b.biblio_id in(select bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic like ?))" "query" => "select b.biblio_id, b.title, b.image, b.isbn_issn, b.publish_year, b.edition, b.collation, b.series_title, b.call_number, mp.publisher_name as `publisher`, mpl.place_name as `publish_place`, b.labels, b.input_date, mg.gmd_name as `gmd`, GROUP_CONCAT(DISTINCT ma.author_name SEPARATOR " - ") AS author, GROUP_CONCAT(DISTINCT mt.topic SEPARATOR ", ") AS topic, b.edition, b.collation, b.series_title, b.call_number from biblio as b left join mst_publisher as mp on b.publisher_id=mp.publisher_id left join mst_place as mpl on b.publish_place_id=mpl.place_id left join mst_gmd as mg on b.gmd_id=mg.gmd_id left join biblio_author AS ba ON ba.biblio_id=b.biblio_id left join mst_author AS ma ON ba.author_id=ma.author_id left join biblio_topic AS bt ON bt.biblio_id=b.biblio_id left join mst_topic AS mt ON bt.topic_id=mt.topic_id where b.opac_hide=0 and (b.biblio_id in(select bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic like ?)) group by b.biblio_id order by b.last_update desc limit 20 offset 10" ]
Bind Value ⚒️: array:1 [ 0 => "%English Drama%" ]
\\\"If by your ar, my dearest father, you have Put the wild waters in this roar, allay them. \\r\\n…O, I have suffer\\\'d \\r\\nWith those that I saw suffer! A brave vessel, \\r\\n…. Dash\\\'d all to pieces. \\r\\n\\r\\nThe Tempest by William shakespeare is Tragicomedy of betrayal, revenge, love and forgiveness. Exiled, and presumed dead, propero and his daugther Miranda survive and trive o…
\\\"Fair is foul, amd foul is fair.\\\" \\r\\n\\r\\nWillian Shakespare\\\'s Macbeth reminds us how a little provocation can trigger an ambitious soul and push him down the path of disaster, treachery and brutality. In Acotland, the able general of King Duncan, Macbeth, and his friend Banquo receive prophecies from a witch trio that Machbeth will soon become a thane, following which he will beco…
\\\"Bit, soft, behold! Lo, where it comes again! I\\\'ll cross it, though it blast me. Stay, illusion! If thou hast any sound, or use of voice, Speak to me.\\\" \\r\\n\\r\\nWilliam Shakespare\\\'s The Tragedy of Hamlet, prince of Denmark is a revenge play set in Elizabethan times. Hamlet, the Prince of Denmark, comes upon his dead father\\\'s ghost and learns of his cruel adn cold-blooded murde…
\\\"Your daughter (if you have not given her leave) I say again, hath made a gross fortunes In an extravagant and wheeling starnger of here and everywhere\\\" \\r\\n\\r\\nOthello, The Moor of Venice by William Shakespeare is a tragedy of enormous proportions. The story follows Othello, a general in the Venetian army, and his bride, Desdemona, as they begin their lives together. Generous and fru…
\\\"Father that wear rags Do make their children blind, But Fathers that bear bags Shall see their children kind. Fortune, that arrant whore, Ne\\\'er turns the key to th\\\' poor\\\" \\r\\n\\r\\nThe tragedy of King Lear by Willian shakespare is a tel of btrayal, trachery, war and pain. The story revolves around a self-absorbed and delusional father and his three daughters, particulary drawing …
William Shakespare\\\'s The Life of Timon of Athens is one of his later plays, composed between 1605-08. It is tragedy in five acts, which tells the the story of Timon of Athens, and the unfortunate circumstances which led to his downfall. \\r\\n\\r\\nThe Magnanimous and generous TImon is loved by all for he is thriftless when it comes to patronising painters and poets, giving gifts to his frie…
\\\"My bounty is a boundless as the sea, My love as deep; the more I give to thee, The more I have, for both are infinite\\\" \\r\\n\\r\\nWilliam Shakespare\\\'s Romeo and Juliet is one if the most admired plays. The story takes shape in the city of Verona, Italy, where the Houses of Capulet and Montague are in conflict with one another. Montague\\\'s son Romeo and Capulet\\\'s daughter Juliet …
00O, these are barren taska, too hard to keep Not to see ladies, study, fast, not sleep!\" \r\n\r\nLove\'s labour\'s Lost by William Shakespeare is a humorous tale underlining the disjunction between idealised love and love in the real world. The story begins with the King of Navarre and his lords vowing to renounce women in order to spend three years in study and fasting. The arrival of the Pr…
\\\"There had she not been long but she became A joyful mother of two goodly sons; And, which was strange, the one so like the other As could not be distinguish\\\'d but by names.\\\" \\r\\n\\r\\n0000The Comedy of Errors by William Shakespare is a comedy of mistaken identities. Separated soon after birth, and oblivious of each other, two sets of identical twins happen to end up in the same city…
William Shakespare\\\'s Antony and Cleopatra is a tragedy that takes place over five acts. After the death of Julius Caesar, the triumvirate: Cleopatra, the Queen of Egypt; Mark Antony; Roman Military Leader; and Octavius Caesar are ruling together. \\r\\n\\r\\nMark Antony, who is besotted with Cleopata, rushes home at the news of his wife, Fulvia;s death, to try and heal political tensions by …
Cymbeline, by William Shakespeare, is a tragi-comedic play based on King Cymbeline, as the name suggests. King Cymbeline ruled the British with the blessing of Rome and Julius Caesar, which meant that he had to pay tribute to the Romans periodically. \\r\\n\\r\\nKing Cymbeline decides that his daughter, Imogen would marry his stepson, Cloten, only to discover that she is already married to a ma…
The Two Gentlemen of Verona tells the story of two devoted friends, Valentine and Proteus. Valentine leaves their home city of Verona for Milan, but Proteus, in love with Julia, stays behind. Then Proteus’s father sends him to Milan, too. \\r\\nBefore leaving, Proteus pledges his love to Julia. In Milan, Valentine and the duke’s daughter, Sylvia, are in love. Proteus, on arriving, falls in…