/var/www/html/lib/SearchEngine/DefaultEngine.php:705 "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, b.title, b.image, b.isbn_issn, b.publish_year, b.edition, b.collation, b.series_title, b.call_number, mp.publisher_name, mpl.place_name, b.labels, b.input_date, mg.gmd_name order by b.last_update desc limit 20 offset 10" ]
Bind Value ⚒️: array:1 [ 0 => "%-%" ]
Have you ever wondered what makes storytelling and digital media a powerful combination? This edited volume examines the opportunities to think, do, and/or create jointly afforded by digital storytelling. The editors of this volume contend that digital storytelling and digital media can create spaces of empowerment and transformation by facilitating multiple kinds of border crossings and conver…
Eighteenth-century English is often associated with normative grammar. But to what extent did prescriptivism impact ongoing processes of linguistic change? The authors of this volume examine a variety of linguistic changes in a corpus of personal correspondence, including the auxiliary do, verbal -sand the progressive aspect, and they conclude that direct normative influence on them must have b…
Who mediated intercultural exchanges in 9th-century East Asia or in early voyages to the Americas? Did the Soviets or the Americans invent simultaneous interpreting equipment? How did the US government train its first Chinese interpreters? Bringing together papers from an international symposium held at Rikkyo University in 2014 along with two select pieces, this volume pursues such questions i…