- "SELECT id, name, title, duration, user_id, views, thumbs_count,
- default_thumb, (views + likes - dislikes) AS score
- FROM `videos`
- WHERE category_id = ?
+ "SELECT v.id, name, title, duration, user_id, u.username, views,
+ thumbs_count, default_thumb,
+ (views + likes - dislikes) AS score
+ FROM `videos` v, `users` u
+ WHERE v.user_id = u.id AND $cond_category AND $cond_user