SELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice
FROM cms_categorie AS cat2
INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2)
INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='azienda')
INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it')
INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it')
WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESCSELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice
FROM cms_categorie AS cat2
INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2)
INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='pagamenti')
INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it')
INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it')
WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESCSELECT cat2.id, lang_cat2.nome, lang_cat1.nome AS categoria1, cat2.codice
FROM cms_categorie AS cat2
INNER JOIN cms_categorie_albero alb ON (cat2.id=alb.categoria_id AND alb.livello=2)
INNER JOIN cms_categorie AS cat1 ON(cat1.id=alb.parent_id AND cat1.codice='garanzie')
INNER JOIN cms_categorie_lang AS lang_cat2 ON (cat2.id=lang_cat2.categoria_id AND lang_cat2.lang='it')
INNER JOIN cms_categorie_lang AS lang_cat1 ON (cat1.id=lang_cat1.categoria_id AND lang_cat1.lang='it')
WHERE cat2.attivo='1' ORDER BY alb.ordinazione ASC, cat2.id DESC
