structure.similarity = 0.90 structure.smiles = Cc1ccc(cc1)OCC(=O)Oc2ccc3ccccc3c2C=O page.num = 1 filter.purchasability = purchasable
SELECT DISTINCT(q.sub_id) AS sub_id FROM zinctmp.qury AS q INNER JOIN catalog_item AS ci ON q.sub_id=ci.sub_id_fk INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE q.qury_id = 10046964 AND q.sub_id >= 1 AND c.free = 1 AND c.purchasable IN (1,2,4,5) LIMIT 50