ON p.manufacturers_id = m.manufacturers_id LEFT JOIN
" . $oostable['products_description'] . " pd
ON p.products_id = pd.products_id AND
pd.products_languages_id = '1' LEFT JOIN
" . $oostable['specials'] . " s
ON p.products_id = s.products_id
WHERE
(p.products_status >= '1' or p.products_status <= '4')
ORDER BY
p.products_date_added DESC,
pd.products_name";
$products_result = $dbconn->Execute($products_sql);
while ($products = $products_result->fields) {
if ( (!empty($products['products_name'])) && (!empty($products['products_image'])) && (!empty($products['products_model'])) && (!empty($products['products_description'])) ) {
if (isset($products['specials_new_products_price'])) {
$products_price = $currencies->psm_price($products['specials_new_products_price'], oos_get_tax_rate($products['products_tax_class_id']));
} else {
$products_price = $currencies->psm_price($products['products_price'], oos_get_tax_rate($products['products_tax_class_id']));
}
switch ($products['products_status']) {
case '1':
case '2':
$products_status = 'nicht verfgbar';
break;
case '3':
case '4':
$products_status = '3 Tage';
break;
}
$products_description = strip_tags($products['products_description']);