page.format = list page.num = 1 catalog.name = hmdbdrug filter.purchasability = purchasable
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 AND c.short_name LIKE 'hmdbdrug' AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 AND c.purchasable IN (1,2,4,5) ) LIMIT 50
//zinc12.docking.org/results/combination?catalog.name=hmdbdrug&filter.purchasability=purchasable