SELECT 
						
				training_solution_category_partner.ID as categoryPartnerID,
				training_solution_category_partner.webDir2 as partner_webDir2,
				training_solution_category_partner.description as partner_description,
				training_solution_category_partner.item as categoryPartner,
				training_solution_category_partner.item_fr as categoryPartner_fr,
				training_solution_category_partner.orderIndex as partnerOrderIndex     from training_solution_category_partner   WHERE   training_solution_category_partner.webDir2 = 'vmware'