问不忽略MySQL行

EN

SELECT nvdtechnical.TECH_Value_Float FROM nvdtechnical 
 WHERE TECH_TechCode = '11' 
 AND nvdtechnical.TECH_Id = capder.cder_ID
 **AND nvdtechnical.TECH_Value_Float > 30** 
 LIMIT 1

SELECT *
FROM (
SELECT *, (SELECT PR_Basic + PR_VAT + PR_Delivery FROM nvdprices 
WHERE PR_Id = capder.cder_ID ORDER BY PR_EffectiveTo ASC LIMIT 1) as P11D,

(SELECT nvdtechnical.TECH_Value_Float FROM nvdtechnical 
 WHERE TECH_TechCode = '11' 
 AND nvdtechnical.TECH_Id = capder.cder_ID
 AND nvdtechnical.TECH_Value_Float > 30
 LIMIT 1) as **MPG_VALUE**

from capmod 

JOIN capder ON capder.cder_modcode = capmod.cmod_code 
JOIN caprange ON capder.cder_rancode = caprange.cran_code 
JOIN capman ON caprange.cran_mantextcode = capman.cman_code 
JOIN nvdmodelyear ON capder.cder_ID = MY_Id 

AND nvdmodelyear.MY_EffectiveTo = '0000-00-00 00:00:00' 

JOIN nvdtechnical ON nvdtechnical.TECH_Id = capder.cder_ID
JOIN nvddictionarytechnical ON nvddictionarytechnical.DT_TechCode = nvdtechnical.TECH_TechCode
JOIN nvddictionarycategory ON nvddictionarycategory.DC_CatCode = nvddictionarytechnical.DT_CatCode

AND nvddictionarycategory.DC_CatCode=4 
AND nvddictionarytechnical.DT_TechCode = 67
AND nvdtechnical.TECH_Value_Float >= '255' 

JOIN capfueltype ON capfueltype.cft_code = capder.cder_fueltype 
JOIN nvdbodystyle ON capmod.cmod_bodystyle = nvdbodystyle.bs_code 

WHERE caprange.cran_mantextcode='140' 
AND caprange.cran_code='522' 
AND capder.cder_fueltype='P' 
AND capder.cder_transmission='A' 
AND nvdbodystyle.bs_code='3' 
AND (cmod_discontinued=0 OR cmod_discontinued=2015) 
AND capman.cman_code IN ('1','140','164') 
AND caprange.cran_code IN ('924','126','147','955','965','661') 

ORDER BY P11D, capman.cman_name ASC, caprange.cran_name, capmod.cmod_name 
) x
WHERE x.MPG_VALUE IS NOT NULL;

SELECT *, (SELECT PR_Basic + PR_VAT + PR_Delivery FROM nvdprices 
WHERE PR_Id = capder.cder_ID ORDER BY PR_EffectiveTo ASC LIMIT 1) as P11D,
MPG_VALUE.TECH_Id
from capmod
JOIN capder ON capder.cder_modcode = capmod.cmod_code 
JOIN caprange ON capder.cder_rancode = caprange.cran_code 
JOIN capman ON caprange.cran_mantextcode = capman.cman_code 
JOIN nvdmodelyear ON capder.cder_ID = MY_Id 
AND nvdmodelyear.MY_EffectiveTo = '0000-00-00 00:00:00' 
JOIN nvdtechnical ON nvdtechnical.TECH_Id = capder.cder_ID
JOIN nvddictionarytechnical ON nvddictionarytechnical.DT_TechCode = nvdtechnical.TECH_TechCode
JOIN nvddictionarycategory ON nvddictionarycategory.DC_CatCode = nvddictionarytechnical.DT_CatCode
AND nvddictionarycategory.DC_CatCode=4 
AND nvddictionarytechnical.DT_TechCode = 67
AND nvdtechnical.TECH_Value_Float >= '255' 
JOIN capfueltype ON capfueltype.cft_code = capder.cder_fueltype 
JOIN nvdbodystyle ON capmod.cmod_bodystyle = nvdbodystyle.bs_code 
INNER JOIN 
(
    SELECT TECH_Value_Float,TECH_Id
    FROM nvdtechnical 
    WHERE TECH_TechCode = '11' 
    AND TECH_Value_Float > 30
) MPG_VALUE
ON MPG_VALUE.TECH_Id = capder.cder_ID
WHERE caprange.cran_mantextcode='140' 
AND caprange.cran_code='522' 
AND capder.cder_fueltype='P' 
AND capder.cder_transmission='A' 
AND nvdbodystyle.bs_code='3' 
AND (cmod_discontinued=0 OR cmod_discontinued=2015) 
AND capman.cman_code IN ('1','140','164') 
AND caprange.cran_code IN ('924','126','147','955','965','661') 
ORDER BY P11D, capman.cman_name ASC, caprange.cran_name, capmod.cmod_name;