aa

$analyzes =
    DB::table('patient_analyzes')
    ->join('patients','patient_analyzes.patient_analyze_patient_id','=','patients.patient_id')
    ->select(
        'patient_analyzes.patient_analyze_patient_id',
        'patient_analyzes.patient_analyze_analyzes',
        'patient_analyzes.checked_level',
        'patient_analyzes.patient_analyze_id',
        'patient_analyzes.created_at as cdate',
        'patient_analyzes.patient_analyze_part_count',
        'patients.*'
    )
    ->where('patient_analyzes.checked_level' , '!=', 1)  // faqat tolovi amalga oshirilgan analizlar
    ->orderBy('patient_analyzes.patient_analyze_id' , 'desc')
    ->paginate(30);