select  product.name,product.shortdescription, product.codigoeanunidade,product.procodigo,
categories = STUFF((
    SELECT ', ' + c.name FROM category c
	inner join product_category_mapping pcm on c.id = pcm.categoryid
    WHERE pcm.productid = product.id
	and c.name <> 'Pesquisa'
	and c.parentcategoryid <> 13483
    FOR XML PATH(''), TYPE).value('.[1]', 'nvarchar(max)'), 1, 2, '')
from product product
where product.published = 1
and product.filcodigo = 1
for xml auto