SELECT S_Articles.UID AS UID,
S_Articles.Modified AS Modified,
S_Articles.Name AS Name,
S_Articles.PreTitle AS PreTitle,
S_Articles.Description AS Description,
S_ItemsCategories.ItemsCategoriesModeID AS ItemsCategoriesModeID,
S_Articles.HTML AS HTML, CASE
WHEN NOT S_Articles.HTML IS NULL AND N''>'' THEN
dbo.S_MarkPhrases((SELECT Text FROM dbo.S_RemoveTags(S_Articles.HTML) FOR XML RAW('a')), N'', '', '')
ELSE NULL END AS MarkedHTML,
[dbo].S_GetItemAttributesList(3, S_Articles.UID) AS AttributesList, CASE WHEN TitleLogoPictures.FileName>'' THEN '../UserFiles100/'+TitleLogoPictures.FileName ELSE '' END AS TitleLogoPictureFileName
FROM S_Articles
INNER JOIN S_ItemsCategories ON (S_ItemsCategories.ItemTypeID=3 AND S_Articles.UID=S_ItemsCategories.ItemUID)
LEFT JOIN S_Pictures AS TitleLogoPictures ON S_Articles.TitleLogoPictureUID=TitleLogoPictures.UID
WHERE S_ItemsCategories.ShopID=100
AND S_Articles.IsActive <> 0
AND S_Articles.ShopID = 100 AND S_ItemsCategories.CategoryUID = '{73DC18C8-E443-402D-A069-5E5AE2F6A821}' ORDER BY S_ItemsCategories.[Index]
