Select Code to Download

create table attribute_table ( blob_uni int, attribute text, value tex
+t );
create unique index a_t_uni on attribute_table ( blob_uni, attribute )
+;

select * from blob_table where id IN ( select blob_id from attribute_t
+able where attribute='color' and value='red );