SELECT rnkid,rnktitle,rankpicname,weburl,rankyear,mag_id,app_status,rank_banner_img FROM ranking where mag_id=(select sno from magazine_details where label2='April' and year=2019 and status != 0 and web_id = 27) and app_status=1 and web_id = 27

Top