/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 70" ]
Bind Value ⚒️: array:1 [ 0 => "%Ghazali%" ]
Judul asli:Fiqh al Sirah
MTR 2X5
IAB 2X9.12WSS 2X9.2
JA: Al Arba'un an NabawiyahSAS 2X1.3KDR:2x2.352AMB 2X2.01
WSS:2x7.25IAB:2x7.2MTR 2X7.24
SUSKA 2X0.01
SAS 2X4.12WSS 2X4.12
SUSKA 2X3.1
SAS 2X3KDR 2X3IAB 2X3
SUSKA 2X5.1
SAS 2X9.4 Ash k
IAB 2X4.83
SHJ 2X3.4SUSKA 290
Juz.1-2 = C.1-C.3SMRD 297.4
SAS 2X5.213IAB 2X5.214
SAS 2X4
Lihat juga: 297.082 GHA iCRB 2X0
Judul asli: Mi'ah su'al in al IslamSKY 2X9.871PLK 2X0STJ 2X0.1SUSKA 2X0.02PNRG 2X0
IAB 2X3.5
Judul asli: The Ninety nine beatiful names of GodBibliografi hlm. 225-226Indeks hlm. 226-232PLK 2X3.12SMRD 297.211STJ 2X3.12CRB 2X5.212IAB 2X3.12
Bibliografi: p. 95-98STJ 2X6.11MTR 2X6.31
SAS 2X7WSS 200.859 8
JA: al-Adzkar waj da'awat, ad-Da'awat al mustajabah wa mafatik al farajSAS 2X5.4KDR 2X5.4
WSS 2X5.2KDR 2X5.1
SHJ 2X5.2SKY 2X5.2SUSKA 2X5.22
SHJ 2X5.2SKY 2X5.2SUSKA 2X5.22
SHJ 2X0.01SKY 2X0.001KDR 2X7.1WSS 2X7.15SUSKA 2X0IAB 2X7.3
SKY 2X5.2CRB 2X5.2SUSKA 2X5.22SUSKA 2X5.2