SELECT
    M.modelid
FROM
    dbo.Models AS M INNER JOIN
    dbo.ModelAttributes AS MA
        ON MA.ModelId = M.ModelID
WHERE
    (
     MA.AttributeID = 29 AND
     MA.Value LIKE N'%IL%'
    )AND
    (M.ProductID = 2)
UNION ALL
SELECT
    M.modelid
FROM
    dbo.Models AS M INNER JOIN
    dbo.ModelAttributes AS MA
        ON MA.ModelId = M.ModelID
WHERE
    (
     MA.AttributeID = 7 AND
     (
      CONVERT(DECIMAL(10, 5), MA.Value) >= 0.0360 AND
      CONVERT(DECIMAL(10, 5), MA.Value) <= 0.0840
     )
     ) AND
    (M.ProductID = 2)

SELECT
  M.*, MA.AttributeID, MA.Value
FROM
  dbo.Temp_Models AS M 
  INNER JOIN dbo.Temp_Attributes AS MA
    ON MA.ModelId = M.ModelID
WHERE
  (M.ProductID = 2)

SELECT
   *
FROM
    dbo.Temp_Models AS M INNER JOIN
    dbo.Temp_Attributes AS MA
        ON MA.ModelId = M.ModelID
WHERE
    -- either of thes will work, I prefer in
     MA.AttributeID IN (7, 29) 
     /*
     (
     MA.attributeID = 29 OR
     MA.attributeId = 7
     )
     */
     AND
     (      
     MA.Value LIKE '%IL%' OR
     MA.Value >= 0.03860 AND MA.Value <= 0.0840
     ) AND
     M.ProductID = 2
     
     
SELECT
    *
FROM
    dbo.Temp_Models AS M INNER JOIN
    dbo.Temp_Attributes AS MA
        ON MA.ModelId = M.ModelID
WHERE
    (
     MA.AttributeID = 29 AND
     MA.Value LIKE N'%IL%'
    )AND
    (M.ProductID = 2)
UNION ALL
SELECT
    *
FROM
    dbo.Temp_Models AS M INNER JOIN
    dbo.Temp_Attributes AS MA
        ON MA.ModelId = M.ModelID
WHERE
    (
     MA.AttributeID = 7 AND
     (
      CONVERT(DECIMAL(10, 5), MA.Value) >= 0.0360 AND
      CONVERT(DECIMAL(10, 5), MA.Value) <= 0.0840
     )
     ) AND
    (M.ProductID = 2)