SELECT * FROM journal,volume,issue WHERE jr_id=vol_jr_id AND vol_id=isu_vol_id AND vol_jr_id='25' AND isu_isactive=1 GROUP BY vol_id ORDER BY vol_year DESC, isu_date DESC