SELECT DISTINCT autorin_id, autorin_vorname, autorin_nachname, institution, autorin_image, SUBSTRING(autorin_beschreibung,1,300) AS autorin_kurzbeschreibung, autorin_link FROM authors AS a LEFT JOIN titel_autoren AS ta ON a.autorin_id = ta.autorID LEFT JOIN books AS b ON ta.titelID = b.books_id WHERE (autorin_nachname LIKE 'x%' OR institution LIKE 'x%') AND (books_statustext LIKE 'lieferbar' OR books_statustext LIKE 'vergriffen' OR books_statustext LIKE 'in Vorbereitung') ORDER BY autorin_nachname, institution ASC
 
 

 

AutorInnen X




BONGANI XEZWI

 

Bongani Xezwi ist Aktivist und freischaffender Feldforscher in Johannesburg.

» DETAILS