From e355ff94fa1c3283daddb8bfd069c80f461e9d38 Mon Sep 17 00:00:00 2001 From: hylom Date: Thu, 4 Apr 2019 18:59:30 +0900 Subject: [PATCH] Model::Submissions: select() returns item with url field --- src/newslash_web/lib/Newslash/Model/Submissions.pm | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/newslash_web/lib/Newslash/Model/Submissions.pm b/src/newslash_web/lib/Newslash/Model/Submissions.pm index bdde1767..279ae4cf 100644 --- a/src/newslash_web/lib/Newslash/Model/Submissions.pm +++ b/src/newslash_web/lib/Newslash/Model/Submissions.pm @@ -167,6 +167,7 @@ SELECT submissions.*, firehose.neediness, firehose.activity, topics.*, + urls.url, discussions.type AS discussion_type, discussions.commentcount AS comment_count FROM submissions @@ -175,6 +176,7 @@ SELECT submissions.*, ON (submissions.subid = firehose.srcid AND firehose.type = "submission") LEFT JOIN discussions ON firehose.discussion = discussions.id LEFT JOIN topics ON submissions.tid = topics.tid + LEFT JOIN urls ON firehose.url_id = urls.url_id $where_clause $orderby_clause $limit_clause -- 2.11.0