Facebook
From Vitalik, 3 Years ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 47
  1. SELECT deals.id AS crm_id,
  2. users.name,
  3. payments.created_at,
  4. affiliate_sites.foreign_id AS site_id,
  5. countries.name,
  6. affiliate.foreign_id AS aff_id,
  7. deal_buying_smm_stats.reach AS reach_per_post,
  8. deal_buying_smm_stats.count AS number_of_position,
  9. deal_buying_smm_stats.link AS link,
  10. wallet_types.name AS walletn_name,
  11. wallets.value AS wallet_number,
  12. payments.summary AS summary,
  13. currencies.name AS currency,
  14. deal_buying_smm_stats.comment AS site_overview_comment,
  15. deal_places.comment AS deal_place_comment,
  16. payments.status
  17.  
  18. FROM payments
  19.  
  20. LEFT JOIN deals ON deals.id = payments.deal_id
  21. LEFT JOIN users ON deals.manager_id = users.id
  22. LEFT JOIN deal_places ON deal_places.deal_id = deals.id
  23. LEFT JOIN partners ON deals.partner_id = partners.id
  24. LEFT JOIN affiliate ON partners.id = affiliate.our_id
  25. LEFT JOIN deal_buying_smm_stats ON deal_buying_smm_stats.deal_id = deals.id
  26. LEFT JOIN wallets ON payments.wallet_id = wallets.id
  27. LEFT JOIN wallet_types ON wallet_types.id = wallets.wallet_type_id
  28. LEFT JOIN currencies ON currencies.id = wallets.currency_id
  29. LEFT JOIN countries ON countries.id = deal_places.country_id
  30. LEFT JOIN affiliate_sites ON affiliate_sites.id = deal_places.site_id
  31.  
  32. WHERE payments.created_at BETWEEN '2019-12-01 00:00:00.000000' AND '2019-12-27 00:00:00.000000' AND deals.team_id = 1 AND payments.status LIKE 'done'