Ticket tags+by create+tix
No results? ActiveRecord::StatementInvalid: Mysql2::Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery': (select t.name from cards t where t.id in (select tx.id from cards tx where tx.id in (select txx.id from cards txx where txx.id in (select referenced_card_id from wiki_references where card_id IN (select txxx.id from cards txxx where txxx.tag_id in (select txxxx.id from cards txxxx where txxxx.key = 'tag' and (txxxx.read_rule_id IN (20576,19077)) and txxxx.trash is false ) and txxx.trunk_id in (select txxxx.id from cards txxxx where txxxx.typecode = 'Ticket' and (txxxx.id in (select txxxxx.trunk_id from cards txxxxx where txxxxx.tag_id in (select txxxxxx.id from cards txxxxxx where txxxxxx.key = 'statu' and (txxxxxx.read_rule_id IN (20576,19077)) and txxxxxx.trash is false ) and txxxxx.id in (select card_id from wiki_references where referenced_card_id IN (select txxxxxx.id from cards txxxxxx where txxxxxx.key = 'open' and (txxxxxx.read_rule_id IN (20576,19077)) and txxxxxx.trash is false )) and (txxxxx.read_rule_id IN (20576,19077)) and txxxxx.trash is false ) or txxxx.id in (select txxxxx.tag_id from cards txxxxx where txxxxx.id in (select card_id from wiki_references where referenced_card_id IN (select txxxxxx.id from cards txxxxxx where txxxxxx.key = 'open' and (txxxxxx.read_rule_id IN (20576,19077)) and txxxxxx.trash is false )) and txxxxx.trunk_id in (select txxxxxx.id from cards txxxxxx where txxxxxx.key = 'statu' and (txxxxxx.read_rule_id IN (20576,19077)) and txxxxxx.trash is false ) and (txxxxx.read_rule_id IN (20576,19077)) and txxxxx.trash is false )) and (txxxx.read_rule_id IN (20576,19077)) and txxxx.trash is false ) and (txxx.read_rule_id IN (20576,19077)) and txxx.trash is false )) and (txx.read_rule_id IN (20576,19077)) and txx.trash is false LIMIT 200 ) and (tx.read_rule_id IN (20576,19077)) and tx.trash is false ) and (t.read_rule_id IN (20576,19077)) and t.trash is false ORDER BY t.updated_at desc LIMIT 20 OFFSET 0){"found_by": "_self", "append": "ticket tag summary", "view": "content"}