SELECT
    oc.id,
    caas.hydrant_from,
    caas.hydrant_without,
    pb.concrete_volume,
    pb.diameter_inner,
    pb.diameter_outer,
    pb.height,
    pb.name_product,
    pt.name_type,
    sn.name_schema,
    ht.name_hatch_height,
    ht.name_hatch_type,
    tt.throat_type_height,
    tt.name_throat_type,
    u.*,
    un.name_unit,
    un.hydrant
FROM
    wk_cas_construction_and_assembly_scheme AS caas
    INNER JOIN productbrand_throattype AS temp
    INNER JOIN wk_cas_product_brand AS pb
    INNER JOIN wk_cas_product_type AS pt
    INNER JOIN wk_cas_schema_name AS sn
    INNER JOIN wk_other_hatch_type AS ht
    INNER JOIN wk_other_throat_type AS tt
    INNER JOIN wk_cas_unit AS u
    INNER JOIN wk_cas_unit_name AS un
    INNER JOIN wk_mainwork_object_composition AS oc
    INNER JOIN wk_mainwork_object AS o
WHERE
    o.id = 77 AND
    pb.id = caas.product_brand_id AND
    pb.id = temp.productbrand_id AND
    pb.product_type_id = pt.id AND
    tt.id = temp.throattype_id AND
    tt.id = oc.throat_id AND
    tt.hatch_type_id = ht.id AND
    u.id = oc.unit_id AND
    u.unit_name_id = un.id AND
    u.schema_name_id = sn.id AND
    caas.schema_name_id = sn.id;

select new SomeClassName(a.fieldOne, a.fieldTwo) from AnotherClassName a