SELECT files.*, file_attachments.main, file_attachments.id AS attachment_id FROM file_attachments LEFT JOIN files ON file_attachments.file_id = files.id WHERE file_attachments.object_id = ORDER BY main DESC, weight ASC
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 'ORDER BY main DESC, weight ASC' at line 1