Třídová akce

Kód:

24

Tělo:

select 
  A.categoryitemgroup_id, A.categoryitem_id, M.id as ID, cg.name as GroupName, ci.name as CategoryName
from
  GetCategoryItemByGroup A
  left join firmcategoriesmetadata M on (m.categoryitem_id=a.categoryitem_id and m.parent_id=:OBJID)
  left join categoryitemgroups CG on (A.categoryitemgroup_id=cg.id)
  left join categoryitems CI on (A.categoryitem_id=ci.id)
where
  A.categoryitem_id is null or
  ci.hidden = 'N'
order by
  cg.name,
  ci.name

Generated by ABRA Software a.s. 27.10.2021 16:34:09