/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 => "%J.R.R Tolkien%" ]
When Thorin Oakenshield and his band of dwarves embark upon a dangerous quest to reclaim their home from the ruthless dragon Smaug, Gandalf the wizard suggests an unlikely accomplice: Bilbo Baggins, an unassuming hobbit dwelling in peaceful Hobbiton. As They journey from the wonders of Rivendell to the terrors of Mirkwood and qualities of courage and cunning. And with toward his great destiny .…
The Ringwraiths, terrible thrall to the Enemy, are searching for a Hobbit. Frodo Baggins know that they are seeking him and the Ring he bears---the Ring of Power that will enable the Dark Lord Sauron to destroy all that is good in Middle-earth. Now it is up to Frodo and his Faithful servant, Sam, with a small band of companions, to carry the Ring to the one place it can be destroyed: Mount Doom…
The Fellowship is scattered. Some brace hopelessly for war against the ancient evil of Sauron. Others must contend with the treachery of the wizard Saruman. Only Frodo and Sam are left to take the One Ring, ruler of all the accursed Rings of Power, to be destroyed in Mondor, the dark realm where Sauron is supreme. Their guide is Gollum, deceitful and obsessive slave to the corruption of the Ring.
The dark Lord Sauron has regained much of this old power, and as he unleashes hordes of orcs to conquer all Middle-earth, Frodo and Sam struggle deep into Mordor, seat of Sauron's power. To defeat Sauron, the One Ring, ruler of all the accursed Rings of Power, must be destroyed in the fires of Mount Doom. But the way is impossibly hard, and Frodo is weakening. Weighed down by the compulsion of …