Дублировать вывод из MySQL ⇐ Php

[Anonymous]

Запрос MySQL дает повторяющиеся данные в результате запроса. Вот как я пытаюсь этого избежать.

Самый запрос:

$product_sql_test2 = $this->db->query("SELECT p.product_id, p.price, pc.product_id AS product_id
FROM oc_product p
INNER JOIN oc_product_to_category pc ON p.product_id = pc.product_id
WHERE p.price BETWEEN '".$product_info['related_kv4nt_min_2']."' and '".$product_info['related_kv4nt_max_2']."'
AND pc.category_id = '".$product_info['related_kv4nt_id_2']."'
GROUP BY pc.product_id
ORDER BY RAND( )
LIMIT 0 , 10");


Вот что я делаю после выбора:

if(isset($product_sql_test2->row['product_id'])){$this->data['product_spec_2_'.$i.''] = $product_sql_test2->row['product_id'];}
$i++;
}

$pr_unique2 = array_unique($this->data['product_spec_2_'.$i.'']);
if ($this->data['product_spec_2_'.$i.''] != $pr_unique2[$i]){
$product_sql_test2 = $this->db->query("SELECT p.product_id, p.price, pc.product_id AS product_id
FROM oc_product p
LEFT JOIN oc_product_to_category pc ON p.product_id = pc.product_id
WHERE p.price BETWEEN '".$product_info['related_kv4nt_min_2']."' and '".$product_info['related_kv4nt_max_2']."'
AND pc.category_id = '".$product_info['related_kv4nt_id_2']."'
GROUP BY pc.product_id
ORDER BY RAND( )
LIMIT 0 , 10");//$sql_price_minus = $product_info['price'] - ($product_info['price'] * 0.10);
$this->data['product_spec_2_'.$i.''] = $product_sql_test2->row['product_id'];
continue;
}


Как предотвратить дублирование результатов?

Вот как я отредактировал код, но получил ошибку, которая сказал, что запрос выполнялся более 30 секунд. Что можно сделать?

$product_sql_test2 = $this->db->query("SELECT p.product_id, p.price, pc.product_id AS product_id
FROM oc_product p
LEFT JOIN oc_product_to_category pc ON p.product_id = pc.product_id
WHERE p.price BETWEEN '".$product_info['related_kv4nt_min_2']."' and '".$product_info['related_kv4nt_max_2']."'
AND pc.category_id = '".$product_info['related_kv4nt_id_2']."'
GROUP BY pc.product_id
ORDER BY RAND()
LIMIT 10");

if(isset($product_sql_test2->row['product_id'])){$this->data['product_spec_2_'.$i.''] = $product_sql_test2->row['product_id'];}
$data[]=$this->data['product_spec_2_'.$i.''];
$pr_unique = array_unique($data);

$i++;
if ($data != $pr_unique[$i]){
$product_sql_test2 = $this->db->query("SELECT p.product_id, p.price, pc.product_id AS product_id
FROM oc_product p
LEFT JOIN oc_product_to_category pc ON p.product_id = pc.product_id
WHERE p.price BETWEEN '".$product_info['related_kv4nt_min_2']."' and '".$product_info['related_kv4nt_max_2']."'
AND pc.category_id = '".$product_info['related_kv4nt_id_2']."'
GROUP BY pc.product_id
ORDER BY RAND()
LIMIT 10");
$i=1;
}
if(isset($product_sql_test2->row['product_id'])){$this->data['product_spec_2_'.$i.''] = $product_sql_test2->row['product_id'];}
$i++;


Подробнее здесь: https://stackoverflow.com/questions/175 ... -fro-mysql