alter view vBluesealMarketplaceProductList as SELECT
  concat(`p`.`id`, '-', `p`.`productVariantId`)           AS `code`,
  `p`.`id`                                                AS `id`,
  `p`.`productVariantId`                                  AS `productVariantId`,
  `p`.`itemno` AS `itemno`,
  concat(pss.name, pss.year) as season,
  `pb`.`name`                                             AS `brand`,
  `p`.`creationDate`                                      AS `creationDate`,
  concat(ifnull(`m`.`name`, ''), ifnull(`ma`.`name`, '')) AS `marketplaceAccountName`,
  `s`.`name`                                              AS `shop`
FROM (((((((`Product` `p`
  JOIN `ProductStatus` `ps` ON ((`p`.`productStatusId` = `ps`.`id`)))
  JOIN `ShopHasProduct` `shp` ON (((`p`.`id` = `shp`.`productId`) AND (`p`.`productVariantId` = `shp`.`productVariantId`))))
  JOIN `Shop` `s` ON ((`s`.`id` = `shp`.`shopId`)))
  JOIN `ProductSeason` pss ON pss.id = p.productSeasonId
  JOIN `ProductBrand` `pb` ON ((`p`.`productBrandId` = `pb`.`id`)))
  LEFT JOIN `MarketplaceAccountHasProduct` `mahp` ON (((`mahp`.`productId` = `p`.`id`) AND (`mahp`.`productVariantId` = `p`.`productVariantId`))))
  LEFT JOIN `MarketplaceAccount` `ma` ON (((`ma`.`marketplaceId` = `mahp`.`marketplaceId`) AND (`ma`.`id` = `mahp`.`marketplaceAccountId`))))
  LEFT JOIN `Marketplace` `m` ON ((`m`.`id` = `ma`.`marketplaceId`)))
WHERE ((`ps`.`isReady` = 1) AND (`p`.`qty` > 0))