SELECT categoriesID,category AS english,categories.french,types.typesID,type,photo,categories.description,categories.description_source_URL FROM categories,types WHERE category='Subject Pronouns' AND categories.typesID=types.typesID