SELECT
t2.PropertyName,
t1.Value
FROM Property AS t1
LEFT JOIN PropertyItem AS t2 ON t1.PropertyID=t2.PropertyID , Details
WHERE Details.DetailID=28783562142 and t1.GoodID = Details.GoodID ORDER BY t2.PropertyName
"Love2art" БГ-001 Кувшин с одной ручкой керамика 8.5 см /