text: ﻿
  CREATE PROCEDURE [dbo].[app_MGHiddenPicBk_GetByIDWithParent] @MGID INT
  AS
  SELECT mg.*,
  	MiniGameTypeName,
  	AdminName,
  	GameName,
  	isActive,
  	NumberPoints,
  	AwardedBadgeID,
  	Acknowledgements
  FROM MGHiddenPicBk mg
  INNER JOIN dbo.Minigame g ON mg.MGID = g.MGID
  WHERE g.MGID = @MGID
  