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 '%Rigney, Ryan%')) ORDER BY biblio.publish_year DESC, biblio.title ASC LIMIT 0, 20
1
1
20
Edge:
Issue 259 November 2013
Future Publishing Limited
Primary Author
Alexander, Leigh
Contributor
Brandle, Rose
Contributor
Ellison, Cara
Contributor
Fyfe, Duncan
Contributor
Harris, Duncan
Contributor
Hocking, Clint
Contributor
Howe, Brian
Contributor
Kelly, Tadhg
Contributor
Leach, James
Contributor
Owens, Craig
Contributor
Poole, Steven
Contributor
Rigney, Ryan
Contributor
Russell, Jamie
Contributor
Salmon, Will
Contributor
Shchilling, Chris
Contributor
Stuart, Keith
Contributor
Thursten, Chris
Contributor
Weetman, Alvin
Contributor
Wiltshire, Alex
Contributor
mixed material
029074041795
London
Future Publishing Limited
2013
16556273566ab04b69b3bb0.52936767.PNG