SELECT Company.CompanyID, Company.CompanyName, Article.ArticleID, Article.ArticleActiveDate, Article.ArticleNick, Article.ArticleName, Article.ArticleRubric FROM Article INNER JOIN CompanyArticle ON CompanyArticle.ArticleID = Article.ArticleID INNER JOIN Company ON CompanyArticle.CompanyID = Company.CompanyID WHERE Article.ArticleRubric = "Announce" AND Article.IsActive = 1 AND Article.ArticleActiveDate >= "2017-10-23 00:00:00" AND Article.ArticleActiveDate < "2017-10-23 23:59:59" ORDER BY Article.IsPremium DESC, Article.ArticleID ASC LIMIT 0,5 Тайвань

Материалы по направлению «Тайвань»