SELECT * FROM qs_product p, qs_brand b, qs_group_product g WHERE p.brand_id = b.id AND p.group_id = g.group_id AND p.type = 'server' AND b.f_code = 'LENOVO' AND p.product_name = 'Lenovo ThinkServer TS460' AND g.group_name = 'Tower : Single Socket' AND p.product_ranking NOT IN ('','0') ORDER BY p.product_ranking
