CREATE VIEW `concept_view` AS
  SELECT
    `openmrs`.`concept`.`concept_id`              AS `concept_id`,
    `concept_full_name`.`name`                    AS `concept_full_name`,
    `concept_short_name`.`name`                   AS `concept_short_name`,
    `openmrs`.`concept_class`.`name`              AS `concept_class_name`,
    `openmrs`.`concept_datatype`.`name`           AS `concept_datatype_name`,
    `openmrs`.`concept`.`retired`                 AS `retired`,
    `openmrs`.`concept_description`.`description` AS `description`,
    `openmrs`.`concept`.`date_created`            AS `date_created`
  FROM (((((`openmrs`.`concept`
    LEFT JOIN `openmrs`.`concept_name` `concept_full_name` ON ((
      (`concept_full_name`.`concept_id` = `openmrs`.`concept`.`concept_id`) AND
      (`concept_full_name`.`concept_name_type` = 'FULLY_SPECIFIED') AND (`concept_full_name`.`locale` = 'en') AND
      (`concept_full_name`.`voided` = 0)))) LEFT JOIN `openmrs`.`concept_name` `concept_short_name` ON ((
    (`concept_short_name`.`concept_id` = `openmrs`.`concept`.`concept_id`) AND
    (`concept_short_name`.`concept_name_type` = 'SHORT') AND (`concept_short_name`.`locale` = 'en') AND
    (`concept_short_name`.`voided` = 0)))) LEFT JOIN `openmrs`.`concept_class`
      ON ((`openmrs`.`concept_class`.`concept_class_id` = `openmrs`.`concept`.`class_id`))) LEFT JOIN
    `openmrs`.`concept_datatype`
      ON ((`openmrs`.`concept_datatype`.`concept_datatype_id` = `openmrs`.`concept`.`datatype_id`))) LEFT JOIN
    `openmrs`.`concept_description`
      ON ((`openmrs`.`concept_description`.`concept_id` = `openmrs`.`concept`.`concept_id`)))