WWII-century-history|all

All Subjects (Change) Anthropology (all titles)Anthropology (General)Anthropology of ReligionApplied AnthropologyDevelopment StudiesFood & NutritionMedical AnthropologyPolitical and Economic AnthropologyTheory and MethodologyArchaeologyCultural Studies (all titles)Cultural Studies (General)Heritage StudiesMuseum StudiesLiterary StudiesMedia StudiesPerformance StudiesEducational StudiesEnvironmental Studies (all titles)Environmental Studies (General)Urban StudiesSustainable Development GoalsFilm and Television StudiesGender Studies and SexualityGeographyHistory (all titles)History (General)Colonial HistoryGenocide HistoryJewish StudiesMemory StudiesHistory: Medieval/Early ModernHistory: 18th/19th CenturyHistory: World War IHistory: World War IIHistory: 20th Century to PresentHistory: 21st CenturyMobility Studies (all titles)Mobility StudiesRefugee and Migration StudiesRoma StudiesTransport StudiesTravel and TourismSociologyPeace and Conflict Studies

All Areas (Change) AfricaAsiaAsia-PacificSouth/CentralAsiaMiddle East & IsraelCircumpolarNorth AmericaLatin America and the CaribbeanEuropeNorthern EuropeSouthern EuropeCentral/Eastern EuropeFranceGermany

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 ORDER BY TRIM( LEADING '(' FROM TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( replace(title_detail,'\'',''))))))