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 StudiesFilm and Television StudiesGender Studies and SexualityHistory (all titles)History (General)Colonial HistoryGenocide HistoryJewish StudiesMemory StudiesHistory: Medieval/Early ModernHistory: 18th/19th CenturyHistory: World War IHistory: World War IIHistory: 20th Century to PresentMobility Studies (all titles)Mobility StudiesRefugee and Migration StudiesTransport StudiesTravel and TourismSociologyPeace and Conflict Studies

All Areas (Change) AfricaAsiaAsia-PacificMiddle 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 (subject_1='' or subject_2='' or subject_3='' or subject_4='') ORDER BY TRIM( LEADING '(' FROM TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( replace(title_detail,'\'',''))))))