SELECT new_idFROM news,categories_multiWHERE categories_multi.lang_id = 1 AND cat_id = new_category AND cat_type = 'video' AND cat_id = 343 AND new_active = 1