join so we can order by date and weight

--HG--
branch : noink