var product = db.Query(sqlSelect, article)

 @foreach (var item in product) 
            {
                <li>
                    <div>
                        <figure class="img-thumbnail">
                            <a href="/ProductDetails/@item.productID">@Products.ShowFeaturedProductThumbnail(item.articleRec)</a>                    
                            <figcaption class="productText">
                                <hgroup>
                                    <h3>
                                        <span><a href="/ProductDetails/@item.productID">Арт. @item.articleRec </a></span>
                                    </h3>
                                    <h4><span>@item.titleRec</span></h4>
                                    <h4><span class="price">@item.priceRec RUB</span></h4>
                                </hgroup>
                            </figcaption>
                            <p class="productText">
                                <a href="/ProductDetails/@item.productID" class="btn btn-primary" role="button">Подробнее ...</a>
                            </p>
                        </figure>
                    </div>                  
                </li>
            }

var sqlSelect = "SELECT P.productID, P.article, P.title, P.price, S.StatusName FROM ProductStatus AS S " +
            "LEFT OUTER JOIN (Categories AS C LEFT OUTER JOIN Products AS P ON C.categoryID = P.categoryID) ON S.StatusID=P.StatusID " +
            "WHERE S.StatusName='Новинка' " +
            "UNION " +
            "SELECT CP.cabinetProductID, CP.CabinetArticle, CP.CabinetTitle, CP.Price, S.StatusName FROM ProductStatus AS S " +
            "LEFT OUTER JOIN (CabinetCategories AS CC LEFT OUTER JOIN CabinetProducts AS CP ON CC.categoryCabinetID = CP.categoryCabinetID) ON S.StatusID=CP.StatusID " +
            "WHERE S.StatusName='Новинка'";