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 '%Lovell, Matt%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
1
1
20
The Essential Guide to Road Cycling 2013
Future Publishing Limited
Primary Author
Owen, Richard
Editor
Barbour, Matthew
Contributor
Clarke, Will
Contributor
Cook, Nik
Contributor
Duffy, Glenn
Contributor
Kelly, Siobhan
Contributor
Lovell, Matt
Contributor
McGregor, Renee
Contributor
Morgan, Nick
Contributor
Motton, David
Contributor
Murphy, Sam
Contributor
Pedoe, Neil
Contributor
Raymond, Kevin
Contributor
Sargent, Rebecca
Contributor
Smith, Nicola
Contributor
Stone, Hilary
Contributor
mixed material
977178930003
London
Future Publishing Limited
2013