# /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 30" ]
^ "Bind Value ⚒️"
^ array:1 [ 0 => "%Komik%" ]
Library has: No.1,2,3 Pertarungan sudara sedarah No.4&5 Rencana jahat Piat Ho
Judul asli: Specialite du Chef Mitsuboshi Tersedia Bahasa Indonesia dan Bahasa Jepang
library has: 1 - 21 (Buku 1 dan 15 rusak/discard)
library has: vol.1-15 (Edisi 6 rusak/discard)
Library has: vol.1, 18
library has: vol.10; vol.14; vol.16; vol.21
librarry has: vol.1,2,3,5
Judul asli: Seito Shokun 2rnlibrary has: vol.2-7; vol.11; vol.15; vol.22
Judul asli: Shin tekken Chimi 4rnLibrary has: vol.4, 12, 13, 15, 19, 20
Judul asli: Gin no toe shoesrnlibrary has: vol.1-2; vol.4
Judul asli: Tsurikichi sanpeirnLibrary has: vol.2-3
Judul asli: Ryuroden 12
library has: vol.3-5
library has: vol.20; vol.24