筛选具有多个条件的EAV表

经过几个小时的合并和尝试，我终于做到了：

    SELECt * FROM objects as oINNER JOIN     attributes AS f1         ON     o.object_id = f1.attr_object_id         AND     f1.attr_property_id = 1        AND    f1.attr_value <= '100000'INNER JOIN     attributes AS f2         ON     f1.attr_object_id = f2.attr_object_id         AND     f2.attr_property_id = 2        AND    f2.attr_value > '2000'WHERe     o.object_group_id = 1

我太接近了，因此将所有过滤条件都移至

INNER JOIN