$sql = "SELECT * FROM " . DB_PREFIX . "product_to_category p2c 
			LEFT JOIN " . DB_PREFIX . "product p ON (p2c.product_id = p.product_id) 
			LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) 
			LEFT JOIN " . DB_PREFIX . "product_attribute pa ON (p.product_id = pa.product_id) 
			WHERE p2c.category_id IN (SELECT category_id FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . (int)$product_id . "'" . $main_category . ")
			AND p.status = '1' 
			AND p.product_id = '" . $product_id . "' 
			AND p.date_available <= NOW() 
			AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' 
			AND p.product_id != '" . (int)$product_id . "' 			
			AND p.quantity > '0'";			
			if($data['ar_price']){
				$sql .= "AND p.price >= ((SELECT price FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "')*0." . $data['min_price'] . ") AND p.price <= ((SELECT price FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "')*1." . $data['max_price'] . ") ";
			}
			if($data['ar_manufacturer']){
				$sql .= "AND p.manufacturer_id = (SELECT manufacturer_id FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "')";
			}
			if($data['ar_attribute'] && $attribute_values){
			  foreach($attribute_values as $attribute_id => $value) {
				$sql .= " AND (TRIM(LOWER(pa.text)) = '" . $value . "' AND pa.attribute_id = '" . $attribute_id . "' AND pa.language_id = '" . $this->config->get('config_language_id') . "')";
			  }			
			}