(1)BAD SQL:select pi.ItemID,pi.ItemNo,pi.ItemTypeID,isnull(pi.Name,pi.NavDescription) as ItemName,pi.ImageItemNo,pi.Description,pi.Comment, pi.SubType, pi.int3 as [PinDiam], pi.int2 as [Height], pi.int1 as [Width], pi.int6 as [ADiam], pi.int7 as [BDiam], pi.str2 as [Model], pi.str1 as [Type], pi.dec1 as [SWL], pi.dec2 as [BRL], pi.int4 as [W], pi.int5 as [L] from pi_items pi where pi.Visibility='all' and ItemTypeID=58 and (sc:Type='standard') order by sc:PinDiam
With parameters:a:0:{}