Disk full (/var/tmp/#sql_7c2_0); waiting for someone to free some space...<br>
SELECT DISTINCT `t3`.`id` AS `cid`, `t3`.`erpid`, `t3`.`logo` AS `clogo`, `t3`.`logo_w` AS `clogo_w`, `t3`.`logo_h` AS `clogoh`, `t2`.`catalog_sn`, `t2`.`p_name`, `t2`.`p_ver`, `t2`.`isnew`, `t5`.`id` AS `contactid`, `t2`.`intro`, `t2`.`catalog_link`, `t6`.`sn`, `t2`.`catalog_dn_enable`, `t7`.`newname`, `t3`.`logo`, `t3`.`logo_b`, `t2`.`id` AS `cgid`, `t2`.`pic_cover`, `latest_catalog_ckg`.`latest_cg_id`, `t3`.`logo_b_h`, `t3`.`logo_b_w`, `t7`.`w`, `t7`.`h`, `latest_catalog_ckg`.`setnew`, `t6`.`name_eng` AS `eName` 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 `mp_customer` AS `t6` ON `t6`.`erp_uid` = `t3`.`erpid` INNER JOIN `mp_group_page` AS `t7` ON `t7`.`fup` = `t6`.`sn` LEFT JOIN `contract_s` AS `t5` ON `t5`.`erpid` = `t3`.`erpid` WHERE `latest_catalog_ckg`.`latest_k_id` = 224 AND `t2`.`enable`=1 AND `t3`.`enable`=1 AND `t7`.`pagegroup` = 0 AND `t7`.`order_sn` = 0 AND `t7`.`cg` = `t2`.`catalog_sn` ORDER BY `latest_catalog_ckg`.`ordernum` ASC, `t2`.`catalog_sn` ASC