Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ms_courses.courses_id,
- ms_courses.courses_hash,
- ms_courses.courses_title,
- ms_courses.courses_tags,
- ms_courses.courses_descr,
- ms_courses.courses_metrics,
- ms_courses.courses_player,
- ms_courses.courses_creation_date,
- ms_courses.courses_update_date,
- b.name,
- c.name,
- ms_courses_metrics.*,
- ms_courses_players.players_title,
- ms_courses_players.players_thumbnail
- FROM
- ms_courses, ms_courses_metrics, ms_courses_players
- JOIN ms_users as b ON ms_courses.courses_creation_user = b.user_id,
- JOIN ms_users as c ON ms_courses.courses_update_user = c.user_id
- WHERE
- (ms_courses.courses_metrics = ms_courses_metrics.metrics_id) AND
- (ms_courses_players.players_id = ms_courses.courses_player) AND
- (MD5(ms_courses.courses_owner) = 'a3d1ewr3238a0b923820dcc509a6f75849b')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement