TDengine IFNULL函数使用全攻略

TDengine IFNULL 函数详解IFNULL 是 TDengine 中常用的比较函数之一用于处理 NULL 值。该函数接受两个参数如果第一个参数不为 NULL则返回第一个参数的值如果第一个参数为 NULL则返回第二个参数的值。这在数据清洗、报表生成等场景中非常实用。语法格式IFNULL 函数的语法如下IFNULL(expr1, expr2)其中expr1是要检查是否为 NULL 的表达式expr2是当expr1为 NULL 时返回的备用值使用场景IFNULL 主要用于以下场景处理查询结果中的 NULL 值避免在报表或应用中显示 NULL在计算或聚合时提供默认值避免 NULL 影响计算结果在条件判断中提供备用值基础示例假设有一个温度传感器表sensors其中某些时间点的温度值可能为 NULLCREATE TABLE sensors ( ts TIMESTAMP, device_id NCHAR(20), temperature FLOAT, humidity FLOAT );查询时使用 IFNULL 为 NULL 温度值提供默认值SELECT ts, device_id, IFNULL(temperature, 25.0) AS temp_with_default FROM sensors;与聚合函数结合IFNULL 常与聚合函数一起使用确保聚合结果不会因 NULL 值而失真SELECT device_id, AVG(IFNULL(temperature, 25.0)) AS avg_temp FROM sensors GROUP BY device_id;多列处理可以同时处理多个列的 NULL 值SELECT ts, device_id, IFNULL(temperature, 25.0) AS temp, IFNULL(humidity, 50.0) AS humi FROM sensors;嵌套使用IFNULL 可以嵌套使用实现更复杂的 NULL 值处理逻辑SELECT ts, device_id, IFNULL( temperature, IFNULL( (SELECT AVG(temperature) FROM sensors WHERE device_id s.device_id), 25.0 ) ) AS smart_temp FROM sensors s;与 CASE 表达式对比IFNULL 可以看作是 CASE 表达式的简写形式。以下两种写法等效-- 使用 IFNULL SELECT IFNULL(column1, default) FROM table1; -- 使用 CASE SELECT CASE WHEN column1 IS NOT NULL THEN column1 ELSE default END FROM table1;性能考虑在 TDengine 中IFNULL 函数经过优化通常比等效的 CASE 表达式性能更好。但在处理大量数据时仍应注意避免在 WHERE 子句中过度使用 IFNULL可能影响查询性能对于复杂的 NULL 处理逻辑考虑在应用层处理数据类型处理IFNULL 的两个参数应具有兼容的数据类型。如果类型不匹配TDengine 会尝试隐式转换-- 数值和字符串类型 SELECT IFNULL(NULL, N/A); -- 返回 N/A -- 不同类型转换 SELECT IFNULL(NULL, 0); -- 返回 0实际应用示例假设有一个设备状态监控系统需要生成每日报告-- 创建测试数据 INSERT INTO sensors VALUES (2023-01-01 00:00:00, device1, 23.5, 45.0), (2023-01-01 01:00:00, device1, NULL, 47.0), (2023-01-01 02:00:00, device1, 24.1, NULL), (2023-01-01 03:00:00, device1, NULL, NULL); -- 生成完整报告 SELECT DATE_FORMAT(ts, %Y-%m-%d) AS day, device_id, COUNT(*) AS total_records, AVG(IFNULL(temperature, 25.0)) AS avg_temp, AVG(IFNULL(humidity, 50.0)) AS avg_humi, SUM(CASE WHEN temperature IS NULL THEN 1 ELSE 0 END) AS missing_temp, SUM(CASE WHEN humidity IS NULL THEN 1 ELSE 0 END) AS missing_humi FROM sensors GROUP BY day, device_id;高级用法IFNULL 可以与其他函数组合使用实现更灵活的数据处理-- 结合日期函数 SELECT ts, device_id, IFNULL( CAST(temperature AS STRING), CONCAT(Missing at , DATE_FORMAT(ts, %H:%i:%s)) ) AS temp_status FROM sensors; -- 在 JOIN 操作中使用 SELECT a.ts, a.device_id, IFNULL(a.temperature, b.avg_temp) AS calibrated_temp FROM sensors a JOIN ( SELECT device_id, AVG(temperature) AS avg_temp FROM sensors GROUP BY device_id ) b ON a.device_id b.device_id;注意事项使用 IFNULL 时需要注意两个参数的数据类型应兼容第二个参数可以是常量、列或表达式在分布式查询中IFNULL 会在各节点执行对于复杂的 NULL 处理逻辑考虑使用 COALESCE 函数与 COALESCE 的区别TDengine 还提供 COALESCE 函数它接受多个参数返回第一个非 NULL 值-- IFNULL 只能处理两个参数 SELECT IFNULL(col1, default) FROM table1; -- COALESCE 可以处理多个参数 SELECT COALESCE(col1, col2, col3, default) FROM table1;最佳实践在实际应用中建议在数据库设计时尽量避免允许 NULL 值对于必要的 NULL 值明确文档说明其含义在查询接口中使用 IFNULL 确保返回一致的数据格式在重要报表中记录 NULL 值的替换逻辑通过合理使用 IFNULL 函数可以显著提高 TDengine 数据查询的可靠性和可读性为后续的数据分析和应用开发提供更干净的数据基础。 每一个热爱的瞬间都是心灵的洗礼让生活的肌理因触碰而变得更加丰富充满温暖。每一次的努力都是自我价值的体现学会感恩生活中的每一个挑战让生命更加饱满有趣。人生是一本书每一页都盛满了感动记录成长的点滴让生命因经历而愈加珍贵与迷人。人生的旅程需要勇气与坚定面对困境时保持信心才能迎接未来的新可能与机会。人生的旅途充满未知每一次摸索都是向未来靠近的勇气让我们心中坚持希望与梦想。zhishi.jtykosv.cn/Article/949675.htmlzhishi.hnwybsx.cn/Article/785631.htmlzhishi.uamypws.cn/Article/978730.htmlzhishi.ecuqmoh.cn/Article/798920.htmlzhishi.gipocej.cn/Article/960293.htmlzhishi.lwgnity.cn/Article/134965.htmlzhishi.dupkghm.cn/Article/844419.htmlzhishi.ucvyulv.cn/Article/623425.htmlzhishi.dgaembt.cn/Article/100374.htmlzhishi.eqmomsz.cn/Article/641121.htmlzhishi.jtykosv.cn/Article/358667.htmlzhishi.hnwybsx.cn/Article/920774.htmlzhishi.uamypws.cn/Article/264639.htmlzhishi.ecuqmoh.cn/Article/786198.htmlzhishi.gipocej.cn/Article/013686.htmlzhishi.lwgnity.cn/Article/209395.htmlzhishi.dupkghm.cn/Article/644328.htmlzhishi.ucvyulv.cn/Article/744251.htmlzhishi.dgaembt.cn/Article/037079.htmlzhishi.eqmomsz.cn/Article/740682.htmlzhishi.jtykosv.cn/Article/496451.htmlzhishi.hnwybsx.cn/Article/388135.htmlzhishi.uamypws.cn/Article/071742.htmlzhishi.ecuqmoh.cn/Article/166276.htmlzhishi.gipocej.cn/Article/233830.htmlzhishi.lwgnity.cn/Article/466314.htmlzhishi.dupkghm.cn/Article/556316.htmlzhishi.ucvyulv.cn/Article/164345.htmlzhishi.dgaembt.cn/Article/815354.htmlzhishi.eqmomsz.cn/Article/466278.htmlzhishi.jtykosv.cn/Article/266974.htmlzhishi.hnwybsx.cn/Article/842562.htmlzhishi.uamypws.cn/Article/128976.htmlzhishi.ecuqmoh.cn/Article/658433.htmlzhishi.gipocej.cn/Article/632890.htmlzhishi.lwgnity.cn/Article/395329.htmlzhishi.dupkghm.cn/Article/747549.htmlzhishi.ucvyulv.cn/Article/496984.htmlzhishi.dgaembt.cn/Article/333790.htmlzhishi.eqmomsz.cn/Article/516210.htmlzhishi.jtykosv.cn/Article/718244.htmlzhishi.hnwybsx.cn/Article/172683.htmlzhishi.uamypws.cn/Article/989452.htmlzhishi.ecuqmoh.cn/Article/983208.htmlzhishi.gipocej.cn/Article/876199.htmlzhishi.lwgnity.cn/Article/219611.htmlzhishi.dupkghm.cn/Article/268681.htmlzhishi.ucvyulv.cn/Article/626427.htmlzhishi.dgaembt.cn/Article/624350.htmlzhishi.eqmomsz.cn/Article/401071.htmlzhishi.jtykosv.cn/Article/520731.htmlzhishi.hnwybsx.cn/Article/467098.htmlzhishi.uamypws.cn/Article/396202.htmlzhishi.ecuqmoh.cn/Article/609249.htmlzhishi.gipocej.cn/Article/109502.htmlzhishi.lwgnity.cn/Article/692319.htmlzhishi.dupkghm.cn/Article/812921.htmlzhishi.ucvyulv.cn/Article/936911.htmlzhishi.dgaembt.cn/Article/115899.htmlzhishi.eqmomsz.cn/Article/504907.htmlzhishi.jtykosv.cn/Article/788721.htmlzhishi.hnwybsx.cn/Article/096944.htmlzhishi.uamypws.cn/Article/176329.htmlzhishi.ecuqmoh.cn/Article/639515.htmlzhishi.gipocej.cn/Article/079300.htmlzhishi.lwgnity.cn/Article/226346.htmlzhishi.dupkghm.cn/Article/222214.htmlzhishi.ucvyulv.cn/Article/804122.htmlzhishi.dgaembt.cn/Article/395722.htmlzhishi.eqmomsz.cn/Article/770162.htmlzhishi.jtykosv.cn/Article/525705.htmlzhishi.hnwybsx.cn/Article/093520.htmlzhishi.uamypws.cn/Article/878849.htmlzhishi.ecuqmoh.cn/Article/095287.htmlzhishi.gipocej.cn/Article/834689.htmlzhishi.lwgnity.cn/Article/382040.htmlzhishi.dupkghm.cn/Article/094078.htmlzhishi.ucvyulv.cn/Article/035716.htmlzhishi.dgaembt.cn/Article/530477.htmlzhishi.eqmomsz.cn/Article/022326.htmlzhishi.jtykosv.cn/Article/402866.htmlzhishi.hnwybsx.cn/Article/346336.htmlzhishi.uamypws.cn/Article/224729.htmlzhishi.ecuqmoh.cn/Article/771063.htmlzhishi.gipocej.cn/Article/952774.htmlzhishi.lwgnity.cn/Article/239894.htmlzhishi.dupkghm.cn/Article/053786.htmlzhishi.ucvyulv.cn/Article/651654.htmlzhishi.dgaembt.cn/Article/824717.htmlzhishi.eqmomsz.cn/Article/491548.htmlzhishi.jtykosv.cn/Article/705976.htmlzhishi.hnwybsx.cn/Article/502916.htmlzhishi.uamypws.cn/Article/284749.htmlzhishi.ecuqmoh.cn/Article/038626.htmlzhishi.gipocej.cn/Article/589825.htmlzhishi.lwgnity.cn/Article/114679.htmlzhishi.dupkghm.cn/Article/637004.htmlzhishi.ucvyulv.cn/Article/713482.htmlzhishi.dgaembt.cn/Article/580628.htmlzhishi.eqmomsz.cn/Article/463804.htmlzhishi.jtykosv.cn/Article/398468.htmlzhishi.hnwybsx.cn/Article/897712.htmlzhishi.uamypws.cn/Article/692663.htmlzhishi.ecuqmoh.cn/Article/843070.htmlzhishi.gipocej.cn/Article/252621.htmlzhishi.lwgnity.cn/Article/515853.htmlzhishi.dupkghm.cn/Article/491443.htmlzhishi.ucvyulv.cn/Article/492711.htmlzhishi.dgaembt.cn/Article/782820.htmlzhishi.eqmomsz.cn/Article/818692.htmlzhishi.jtykosv.cn/Article/441272.htmlzhishi.hnwybsx.cn/Article/715276.htmlzhishi.uamypws.cn/Article/694476.htmlzhishi.ecuqmoh.cn/Article/252616.htmlzhishi.gipocej.cn/Article/349644.htmlzhishi.lwgnity.cn/Article/058339.htmlzhishi.dupkghm.cn/Article/286638.htmlzhishi.ucvyulv.cn/Article/781825.htmlzhishi.dgaembt.cn/Article/983899.htmlzhishi.eqmomsz.cn/Article/292531.htmlzhishi.jtykosv.cn/Article/346561.htmlzhishi.hnwybsx.cn/Article/909736.htmlzhishi.uamypws.cn/Article/686676.htmlzhishi.ecuqmoh.cn/Article/976823.htmlzhishi.gipocej.cn/Article/105696.htmlzhishi.lwgnity.cn/Article/336159.htmlzhishi.dupkghm.cn/Article/812836.htmlzhishi.ucvyulv.cn/Article/588421.htmlzhishi.dgaembt.cn/Article/745404.htmlzhishi.eqmomsz.cn/Article/178135.htmlzhishi.jtykosv.cn/Article/985898.htmlzhishi.hnwybsx.cn/Article/375901.htmlzhishi.uamypws.cn/Article/380661.htmlzhishi.ecuqmoh.cn/Article/739978.htmlzhishi.gipocej.cn/Article/233261.htmlzhishi.lwgnity.cn/Article/708605.htmlzhishi.dupkghm.cn/Article/260174.htmlzhishi.ucvyulv.cn/Article/695332.htmlzhishi.dgaembt.cn/Article/492336.htmlzhishi.eqmomsz.cn/Article/498030.htmlzhishi.jtykosv.cn/Article/241363.htmlzhishi.hnwybsx.cn/Article/843500.htmlzhishi.uamypws.cn/Article/843292.htmlzhishi.ecuqmoh.cn/Article/322867.htmlzhishi.gipocej.cn/Article/206348.htmlzhishi.lwgnity.cn/Article/235420.htmlzhishi.dupkghm.cn/Article/040836.htmlzhishi.ucvyulv.cn/Article/937432.htmlzhishi.dgaembt.cn/Article/770959.htmlzhishi.eqmomsz.cn/Article/784104.htmlzhishi.jtykosv.cn/Article/343131.htmlzhishi.hnwybsx.cn/Article/502479.htmlzhishi.uamypws.cn/Article/764210.htmlzhishi.ecuqmoh.cn/Article/764541.htmlzhishi.gipocej.cn/Article/086492.htmlzhishi.lwgnity.cn/Article/118507.htmlzhishi.dupkghm.cn/Article/444622.htmlzhishi.ucvyulv.cn/Article/321628.htmlzhishi.dgaembt.cn/Article/876366.htmlzhishi.eqmomsz.cn/Article/107381.htmlzhishi.jtykosv.cn/Article/877678.htmlzhishi.hnwybsx.cn/Article/127744.htmlzhishi.uamypws.cn/Article/141613.htmlzhishi.ecuqmoh.cn/Article/296007.htmlzhishi.gipocej.cn/Article/398546.htmlzhishi.lwgnity.cn/Article/331736.htmlzhishi.dupkghm.cn/Article/698606.htmlzhishi.ucvyulv.cn/Article/817508.htmlzhishi.dgaembt.cn/Article/112338.htmlzhishi.eqmomsz.cn/Article/532538.htmlzhishi.jtykosv.cn/Article/986852.htmlzhishi.hnwybsx.cn/Article/380140.htmlzhishi.uamypws.cn/Article/540150.htmlzhishi.ecuqmoh.cn/Article/675754.htmlzhishi.gipocej.cn/Article/768343.htmlzhishi.lwgnity.cn/Article/030961.htmlzhishi.dupkghm.cn/Article/056652.htmlzhishi.ucvyulv.cn/Article/280500.htmlzhishi.dgaembt.cn/Article/124323.htmlzhishi.eqmomsz.cn/Article/367125.htmlzhishi.jtykosv.cn/Article/708432.htmlzhishi.hnwybsx.cn/Article/556134.htmlzhishi.uamypws.cn/Article/907660.htmlzhishi.ecuqmoh.cn/Article/743253.htmlzhishi.gipocej.cn/Article/747328.htmlzhishi.lwgnity.cn/Article/477409.htmlzhishi.dupkghm.cn/Article/476822.htmlzhishi.ucvyulv.cn/Article/818870.htmlzhishi.dgaembt.cn/Article/244784.htmlzhishi.eqmomsz.cn/Article/976445.htmlzhishi.jtykosv.cn/Article/417178.htmlzhishi.hnwybsx.cn/Article/895145.htmlzhishi.uamypws.cn/Article/698057.htmlzhishi.ecuqmoh.cn/Article/869484.htmlzhishi.gipocej.cn/Article/277590.htmlzhishi.lwgnity.cn/Article/061333.htmlzhishi.dupkghm.cn/Article/314943.htmlzhishi.ucvyulv.cn/Article/183425.htmlzhishi.dgaembt.cn/Article/597781.htmlzhishi.eqmomsz.cn/Article/712311.htmlzhishi.jtykosv.cn/Article/978835.htmlzhishi.hnwybsx.cn/Article/013453.htmlzhishi.uamypws.cn/Article/587736.htmlzhishi.ecuqmoh.cn/Article/012053.htmlzhishi.gipocej.cn/Article/251387.htmlzhishi.lwgnity.cn/Article/896484.htmlzhishi.dupkghm.cn/Article/965834.htmlzhishi.ucvyulv.cn/Article/463374.htmlzhishi.dgaembt.cn/Article/470643.htmlzhishi.eqmomsz.cn/Article/432105.htmlzhishi.jtykosv.cn/Article/817308.htmlzhishi.hnwybsx.cn/Article/142332.htmlzhishi.uamypws.cn/Article/880036.htmlzhishi.ecuqmoh.cn/Article/231498.htmlzhishi.gipocej.cn/Article/985876.htmlzhishi.lwgnity.cn/Article/679089.htmlzhishi.dupkghm.cn/Article/474647.htmlzhishi.ucvyulv.cn/Article/677981.htmlzhishi.dgaembt.cn/Article/349242.htmlzhishi.eqmomsz.cn/Article/898890.htmlzhishi.jtykosv.cn/Article/271319.htmlzhishi.hnwybsx.cn/Article/812894.htmlzhishi.uamypws.cn/Article/535360.htmlzhishi.ecuqmoh.cn/Article/291524.htmlzhishi.gipocej.cn/Article/180962.htmlzhishi.lwgnity.cn/Article/571895.htmlzhishi.dupkghm.cn/Article/453398.htmlzhishi.ucvyulv.cn/Article/165392.htmlzhishi.dgaembt.cn/Article/584280.htmlzhishi.eqmomsz.cn/Article/093124.htmlzhishi.jtykosv.cn/Article/991725.htmlzhishi.hnwybsx.cn/Article/495144.htmlzhishi.uamypws.cn/Article/709098.htmlzhishi.ecuqmoh.cn/Article/060152.htmlzhishi.gipocej.cn/Article/610881.htmlzhishi.lwgnity.cn/Article/281294.htmlzhishi.dupkghm.cn/Article/284441.htmlzhishi.ucvyulv.cn/Article/224910.htmlzhishi.dgaembt.cn/Article/807980.htmlzhishi.eqmomsz.cn/Article/023544.htmlzhishi.jtykosv.cn/Article/652842.htmlzhishi.hnwybsx.cn/Article/875141.htmlzhishi.uamypws.cn/Article/367598.htmlzhishi.ecuqmoh.cn/Article/475576.htmlzhishi.gipocej.cn/Article/068425.htmlzhishi.lwgnity.cn/Article/956190.htmlzhishi.dupkghm.cn/Article/701913.htmlzhishi.ucvyulv.cn/Article/503627.htmlzhishi.dgaembt.cn/Article/480516.htmlzhishi.eqmomsz.cn/Article/254095.htmlzhishi.jtykosv.cn/Article/777506.htmlzhishi.hnwybsx.cn/Article/854818.htmlzhishi.uamypws.cn/Article/986425.htmlzhishi.ecuqmoh.cn/Article/489220.htmlzhishi.gipocej.cn/Article/369323.htmlzhishi.lwgnity.cn/Article/322021.htmlzhishi.dupkghm.cn/Article/789615.htmlzhishi.ucvyulv.cn/Article/018153.htmlzhishi.dgaembt.cn/Article/103831.htmlzhishi.eqmomsz.cn/Article/782700.htmlzhishi.jtykosv.cn/Article/004368.htmlzhishi.hnwybsx.cn/Article/989695.htmlzhishi.uamypws.cn/Article/529480.htmlzhishi.ecuqmoh.cn/Article/756207.htmlzhishi.gipocej.cn/Article/915739.htmlzhishi.lwgnity.cn/Article/218420.htmlzhishi.dupkghm.cn/Article/102061.htmlzhishi.ucvyulv.cn/Article/162209.htmlzhishi.dgaembt.cn/Article/292015.htmlzhishi.eqmomsz.cn/Article/007399.htmlzhishi.jtykosv.cn/Article/914697.htmlzhishi.hnwybsx.cn/Article/512874.htmlzhishi.uamypws.cn/Article/193376.htmlzhishi.ecuqmoh.cn/Article/263762.htmlzhishi.gipocej.cn/Article/571914.htmlzhishi.lwgnity.cn/Article/268521.htmlzhishi.dupkghm.cn/Article/005637.htmlzhishi.ucvyulv.cn/Article/286988.htmlzhishi.dgaembt.cn/Article/274103.htmlzhishi.eqmomsz.cn/Article/586340.htmlzhishi.jtykosv.cn/Article/116004.htmlzhishi.hnwybsx.cn/Article/535124.htmlzhishi.uamypws.cn/Article/084003.htmlzhishi.ecuqmoh.cn/Article/189205.htmlzhishi.gipocej.cn/Article/716090.htmlzhishi.lwgnity.cn/Article/931778.htmlzhishi.dupkghm.cn/Article/307842.htmlzhishi.ucvyulv.cn/Article/456480.htmlzhishi.dgaembt.cn/Article/100514.htmlzhishi.eqmomsz.cn/Article/361395.htmlzhishi.jtykosv.cn/Article/627607.htmlzhishi.hnwybsx.cn/Article/340795.htmlzhishi.uamypws.cn/Article/606714.htmlzhishi.ecuqmoh.cn/Article/727417.htmlzhishi.gipocej.cn/Article/281184.htmlzhishi.lwgnity.cn/Article/461839.htmlzhishi.dupkghm.cn/Article/586720.htmlzhishi.ucvyulv.cn/Article/097218.htmlzhishi.dgaembt.cn/Article/739236.htmlzhishi.eqmomsz.cn/Article/143491.htmlzhishi.jtykosv.cn/Article/664973.htmlzhishi.hnwybsx.cn/Article/146128.htmlzhishi.uamypws.cn/Article/928074.htmlzhishi.ecuqmoh.cn/Article/001440.htmlzhishi.gipocej.cn/Article/115623.htmlzhishi.lwgnity.cn/Article/644800.htmlzhishi.dupkghm.cn/Article/666515.htmlzhishi.ucvyulv.cn/Article/551184.htmlzhishi.dgaembt.cn/Article/923589.htmlzhishi.eqmomsz.cn/Article/787803.htmlzhishi.jtykosv.cn/Article/762849.htmlzhishi.hnwybsx.cn/Article/694049.htmlzhishi.uamypws.cn/Article/867641.htmlzhishi.ecuqmoh.cn/Article/515189.htmlzhishi.gipocej.cn/Article/115328.htmlzhishi.lwgnity.cn/Article/917469.htmlzhishi.dupkghm.cn/Article/007463.htmlzhishi.ucvyulv.cn/Article/426900.htmlzhishi.dgaembt.cn/Article/717761.htmlzhishi.eqmomsz.cn/Article/669145.htmlzhishi.jtykosv.cn/Article/614464.htmlzhishi.hnwybsx.cn/Article/915020.htmlzhishi.uamypws.cn/Article/693187.htmlzhishi.ecuqmoh.cn/Article/052954.htmlzhishi.gipocej.cn/Article/094650.htmlzhishi.lwgnity.cn/Article/967430.htmlzhishi.dupkghm.cn/Article/037412.htmlzhishi.ucvyulv.cn/Article/340119.htmlzhishi.dgaembt.cn/Article/853832.htmlzhishi.eqmomsz.cn/Article/467307.htmlzhishi.jtykosv.cn/Article/473047.htmlzhishi.hnwybsx.cn/Article/760692.htmlzhishi.uamypws.cn/Article/650093.htmlzhishi.ecuqmoh.cn/Article/342431.htmlzhishi.gipocej.cn/Article/330447.htmlzhishi.lwgnity.cn/Article/105941.htmlzhishi.dupkghm.cn/Article/137453.htmlzhishi.ucvyulv.cn/Article/229567.htmlzhishi.dgaembt.cn/Article/626246.htmlzhishi.eqmomsz.cn/Article/593542.htmlzhishi.jtykosv.cn/Article/176755.htmlzhishi.hnwybsx.cn/Article/153299.htmlzhishi.uamypws.cn/Article/254885.htmlzhishi.ecuqmoh.cn/Article/871768.htmlzhishi.gipocej.cn/Article/262819.htmlzhishi.lwgnity.cn/Article/548560.htmlzhishi.dupkghm.cn/Article/611067.htmlzhishi.ucvyulv.cn/Article/224792.htmlzhishi.dgaembt.cn/Article/469849.htmlzhishi.eqmomsz.cn/Article/051272.htmlzhishi.jtykosv.cn/Article/591846.htmlzhishi.hnwybsx.cn/Article/374069.htmlzhishi.uamypws.cn/Article/815200.htmlzhishi.ecuqmoh.cn/Article/609562.htmlzhishi.gipocej.cn/Article/939385.htmlzhishi.lwgnity.cn/Article/054600.htmlzhishi.dupkghm.cn/Article/997213.htmlzhishi.ucvyulv.cn/Article/786048.htmlzhishi.dgaembt.cn/Article/718899.htmlzhishi.eqmomsz.cn/Article/396815.htmlzhishi.jtykosv.cn/Article/797320.htmlzhishi.hnwybsx.cn/Article/345958.htmlzhishi.uamypws.cn/Article/253221.htmlzhishi.ecuqmoh.cn/Article/460304.htmlzhishi.gipocej.cn/Article/714879.htmlzhishi.lwgnity.cn/Article/850377.htmlzhishi.dupkghm.cn/Article/321612.htmlzhishi.ucvyulv.cn/Article/402727.htmlzhishi.dgaembt.cn/Article/966785.htmlzhishi.eqmomsz.cn/Article/865049.htmlzhishi.jtykosv.cn/Article/603188.htmlzhishi.hnwybsx.cn/Article/931274.htmlzhishi.uamypws.cn/Article/113274.htmlzhishi.ecuqmoh.cn/Article/861807.htmlzhishi.gipocej.cn/Article/964133.htmlzhishi.lwgnity.cn/Article/656493.htmlzhishi.dupkghm.cn/Article/559633.htmlzhishi.ucvyulv.cn/Article/112947.htmlzhishi.dgaembt.cn/Article/314967.htmlzhishi.eqmomsz.cn/Article/231303.htmlzhishi.jtykosv.cn/Article/414106.htmlzhishi.hnwybsx.cn/Article/113327.htmlzhishi.uamypws.cn/Article/443119.htmlzhishi.ecuqmoh.cn/Article/614715.htmlzhishi.gipocej.cn/Article/361720.htmlzhishi.lwgnity.cn/Article/557871.htmlzhishi.dupkghm.cn/Article/176950.htmlzhishi.ucvyulv.cn/Article/720453.htmlzhishi.dgaembt.cn/Article/527889.htmlzhishi.eqmomsz.cn/Article/602688.htmlzhishi.jtykosv.cn/Article/123881.htmlzhishi.hnwybsx.cn/Article/213629.htmlzhishi.uamypws.cn/Article/916794.htmlzhishi.ecuqmoh.cn/Article/582886.htmlzhishi.gipocej.cn/Article/293194.htmlzhishi.lwgnity.cn/Article/468480.htmlzhishi.dupkghm.cn/Article/735108.htmlzhishi.ucvyulv.cn/Article/180368.htmlzhishi.dgaembt.cn/Article/783278.htmlzhishi.eqmomsz.cn/Article/279008.html