SELECT pbi_id,pbi_date,datepart(month,pbi_date) as mymonth, datename(YEAR,pbi_date) as myyear FROM PERIODIC_PUBLICATION_ISSUES_MAIN WHERE datename(YEAR,pbi_date)=2012 and datepart(MONTH,pbi_date)= 1 and (pbi_pbn_id = 457473 OR pbi_pbn_id IN (SELECT pbn_id FROM PERIODIC_PUBLICATIONS WHERE pbn_parent_id = 457473)) order by pbi_date desc Readpoint.com
FThis Kiosk Logo Readpoint Logo