Not all products displayed in category

[MKI-Miro]

Hi

I have ew products in category but on site it display only one. I enabled debug and i can see this

Code Select Expand

SELECT SQL_CALC_FOUND_ROWS  p.`virtuemart_product_id`, l.product_name

  FROM `l1r20_virtuemart_products` as p   

  LEFT JOIN `l1r20_virtuemart_products_en_gb` as l
  ON l.`virtuemart_product_id` = p.`virtuemart_product_id`

  LEFT JOIN `l1r20_virtuemart_product_shoppergroups` as ps
  ON p.`virtuemart_product_id` = `ps`.`virtuemart_product_id` 

  LEFT JOIN `l1r20_virtuemart_product_categories` as pc
  ON p.`virtuemart_product_id` = `pc`.`virtuemart_product_id`

  WHERE ( `pc`.`virtuemart_category_id` = 114
  AND  ( `ps`.`virtuemart_shoppergroup_id`= "1"  OR `ps`.`virtuemart_shoppergroup_id` IS NULL  ) 
  AND  p.`published`="1" 
  AND  ( p.`virtuemart_product_id` NOT IN (160,159,113,101,99) ) )

  group by p.`virtuemart_product_id`

  ORDER BY `pc`.`ordering` ASC, `product_name` ASC
  LIMIT 0, 24

i dont know why there is this line

AND  ( p.`virtuemart_product_id` NOT IN (160,159,113,101,99) ) )

any idea ? thanks

[GJC Web Design]

see:  http://forum.virtuemart.net/index.php?topic=143904.msg509094#msg509094

isn't from the OMIT and already cached products settings for

afaik changed a while ago in any case

Code Select Expand

if(self::$omitLoaded and self::$_alreadyLoadedIds){
$where[] = ' p.`virtuemart_product_id`!='.implode(' AND p.`virtuemart_product_id`!=',self::$_alreadyLoadedIds).' ';
//$where[] = ' p.`virtuemart_product_id` NOT IN ('.implode(',',self::$_alreadyLoadedIds).') ';
}

[MKI-Miro]

I am sorry I dont understand.

Where do i have to click to display all products (discard this omit)

[GJC Web Design]

VM config->config->templates