/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 10" ]
Bind Value ⚒️: array:1 [ 0 => "%Daradjat, Zakiah%" ]
SHJ 200.19SKY 201.6CRB 200.15KDR 2X7.15WSS 2X7.15SUSKA 155STJ 150.2IAB 2X7.15SMRD 297.64
SHJ 2X4SKY 2X4.31
CRB 2X4.142X4.14PNRG 2X4.14MTR 2X4.14
SKY 2X4.12WSS 2X4.12STJ 2X4.22PNRG 2X4.1IAB 2X4.12
SKY 362.2CRB 150KDR 2X7.15WSS 155.5SUSKA 150STJ 150
WSS 371.11SUSKA 371.1
CRB 155.5WSS 170SUSKA 177.1IAB 170.199WTP 152
SHJ 2X7.3CRB 2X7.320 3KDR 2X6.41WSS 2X7.31SUSKA 297.951IAB 2X7.31WTP 2X7.3
SHJ 2X0.07SAS 2X0CRB 2x38KDR 2x0WSS 2x0.07STJ 2x0SUSKA 2x0MTR 2X0.07
Bibl:hlm.324
Bibl:hlm.151-152
Bibliografi hlm. 325-326
CRB 2X7.3KDR 2X7.3WSS 2X7.3SUSKA 2X7.3STJ 2X7.31IAB 2X7.3
Bibl: hlm. 270
Bibliografi hlm. 325-326
Bibliografi : hlm.94-95
Bibliografi hlm. 210-212indeks hln. 213-214
Bibliografi : hlm.151-152
MTR 2X7.3
SHJ 616.891 46SKY 155.143SUSKA 136WSS 155.4CRB 155.4
SHJ 2X7.3SKY 180.992WSS 320.5WSS 320.5
CRB 291KDR 201.5IAB 291WTP 291
CRB 291KDR 201.5SUSka 290IAB 291PLK 291WTP 291
WTP 291
Biblio :MTR 2X7
CRB 2X7.3KDR 2X7.3WSS 2X7.3SUSKA 2X7.3STJ 2X7.31IAB 2X7.3AMB 2X7.3SHJ 2X7.3MTR 2X7.3