# /var/www/univlia/slims/lib/SearchEngine/DefaultEngine.php:608^ "Engine ⚙️ : 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 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, mp.publisher_name as `publisher`, mpl.place_name as `publish_place`, b.labels, b.input_date, 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 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 ?)) order by b.last_update desc limit 40 offset 0" ]
^ "Bind Value ⚒️"
^ array:1 [ 0 => "%English language - Textbooks for foreign speakers;%" ]
Library has: Series 1 book1: Cat on the mat & Dan and Nan Book 2: Vet in a jet & Ben and Red hen Book 3: Cat's big wig & the tin bin Book 4: Pop and his dog & fox in the box Book 5: Pup in the mud & Bug in the mug Book 6: May and Jay stay away from the rain Book 7: Green frog and the bee Book 8: Mike and his kite Book 9: Joe and Doe on the boat Book 10: Sue's birthday
Library has: Series 2 Book 1: Fred frog and drab crab Book 2: Blue cow goes out to play Book 3: Snooby snail and smarty snake Book 4: Sweety swan and the starfish Book 5: What does Charlie the chimp see? Book 6: Nell and Dell at the ball game Book 7: Bill and Jill Book 8: Rick and his tricks Book 9: A duck's luck Book 10: The king ang the ring
Library has: level 1 workbook 1 Blackline masters; level 3 Blackline masters; level 3 teacher's annotated edition; level 6 Blackline masters.
Library has: Elementary workbook (2 eks); Elementary Student's book (2 eks); Starter Student's book; Intermediate Student's book.
Library has: Student's book 6
Library has: Level 2; level 3
Library has: level 1; level 2; level4; level5; level 6.