select u.id,eb.caption AS "brands_name",t.start_at,t.end_at FROM users u
LEFT JOIN transactions t
 ON u.id=t.user_id
 LEFT JOIN leads_relations lr
 ON u.id=lr.user_id
 LEFT JOIN leads l
 ON lr.lead_id=l.id
 LEFT JOIN editions e
    ON e.id = t.resource_id
  LEFT JOIN transactions_invoice ti
   ON ti.transaction_id = t.id
  LEFT JOIN editions_universal eu
   ON eu.id = ti.journal_id 
 LEFT JOIN complects_for_universal AS cm
   ON cm.id = t.resource_id
 lEFT JOIN editions_brands AS eb
   ON eb.id =e.brand_id
WHERE t.content_type_id IN(1)
AND t.status_id = 2 AND t.sum<>0
    AND t.end_at>='2017-01-01' AND t.end_at<'2018-01-01'
    AND NOT EXISTS (SELECT id FROM transactions t1 WHERE t1.user_id = u.id AND t1.status_id = 2 AND t1.end_at >= '2018-01-01' AND t1.content_type_id IN (1))
   AND u.id=t.user_id
AND t.resource_id IN(7,16,22,23,24,28,29,30,31,37,39,40)

SELECT u.id,eb.caption AS "brands_name",t.start_at,t.end_at FROM users u
  LEFT JOIN transactions t
  ON u.id=t.user_id
   LEFT JOIN leads_relations lr
  ON u.id=lr.user_id
  LEFT JOIN leads l
  ON lr.lead_id=l.id
  LEFT JOIN editions e
    ON e.id = t.resource_id
   LEFT JOIN transactions_invoice ti
    ON ti.transaction_id = t.id
   LEFT JOIN editions_universal eu
    ON eu.id = ti.journal_id
  LEFT JOIN complects_for_universal AS cm
    ON cm.id = t.resource_id
  lEFT JOIN editions_brands AS eb
    ON eb.id =e.brand_id
    WHERE t.end_at>=NOW() AND t.start_at<NOW()
    AND t.resource_id IN(7,16,22,23,24,28,29,30,31,37,39,40)
 AND t.content_type_id in(1) AND t.status_id IN(2) AND t.sum<>0