SELECT 
  DISTINCT(
    vi_ab__video_gallery_descriptions.video_path
  ), 
  videos.video_id, 
  videos.product_id, 
  videos.status, 
  videos.pos, 
  videos.product_pos_type, 
  videos.product_pos, 
  videos.type, 
  videos.autoplay, 
  videos.show_in_list, 
  videos.settings, 
  videos.icon_type, 
  videos.storefront_id, 
  vi_ab__video_gallery_descriptions.title, 
  vi_ab__video_gallery_descriptions.description 
FROM 
  vi_ab__video_gallery AS videos 
  LEFT JOIN vi_ab__video_gallery_descriptions ON vi_ab__video_gallery_descriptions.video_id = videos.video_id 
  AND vi_ab__video_gallery_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND videos.storefront_id IN (1, 0) 
  AND videos.type NOT IN ('H', 'R') 
  AND videos.autoplay = 'N' 
  AND videos.product_id IN (
    SELECT 
      products.product_id 
    FROM 
      vi_products as products 
      LEFT JOIN vi_product_descriptions as descr1 ON descr1.product_id = products.product_id 
      AND descr1.lang_code = 'en' 
      LEFT JOIN vi_product_prices as prices ON prices.product_id = products.product_id 
      AND prices.lower_limit = 1 
      LEFT JOIN vi_companies AS companies ON companies.company_id = products.company_id 
      INNER JOIN vi_products_categories as products_categories ON products_categories.product_id = products.product_id 
      INNER JOIN vi_categories ON vi_categories.category_id = products_categories.category_id 
      AND (
        vi_categories.usergroup_ids = '' 
        OR FIND_IN_SET(0, vi_categories.usergroup_ids) 
        OR FIND_IN_SET(1, vi_categories.usergroup_ids)
      ) 
      AND vi_categories.status IN ('A', 'H') 
      AND vi_categories.storefront_id IN (0, 1) 
      LEFT JOIN vi_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id 
      AND shared_descr.company_id = 1 
      AND shared_descr.lang_code = 'en' 
    WHERE 
      1 
      AND vi_categories.category_id IN (194) 
      AND companies.status IN ('A') 
      AND (
        products.usergroup_ids = '' 
        OR FIND_IN_SET(0, products.usergroup_ids) 
        OR FIND_IN_SET(1, products.usergroup_ids)
      ) 
      AND products.status IN ('A') 
      AND prices.usergroup_id IN (0, 0, 1) 
      AND products.parent_product_id = 0 
    GROUP BY 
      products.product_id
  ) 
  AND videos.status = 'A' 
ORDER BY 
  videos.pos ASC 
LIMIT 
  0, 4