/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 20" ]
Bind Value ⚒️: array:1 [ 0 => "%Jalaluddin%" ]
CRB 001.5KDR 001.42WSS 001.5SUSKA 302.072STJ 302.2IAB 001.5WTP 001.42AMB 001.42
SUSKA 2X2.3
SHJ 2X2.2
Bibliografi hlm. 261-270IAB 2X2.29
SKY 2X1.14WSS 2X1.14
SHJ 2X2.1
SUSKA 2X1.11SMRD 297.12
PLK 2X4.2WTP 2X4.83
Indeks : hlm.495 - 508SHJ 2X2.02SAS 808WSS 2X0.08CRB 2X6.2KDR 300PKL 302.2SUSKA 808.4WTP 303.4MTR 300
STJ 2X4.02
IAB 2X1.1
CRB 2X1.1IAb 2X1.19
Jz.[1-2] c.1-2SUSKA 2X1.31
SKY 2X2.34
IAB 2X2.29
SAS 2X4
SKY 492.71STJ 297.4
SKY 492.71 STJ 297.4
SKY 2X2.1KDR 2X1.3WSS 2X4.03IAB 2X2.34
SAS 615.5
KDR 2X4.02AMB 2X4.05
Bibl. hlm.167-172 Ind. hlm.173-176KDR 370.1PLK 370.1CRB 370.1MTR 2X7.3