CREATE DEFINER=`blisstechindo22`@`%` PROCEDURE `Default_Client_Content`(IN ShopID CHAR(4))
BEGIN
 # DECLRE PARAMETER
 SET @ShopID = ShopID;
 SET @TABLEID = 'E2Q6';
 SET @DETAIL_TABLEID = 'JADC';

 SET @MasterClass =
        (SELECT
            CompletedJsonFormat(
                GROUP_CONCAT(
          DISTINCT(
            JSON_OBJECT(
              "ClassID", C.ClassID,
              "Name", C.`Name`
            )
          )
        )
      )
        FROM
         Class C
    WHERE
     C.ShopID = @ShopID);

 SET @MasterStatus =
        (SELECT
            CompletedJsonFormat(
                GROUP_CONCAT(
          DISTINCT(
            JSON_OBJECT(
              "StatusID", S.StatusID,
              "Name", M.`Value`
            )
          )
        )
      )
        FROM
         `Status` S
    INNER JOIN
     MasterStatus M ON M.MasterStatusID = S.MasterStatusID
    WHERE S.MasterTableID = @TABLEID);

    SELECT @MasterClass MasterClass, @MasterStatus MasterStatus;
END