请问这句SQL是什么意思？

select username,title,oldprice,price,p_price from information where (loginname,thetime) in (select loginname,max(thetime) from information where p_type='$p_type' group by loginname )order by p_price desc;

太长了，搞不懂！