public function getProducts($data) {
        $customer_group_id = $this->getCustomerGroup();

        $sql = "SELECT product_id FROM(";
        $sql .= "SELECT DISTINCT p.product_id, pd.name, p.model, p.quantity, p.price, p.sort_order, p.date_added ";
        if(isset($data["sort"]) && $data["sort"] == "rating") {
            $sql .= ", (SELECT AVG(rating) AS total FROM " . DB_PREFIX . "review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating ";
        }
        $sql .= ", p.price as realprice ";
        $sql .= "FROM " . DB_PREFIX . "product p" .
            " LEFT JOIN " . DB_PREFIX . "product_option_value pov ON (pov.product_id=p.product_id)" .
            " LEFT JOIN " . DB_PREFIX . "product_description pd ON (pd.product_id=p.product_id)" .
            " LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p2s.product_id=p.product_id)" .
            " LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p2c.product_id=p.product_id)";
        if (!empty($data['sub_categories']) || !empty($data['filter_sub_category'])) {
            $sql .= " LEFT JOIN " . DB_PREFIX . "category_path cp ON(cp.category_id=p2c.category_id) ";
        }
        if(!empty($data['attribute_value']) || !empty($data['attr_slider'])) {
            $sql .= " LEFT JOIN " . DB_PREFIX . "product_attribute p2a ON (p2a.product_id=p.product_id)";
        }

        if(!empty($data['tags'])) {
            $sql .= " LEFT JOIN " . DB_PREFIX . "product_tag p2t ON (p2t.product_id=p.product_id)";
        }

        if(!empty($data['attribute_value']) && (empty($this->filterpro_setting) || $this->filterpro_setting['attribute_mode'] == 'and')) {
            $i = 0;

            foreach($data['attribute_value'] as $attribute_id => $values) {
                $sql .= " LEFT JOIN " . DB_PREFIX . "product_attribute p2a" . $i . " ON (p2a" . $i . ".product_id=p2a.product_id)";
                $i++;
            }
        }

        $sql .= " WHERE 1";

        if(!empty($data['instock'])) {
            $sql .= " AND p.quantity > 0 AND (pov.quantity is null OR pov.quantity > 0)";
        }

        if (empty($data['categories']) && !empty($data['filter_category_id'])) {
            $data['categories'][] = $data['filter_category_id'];
        }
        if($data['categories']) {
            if (empty($data['sub_categories']) && empty($data['filter_sub_category'])) {
                $sql .= " AND p2c.category_id IN (" . implode(",", $data['categories']) . ")";
            } else {
                $sql .= " AND cp.path_id IN (" . implode(",", $data['categories']) . ")";
            }
        }

        $option_filters = array();
        if(!empty($data['option_value'])) {
            foreach($data['option_value'] as $option_value) {
                $option_filters[] = "option_value_id IN(" . implode(",", $option_value) . ")";
            }
        }

        if($option_filters) {
            if(empty($this->filterpro_setting) || $this->filterpro_setting['option_mode'] == 'and') {
                foreach($option_filters as $i => $option_filter) {
                    $sql .= " AND EXISTS (select 1 FROM " . DB_PREFIX . "product_option_value pov" . $i .
                        " WHERE pov" . $i . ".product_id=pov.product_id AND pov" . $i . "." . $option_filter . ($data['instock'] ? "AND pov" . $i . ".quantity > 0"
                            : "") . ") ";
                }
            } else {
                $sql .= " AND (" . implode(" OR ", $option_filters) . ")";
            }
        }

        if(!empty($data['manufacturer'])) {
            $sql .= " AND p.manufacturer_id IN(" . implode(", ", $data['manufacturer']) . ")";
        }

        if(!empty($data['tags'])) {
            $sql .= " AND p2t.tag IN( '" . implode("', '", array_map(array($this->db, 'escape'), $data['tags'])) . "') AND p2t.language_id='" . (int)$this->config->get('config_language_id') . "' ";
        }

        $d = $this->filterpro_setting['attr_delimeter'];

        if(!empty($data['attribute_value'])) {
            if(empty($this->filterpro_setting) || $this->filterpro_setting['attribute_mode'] == 'and') {
                $i = 0;

                foreach($data['attribute_value'] as $attribute_id => $values) {
                    if(empty($this->filterpro_setting) || $this->filterpro_setting['attribute_value_mode'] == 'or') {

                        $sql .= " AND p2a" . $i . ".attribute_id = " . (int)$attribute_id .
                            " AND (p2a" . $i . ".text LIKE '%" . implode("%' OR p2a" . $i . ".text LIKE '%", array_map(array($this->db, 'escape'), $values)) . "%')";

                        $i++;
                    } else {
                        foreach($values as $value) {
                            $sql .= " AND  p2a" . $i . ".attribute_id = " . (int)$attribute_id .
                                " AND p2a" . $i . ".text = '" . $this->db->escape($value) . "'";
                            $i++;
                        }
                    }
                }
            } else {
                foreach($data['attribute_value'] as $attribute_id => $values) {
                    $attribute_filters[] = "p2a.attribute_id = " . (int)$attribute_id .
                        " AND (p2a.text = '" . implode("' OR p2a.text = '", array_map(array($this->db, 'escape'), $values)) . "'" .
                        ")";
                    /*										   " OR p2a.text like '" . implode($d . "%' OR p2a.text like '", array_map(array($this->db, 'escape'), $values)) . $d . "%'" .
                                                               " OR p2a.text like '%" . $d . implode("' OR p2a.text like '%" . $d, array_map(array($this->db, 'escape'), $values)) . "'" .
                                                               " OR p2a.text like '%" . $d . implode($d . "%' OR p2a.text like '%" . $d, array_map(array($this->db, 'escape'), $values)) . $d . "%')";*/
                }
                $sql .= " AND (" . implode(" OR ", $attribute_filters) . ")";
            }
        }

        if(!empty($data['attr_slider'])) {
            $i = 0;
            foreach($data['attr_slider'] as $attribute_id => $values) {
                if(!isset($values['min'])) {
                    $sql .= " AND EXISTS (select 1 FROM " . DB_PREFIX . "product_attribute p2a" . $i . " WHERE p2a" . $i . ".product_id = p2a.product_id AND p2a" . $i . ".attribute_id = " . (int)$attribute_id . " AND " .
                        "(p2a" . $i . ".text * 1 <= " . $values['max'] . ")) ";
                } elseif(!isset($values['max'])) {
                    $sql .= " AND EXISTS (select 1 FROM " . DB_PREFIX . "product_attribute p2a" . $i . " WHERE p2a" . $i . ".product_id = p2a.product_id AND p2a" . $i . ".attribute_id = " . (int)$attribute_id . " AND " .
                        "(p2a" . $i . ".text * 1 >= " . $values['min'] . ")) ";

                } else {
                    $sql .= " AND EXISTS (select 1 FROM " . DB_PREFIX . "product_attribute p2a" . $i . " WHERE p2a" . $i . ".product_id = p2a.product_id AND p2a" . $i . ".attribute_id = " . (int)$attribute_id . " AND " .
                        "(p2a" . $i . ".text * 1 BETWEEN " . $values['min'] . " AND " . $values['max'] . ")) ";
                }
                $i++;
            }
        }

        if(!empty($data['min_price']) && $data['min_price'] >= 0) {
            $min_price = $this->currency->convert((int)$data['min_price'], $this->currency->getCode(), $this->config->get('config_currency'));
            $sql .= " AND p.price >=" . (int)($min_price);
        }

        $sql .= " AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p2s.store_id = " . (int)$this->config->get('config_store_id');

        $sort_data = array(
            'pd.name' => 'name',
            'p.model' => 'model',
            'p.quantity' => 'quantity',
            'p.price' => 'realprice',
            'p.sort_order' => 'sort_order',
            'p.date_added' => 'date_added',
            'rating' => 'rating'
        );

        $sql .= ") as innertable WHERE 1 ";
        if(!empty($data['min_price']) && $data['min_price']>= 0) {
            $min_price = $this->currency->convert((int)$data['min_price'], $this->currency->getCode(), $this->config->get('config_currency'));
            $sql .= "AND realprice >=" . (int)($min_price);
        }
        if(!empty($data['max_price']) && $data['max_price']> 0) {
            $max_price = $this->currency->convert($data['max_price'], $this->currency->getCode(), $this->config->get('config_currency'));
            $sql .= " AND realprice <=" . ($max_price);
        }

        if(isset($data['sort']) && array_key_exists($data['sort'], $sort_data)) {
            $data['sort'] = $sort_data[$data['sort']];
            if($data['sort'] == 'name' || $data['sort'] == 'model') {
                $sql .= " ORDER BY LCASE(" . $data['sort'] . ")";
            } elseif ($data['sort'] == 'realprice') {
                $sql .= " ORDER BY (realprice<>0) DESC, realprice";
            } else {
                $sql .= " ORDER BY " . $data['sort'];
            }
        } else {
            $sql .= " ORDER BY  sort_order";
        }
        if(isset($data['order']) && ($data['order'] == 'DESC')) {
            $sql .= " DESC, LCASE(name) DESC";
        } else {
            $sql .= " ASC, LCASE(name) ASC";
        }


        if(isset($data['start']) || isset($data['limit'])) {
            if($data['start'] < 0) {
                $data['start'] = 0;
            }

            if($data['limit'] < 1) {
                $data['limit'] = 20;
            }

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

        $query = $this->db->query($sql);
//		var_dump($sql);
        $product_data = array();
        if($query->rows) {
            $this->load->model('catalog/product');
            foreach($query->rows as $result) {
                $product_data[$result['product_id']] = $this->model_catalog_product->getProduct($result['product_id']);
            }
        }
        return $product_data;
    }