Call +353 (0)51 440075
0
items in your basket
|      All Products
You Are Here : Home >>Posters

Posters

Primary Resources

select a.*,CONVERT(varchar(100),a.description) as desc1,b.name as parentname from tblcategory a left outer join tblcategory b on a.parentid=b.nid where a.bstatus=1 and a.islive=1 and a.parentid =5 and a.showin in ('Both', 'IE') and ( a.nid in ( select catid from getcategorybytype('primary','IE')) or a.nid in(select parentid from tblcategory where nid in ( select catid from getcategorybytype('primary','IE')) ))
Accept Cookies