/home/ktlgelm2106025/public_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 => "%James Preller%" ]
MWAH-HA-HA-HA-HA! SELAMAT DATANG, SILAKAN DUDUK, KAMI AKAN MENCERITAKAN SEBUAH KISAH KEPADAMU. NAMUN, WASPADALAH, HOME SWEET HORROR BUKANLAH CERITA BIASA. INI ADALAH CERITA YANG MENAKUTKAN. PERKENALKAN, LIAM FINN, SEORANG BOCAH PENDERITA ASMA YANG BARU SAJA PINDAH KE RUMAH BARU, BERSAMA AYAH DAN KAKAK PEREMPUANNYA RUMAH TUA ITU TAMPAKNYA KOSONG, PADAHAL TIDAK. ADA HANTU BLOODY MARY DI SA…
Semua binatangsedang tidur siang, tapi mereka terganggu oleh suara cegukan. Siapa yang cegukan ya sampai semua binatang terganggu tidurnya?
Athena Lorenzo has been slimed! And she doesn't thinl it's funny. Someone in Ms. Gleason's class is playing practical jokes. And it's up to Jigsaw and Mila to catch the clown. This could be their stickiest case yet!
Eeew! joey Pignattano membuat taruhan halloween. Dia akan makan cacing forr dolar. Satu-satunya masalah adalah, seseorang mencuri worm. Dan nomor satu sispect adalah mumi! itu akan mengambil dua detestives atas seperti Jigsaw dan mila untuk membuka misteri ini ooey-lengket.
Misteri hilangnya hamster. Semua orang mencari dan memecahkan misteri hilangnya hamster