How can SQL queries be optimized to efficiently retrieve multilingual data for CSV generation in PHP?

To efficiently retrieve multilingual data for CSV generation in PHP, SQL queries can be optimized by using language-specific columns or tables to store translations. This allows for faster retrieval of the necessary data without the need for complex joins or additional processing in PHP. By structuring the database in this way, the CSV generation process can be streamlined and more efficient.

// Example SQL query to retrieve multilingual data efficiently
SELECT id, title_en AS title, description_en AS description FROM products;