SET @sqlList = NULL;
SET @query = NULL;
SELECT
GROUP_CONCAT(
DISTINCT CONCAT('GROUP_CONCAT(IF(`property` = "', `property`,'", `value`, NULL) ORDER BY `mp_sort`, `mp_id`, `m_sort`, `m_id`) AS "',`property`,'"')
ORDER BY `mp_sort`, `mp_id`, `m_sort`, `m_id`
)
INTO @sqlList
FROM `shop_v_model`
WHERE
`entity` = "user";
SET @query
= CONCAT('
CREATE VIEW `shop_v_model_user` AS
SELECT `entity`, `title`, `description`, ', @sqlList, '
FROM `shop_v_model`
WHERE
`entity` = "user"
GROUP BY `title`, `description`, `entity`
ORDER BY `title` ASC
');
-- SELECT @query;
PREPARE stmt FROM @query;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;