# /var/www/slims9/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 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, 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 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 ?)) order by b.last_update desc limit 10 offset 0"
]
^ "Bind Value ⚒️"
^ array:1 [
0 => "%Aulia Pohan%"
]
{"@context":"http:\/\/schema.org","@type":"Book","total_rows":3,"page":1,"records_each_page":10,"@graph":[{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=27574","name":"Potret Kebijakan Moneter Indonesia","author":{"name":["Aulia Pohan"]},"isbn":"978-979-769-166-0","publisher":"Raja Grafindo Persada","dateCreated":"2008","image":"POTRET.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=27718","name":"Sistem Pebayaran : Strategi dan Implementasi di Indonesia","author":{"name":["Aulia Pohan"]},"isbn":"978-979-769-401-2","publisher":"Rajawali Pers","dateCreated":"2013","image":"sistem_pembayaran.jpg.jpg"},{"@id":"http:\/\/lib.radenintan.ac.id\/index.php?p=show_detail&id=27695","name":"Kerangka Kebijakan Moneter & Implementasinya Di Indonesia","author":{"name":["Aulia Pohan"]},"isbn":"978-979-769-172-1","publisher":"PT Raja Grafindo Persada","dateCreated":"2017","image":"KERANGKA_KEBIJAKAN_MONETER_%26_IMPLEMENTASINYA_DI_INDONESIA.jpg.jpg"}]}