/home/muharrik/library.muharrikunnajaah.com/lib/SearchEngine/DefaultEngine.php:692 "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 10 offset 0" ]
Bind Value ⚒️: array:1 [ 0 => "%Sir Arthur Conan Doyle%" ]
The Sign of the Four is the second Sherlock Holmes novel, first published in 1890. The story combines mystery, adventure, and romance, and is notable for introducing Mary Morstan, who later becomes Dr. Watson’s wife. The plot begins when Mary seeks Holmes’s help after receiving mysterious pearls and a summons related to her missing father. Holmes and Watson uncover a complex tale involvi…
The Hound of the Baskervilles is the third Sherlock Holmes novel, first published in 1902. It is widely regarded as one of the most famous and atmospheric Holmes stories. The novel begins with Holmes and Watson investigating the legend of a supernatural hound said to haunt the Baskerville family. When Sir Charles Baskerville is found dead under mysterious circumstances on the moor, his heir,…
The Return of Sherlock Holmes" is a 1905 collection of 13 short stories by Arthur Conan Doyle, marking the detective’s dramatic comeback after his apparent death. Published in 1905, The Return of Sherlock Holmes is the third collection of stories featuring Sherlock Holmes and Dr. John Watson. The collection was written after public demand following Holmes’s apparent death in The Final Pr…
The Valley of Fear is the fourth and final Sherlock Holmes novel, first published in 1915. The story is divided into two distinct parts. Part I (The Mystery): Holmes and Watson investigate the murder of John Douglas at Birlstone Manor. The case involves secret societies, coded messages, and a hidden past that gradually comes to light. Holmes unravels the mystery through deduction, revealing …
This collection presents Sherlock Holmes in the later stages of his career, featuring eight stories that explore a range of criminal mysteries and international intrigues. The tales showcase Holmes in diverse situations: from bizarre murders and the disappearance of a noblewoman to cases involving military espionage. The highlight of the book is the story His Last Bow, in which Holmes emerge…
A classic collection of eleven Sherlock Holmes stories showcasing the detective’s brilliance and his confrontation with Professor Moriarty. The Memoirs of Sherlock Holmes is a collection of short stories by Sir Arthur Conan Doyle, first published in 1893, featuring the legendary detective Sherlock Holmes and his loyal companion Dr. Watson. Set in Victorian-era London, the collection highligh…