The images on the patterns below meet our minimum threshold for card publication, but we're not thrilled with them. They don't have to be replaced, but it would be better if they were. When push comes to shove and its time to publish, we'll use whichever ones of these are left.
(Also see image ready / want better image)
No results? ActiveRecord::StatementInvalid: Mysql2::Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery': (select coalesce(count(*),0) as count from cards t where t.id in (select tx.id from cards tx where tx.typecode = 'Pattern5' and (tx.id in (select txx.trunk_id from cards txx where txx.tag_id in (select txxx.id from cards txxx where txxx.key = 'image_statu' and (txxx.read_rule_id IN (11336)) and txxx.trash is false ) and txx.id in (select card_id from wiki_references where referenced_card_id IN (select txxx.id from cards txxx where txxx.key = 'image_good_enough' and (txxx.read_rule_id IN (11336)) and txxx.trash is false )) and (txx.read_rule_id IN (11336)) and txx.trash is false ) or tx.id in (select txx.tag_id from cards txx where txx.id in (select card_id from wiki_references where referenced_card_id IN (select txxx.id from cards txxx where txxx.key = 'image_good_enough' and (txxx.read_rule_id IN (11336)) and txxx.trash is false )) and txx.trunk_id in (select txxx.id from cards txxx where txxx.key = 'image_statu' and (txxx.read_rule_id IN (11336)) and txxx.trash is false ) and (txx.read_rule_id IN (11336)) and txx.trash is false )) and (tx.read_rule_id IN (11336)) and tx.trash is false LIMIT 500 ) and (t.read_rule_id IN (11336)) and t.trash is false LIMIT 20 OFFSET 0)
{"found_by":"_self",
"return":"count"
}
images
{"found_by":"_self", "return":"count" }
.