SELECT
cscart_at_videos.video_id,
cscart_at_videos.status,
cscart_at_videos.position,
cscart_at_videos.type,
cscart_at_video_descriptions.name,
cscart_at_videos.autoplay,
cscart_at_videos.loop,
cscart_at_videos.muted,
cscart_at_videos.filesize,
cscart_at_videos.user_id,
cscart_at_videos.timestamp,
cscart_at_videos.filename,
cscart_at_video_descriptions.description,
cscart_at_video_descriptions.html_code,
cscart_at_product_video.*
FROM
cscart_at_videos cscart_at_videos
LEFT JOIN cscart_at_product_video ON cscart_at_videos.video_id = cscart_at_product_video.video_id
LEFT JOIN cscart_at_video_descriptions ON cscart_at_video_descriptions.video_id = cscart_at_videos.video_id
AND cscart_at_video_descriptions.lang_code = 'en'
WHERE
1
AND cscart_at_product_video.product_id = 216182
AND cscart_at_videos.status = 'A'
ORDER BY
cscart_at_videos.position asc