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']);