Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select
- -> su.id,
- -> su.title,
- -> su.email,
- -> surb.broadcast_id,
- -> dgb.title
- -> from sys_user su
- -> inner join sys_user_resource_broadcast surb on su.id = surb.user_id
- -> inner join data_group_broadcast dgb on surb.broadcast_id = dgb.id
- -> where su.email in ('[email protected]','[email protected]');
- +---------+---------------------+---------------------------------------+--------------+---------------------------+
- | id | title | email | broadcast_id | title |
- +---------+---------------------+---------------------------------------+--------------+---------------------------+
- | 1112541 | ALFREDO CASTRO | [email protected] | 1112307 | Victor Tolul - Motivacion |
- | 1112538 | Victor Tolul - Live | [email protected] | 1112481 | Victor Tulol - Roca |
- +---------+---------------------+---------------------------------------+--------------+---------------------------+
- before:
- mysql> select id,title,broadcast_id from data_content where id = 11762;
- +-------+-------------+--------------+
- | id | title | broadcast_id |
- +-------+-------------+--------------+
- | 11762 | ROCA STEREO | 1110948 |
- +-------+-------------+--------------+
- after:
- mysql> select id,title,broadcast_id from data_content where id = 11762;
- +-------+-------------+--------------+
- | id | title | broadcast_id |
- +-------+-------------+--------------+
- | 11762 | ROCA STEREO | 1112481 |
- +-------+-------------+--------------+
Advertisement
Add Comment
Please, Sign In to add comment