select SQL_CACHE dc.description, dc.title, mmp.id, mmp.resourceTypeID, fullsearch.bodytext, (nc_keystage.keystage4plus*5 + nc_keystage.keystage4*4 + nc_keystage.keystage3*3 + nc_keystage.keystage2*2 +nc_keystage.keystage1*1)/(nc_keystage.keystage4plus + nc_keystage.keystage4 + nc_keystage.keystage3 + nc_keystage.keystage2 +nc_keystage.keystage1) as SUMKSWEIGHT from monthManager,mmp,dc,nc_keystage,fullsearch where monthManager.publish_date="20090201000000" and dc.rel_mmp_id=mmp.id and mmp.status="published" and monthManager.rel_mmp_id=mmp.id and nc_keystage.rel_mmp_id=mmp.id and fullsearch.rel_mmp_id=mmp.id and mmp.resourceTypeID != 3 and mmp.resourceTypeID != 2 order by SUMKSWEIGHT desc ,difficulty desc