Parameters Provided:
target.name = CAH1-9-E
target.type = B10
page.format = summary
page.num = 1
filter.purchasability = purchasable
Structural Results Found: (before additional filtering)
SQL Query Was
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 activity AS ac ON ci.sub_id_fk=ac.sub_id_fk INNER JOIN target AS t ON ac.target_fk=t.target_id WHERE c.free = 1 AND t.code LIKE 'CAH1-9-E' AND t.atype_fk = 0 AND c.purchasable IN (1,2,4,5) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?target.name=CAH1-9-E&target.type=B10&filter.purchasability=purchasable
Embed Link to Results