SELECT
cscart_ab__video_gallery_descriptions.video_path,
videos.video_id,
videos.product_id,
videos.status,
videos.pos,
videos.type,
videos.settings,
videos.icon_type,
cscart_ab__video_gallery_descriptions.title,
cscart_ab__video_gallery_descriptions.description
FROM
cscart_ab__video_gallery AS videos
LEFT JOIN cscart_ab__video_gallery_descriptions ON cscart_ab__video_gallery_descriptions.video_id = videos.video_id
AND cscart_ab__video_gallery_descriptions.lang_code = 'en'
WHERE
1
AND videos.type NOT IN ('H', 'R')
AND videos.status = 'A'
AND videos.product_id = 15393
ORDER BY
videos.pos ASC