OpenCart 🇺🇦

$sql = "
	SELECT p.product_id, marketplace, aps.status, aps.data, aps.matches
	FROM " . DB_PREFIX . "product p
	LEFT JOIN " . DB_PREFIX . "amazon_product_search aps ON p.product_id = aps.product_id AND aps.marketplace = '" . $this->db->escape($data['filter_marketplace']) . "'
	LEFT JOIN " . DB_PREFIX . "amazon_product_link apl ON p.product_id = apl.product_id
	LEFT JOIN " . DB_PREFIX . "amazon_product ap ON p.product_id = ap.product_id
	WHERE apl.product_id IS NULL AND ap.product_id IS NULL ";

if (!empty($data['status'])) {
	$sql .= " AND aps.status = '" . $this->db->escape($data['status']) . "'";
}

$sql .= " LIMIT " . (int)$data['start'] . ", " . (int)$data['limit'];

$results = array();

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

foreach ($rows as $row) {
	$results[] = array(
		'product_id' => $row['product_id'],
		'marketplace' => $row['marketplace'],
		'status' => $row['status'],
		'matches' => $row['matches'],
		'data' => json_decode($row['data'], 1),
	);
}

return $results;