SELECT o.id, o.object_title, o.object_status, ot.object_type_title, u.contractor_title_full FROM objects_object AS o LEFT JOIN objects_objecttype AS ot ON ot.id = o.object_type_id LEFT JOIN users_userout AS u ON u.id = o.customer_id  ORDER BY o.id DESC