Filter by

  • Publication Year
    To
  • Availability
  • Attachment
  • Collection Type
    See More
  • General Material Designation
    See More
  • Location
    See More
  • Language
    See More
Found 4 from your keywords: subject="Medicine"
# 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 => "%Medicine%"
]
cover
A Bad Case of Stripes
Comment Share
David Shannon

A bad case of stripes.

Edition
-
ISBN/ISSN
0439079551
Collation
CBAS 1616
Series Title
-
Call Number
700 SHA
cover
Doctor Quack
Comment Share
Geraldine McCaughrean

Out from the pack came a greenish bottle, full of greenish liquid. Benedick held it like a green duck egg, like a handful of precious emeralds."This medicine," he said, "will cure coughs and colds and collywobbles. This medicine will heal hives,hiccups and whooping cough!". Benedick now travel from town to town to selling cure and potion.

Edition
-
ISBN/ISSN
0340866063
Collation
-
Series Title
-
Call Number
FA MCC
cover
Ilmu Kesehatan Olah Raga
Comment Share
Prof. H. Y. S Santosa Giriwijoyo

Buku ini menguraikan secara terperinci tata hubungan antara olahraga dengan kesehatan, cara mlakukan olahraga untuk kesehatan, berapa berat olahraga harus dilakukan dan permasalah penting lainnya yang menyangkut kesehatan.

Edition
-
ISBN/ISSN
9789796920853
Collation
-
Series Title
-
Call Number
610 GIR
cover
George's Marvellous Medicine
Comment Share
Quentin BlakeRoald Dahl

Goerge has a grizzly old grunion of grandma with revolting eating habits. Ehan he can't stand her any longer, Goerge decides to cure her nastiness for good

Edition
-
ISBN/ISSN
014031492X
Collation
-
Series Title
-
Call Number
FA DAH