SELECT 
  cv.video_id, 
  cvd.video, 
  cvd.description, 
  cvd.short_description, 
  cvd.like_count, 
  cvd.comment_count, 
  cv.status, 
  cv.user_id, 
  cv.community_thumbnail, 
  cv.community_video_url, 
  cv.community_url, 
  cu.firstname, 
  CASE WHEN MAX(mum.avatar) IS NOT NULL 
  AND MAX(mum.avatar) != '' THEN CONCAT(
    'https://cdn.kindlife.in/', 
    MAX(mum.avatar)
  ) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar 
FROM 
  cscart_cp_videos cv 
  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id 
  AND cvd.lang_code = 'en' 
  LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id 
  LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id 
WHERE 
  1 
  AND cv.status = 'A' 
GROUP BY 
  cv.video_id, 
  cvd.video, 
  cvd.description, 
  cvd.short_description, 
  cvd.like_count, 
  cvd.comment_count, 
  cv.status, 
  cv.user_id, 
  cv.community_thumbnail, 
  cv.community_video_url, 
  cu.firstname 
ORDER BY 
  cv.timestamp DESC 
LIMIT 
  0, 5

Query time 0.01547

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "2104.62"
    },
    "ordering_operation": {
      "using_filesort": true,
      "grouping_operation": {
        "using_temporary_table": true,
        "using_filesort": false,
        "nested_loop": [
          {
            "table": {
              "table_name": "cv",
              "access_type": "ref",
              "possible_keys": [
                "status_idx",
                "idx_cp_videos_status_userid_videoid",
                "idx_status_timestamp"
              ],
              "key": "status_idx",
              "used_key_parts": [
                "status"
              ],
              "key_length": "3",
              "ref": [
                "const"
              ],
              "rows_examined_per_scan": 792,
              "rows_produced_per_join": 792,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "32.62",
                "eval_cost": "79.20",
                "prefix_cost": "111.83",
                "data_read_per_join": "1M"
              },
              "used_columns": [
                "video_id",
                "timestamp",
                "status",
                "user_id",
                "community_url",
                "community_thumbnail",
                "community_video_url"
              ]
            }
          },
          {
            "table": {
              "table_name": "cvd",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "video_id",
                "lang_code"
              ],
              "key_length": "9",
              "ref": [
                "cscart_db.cv.video_id",
                "const"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 792,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "198.00",
                "eval_cost": "79.20",
                "prefix_cost": "389.02",
                "data_read_per_join": "3M"
              },
              "used_columns": [
                "video_id",
                "lang_code",
                "video",
                "description",
                "short_description",
                "like_count",
                "comment_count"
              ]
            }
          },
          {
            "table": {
              "table_name": "cu",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "user_id"
              ],
              "key_length": "3",
              "ref": [
                "cscart_db.cv.user_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 792,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "775.17",
                "eval_cost": "79.20",
                "prefix_cost": "1243.39",
                "data_read_per_join": "5M"
              },
              "used_columns": [
                "user_id",
                "firstname"
              ],
              "attached_condition": "<if>(is_not_null_compl(cu), (`cscart_db`.`cu`.`user_id` = `cscart_db`.`cv`.`user_id`), true)"
            }
          },
          {
            "table": {
              "table_name": "mum",
              "access_type": "eq_ref",
              "possible_keys": [
                "PRIMARY"
              ],
              "key": "PRIMARY",
              "used_key_parts": [
                "user_id"
              ],
              "key_length": "3",
              "ref": [
                "cscart_db.cv.user_id"
              ],
              "rows_examined_per_scan": 1,
              "rows_produced_per_join": 792,
              "filtered": "100.00",
              "cost_info": {
                "read_cost": "782.03",
                "eval_cost": "79.20",
                "prefix_cost": "2104.62",
                "data_read_per_join": "14M"
              },
              "used_columns": [
                "user_id",
                "avatar"
              ],
              "attached_condition": "<if>(is_not_null_compl(mum), (`cscart_db`.`cv`.`user_id` = `cscart_db`.`mum`.`user_id`), true)"
            }
          }
        ]
      }
    }
  }
}

Result

video_id video description short_description like_count comment_count status user_id community_thumbnail community_video_url community_url firstname userAvatar
2163 Episode 15 of TBH Kindcrew reviews blackberry range. And their reaction says it all? 0 0 A 21551 https://www.kindlife.in/images/video_library/2163_Video-844_preview.jpg https://www.kindlife.in/images/video_library/2163_Video-844.mp4 https://www.kindlife.in/episode-15-of-tbh kindlife https://cdn.kindlife.in/images/kl_album/21551/2025/08/21/68a709aba0a47php5imtsL.jpeg
2162 BRO-TOX EP-2 Get ready with kindcrew while driving and getting ready for Diwali party? 0 0 A 21551 https://www.kindlife.in/images/video_library/2162_Video-747_preview.jpg https://www.kindlife.in/images/video_library/2162_Video-747.mp4 https://www.kindlife.in/bro-tox-ep-2 kindlife https://cdn.kindlife.in/images/kl_album/21551/2025/08/21/68a709aba0a47php5imtsL.jpeg
2161 Episode 13 of TBH Kindcrew reviews Roundloab dokdo toner? ? 0 0 A 21551 https://www.kindlife.in/images/video_library/2161_Video-699_preview.jpg https://www.kindlife.in/images/video_library/2161_Video-699.mp4 https://www.kindlife.in/episode-13-of-tbh-en kindlife https://cdn.kindlife.in/images/kl_album/21551/2025/08/21/68a709aba0a47php5imtsL.jpeg
2160 BRO-TOX by kindlife Skincare products tried and tested by the kindcrew boy? 0 0 A 21551 https://www.kindlife.in/images/video_library/2160_Video-577_preview.jpg https://www.kindlife.in/images/video_library/2160_Video-577.mp4 https://www.kindlife.in/bro-tox-by-kindlife kindlife https://cdn.kindlife.in/images/kl_album/21551/2025/08/21/68a709aba0a47php5imtsL.jpeg
2159 To be honest with kindcrew All time favourite tirtir reviewed by the kindcrew and we loved it? 0 0 A 21551 https://www.kindlife.in/images/video_library/2159_Video-33_preview.jpg https://www.kindlife.in/images/video_library/2159_Video-33.mp4 https://www.kindlife.in/to-be-honest-with-kindcrew kindlife https://cdn.kindlife.in/images/kl_album/21551/2025/08/21/68a709aba0a47php5imtsL.jpeg