SELECT z.*, pt.pagelink ,DATE_FORMAT(, '%d/%m/%Y в %H:%i' ) as dat,
     DATE_FORMAT(, '%Y-%m-%d' ) as dt,
     DATE_FORMAT(, '%H:%i' ) as time,
     DATE_FORMAT(, '%Y/%m/%d  %H:%i' ) as datt, u.login, u.nickname, as zemail, as uphone
FROM zakas z
LEFT JOIN cms_users u ON = z.user_id
LEFT JOIN cms_perevozki_tupem pt ON = z.gruzopodiemnostId

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 8