export query result to csv + using dynamic name variables

.sql

SET @outpath = "/var/lib/mysql-files/";
SET @outfile = (SELECT date_format(now(), '%Y%m%d%H%m%S'));
SET @outextension = "_products.csv";
SET @csvfinal = ' FIELDS TERMINATED BY \',\' ENCLOSED BY \'"\' LINES TERMINATED BY \'\n\'';

SELECT CONCAT("your query here INTO OUTFILE ",@outpath,@outfile,@outextension,@csvfinal) 
INTO @SQL; PREPARE stmt FROM @SQL;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;