/var/www/html/lib/SearchEngine/DefaultEngine.php:692 "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 order by b.last_update desc limit 50 offset 30" ]
Bind Value ⚒️: array:1 [ 0 => "%Harun%" ]
Bibl:hlm.111-112Indeks:hlm.117-123
Jl.I.C.1-43
Bibilografi hlm. 93Indeks hlm.94-96
Bibilografi hlm. 96-97Indeks hlm. 100-102
Bibl:hlm.116Indeks:hlm.117-122
Bibl:hlm.186
Bibl:hlm.210-211Indeks:hlm.212-214
Indeks:hlm.117-123
Jl.I.C.1-43
Bibliografi hlm. 100-102Indeks. hlm. 103
SHJ 2X4.763
SHJ 2X4.763SUSKA 297.91CRB 200.1KDR 2X7.91MTR 2X7.1
SHJ 2X7SKY 2X5.214CRB 2X7.11KDR 2X7.1STJ 2X7.1IAB 2X7.12SUSKA 297.6MTR 2X7.1
SUSKA 297.91WSS 2X7.1IAB 2X7.1MTR 2x7.1
Bibliografi hal. 97SAS 2X7.1SUSKA 297.61WSS 2X7.1CRB 2X7.1
Bibliografi hlm.325-327
Bibliografi hlm. 100