mysql - joining two tables with multiple conditions in rails

Question

I have two tables named lines and attribute_values. From that I want to select the fields name from the lines tables with conditions given in the MySQL query below:

select distinct a.name 
from lines a join attribute_values b 
where a.advertiser_id = 280 
  and a.id = b.line_id 
  and b.name in (11, 18) 
  and b.value != 0;

How do I write this query using Ruby code?

Answer 1

Line.joins("a LEFT JOIN attribute_values b ON a.id = b.line_id").select("DISTINCT(a.name)").where("b.value != ? AND b.name in (?) AND a.advertiser_id = ?", 0, [11, 18], 280)