/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 => "%K. Usman%" ]
PAra kurcaci dan peri bunga berlomba menampung gerimis. Namun, Hujan badai menerjang!! Istana JAmur terendam. Para Kurcaci harus mengungsi. Kemana mereka akan menyelamatkan diri? Apa yang harus dilakukan para peri bunga untuk menolong kerajaan kurcaci yang dilanda bencana?
bercerita tentang raja kurcaci yang menolong tanpa mengharap imbalan
Kurcaci putih lomba menabung awan
Serial Peri sedap malam tentang kejujuran dalam berlomba
The rich has very dirty house. the dwarfs want to make it tidy and they work hard to clean it. the dirty stuffs are being washes immediately, but the owner of that house can not bear if her dirty stuffs are being washed without permission. futhermore, she spreads snares for the dwarfs. look..! she spreads nuts in the floor and stairs. it is very dangerous for the dwarfs, isn't it? what happen t…
Para Peri bunga heran melihat rumah peri anggrek Bulan kosong. Kemana dia pergi, ya? 'peri Anggrek Bulan diculik para Kurcaci," kata burung beo. Astaga! untuk apa para kurcaci menculiknya? peri mawar segera memimpin para peri bunga menuju Istana Jamur. Tapi para kurcaci menyangkal telah berbuat jahat. Apa yang sebenarnya terjadi?
Permaisuri Raja kurcaci rajin bangun pagi. Lihat, sebelum matahari terbit, permaisuri sudah sibuk didapur untuk menyiapkan makanan bagi keluarganya.
Kurcaci dan peri sangat menyukai awan. Mereka berlomba mengumpulkan awan. Namun, hujan dan badai datang. Bagaimana dengan perlombaannya. Masihkan dilanjutkan?