SELECT o.*,
DATE_FORMAT(o.date_created, '%d.%m.%Y') as date_created,
DATE_FORMAT(o.date_created, '%H:%i') as time_created,
DATE_FORMAT(o.date_payment, '%d.%m.%Y') as date_payment,
DATE_FORMAT(o.date_payment, '%H:%i') as time_payment,
DATE_FORMAT(o.date_closed, '%d.%m.%Y') as date_closed,
DATE_FORMAT(o.date_closed, '%H:%i') as time_closed,
d.title as d_name,
IFNULL(u.login, '') as user_login,
IFNULL(u.nickname, '') as user_nickname
FROM cms_shop_orders o
LEFT JOIN cms_shop_delivery d ON d.id = o.d_type
LEFT JOIN cms_users u ON u.id = o.user_id
WHERE o.id =
LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 15