cck views

I`m trying to upgrade our hotel booking site. Each hotel has several characteristics, so I put them in integer CCK fields. After that I created a view with about 30 exposed filters according all the hotel fields.
After I put the site live (~1500 visitors per day), the mysql server went down almost immediately. The problem is crazy sql queries that views module makes. For example, http://pastebin.com/gxNTzwuR . It`s the real user query I`ve took from the query log.
I`ve added indexes to all that 'content_field_xxx' tables (field_xxx_value) - still no luck.

By default, taxonomy pages display content in chronological order, and this is not customizable unless you update the core module.

To get around this, create a view with taxonomy term as the argument, simple (if you're new to views and arguments, check-out this tutorial video: http://gotdrupal.com/videos/drupal-views-arguments).

In the argument settings, if you enter %1 as the title override, the page title will become the Taxonomy term of the taxonomy id argument, BUT this method fails to show the translated string if you're not viewing the page in the default language.

General Use

A Standing Operating Procedure: A set of instructions covering those features of operations which lend themselves to a definite or standardized procedure without loss of effectiveness. Also called SOP.

Major Stages in the Preparation of an SOP Manual

The preparation of an SOP manual is an involved task and usually involves three major stages:

1. Business systems and process study by intensive interaction with process owners, managers, operatives, etc. to understand in detail the tasks that are performed.

Så mitt exempel är detta:

Jag har en content_profile profil (A). Där finns ett cck-fält med massa alternativ man kan kryssa i (X, Y, Z), i mitt fall har jag valt X och Y.

Det finns även en nodtyp (B) som delar cck-fältet med samma värden(X, Y, Z).

När man skapar en nodtyp B med ett av värdena, ska det komma upp i en lista de noder som har ikryssat antingen X eller Y (eftersom det matchar mot content-profilen).

Problemet med Views Or blir när man väljer antal argument som är fler än antalet värden man har kryssat i.

I have a strange problem that is difficult to explain.

I have 2 D6 cck Views, 1 (ArticleList) has a page display that shows a list of a particular node and has a menu entry which works fine, the other view (AssociatedItems) displays a list of different node types including page but the page entry created by ArcticleList is not showing up in that.

Is there a particular setting on the page display I need to change to have it listed as a page in other views?