SELECT new_id FROM news,categories_multi WHERE categories_multi.lang_id = 1 AND cat_id = new_category AND cat_type = 'video' AND cat_id = 343 AND new_active = 1