1 2 3 4 5 6 7
my @items = @clusters ? $c->itemclusterRS->search({ cluster_id => {'in' => [map {$_->id} grep {$_->status != 0} @clusters]}, 'item.status' => {'>', 0}, }, { join => 'item', 'order_by' => 'me.weight desc, item.ctime desc', }) : ();