/** * @return \Magento\Framework\DB\Select */ public function getLogDataSelect() { $fields = ['visitor_id' => 'lv.visitor_id', 'customer_id' => 'lc.customer_id', 'session_id' => 'lv.session_id', 'last_visit_at' => 'lv.last_visit_at']; /** @var \Magento\Framework\DB\Select $select */ $select = $this->sourceAdapter->getSelect(); $select->from(['lv' => $this->source->addDocumentPrefix('log_visitor')], $fields)->joinLeft(['lc' => $this->source->addDocumentPrefix('log_customer')], 'lv.visitor_id = lc.visitor_id', [])->group('lv.visitor_id')->order('lv.visitor_id'); return $select; }