Error Number: 3
Error writing file '/tmp/MYwijI9p' (Errcode: 28)
SELECT m.uid AS muid, m.model_name AS model, m.model_name2 AS model2, m.model_ver AS model_ver, c.seats AS seats, m.turbo AS turbo, c.manuYear AS manuYear, (count(m.uid)) AS total, max( c.finalPrice ) AS maxPrice, min(c.finalPrice) AS minPrice, b.`name` AS bname, b.cname AS bcname, b.uid AS buid, m.display_cylinder AS display_cylinder, c.`type` AS carType, avg(c.finalPrice) AS avgPrice FROM (`model_info` m) JOIN `carBrand_hk` b ON `b`.`uid`=`m`.`brand_uid` JOIN `car` c ON `m`.`uid` = `c`.`model_info_uid` WHERE `m`.`hk` = 'Y' AND c.lastUpdate>DATE_ADD(curdate(), INTERVAL -1 YEAR) AND `c`.`finalPrice` > 500 AND `c`.`src_valid` = 'Y' GROUP BY `m`.`uid`, `c`.`manuYear`, `m`.`display_cylinder` having (total > 5) ORDER BY `model`, `manuYear`, `avgPrice`, `bname`, `display_cylinder` desc, `total` desc LIMIT 30
Filename: /var/www/www.328car.com/public_html/controllers/usedCarPrice.php
Line Number: 3864