Join our Email List Berghahn Books Logo

berghahn New York · Oxford

  • Facebook
  • Twitter
  • Youtube
  • Instagram



By Subject: Urban Studies

View: By Date | Alphabetical | eBooks | Paperbacks

SELECT rowtag,isbn,e_isbn,oa_isbn,cover_img,author_index,title_index,title_detail,subtitle,subject_1,subject_2,subject_3,subject_4,description,description_short,is_epub,on_sale,price_dollars,price_pounds,epub_price_dollars,epub_price_pounds,pub_date,publishing_status,year,season,release_date,cover_type FROM `stock` WHERE title_detail!='0' AND title_detail!='' AND active='1' AND (subject_1='urba' or subject_2='urba' or subject_3='urba' or subject_4='urba') ORDER BY TRIM( LEADING '(' FROM TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( replace(title_detail,'\'',''))))))