query con LeftJoin e Date Format

[marketto]

"select *, DATE_FORMAT(...) AS data from TABELLA111 as tab_1 ".
"left join TABELLA222 as tab_2 on tab_1.placeid=tab_2.IDX ".
"where tab_1.valido=1 and tab_1.placeid LIKE 'LI%'".
" order by tab_1.placeid";