// Get filter name: value
$q = $this->db->query("SELECT pf.product_id, fgd.name as name_param, fd.name as name_value FROM `".DB_PREFIX."product_filter` pf
LEFT JOIN `".DB_PREFIX."filter` f ON (f.filter_id = pf.filter_id)
LEFT JOIN `".DB_PREFIX."filter_description` fd ON (fd.filter_id = pf.filter_id)
LEFT JOIN `".DB_PREFIX."filter_group_description` fgd ON (fgd.filter_group_id = fd.filter_group_id) WHERE pf.product_id = ".$this->request->get['product_id']." ");
$data['attributes_from_filter'] = array();
// print_r ($q->rows); exit;
if ($q->rows) {
foreach ($q->rows as $row) {
$data['attributes_from_filter'][] = array(
'name' => $row['name_param'],
'value' => $row['name_value']
);
}
}
Вот так этот выглядит в контроллере продукта