Women Philosophers

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