Disk full (/var/tmp/#sql_7c2_0); waiting for someone to free some space...<br>
SELECT `agent`.`id`, `agent`.`company_id`, `agent`.`agent_name`, `agent`.`agent_country`, `agent`.`agent_content`, `agent`.`orderNum`, `agent`.`agent_enable`, `t2`.`country` FROM agent INNER JOIN `agent_list` AS `t3` ON `t3`.`agent_id` = `agent`.`id` INNER JOIN `country_flag` AS `t2` ON `t2`.`title` = `agent`.`agent_country` WHERE `t3`.`company_id` = 277 AND `t3`.`dn_id` = 51 AND `t3`.`open_agent` = 1 ORDER BY `t3`.`orderNum` ASC, `t2`.`country` ASC