/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 => "%HAMKA%" ]
SHJ 2X6.9SAS 2X5WSS 2X7.4SUSKA 297.512MTR 2X0.303.4
SHJ 2X9.2PNRG 2X9SUSKA 297.622PLK 2X9.01CRB 2X9KDR 2X9IAB 2X9WSS 2X9.14WTP 297.94
CRB 2X6.4KDR 2X6.152 2WSS 2X6.4SUSKA 297.07IAB 2X6.4MTR 2X6.4
IAB 920
SHJ 2X5.1 Ham lCRB 2X5.1KDR 2X5.1WSS 2X5.1AMB 2X5
SHJ 2X5.1CRB 2X5.1WSS 2X5.1
SHJ 2X7.209CRB 2X9.65 8KDR 2X9.8WSS 959.89SUSKA 297.620IAB 2X3.3
SHJ 2X9.865.58SUSKA 922
Indek: hlm. 187-192
SAS 2X0.lWSS 2x5.1CRB 2x0.113IAB 2X7.1
SHJ 2X3.1WSS 211.6SUSKA 2X7STJ 2X7.1IAB 2X7.1MTR 2X3.001
SHJ 2X0.02
SHJ 2X0.02
Bibliografi:hlm.275-279