Filter by

  • Publication Year
    To
  • Availability
  • Attachment
  • Collection Type
    See More
  • General Material Designation
    See More
  • Location
    See More
  • Language
    See More
Found 12 from your keywords: subject="fairytale"
# Debug Box 
/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 bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic 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 bt.biblio_id from biblio_topic as bt left join mst_topic as mt on bt.topic_id=mt.topic_id where mt.topic like ?)) group by b.biblio_id order by b.last_update desc limit 50 offset 0"
]

Bind Value ⚒️: array:1 [
  0 => "%fairytale%"
]
cover
Goldilocks and the Three Bears
Comment Share
Nat Lambert

Warm up a bowl of porridge and explore the three bears’ house with Goldilocks! Color, play games, find hidden objects and more as you read, learn and play with the free Hippo Magic App.

Edition
-
ISBN/ISSN
9781949679502
Collation
-
Series Title
-
Call Number
398.2 LAM
cover
Labu Ibu Maneo
Comment Share
Marion Drew

Ibu Maneo menanam biji labu yang tumbuh menjadi besa. Pada musim panas, ternyata labu itu menjadi kejutan besar bagi seluruh penduduk lembah.

Edition
1
ISBN/ISSN
9786233076210
Collation
20 hlm.; 22,9 cm
Series Title
-
Call Number
398 DRE
cover
Snow White
Comment Share
Grace Lim Pineda

Ajak anak anda ke negeri impian!

Edition
-
ISBN/ISSN
9786022432975
Collation
-
Series Title
-
Call Number
300 PIN
cover
Fairy Tale Jigsaw Puzzle Book
Comment Share

Edition
-
ISBN/ISSN
915100031
Collation
-
Series Title
-
Call Number
FA NUT

Edition
-
ISBN/ISSN
915100031
Collation
-
Series Title
-
Call Number
FA NUT
cover
Goldilocks and The Three Bears
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574745
Collation
-
Series Title
-
Call Number
FA SUN
cover
Sleeping Beauty
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
184557477X
Collation
-
Series Title
-
Call Number
FA SUN
cover
Little Red Riding Hood
Comment Share
risi

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574761
Collation
-
Series Title
-
Call Number
FA SUN
cover
Rapunzel
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574753
Collation
-
Series Title
-
Call Number
FA SUN
cover
Snow White
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574788
Collation
-
Series Title
-
Call Number
FA SUN
cover
The Princess of Aladdin's Heart
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574729
Collation
-
Series Title
-
Call Number
FA SUN
cover
Cinderella
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574737
Collation
-
Series Title
-
Call Number
FA SUN
cover
Thumbelina
Comment Share
Rising Sun

This series of fairy tales features little princesses who have captured the hearts of young readers down the ages with their innocence, beauty and charm.

Edition
-
ISBN/ISSN
1845574796
Collation
-
Series Title
-
Call Number
FA SUN