using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand()
                {
                    CommandText = string.Format(
                    "SELECT * FROM " +
                        "(SELECT I.col1, Count(*) as [Count] " +
                        "FROM I " +
                            "INNER JOIN ITS ON ITS.col1 = I.col1 " +
                            "INNER JOIN IT ON IT.col2=ITS.col2 " +
                        "WHERE IT.col3 IN ('{0}') " +
                            "AND I.col4 = (SELECT col4 FROM E WHERE col5 = '{1}') " +
                        "GROUP BY col1 " +
                        "HAVING Count(*) > 0) T " +
                    "ORDER BY T.[Count] DESC", string.Join("', '", t), guid),
                    Connection = conn
                };
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    if (reader != null)
                    {
                        int curCount = -1;
                        while (reader.Read()) ------- Вот в WHILE уже не заходит, но если запрос руками выполнять, то результат есть. В DB Profiler также результат есть.
                        {
                            if (curCount <= int.Parse(reader["Count"].ToString()))
                            {
                                candidateList.Add(new MlgImage()
                                {
                                     ..........................
                                });
                                curCount = int.Parse(reader["Count"].ToString());
                            }
                            else break;
                        }
                        reader.Close();
                    }
                }
            }