/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 => "%Sudarsono%" ]
CRB 2X4.27WSS 2X4.27STJ 2X4.27
SKY 2X5.101
CRB 2X7.1WSS 2X7.1STJ 2X7.1PLK 2X7.1MTR 2X7.1
MTR 658.1
Bibliografi hlm. 251STJ 2X6.3WTP 2X6.3MTR 2X6.3
Bibliografi hlm 177-181SAS 364.3KDR 364.3WSS 362.7STJ 345.03PLK 155.5
SAS 340KDR 340.03WSS 340.03STJ 340.03
WSS 150.03IAB 103
SMRD 297.03
SHJ 2X0.01WSS 2X4.07STJ 2X4
Bibliografi hlm. 251
Bibliografi: p. 355
Bibliografi: p. 153-156
bibilografi : hlm. 355-356
Bibilografi : hlm. 307-308
Bibliografi hlm. 251
SKY 2X5.101
Bibliografi : 384-385Indeks : hlm.386-387
SUSKAWSS 340.07STJ 346.01MTR 346.1
SHJ 346.05WSS 346.05STJ 346.06
CRB 340.598SUSKA 340.095MTR 340.598
SKY 338.9SUSKA 338.9
CRB 348.02KDR 347.01WSS 347.01SUSKA 340.1MTR 342WTP 347.03
IAB 338.5KDR 338.5MTR 338.5
Bibl.hlm.: 307-308IAB 340SUSKA 340WSS 340.1MTR 340.1
SKY 2X5.101MTR 2X5.1