Add: I also looked at recent_comments.bml today and am thinking about whether to do something similar as in there, as it also gets some entry information based on the last comments with
my $lrow = $logrow{"$u->{userid} $r->{nodeid}"} ||= LJ::get_log2_row($u, $r->{'nodeid'});
But, basically, any suggestions welcomed. I have an early version of an SQL query so I can see what I actually need, how to sort it, etc., but I am far from set on actually *using* it.
no subject
my $lrow = $logrow{"$u->{userid} $r->{nodeid}"} ||= LJ::get_log2_row($u, $r->{'nodeid'});
But, basically, any suggestions welcomed. I have an early version of an SQL query so I can see what I actually need, how to sort it, etc., but I am far from set on actually *using* it.