我需要向查询添加一个额外的联接,但我不确定在什么上联接它。
SELECT DISTINCT * FROM {$this->prefix}category c
LEFT JOIN {$this->prefix}category_description cd
ON (c.category_id = cd.category_id)
LEFT JOIN {$this->prefix}category_to_store c2s
ON (c.category_id = c2s.category_id)
WHERE c.category_id = '" . (int)$category_id . "'
AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "'
AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'
AND c.status = '1'
我现在需要通过一个列值加入我的url_alias表,如:
SELECT keyword FROM {$this->prefix}url_alias
WHERE query = 'category_id=" . (int)$category_id . "'
--编辑以澄清--
这是针对一个OpenCart项目,该项目需要通过将关键字添加到现有类别/产品/制造商查询中来简化url重写。
这个怎么样:
SELECT DISTINCT * FROM {$this->prefix}category c
LEFT JOIN {$this->prefix}category_description cd
ON (c.category_id = cd.category_id)
LEFT JOIN {$this->prefix}category_to_store c2s
ON (c.category_id = c2s.category_id)
LEFT JOIN {$this->prefix}url_alias u
ON u.query = CONCAT('category_id=', c.category_id)
WHERE c.category_id = '" . (int)$category_id . "'
AND cd.language_id = '" . (int)$this->config->get('config_language_id') . "'
AND c2s.store_id = '" . (int)$this->config->get('config_store_id') . "'
AND c.status = '1'