BEGIN
 
 SELECT * FROM `literature` where `status`=1 and auditstatus=2 and UID in
(
select ItemId from userfavdata 
where GroupName='literature' and deviceID=`pDeviceId`  

)

 order by literatureYear,MagazineName;

END

IN `pDeviceId` char(36)