DB::table('TYPE_NUMBERS')->select('TYP_ID', 'MFA_BRAND', 'DES_TEXTS7.TEX_TEXT AS MOD_CDS_TEXT', 'DES_TEXTS.TEX_TEXT AS TYP_CDS_TEXT', 'TYP_PCON_START', 'TYP_PCON_END', 'TYP_CCM', 'TYP_KW_FROM', 'TYP_KW_UPTO', 'TYP_HP_FROM', 'TYP_HP_UPTO', 'TYP_CYLINDERS', 'ENGINES.ENG_CODE', 'DES_TEXTS2.TEX_TEXT AS TYP_ENGINE_DES_TEXT', 'DES_TEXTS3.TEX_TEXT AS TYP_FUEL_DES_TEXT', DB::raw('IFNULL(DES_TEXTS4.TEX_TEXT, DES_TEXTS5.TEX_TEXT) AS TYP_BODY_DES_TEXT'), 'DES_TEXTS6.TEX_TEXT AS TYP_AXLE_DES_TEXT', 'TYP_MAX_WEIGHT')->leftJoin('COUNTRY_DESIGNATIONS', 'COUNTRY_DESIGNATIONS.CDS_ID', '=', 'TYP_CDS_ID')->leftJoin('DES_TEXTS', 'DES_TEXTS.TEX_ID', '=', 'COUNTRY_DESIGNATIONS.CDS_TEX_ID')->leftJoin('MODELS', 'MOD_ID', '=', 'TYP_MOD_ID')->leftJoin('MANUFACTURERS', 'MFA_ID', '=', 'MOD_MFA_ID')->leftJoin('COUNTRY_DESIGNATIONS AS COUNTRY_DESIGNATIONS2', 'COUNTRY_DESIGNATIONS2.CDS_ID', '=', 'MOD_CDS_ID')->leftJoin('DES_TEXTS AS DES_TEXTS7', 'DES_TEXTS7.TEX_ID', '=', 'COUNTRY_DESIGNATIONS2.CDS_TEX_ID')->leftJoin('DESIGNATIONS', 'DESIGNATIONS.DES_ID', '=', 'TYP_KV_ENGINE_DES_ID')->leftJoin('DES_TEXTS AS DES_TEXTS2', 'DES_TEXTS2.TEX_ID', '=', 'DESIGNATIONS.DES_TEX_ID')->leftJoin('DESIGNATIONS AS DESIGNATIONS2', 'DESIGNATIONS2.DES_ID', '=', 'TYP_KV_FUEL_DES_ID')->leftJoin('DES_TEXTS AS DES_TEXTS3', 'DES_TEXTS3.TEX_ID', '=', 'DESIGNATIONS2.DES_TEX_ID')->leftJoin('LINK_TYP_ENG', 'LTE_TYP_ID', '=', 'TYP_ID')->leftJoin('ENGINES', 'ENG_ID', '=', 'LTE_ENG_ID')->leftJoin('DESIGNATIONS AS DESIGNATIONS3', 'DESIGNATIONS3.DES_ID', '=', 'TYP_KV_BODY_DES_ID')->leftJoin('DES_TEXTS AS DES_TEXTS4', 'DES_TEXTS4.TEX_ID', '=', 'DESIGNATIONS3.DES_TEX_ID')->leftJoin('DESIGNATIONS AS DESIGNATIONS4', 'DESIGNATIONS4.DES_ID', '=', 'TYP_KV_MODEL_DES_ID')->leftJoin('DES_TEXTS AS DES_TEXTS5', 'DES_TEXTS5.TEX_ID', '=', 'DESIGNATIONS4.DES_TEX_ID')->leftJoin('DESIGNATIONS AS DESIGNATIONS5', 'DESIGNATIONS5.DES_ID', '=', 'TYP_KV_AXLE_DES_ID')->leftJoin('DES_TEXTS AS DES_TEXTS6', 'DES_TEXTS6.TEX_ID', '=', 'DESIGNATIONS5.DES_TEX_ID')->where('TYN_SEARCH_TEXT', '=', '"@KBA_NR"')->orderBy('MFA_BRAND')->orderBy('MOD_CDS_TEXT')->orderBy('TYP_CDS_TEXT')->orderBy('TYP_PCON_START')->orderBy('TYP_CCM')->get()