/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 Fiction%" ]
If I be waspish best beware my sting.
"Time is only a kind of Space."
"Our lives are one masked ball."
"A brave heart and a courteous tongue. The shall carry thee far trough the jungle manling."
"Forward, my friend, into the interior of the earth."
"The True courage is I facing danger when you are afraid."
"I Kew who I was this morning, but I've changed a few times since then."
"All men, however highly educated, retain some superstitious inklings"
"When one tries to rise above Nature one is liable to fall below it."
"You must allow me to tell you how ardently I ad mire and love you."
"When one wishes todo a thing, one finds no lack of reasons of the doing."
"When Pain is Over, the remembrance of it often becomes a pleasure."
"Everybody's youth is a dream, a form of chemical madness"
"Few people realise the immensity of vacancy in which the dust of the material universe swims"
"I am sure there is Magic in everything, only we have not sense enough to get hold of it and make it do things for us"
"That power lies in her heart, because she is a sweet and innocent child!"
"Nothing is so painful to the human mind as a great and sudden change"