신차장기 견적받기

mode : slave
timeUse : 0.00085186958312988
memoryUse : 424, total : 3,091,480
error : Unknown column 'this.statCode' in 'where clause'(1054)
query : /* m.helphouse.co.kr/ 2022-10-04 09:55:57 */ SELECT * , `idx` AS `idxModel` , (SELECT `title` FROM `nTreeCarMaker` AS `this` WHERE `this`.`idx` = `nTreeCarModel`.`idxMaker`) AS `maker` , (SELECT `icon` FROM `nTreeCarMaker` AS `this` WHERE `this`.`idx` = `nTreeCarModel`.`idxMaker`) AS `makerIcon` , (SELECT `title` FROM `nTreeCarName` AS `this` WHERE `this`.`idx` = `nTreeCarModel`.`idxName`) AS `name` , `title` AS `model` , `modelLunchY` , `modelLunchM` , (   (SELECT COUNT(*) FROM `nTreeCarMark` AS `this` WHERE `this`.`statCode` = 'normal' AND `this`.`markSaleYN` = 'Y' AND `this`.`idxModel` = `nTreeCarModel`.`idx`)  ) AS `cntMarkSale` , (   (SELECT COUNT(*) FROM `nTreeCarMark` AS `this` WHERE `this`.`statCode` = 'normal' AND `this`.`markFastYN` = 'Y' AND `this`.`idxModel` = `nTreeCarModel`.`idx`)  ) AS `cntMarkFast` , (   (SELECT COUNT(*) FROM `nTreeCarMark` AS `this` WHERE `this`.`statCode` = 'normal' AND `this`.`markPopularYN` = 'Y' AND `this`.`idxModel` = `nTreeCarModel`.`idx`)  ) AS `cntMarkPopular` , (SELECT MIN(`trimPrice`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `trimPriceMin` , (SELECT MIN(`trimPrice`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`) AS `trimPriceMax` , (SELECT GROUP_CONCAT(DISTINCT `trimEngineFuelCode` SEPARATOR '|') FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `trimEngineFuelCodeStr` , (SELECT MIN(`trimEngineEff`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `trimEngineEffMin` , (SELECT MAX(`trimEngineEff`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `trimEngineEffMax` , (SELECT MIN(`trimEngineSize`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimEngineSize` > 0  ) AS `trimEngineSizeMin` , (SELECT MAX(`trimEngineSize`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimEngineSize` > 0  ) AS `trimEngineSizeMax` , (SELECT MIN(`trimPrice`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimPrice` > 0  ) AS `trimPriceMax` , (SELECT GROUP_CONCAT(DISTINCT `trimEngineFuelCode` SEPARATOR '|') FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimEngineFuelCode` != ''  ) AS `trimEngineFuelCodeStr` , (SELECT MIN(`trimEngineEff`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimEngineEff` > 0  ) AS `trimEngineEffMin` , (SELECT MAX(`trimEngineEff`) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  AND `this`.`trimEngineEff` > 0  ) AS `trimEngineEffMax` , (SELECT GROUP_CONCAT(`idx` ORDER BY `priceMonth` ASC) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) AS `priceIdxStr` , (SELECT GROUP_CONCAT(DISTINCT `idxGrade` ORDER BY `priceMonth` ASC) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) AS `priceIdxGradeStr` , (SELECT GROUP_CONCAT(DISTINCT `idxTrim` ORDER BY `priceMonth` ASC) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) AS `priceIdxTrimStr` , (SELECT MIN(`priceMonth`) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) AS `priceMonthMin` , (SELECT MAX(`priceMonth`) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) AS `priceMonthMax` , (SELECT GROUP_CONCAT(`title` SEPARATOR '|') FROM `nTreeCarOption` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `optionTitleStr` , (SELECT GROUP_CONCAT(`idx` SEPARATOR '|') FROM `nTreeCarOption` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) AS `optionIdxStr` FROM `nTreeCarModel` WHERE (SELECT COUNT(*) FROM `nTreeCarTrim` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`  ) >= '1' AND (SELECT COUNT(*) FROM `nTreeCarPrice` AS `this`  WHERE `this`.`idxMaker` = `nTreeCarModel`.`idxMaker` AND `this`.`idxName` = `nTreeCarModel`.`idxName` AND `this`.`idxModel` = `nTreeCarModel`.`idx`    AND `this`.`priceMonth` > 0) >= '1' ORDER BY `idx`  ASC LIMIT 0, 20