Список карточек заданных групп классификатора через запрос : Супермаг Плюс (Супермаг 2000)

select c.article from supermag.smcard c, Supermag.SACardClass, Supermag.SACardClass R1
               where Supermag.SACardClass.ID = c.IDClass
                and c.IDClass=R1.ID
                and R1.Tree like (select saa.tree from sacardclass saa where id in (380.0))||'%'; 

and R1.Tree like (select saa.tree from sacardclass saa where id in (379.0,380.0))||'%'; 

SELECT c.article
FROM supermag.smcard c
JOIN supermag.sacardclass ON supermag.sacardclass.ID = c.IDClass
JOIN supermag.sacardclass R1 ON c.idclass = R1.ID
WHERE EXISTS (
    SELECT 1
    FROM supermag.sacardclass saa
    WHERE saa.id IN (380, 390)
      AND R1.tree LIKE saa.tree || '%'
); 

select saa.id from sacardclass saa where saa.tree Like (380.0||'%') 

WHERE saa.id IN (380, 390)
      AND R1.tree LIKE saa.tree || '%' 

SELECT c.* 
  FROM supermag.smcard c,
       ( SELECT sc1.id
           FROM supermag.sacardclass sc, supermag.sacardclass sc1 
          WHERE sc.id IN (380, 390)
            AND sc1.tree like sc.tree||'%' ) a
 WHERE c.idclass=a.id;