/www/wwwroot/opac.indramayukab.go.id/lib/SearchEngine/DefaultEngine.php:691 "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 10 offset 0" ]
Bind Value ⚒️: array:1 [ 0 => "%Rainbow S.p.A%" ]
rose and her team have to get the perfect costumes before the grand ball begins. would they be able to find their costumes in time? road to find out!
oh no, grandma snowhite has a magic cold. the only thing that can cure her magic cold is a cup of hot herbal tea with three golden apples from the kingdom of king melindo.
rose has to study for a test. princess scheherazade is helping her with the preparation. but someone captures the princess! can rose and her team rescue princess scheherazade before rase's test begins? read to find out!
rose and her team are ready to recerive armour suits from forge dragon. but oh no, forge dragon is away.
rase and her team get to spend a whole day on earth! they are so excited to do fun things, but shortbread witch has an evil plan! will they get to spend a fun and unforgettable day on earth ? read to find out.
Rase ends up in regal academy on her first day of school. she discover a secret. read to find out what that secretis.
oh no! joy's pet, king, has disappeared! did he run away ? or did someone kidnap him? can rose and her team find kng? read to find out!
oh no! the baby goats have been captured by bad wolf. find out if rose and her team can defeat bad wolf and rescue them.
rose has an appointment for a dental check-up. she feels afraid. but hawk has asolution-rose and her team need to find the tooth fairy to give rose a perfect set of teeth. read to find out wether rose and her team are able to find the tooth fairy before rose's dental check-up.