| 1234567 |
- select t1.fitemclsnum,
- (&attchdownurl&+ convert (varchar (10), case when docinfoid is not null then docinfoid else t3.fdefaultitempic end)) as picurl
- from titemclass t1
- left join doclinks t2 on t1.titemclassid = t2.ownerid and t2.ownertable = 'titemclass' and
- (t2.document like '%jpg' or t2.document like '%png')
- left join sysvars t3 on t3.siteid = t1.siteid
- where t1.fitemclsnum in $fitemclsnum$ and t1.siteid=$siteid$
|
