SELECT biblio.biblio_id, biblio.title, biblio.image, biblio.isbn_issn,
biblio.publish_year, pbl.publisher_name AS `publisher`, pplc.place_name AS `publish_place`, biblio.labels, biblio.input_date FROM biblio LEFT JOIN mst_publisher AS pbl ON biblio.publisher_id=pbl.publisher_id LEFT JOIN mst_place AS pplc ON biblio.publish_place_id=pplc.place_id WHERE opac_hide=0 AND (biblio.biblio_id IN (SELECT ba.biblio_id FROM biblio_author AS ba LEFT JOIN mst_author AS a ON ba.author_id=a.author_id WHERE author_name LIKE '%Mei, Ruo%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
3
1
20
The beginner's guide to Chinese painting ; plum,orchid,bamboo and chrysanthemum
Mei, Ruo
Primary Author
mixed material
9781602201095
New York
Better Link Press
2008
712RJmfytlL._AC_UY218_.jpg.jpg
The beginner's guide to Chinese painting :
birds and insect
Mei, Ruo
Primary Author
mixed material
9781602201088
New York
Better Link Press
2008
61nF5-26ZcL.jpg.jpg
The beginner's guide to Chinese painting :
flowers
Mei, Ruo
Primary Author
mixed material
9781602201101
New York
Better Link Press
2008
107867455262de5a2b34bbb3.64136802.jpg