alter view vBluesealProductNameList as 
SELECT
  `pn`.`productId`                                                                   AS `productid`,
  `pn`.`productVariantId`                                                            AS `productVariantId`,
  `pn`.`langId`                                                                      AS `langId`,
  group_concat(DISTINCT concat(`p`.`id`, '-', `p`.`productVariantId`) SEPARATOR ',') AS `code`,
  group_concat(DISTINCT `pc`.`slug` SEPARATOR ',')                                   AS `slug`,
  `pn`.`name`                                                                        AS `name`,
  count(pn.productVariantId)                                       AS `count`,
  max(ProductStatus.isVisible) as isVisible
FROM (((`ProductNameTranslation` `pn`
  JOIN `Product` `p`
    ON (((`pn`.`productId` = `p`.`id`) AND (`pn`.`productVariantId` = `p`.`productVariantId`)))) LEFT JOIN
  (`ProductHasProductCategory` `phpc`
    JOIN `ProductCategory` `pc` ON ((`phpc`.`productCategoryId` = `pc`.`id`)))
    ON (((`p`.`id` = `phpc`.`productId`) AND (`p`.`productVariantId` = `phpc`.`productVariantId`)))) JOIN
  `ProductStatus`)
WHERE (
  (`ProductStatus`.`id` = `p`.`productStatusId`) AND (`ProductStatus`.`code` IN ('P')) AND (`pn`.`langId` = 1)
  AND (`p`.`qty` > 0))
GROUP BY `pn`.`name`