Select `product_id`, `cnt` from (select `product_id`, count(*) as `cnt`
from `product_prop`
where `prop_id` in (1,2,3,...)
group by `product_id`) as q1
order by `cnt` desc...
var webStream = request.GetResponse().GetResponseStream();
using (StreamReader sr = new System.IO.StreamReader(webStream) )
{
string line;
// Read and display lines from the file until the end of
// the file is reached.
while ((line = sr.ReadLine()) != null)
{
Console.WriteLine(line);
}
}