내가 추천한 글/댓글 목록 보기 ... 작업중

$args = new stdClass;
$args->member_srl = $this->user->member_srl;

// 중략

$oDB = DB::getInstance();
$query = '
(SELECT document_voted_log.document_srl, null as comment_srl, document_voted_log.member_srl, document_voted_log.ipaddress, document_voted_log.regdate as voted_date, document_voted_log.point
FROM document_voted_log LEFT JOIN comment_voted_log ON document_voted_log.member_srl = comment_voted_log.member_srl
WHERE document_voted_log.member_srl = ?)
UNION
(SELECT null as document_srl, comment_voted_log.comment_srl, comment_voted_log.member_srl, comment_voted_log.ipaddress, comment_voted_log.regdate as voted_date, comment_voted_log.point
FROM document_voted_log RIGHT JOIN comment_voted_log ON document_voted_log.member_srl = comment_voted_log.member_srl
WHERE comment_voted_log.member_srl = ?)
ORDER BY voted_date ASC LIMIT 20
';
$stmt = $oDB->query($query, [$args->member_srl, $args->member_srl]);
$result = $stmt->fetchAll();