Antwort #1 am: 28. Februar 2011, 20:48:22
Suche mal in deiner "/includes/classes/product.php" nach:
// BOF - vr - 2010-04-21 make sql human readable, update to SQL-92-Standard
$orders_query = "select p.products_fsk18, p.products_id, p.products_price, p.products_tax_class_id,
p.products_image, pd.products_name, p.products_vpe, p.products_vpe_status,
p.products_vpe_value, pd.products_short_description
from ".TABLE_ORDERS_PRODUCTS." op1
join ".TABLE_ORDERS_PRODUCTS." op2 on op2.orders_id = op1.orders_id
join ".TABLE_ORDERS." o on o.orders_id = op2.orders_id
join ".TABLE_PRODUCTS." p on p.products_id = op2.products_id
join ".TABLE_PRODUCTS_DESCRIPTION." pd on pd.products_id = op2.products_id
where op1.products_id = '".$this->pID."'
and op2.products_id != '".$this->pID."'
and p.products_status = '1'
and pd.language_id = '".(int) $_SESSION['languages_id']."'
".$group_check."
".$fsk_lock."
group by p.products_id
order by o.date_purchased desc
limit ".MAX_DISPLAY_ALSO_PURCHASED;
// EOF - vr - 2010-04-21 make sql human readable
und ersetze mit:
// BOF - vr - 2010-04-21 make sql human readable, update to SQL-92-Standard
$orders_query = "select p.products_fsk18, p.products_id, p.products_price, p.products_tax_class_id,
p.products_image, pd.products_name, p.products_vpe, p.products_vpe_status,
p.products_vpe_value, pd.products_description, pd.products_short_description
from ".TABLE_ORDERS_PRODUCTS." op1
join ".TABLE_ORDERS_PRODUCTS." op2 on op2.orders_id = op1.orders_id
join ".TABLE_ORDERS." o on o.orders_id = op2.orders_id
join ".TABLE_PRODUCTS." p on p.products_id = op2.products_id
join ".TABLE_PRODUCTS_DESCRIPTION." pd on pd.products_id = op2.products_id
where op1.products_id = '".$this->pID."'
and op2.products_id != '".$this->pID."'
and p.products_status = '1'
and pd.language_id = '".(int) $_SESSION['languages_id']."'
".$group_check."
".$fsk_lock."
group by p.products_id
order by o.date_purchased desc
limit ".MAX_DISPLAY_ALSO_PURCHASED;
// EOF - vr - 2010-04-21 make sql human readable
Zu der SEO-Frage habe ich keine Meinung, sorry.
Grüße
Torsten