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