annotation.name = PYRD_RAT anotation.type = B10 page.format = summary page.num = 1 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 INNER JOIN note AS n ON ci.sub_id_fk=n.sub_id_fk INNER JOIN annotation AS a ON n.anno_id_fk=a.anno_id WHERE c.free = 1 AND a.short_desc LIKE 'PYRD\\_RAT' AND c.purchasable IN (1,2,4,5) LIMIT 50
//zinc12.docking.org/results/combination?annotation.name=PYRD_RAT&filter.purchasability=purchasable