SELECT TOP (100) PERCENT mj_t_MakingRecipeTag.TagMakingID, mj_t_MakingRecipe.RecipeTitle, mj_t_MakingRecipe.RecipeMaskTitle, mj_t_MakingRecipe.RecipeSlogan, mj_t_MakingRecipe.SortID, mj_t_MakingRecipe.Active, mj_t_ImageLibrary.ImageType, mj_t_ImageLibrary.ImageSRC FROM mj_t_Image LEFT OUTER JOIN mj_t_ImageLibrary ON mj_t_Image.ImageLibraryID = mj_t_ImageLibrary.ImageLibraryID RIGHT OUTER JOIN mj_t_MakingRecipe ON mj_t_Image.ParentID = mj_t_MakingRecipe.RecipeID RIGHT OUTER JOIN mj_t_MakingRecipeTag ON mj_t_MakingRecipe.RecipeID = mj_t_MakingRecipeTag.RecipeID WHERE (mj_t_MakingRecipe.Active = 1) AND (mj_t_MakingRecipeTag.TagMakingID=9) AND (mj_t_ImageLibrary.ImageType IS NULL OR mj_t_ImageLibrary.ImageType = N'RMAIN') ORDER BY mj_t_MakingRecipe.SortID
