OpenCart 🇺🇦

$query = "SELECT `apl`.`amazon_sku`, `apl`.`product_id`, `pd`.`name` as `product_name`, `p`.`model`, `p`.`sku`, `apl`.`var`, '' as `combi`
	FROM `" . DB_PREFIX . "amazon_product_link` as `apl`
	LEFT JOIN `" . DB_PREFIX . "product_description` as `pd`
	ON `apl`.`product_id` = `pd`.`product_id`
	LEFT JOIN `" . DB_PREFIX . "product` as `p`
	ON `apl`.`product_id` = `p`.`product_id`";
if($product_id != 'all') {
	$query .= " WHERE `apl`.`product_id` = '" . (int)$product_id . "' AND `pd`.`language_id` = '" . (int)$this->config->get('config_language_id') . "'";
}else{
	$query .= "WHERE `pd`.`language_id` = '" . (int)$this->config->get('config_language_id') . "'";
}

$rows = $this->db->query($query)->rows;

$this->load->library('amazon');
if ($this->openbay->addonLoad('openstock')) {
	$this->load->model('openstock/openstock');
	$this->load->model('tool/image');
	$rowsWithVar = array();
	foreach($rows as $row) {
		$stockOpts = $this->model_openstock_openstock->getProductOptionStocks($row['product_id']);
		foreach($stockOpts as $opt) {
			if($opt['var'] == $row['var']) {
				$row['combi'] = $opt['combi'];
				$row['sku'] = $opt['sku'];
				break;
			}
		}
		$rowsWithVar[] = $row;
	}
	return $rowsWithVar;
} else {
	return $rows;
}