SELECT C_OUTER.* , B.md_name AS brand, M.md_name AS model, LM.md_name AS low_model, G.md_name AS grade, LG.md_name AS low_grade FROM ( SELECT C.* FROM `inko_car_data_sample` AS C WHERE C.cd_state = 1 and C.cd_m_date_yyyy >= '2006' and C.cd_mileage >= '300' and C.cd_price >= '300' AND (C.cd_kind='중형차')
AND EXISTS (
SELECT 1
FROM inko_area A
WHERE A.ad_sido <> '' AND A.ad_gugun <> ''
AND A.ad_sido = C.cd_sido
AND A.ad_gugun = C.cd_gugun
)
AND C.`idx` >= '0' ORDER BY idx DESC LIMIT 20 ) AS C_OUTER JOIN `inko_model_data` AS B ON B.md_gubun = C_OUTER.cd_gubun AND B.md_brand = C_OUTER.cd_brand AND B.md_model = 0 AND B.md_submodel = 0 AND B.md_level = 0 AND B.md_sublevel = 0 JOIN `inko_model_data` AS M ON M.md_gubun = C_OUTER.cd_gubun AND M.md_brand = C_OUTER.cd_brand AND M.md_model = C_OUTER.cd_model AND M.md_submodel = 0 AND M.md_level = 0 AND M.md_sublevel = 0 JOIN `inko_model_data` AS LM ON LM.md_gubun = C_OUTER.cd_gubun AND LM.md_brand = C_OUTER.cd_brand AND LM.md_model = C_OUTER.cd_model AND LM.md_submodel = C_OUTER.cd_submodel AND LM.md_level = 0 AND LM.md_sublevel = 0 JOIN `inko_model_data` AS G ON G.md_gubun = C_OUTER.cd_gubun AND G.md_brand = C_OUTER.cd_brand AND G.md_model = C_OUTER.cd_model AND G.md_submodel = C_OUTER.cd_submodel AND G.md_level = C_OUTER.cd_level AND G.md_sublevel = 0 JOIN `inko_model_data` AS LG ON LG.md_gubun = C_OUTER.cd_gubun AND LG.md_brand = C_OUTER.cd_brand AND LG.md_model = C_OUTER.cd_model AND LG.md_submodel = C_OUTER.cd_submodel AND LG.md_level = C_OUTER.cd_level AND LG.md_sublevel = C_OUTER.cd_sublevel
