/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 0" ]
Bind Value ⚒️: array:1 [ 0 => "%Nasution, S%" ]
Bibliografi:hlm.193-195
SUSKA 370.15
SUSKA 001.4PLK 001.42IAB 001.4WTP 001.4
SHJ 375.001SKY 375.01CRB 375KDR 378.19WSS 378.1SUSKA 375IAB 375
KDR:371.3SUSKA:371.3IAB:371.3WTP 371.3MTR 371.1
MTR 371.3
Bibliografi: pada tiap bab.STJ:371
WSS 371.3SUSKA 371.1
SHJ 808.023
SUSKA 370.15
SHJ 375.001SKY 375.01CRB 375KDR 378.19WSS 378.1SUSKA 375IAB 375SAS 378.19AMB 375MTR 375
KDR:371.3SUSKA:371.3IAB:371.3
indeks hlm. 187-191
Bibliografi : hlm. 155-162SAS 370.959 8CRB 370.9KDR 370.959 8WSS 372.959 8STJ 370.598SUSKA 370.959 8IAB 370.959 8PLK 370.9WTP 370.959 8MTR 370.9
Bibliografi hlm. 281-284Illus
Bibilografi hlm. 248-251Indeks hlm. 252-255
Bibilografi hlm. 184-185Indeks hlm. 186-189
SAS 001.4KDR 001.4WSS 808.066PLK 001.4WTP 808.02MTR 808
SUSKA 001.4