SELECT pcr.* FROM products_classifiers_ranking as pcr WHERE pcr.multiple_classifiers != '' AND pcr.product_ID IN () ORDER BY pcr.multiple_classifiers, pcr.rank DESC2013-05-21 19:05:27