query.sql

SELECT DISTINCT COUNT(DISTINCT h.id)
	FROM cms3_hierarchy h, cms3_object_types t, cms3_permissions p, cms3_objects o
	LEFT JOIN cms3_object_content oc_674_lj ON oc_674_lj.obj_id=o.id AND oc_674_lj.field_id = '674'
	WHERE o.type_id IN (123, 124, 125, 126, 132) AND
        t.id = o.type_id AND
        h.type_id IN (55) AND
        (oc_674_lj.varchar_val IN()) AND
        h.domain_id = '7' AND
        h.lang_id = '1' AND
        h.is_deleted = '0' AND
        h.is_active = '1' AND
        (p.rel_id = h.id AND p.level & 1 AND p.owner_id IN(334)) AND
        h.obj_id = o.id;