Throughout history, there have been many women philosophers who have made significant contribution to the field. The list includes many familiar and great female philosophers such as Simone de Beauvoir, Mary Wollstonecraft, Rosa Luxemburg, Peter Kropotkin, Edith Stein.The women philosophers featured in this list are from United States, United Kingdom, Canada & Australia and many more countries.
SELECT a.*, a.status as fm_status , img.*, pr.boost_page_views, rnk.total_count as like_dislike_total_count, sd.description,
CASE WHEN (a.wiki_link!='' or a.status='1')THEN pr.boost_page_views ELSE 0 END AS FinalViews FROM features_master a JOIN features_cat_rel fcr ON a.ID = fcr.featuresId AND fcr.catId = 11
LEFT OUTER JOIN features_master_images img on a.ID=img.profile_id AND img.is_visible=1 LEFT OUTER JOIN profile_short_desc_manager as sd ON sd.profile_id = a.ID and verified = '1'
JOIN profile_ranking as pr ON pr.profile_id = a.ID
LEFT JOIN combi_category_profile_ranking AS rnk ON rnk.cat_id = 11 and rnk.profile_id = a.ID
WHERE a.status!='2' AND gender='women' group by a.ID
ORDER BY FinalViews DESC, a.wiki_link IS NOT NULL ,a.wiki_link DESC,a.status DESC,pr.boost_page_views DESC LIMIT 50 OFFSET 0