/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 => "%Soekanto, Soerjono%" ]
Bibliografi hlm. 451-461indeks hlm. 463-465
Bibl:hlm.586
SHJ 340.11SKY 340SUSKA 306PLK 340.01WSS 340.5
SHJ 392.03CRB 340.03WSS 340.3
IAB 301
STJ 340.559 8SUSKA 340.598PLK 340.57WTP 340.57
SUSKA 352.007 959 8
WSS 301PLK 301IAB 307
SUSKA 301.03PNRG 030.301WSS 301.03
SUSKA 301.04STJ 301SAS 302IAB 301PLK 301
SUSKA 240.11CRB 340.11
WTP 340.11MTR 340.1
Bibl:hlm.378-382
Indeks:hlm.403-404
Indeks:hlm.403-404
Bibl: hlm. 258-261
Bibliografi:hlm.258
Bibli hlm.378-382SUSKA 340.57
bibli hal 275-262AMB 340.01; Indeks hal 282-286
Bibilografi :Hlm. 59-60
SUSKA 302.5
SUSKA 344
SHJ 340.1SKY 340CRB 370.115KDR 340.115WSS 340.115SUSKA 340.115PLK 340.115WTP 340.115
PLK 344WSS 344
Bibl:hlm.128
WSS 301.04
SKY SUSKA 305WSS 301.5CRB 301.04
PLK 301.01