\includes\extra\default\center_modules\new_products_default.php
$new_products_query = "SELECT p.*,
pd.products_name,
pd.products_short_description,
m.manufacturers_name
FROM ".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_MANUFACTURERS." m
ON p.manufacturers_id = m.manufacturers_id
JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd
ON p.products_id = pd.products_id
AND pd.products_name <> ''
AND pd.language_id = '".(int) $_SESSION['languages_id']."'
WHERE p.products_startpage = 1
AND p.products_status = 1
".PRODUCTS_CONDITIONS_P."
GROUP BY p.products_id
ORDER BY p.products_startpage_sort ASC
LIMIT ".MAX_DISPLAY_NEW_PRODUCTS;
Erweitern:
$new_products_query = "SELECT p.*,
pd.products_name,
pd.products_short_description,
m.manufacturers_name
FROM ".TABLE_PRODUCTS." p
LEFT JOIN ".TABLE_MANUFACTURERS." m
ON p.manufacturers_id = m.manufacturers_id
JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd
ON p.products_id = pd.products_id
AND pd.products_name <> ''
AND pd.language_id = '".(int) $_SESSION['languages_id']."'
WHERE p.products_startpage = 1
AND p.products_status = 1
AND p.products_date_available < NOW()
".PRODUCTS_CONDITIONS_P."
GROUP BY p.products_id
ORDER BY p.products_startpage_sort ASC
LIMIT ".MAX_DISPLAY_NEW_PRODUCTS;
Sollte theoretisch funktionieren ... dann ist bei TOP, niemals ein angekündigter Artikel, egal was eingestellt wird.