Partner Leiloeiros

SELECT * FROM objects o inner join object2language o2l on o.id_object=o2l.id_object WHERE o.type='2' and o.operation_type='3' and status in (1) and promo in (0) and o2l.id_language='1' ORDER BY o.dt_end_trim desc