SELECT c.video_id FROM videos_categories c INNER JOIN videos_tags t1 ON t1.video_id=c.video_id AND t1.tag_id=206 INNER JOIN videos_tags t2 ON t2.video_id=c.video_id AND t2.tag_id=9 WHERE c.category_id=? ORDER BY c.sort_relevant,c.video_id LIMIT 0,24