Disk full (/var/tmp/#sql_7c2_0); waiting for someone to free some space...<br>
SELECT `t4`.`company_name_eng` AS `eName`, `t2`.`p_ver`, `t2`.`p_name`, `t2`.`intro`, `t3`.`logo`, `t6`.`newname`, `t6`.`w`, `t6`.`h`, `t5`.`sn`, `t2`.`catalog_sn`, `latest_catalog_ckg`.`latest_k_id`, `t2`.`catalog_link`, `t2`.`catalog_dn_enable`, `latest_catalog_ckg`.`id` AS `cgid` FROM latest_catalog_ckg INNER JOIN `latest_catalog_cg` AS `t2` ON `t2`.`id` = `latest_catalog_ckg`.`latest_cg_id` INNER JOIN `latest_catalog_c` AS `t3` ON `t3`.`erpid` = `t2`.`erpid` INNER JOIN `company` AS `t4` ON `t4`.`erpid` = `t3`.`erpid` INNER JOIN `mp_customer` AS `t5` ON `t5`.`erp_uid` = `t3`.`erpid` INNER JOIN `mp_group_page` AS `t6` ON (`t6`.`fup` = `t5`.`sn` AND `t6`.`cg` = `t2`.`catalog_sn`) INNER JOIN `latest_catalog_k` AS `t7` ON `t7`.`id` =`latest_catalog_ckg`.`latest_k_id` WHERE `latest_catalog_ckg`.`latest_k_id` IN ('172','180','195','208','216','170','224','231','234') AND `t2`.`isnew` = 1 AND `t2`.`enable` = 1 AND `t3`.`enable` = 1 AND `t6`.`pagegroup` = 0 AND `t6`.`order_sn` = 0 AND `latest_catalog_ckg`.`setnew` = 1 AND t7.dn_id = 51 ORDER BY `t7`.`ordernum` ASC, `t7`.`kname` ASC