beowulf1416

Untitled

Jun 29th, 2015
312
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.62 KB | None | 0 0
  1. mysql> select
  2. -> su.id,
  3. -> su.title,
  4. -> su.email,
  5. -> surb.broadcast_id,
  6. -> dgb.title
  7. -> from sys_user su
  8. -> inner join sys_user_resource_broadcast surb on su.id = surb.user_id
  9. -> inner join data_group_broadcast dgb on surb.broadcast_id = dgb.id
  10. -> where su.email in ('[email protected]','[email protected]');
  11. +---------+---------------------+---------------------------------------+--------------+---------------------------+
  12. | id | title | email | broadcast_id | title |
  13. +---------+---------------------+---------------------------------------+--------------+---------------------------+
  14. | 1112541 | ALFREDO CASTRO | [email protected] | 1112307 | Victor Tolul - Motivacion |
  15. | 1112538 | Victor Tolul - Live | [email protected] | 1112481 | Victor Tulol - Roca |
  16. +---------+---------------------+---------------------------------------+--------------+---------------------------+
  17.  
  18. before:
  19. mysql> select id,title,broadcast_id from data_content where id = 11762;
  20. +-------+-------------+--------------+
  21. | id | title | broadcast_id |
  22. +-------+-------------+--------------+
  23. | 11762 | ROCA STEREO | 1110948 |
  24. +-------+-------------+--------------+
  25.  
  26. after:
  27. mysql> select id,title,broadcast_id from data_content where id = 11762;
  28. +-------+-------------+--------------+
  29. | id | title | broadcast_id |
  30. +-------+-------------+--------------+
  31. | 11762 | ROCA STEREO | 1112481 |
  32. +-------+-------------+--------------+
Advertisement
Add Comment
Please, Sign In to add comment