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 '%Master collection%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
4
1
20
Digital painting techniques:
volume 5
Master collection
Primary Author
mixed material
9781909414013
United Kingdom
3DTotal Publishing
2013
%2B-%2B782014713_140.jpg.jpg
Digital painting techniques :
volume 4
Master collection
Primary Author
3Dtotal.com (Firm)
Primary Author
mixed material
9780956817129
United Kingdom
3Dtotal Pub
2012
%2B-%2B781606832_140.jpg.jpg
Digital painting techniques :
volume 3
Master collection
Primary Author
mixed material
9780955153068
United Kingdom
3DTotal Publishing
2011
%2B-%2B517494902_140.jpg.jpg
Digital painting techniques (volume 2)
Master collection
Primary Author
mixed material
9780955153013
United Kingdom
3DTotal Publishing
2010
51QIlHP956L._SX384_BO1%2C204%2C203%2C200_.jpg.jpg