# /var/www/univlia/slims/lib/SearchEngine/DefaultEngine.php:608^ "Engine ⚙️ : 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 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, mp.publisher_name as `publisher`, mpl.place_name as `publish_place`, b.labels, b.input_date, 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 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 ?)) order by b.last_update desc limit 40 offset 80" ]
^ "Bind Value ⚒️"
^ array:1 [ 0 => "%APA%" ]
compiled by Wm. Theodore de Bary ... [et al.] ; with collaboration of William Bodiford, Jurgis Elisonas, Philip Yampolsky ; and contributions by Yoshiko Dykstra ... [et al.].
Yoshio Sugimoto.
Barbara Sato.
Marcia Iwatate and Geeta K. Mehta ; photography by Nacása & Partners.
edited by Patrick Heinrich and Christian Galan.
edited by René Haak and Markus Pudelko.
Miriam Silverberg.
James W. Heisig & Tanya Sienko.
Margaret Sleeboom.
Indra Levy.
Robert Matthew.
Sandra Wilson.
Sari Kawana.
edited by Rebecca L. Copeland and Melek Ortabasi.
Stephen S. Large.
Senko K. Maynard.
Mikael S. Adolphson.
edited by Marcus Rebick and Ayumi Takenaka.
Jay Keister.
Mary Alice Haddad.