select b.rnkid,b.weburl,a.cat_id,b.app_status,a.year,b.master_stat,a.url,a.image_name from magazine_details a left outer join ranking b on b.mag_id=a.sno where b.app_status != 0 and b.rnkid is not null and cat_id in(11,24,43,45,47,49,50,53,54,55,57,58,59,60,62,63,65,66,67,68,72,1,2,3,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,26,27,28,30,31,32,37,-1) and a.web_id = 22 and b.web_id = 22 order by a.position desc limit 1