# /app/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 50 offset 0" ]
^ "Bind Value ⚒️"
^ array:1 [ 0 => "%Hamalik, Oemar%" ]
Bibl:hlm.134
CRB 375 dan 378.199KDR 375SUSKA 378
KDR 371.302 8WSS 371.1SUSKA 371.1SMRD 371.3IAB 371.3AMB 371.3
CRB 375WSS 375STJ 375
KDR 371.207
Bibilografi hlm.183-185
Bibliografi hlm. 241-242MTR 371.1
Bibliografi:hlm.241-142
SMRD 371.394KDR 371.1
KDR 371.7WSS 371.3IAB 371.1WTP 371.7MTR 371.3
Bibliografi hlm. 264
KDR 378WSS 378.16
Bibl:hlm.183-185
CRB 375WSS 375STJ 375WTP 375MTR 375