/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 => "%WINARNO%" ]
Bibl: hlm. 77-81
Indeks 561-571.
Bibli hlm. 241-243Indeks hlm. 245-251.
Bibl:161-165; ind:166-167
Bibilografi hlm: 208-217
Indeks : hkm.337-338
Bibilografi hlm. 161-165Indeks hlm. 166-167
SHJ 158.1SUSKA 137WSS 155.2
WSS 155.5MTR 1255.2
IAB 001.42SUSKA 001.4CRB 001.4
IAB 371SUSKA 371.1WSS 370.2KDR 370.3CRB 371.3MTR 371.3
CRB 425
SAS 425CRB 425
WSS 413
SUSKA 612.3AMB 540
Indeks hlm.: 151-152SAS 370.1CRB 371.3KDR 370.1WSS 371.3SUSKA 370.1
SUSKA 371.17
KDR 378.12
IAB:001.4