/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 ba.biblio_id from biblio_author as ba left join mst_author as ma on ba.author_id=ma.author_id where ma.author_name 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 ba.biblio_id from biblio_author as ba left join mst_author as ma on ba.author_id=ma.author_id where ma.author_name like ?)) group by b.biblio_id order by b.last_update desc limit 20 offset 0" ]
Bind Value ⚒️: array:1 [ 0 => "%William Shakespeare%" ]
Shakespare\\\\\\\'s The Winter\\\\\\\'s Tale is a five-fact lay that focuses on fidelity, trust and frienship. It is considered to be a romantic comedy with hints of tragedy in it. \\\\r\\\\n\\\\r\\\\nIn the play, the King of Sicilia, Leontes wrongly accuses his wife, Hermonie, of infidelity, and tries to get his faithful follower, Camillo to kill his friend, Polixenes for being party to his wi…
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 …
\\\\\\\\\\\\\\\"Steal forth thy father\\\\\\\\\\\\\\\'s house tommorrow night; And in the wood, a league without the town…There will I saty for thee.\\\\\\\\\\\\\\\" \\\\\\\\r\\\\\\\\n\\\\\\\\r\\\\\\\\nA Midsummer Night\\\\\\\\\\\\\\\'s Dream by William Shakespeare is a farcical take on love and romance, that plays out around Theseus and Hippolyta\\\\\\\\\\\\\\\'s marriage. \\\\\\\\r\\\\\\\\n…
All\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\…
Much Ado About Nothing, a five-act comedy by William Shakespeare, uses the oldest premise-that of a woman being falsely accused of being unchaste-for comedic relief. \\r\\n\\r\\nIn the play, we have two different pairs, the main characters being Cludia and Hero, the daughter of Leonato, the gentleman hosting Don Pedro and party. Claudia falls in love wit Hero but on the day of their wedding acc…
\\\"Why, fear not, man, I will not forfeit it, Within these two mnths, that\\\'s a month before This bond expires, I do expect return of thrice three times the value of this bond.\\\"\\r\\n\\r\\nThe Mechant of Venie by William Shakespeare is a tale that intermingles the prejudice of the times with retribution and mercy. \\r\\nThe story centres around Shylock, a Jewish loan shark, who resorts to…
\\\"Haste still pays haste, and leisure answers leisure, Like doth uit like, and measure still for measure.\\\" \\r\\n\\r\\nSet in Vienna, Measure of Measure is a dark comedy by Shakespeare. The main theme revolves around merciful justice. The main protagonist, Duke Vincento of Vienna, pretends to leave the city. He gives authority to his trusted minister, Angelo, whom he empowers to do the nee…
\\\\\\\"…But \\\\\\\'tis a common proof, That lowliness id young ambition\\\\\\\'s ladder, Whereto the climber-upward turns his face; \\\\r\\\\nBut when he once attains the upmost round, He then unto the leadder turns his back, \\\\r\\\\nLooks in the clouds, scorning the base degrees By which he did ascend. So Caesar may...\\\\\\\" \\\\r\\\\n\\\\r\\\\nThe Tragedy of Julius Caesar by William S…
Twelfth Night: Or, What You Will is one of Shakespeare\\\'s most entertaining comedies. It is a high-speed romantic cocktail of mistaken identities, love, desire, concealment, pretention, and madness. It takes us through the whirlwind journet of twins, Sebastian and Viole who gets separated gets separated after a shipwreck. \\r\\n\\r\\nViola takes the disguise of a young man and names herself C…
William Shalepere\\\'s As You Like It is five-act comedy, thought to be written around 1600. The play takes place in two location - the court, taken over by Dyke Frederic from his brother, Duke senior and the Forest of Arden, where the Duke and his followers fled to, after being expelled. \\r\\n\\r\\nOrlando and his faithful sevant Adam, flee to the Forest of Arden, to escape the murderous inte…
\\\"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…
Thinkest thou. Hortensio, though her father be very rich, any man is so very a fool to be married to hell?\\\\\\\' \\\\r\\\\n\\\\r\\\\nThe Taming of the Shrew by William Shakespeare is a comedy about love and marriage. \\\\r\\\\nThe central plot of the tale is the seach for a men who would wed Katherina, a wilful, outspoken and argumentative young woman, to clear the way for her younger sister…
\\\"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…