SUMMER READING SALE! 30% off all eBooks until Sept 2nd!
Join our Email List Berghahn Books Logo

berghahn New York · Oxford

  • Facebook
  • Twitter
  • Youtube
  • Instagram
Browse

Browse

history-all|all

By Subject: History (all titles)


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='hist_earl' or subject_2='hist_earl' or subject_3='hist_earl' or subject_4='hist_earl' or subject_1='hist_1819' or subject_2='hist_1819' or subject_3='hist_1819' or subject_4='hist_1819' or subject_1='hist_20' or subject_2='hist_20' or subject_3='hist_20' or subject_4='hist_20' or subject_1='hist_wwi' or subject_2='hist_wwi' or subject_3='hist_wwi' or subject_4='hist_wwi' or subject_1='hist_wwii' or subject_2='hist_wwii' or subject_3='hist_wwii' or subject_4='hist_wwii' or subject_1='hist_post' or subject_2='hist_post' or subject_3='hist_post' or subject_4='hist_post' or subject_1='hist_geno' or subject_2='hist_geno' or subject_3='hist_geno' or subject_4='hist_geno' or subject_1='hist_colo' or subject_2='hist_colo' or subject_3='hist_colo' or subject_4='hist_colo' or subject_1='hist' or subject_2='hist' or subject_3='hist' or subject_4='hist') ORDER BY TRIM( LEADING '(' FROM TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( replace(title_detail,'\'',''))))))