Отзывы

SELECT ur.manager_guid,
i.sku AS "Артикул", i.title AS "Название товара", i.url,
urt.title AS "Тип", urs.title AS "Статус", ur.topic AS "Отзыв", ur.created_at AS "Дата отзыва",
m.message AS "Ответ", m.created_at AS "Дата ответа"
FROM user_request ur JOIN user_request_type urt ON ur.type_id=urt.id
JOIN user_request_status urs ON ur.status_id =urs.id
JOIN item i ON ur.item_guid=i.guid
JOIN message m ON ur.guid=m.user_request_id
JOIN USER u ON ur.user_guid =u.guid
WHERE u.email LIKE 'dg%.swdev.web@nag.ru'
ORDER BY ur.created_at DESC