/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 20" ]
Bind Value ⚒️: array:1 [ 0 => "%Roderick Hunt%" ]
The artist Botticelli has a problem. Can the children solve it?
What happens when the children go on a Roman adventure?
Can the children help rescue the crew of a ship in trouble?
What will the children put in their time capsule
Mum gets a surprise when dad learns to dance!
What might spoil the maypole dance? Can Mrs May save the day?
Can Wilf fool a magician with his magic trick?
What happens when the children's jigsaw puzzel takes them into the past?
Uncle Max tells lots of tales. Will he enjoy a real adventure
The magic key takes the children to a forest. What mystery animal do they met?
Thanks to Gran, the children have a wonderful holiday!
Who will solve the crime? Sherlock Holmes or Aneena?
Watch the family perform at a singing competition in this exciting Read with Oxford story
Go on a space adventure with Kipper and Little Ted as they shoot off to the moon in this exciting Read with Oxford story
Watch Biff and Chip look after the hens in this exciting Read with Oxford story
Find out what happens when Floppy on an adventure in the jungle in this exciting Read with Oxford story
Find out who wins the raft race in this exciting Read with Oxford story
Find out what happens when chip loses his backpack in this exciting Read with Oxford story
Find out what happens when Floppy finds a toy rabbit in the park in this exciting Read with Oxford Story
Find out what happens when Floppy takes a juicy bone in this exciting Read with Oxford story
See Chip dress up as a king in this funny Read with Oxford story
Join Floppy in an adventure in the desert in this exciting Read with Oxford story
Go on a space adventure with Kipper and Floppy in this exciting Read wit Oxford story
Find out what happens when Kipper gets stuck in a fence
What happens to Floppy and the children in Ancient Egypt?
Can Kippet get out of trouble?
Who are the aliens who arrive with the fireball, and what do they want?
What happens to the young inventors flying machine?
How do the children help the travelling player?
Why is the pop star in disguise?
What happens to the knight in town?
What will ogres eat for dinner?
Can Biff and wilma help the princes to escape from the tower?
Can Chip, Wilf and Nadim do a good turn when the magic key takes them to the very first Scout camp?
What do Kipper and Lee find on their walk?
Will Kipper's aikido classes come in useful when he has a magic key adventure Japan?
Will Biff her fear of bees to help some villagers in Africa to protect their crops? This exciting Read with Oxford story is ideal for children who are becoming independent readers
What will the children find in the strange house? This exciting Read with Oxford story is ideal for children who are becoming independent readers
Mum and Dad take the family on a holiday by train, bu the journey isn't quite what they expect! This exciting Read with Oxford story is ideal for children who are becoming independent readers
Join the family on a fishing expedition at the seaside in this funny Read with Oxford story, ideal for children who are taking their first steps in reading
Join in with the famil's silly races in this funny Read with Oxford story, ideal for children who are taking their first steps in reading.
Join the children building a snowman in this funny Read with Oxford story, ideal for children who are taking their first steps in reading.
Join the children at a fireworks party and watch as Biff and Dad make a mess in the kitchen in these two funny Read with Oxford stories, ideal for children who are taking their first steps in reading.
join the family as they read stories in bed and find out who wins the big water fight in these two funny Read with Oxford stories, ideal for children who are taking their first steps in reading.
Find out what happens when a picnic in the country doesn't go to plan in this funny Read with Oxford story, ideal for children who are taking their first steps in reading.