SELECT
q_product_files.*,
q_product_file_descriptions.file_name,
q_product_file_descriptions.license,
q_product_file_descriptions.readme
FROM
q_product_files
LEFT JOIN q_product_file_descriptions ON q_product_file_descriptions.file_id = q_product_files.file_id
AND q_product_file_descriptions.lang_code = 'en'
WHERE
1 = 1
AND q_product_files.product_id = 33162
AND preview_path != ''
AND q_product_files.status = 'A'
ORDER BY
q_product_files.position asc,
q_product_file_descriptions.file_name asc