SELECT
                            `mod_service_order`.*,
                            `mod_service`.`id` `service_id`,
                            `mod_service`.`category` `service_category`,
                            `mod_service`.`title` `service_title`,
                            `mod_service`.`name` `service_name`,
                            `mod_service`.`url` `service_url`,
                            `mod_service`.`min_story` `service_min_story`,
                            `mod_service`.`full_story` `service_full_story`,
                            `mod_service`.`action` `service_action`,
                            `mod_service_category`.`id` `category_id`,
                            `mod_service_category`.`icon` `category_icon`,
                            `mod_service_category`.`title` `category_title`,
                            `mod_service_category`.`name` `category_name`,
                            `mod_service_category`.`url` `category_url`,
                            `mod_service_category`.`description` `category_description`,
                            `mod_service_category`.`action` `category_action`,
                            `mod_service_status`.*,
                            `users`.`id` `curator_id`,
                            `users`.`login` `curator_login`,
                            `users`.`id` `curator2_id`,
                            `users`.`login` `curator2_login`
                                FROM 
                                    `mod_service_order`
                                    LEFT JOIN `mod_service` ON(`mod_service`.`id`=`mod_service_order`.`usluga`)
                                    LEFT JOIN `mod_service_category` ON(`mod_service_category`.`id`=`mod_service`.`category`)
                                    LEFT JOIN `mod_service_status` ON(`mod_service_status`.`status_id`=`mod_service_order`.`status`)
                                    INNER JOIN `users` as `curator` ON(`users`.`id`=2)
                                    INNER JOIN `users` as `curator2` ON(`users`.`id`=2)
                                        ORDER BY `mod_service_order`.`date` DESC

Почемуто выходит ошибка
#1054 - Unknown column 'users.id' in 'field list'
Загвозка тут

INNER JOIN `users` as `curator` ON(`users`.`id`=2)
INNER JOIN `users` as `curator2` ON(`users`.`id`=2)