Re: Help with a very slow select query

[Francisco Javier Morales López de Gamarra]

Sorry Rich.

Thanks you very much .. but I think that I have not explain well my problem ... your sql query works fine .... BUT I have the following problem ...

Categories table has two levels (nivel) and categories on the level 1 has a father (padre) that is the id_categoria of the level 0 ...

with your select I can get the total number of items on a categy but it does not count items that are on the level 1 and that their father is the category that I am counting ...

I just have 2 levels of categories, level 0 and level 1 (nivel 0 and nivel 1)

any idea?? Could I count all the items in all the categories and that the count has the children categories to??

Thanks a million



Edited 2 time(s). Last edit at 02/02/2011 07:01AM by Francisco Javier Morales López de Gamarra.