select a.sno,a.imagename,a.imageurl,a.subject,a.cat_id,a.dateadded,a.magazine_headline,b.year from subscription_slider a,ranking_detail b where a.cat_id=73 and a.sno=b.mag_id and b.year in(2016,2015) group by b.mag_id order by b.year desc
Juniper Networks Industry News - Latest Business Analytics - Juniper Networks Technology Review | pgno=1