Gefunden ... ich hoffe das passt so. Ab Zeile 403 ...
// BOF Suche nach Produkten ohne Bestand
if($_GET['search']=='nostock'){
$_GET['search'] = "' AND p.products_status !=0 AND p.products_quantity LIKE '0";
$listing_sql = "
SELECT
p.products_tax_class_id,
p.products_id,
pd.products_name,
p.products_sort,
p.products_quantity,
p.products_image,
p.products_model,
p.products_price,
p.products_discount_allowed,
p.products_date_added,
p.products_last_modified,
p.products_date_available,
p.products_status,
p.products_startpage,
p.products_startpage_sort,
p2c.categories_id FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
WHERE p.products_id = pd.products_id AND pd.language_id = '" . $_SESSION['languages_id'] . "' AND
p.products_id = p2c.products_id AND (pd.products_name like '%" . $_GET['search'] . "%' OR "
. "p.products_model like '%" . $_GET['search'] . "%') ORDER BY " . $prodsort;
$products_split = new splitPageResults($_GET['page'], MAX_DISPLAY_LIST_PRODUCTS, $listing_sql, $products_query_numrows, 'p.products_id');
$products_query = xtc_db_query($listing_sql);
if($_GET['search']=="' AND p.products_status !=0 AND p.products_quantity LIKE '0") $_GET['search'] ='nostock';
} else {
// EOF Suche nach Produkten ohne Bestand