/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 0" ]
Bind Value ⚒️: array:1 [ 0 => "%Novel - English Fiction%" ]
In the sleepy English countryside of decades past, there is a town that has stood on a jut of granite for six hundred years. And immediately to the east stands a high stone wall, for which the village is named. Here in the town of Wall, Tristran Thorn has lost his heart to the hauntingly beautiful Victoria Forester. One crisp October night, as they watch, a star falls from the sky, and Victoria…
Laura and Alamanzo Wilder have just been married, and their life on small prairie homestead begins with high hopes. But each year brings unexpected disasters--storms, sickness, fire, and unpaid debts. Their pioneer lives have trained them well, however, and they are determined to succeed and to provide for the newest member of the family--baby Rose.
Laura is teaching school, and it's terrifying! Most of the students are taller than she is, and she must live away Friday--no matter what the weather--Alamanzo Wilder arrives to take her home to her family for the weekend. Laura knows that this is a time for new beginnings.
The long winter is over. with spring comes a new job for Laura, town parties, and "Literaries" Laura spends many hours each day sewing shirts to help earn money that will send Mary to a college for the blind. But in the evenings, she makes time for a new caller, Almanzo Wilder.
The town of De Smet is hit with terrible, howling blizzards. Snow has reached the rooftops, and no trains can get through with food or coal. The people of De Smet, including Laura's family, are starving. It is young Almanzo Wilder who finally understands what needs to be done. He must save the town, even if it means risking his own life.
Laura and her family are headed to the Dakota Territory for a chance to own their own land-and stop moving . The new town of De Smet is filling up with settlers lured west by the promise of free land, and the Ingalls family must do whatever it takes to defend their claim.
The adventures of Laura Ingalls and her family continue as they leave their little house on the prairie and travel in their covered wagon to Minnesota. Here they settle in a little house made of sod beside the banks of beautiful Plum Creek. Soon Pa builds a wonderful new little house with real glass windows and a hinged door. Laura and her sister Mary go to school, help with the chores, and fis…
Pa Ingalls decides to sell the little log house, and the family sets out for Indian country! They travel from Wisconsin to Kansas, and there, finally, Pa builds their little house on the prairie. Sometimes farm life is difficult, even dangerous, but Laura and her family are kept busy and are happy with the promise of their new life on the prairie.
While Laura Ingalls grows up in a little house on the western prairie, Almanzo Wilder is living on a big farm in New York State. Almanzo and his brother and sisters work at their chores from dawn to supper no matter what the weather. There is still time for fun, though, and Almanzo wishes for his very own horse. But Father doesn't yet trust him with that responsibility, and Almanzo must find a …
Wolves and panthers and bears roam the deep Wisconsin woods in the late 1870’s. In those same woods, Laura lives with Pa and Ma, and her sisters Mary and Baby Carrie, in a snug little house made of logs. All night long, the wind howls lonesomely, but Pa plays the fiddle and sings, keeping the family safe and cozy.
Half-Japanese and half-Javanese Lasi flees from the constraints of her small village to find herself enmeshed in the political corruption of Jakarta. *** The bekisar is a fine crossbreed between jungle fowl and domestic chicken that adorns the houses of the wealthy. Lasi, whose father was a Japanese soldier, fair skinned and beautiful, is such an acquisition for a rich man in Jakarta. She is bo…
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 …