SELECT a.id, a.book_title, a.description, a.ad_image, a.image_tag, a.isbn, a.asking_price, a.book_condition, a.book_store_url, a.sg_type, a.url_path, c.subject_id, c.subject FROM tbl_used_book as a, tbl_booksubject_description as b, tbl_level_subjects as c WHERE a.exam_code = "ilts-english-language-proficiency-test-ilts-055" AND a.subject_id = b.subject_id AND a.subject_id = c.subject_id AND a.is_available = "1"