OpenCart 🇺🇦

$this->log('getEndedListingArray()');
$active = $this->getLiveListingArray();

$qry = $this->db->query("SELECT e.* FROM (SELECT `product_id`, MAX(`ebay_listing_id`) as `ebay_listing_id` FROM `" . DB_PREFIX . "ebay_listing` WHERE `status` = 0 GROUP BY `product_id`) `a` INNER JOIN `" . DB_PREFIX . "ebay_listing` `e` ON (`e`.`ebay_listing_id` = `a`.`ebay_listing_id`)");

$data = array();
if($qry->num_rows > 0) {
	foreach($qry->rows as $row) {
		$data[$row['product_id']] = $row['ebay_item_id'];
	}
}

foreach($active as $k => $v) {
	if(array_key_exists($k, $data)) {
		unset($data[$k]);
	}
}

return $data;