SQL Query to show categories without subs

[Brutus2k]

Hi!

 

I want integrate a prestashop menu in my own homepage (no shop) what is the sql query to show?

 

i have this:

SELECT * FROM ps_category_lang WHERE id_lang = 14 AND id_category <> 1 ORDER BY id_category

 

Where lang id 14 is dutch (my shop is only dutch) id_category 1 is the home category.

 

But with this query i miss the correct order (thats a other table).

 

Can you help?

[Brutus2k]

I resolve the problem

 

the answer is:

SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite

FROM ps_category c

LEFT JOIN ps_category_lang cl ON (c.id_category = cl.id_category AND id_lang = '14')

LEFT JOIN ps_category_group cg ON (cg.`id_category` = c.id_category)

WHERE c.id_category <> '1' AND c.level_depth = '1'

ORDER BY level_depth ASC, c.position ASC

Edited May 9, 2012 by Brutus2k (see edit history)