return $this->db->query("
SELECT `ap`.`status`, `ap`.`product_id`, `ap`.`sku` as `amazon_sku`, `pd`.`name` as `product_name`, `p`.`model` as `product_model`, `p`.`sku` as `product_sku`, `ap`.`var` as `var`
FROM `" . DB_PREFIX . "amazon_product` as `ap`
LEFT JOIN `" . DB_PREFIX . "product_description` as `pd`
ON `ap`.`product_id` = `pd`.`product_id`
LEFT JOIN `" . DB_PREFIX . "product` as `p`
ON `ap`.`product_id` = `p`.`product_id`
WHERE `ap`.`status` = 'saved'
AND `pd`.`language_id` = '" . (int)$this->config->get('config_language_id') . "'")->rows;
