/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 => "%Bari%" ]
Judul asli: Mausu'ah Al-Mar'atul Muslimah
CRB 2X4.8SUSKA 2X4.8WSS 2X4.8SMRD 297.4IAB 2X4.8
SAS 2X1.12WSS 2X1.1STJ 2X1IAB 492.7
Juz I-XV=C.1-2SAS 2X1.13
SKY 2X1.3
SKY 2X1.3
SKY 2x1.3
SKY 2X1.3
SKY 2x1.3
SKY 2x1.3
SKY 2x1.3
SKY 2X1.3
SKY 2x1.3
SUSKA 2X1.13
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01
SHJ 2X9.5SKY 2X9.82SUSKA 2X9.01