Clarkson/flyway/sql/V1.6__Create_Procedure_User_GetByUsername.sql

DELIMITER $$

CREATE PROCEDURE `User_GetByUsername`
(
    in_username VARCHAR(100)
)
BEGIN

    SELECT
        U.`id`,
        U.`email`,
        U.`username`,
        U.`password`,
        U.`admin`,
        U.`fuelUnit`            AS `fuelUnitId`,
        FU.`unit` 		        AS `fuelUnit`,
        FU.`unitName` 	        AS `fuelUnitName`,
        U.`distanceUnit`        AS `distanceUnitId`,
        DU.`unit` 		        AS `distanceUnit`,
        DU.`unitName` 	        AS `distanceUnitName`,
        U.`fuelConsumptionUnit` AS `fuelConsumptionUnitId`,
        FCU.`unit` 		        AS `fuelConsumptionUnit`,
        FCU.`unitName`          AS `fuelConsumptionUnitName`,
        U.`currencyUnit`        AS `currencyUnitId`,
        CU.`unit`               AS `currencyUnit`,
        CU.`unitName`           AS `currencyUnitName`,
        CU.`symbol`             AS `currencyUnitSymbol`
    FROM
        `Users` U
    INNER JOIN
        `DistanceUnits` DU ON U.`distanceUnit` = DU.`id`
    INNER JOIN
        `FuelUnits` FU ON U.`fuelUnit` = FU.`id`
    INNER JOIN
        `FuelConsumptionUnits` FCU ON U.`fuelConsumptionUnit` = FCU.`id`
    INNER JOIN
        `CurrencyUnits` CU ON U.`currencyUnit` = CU.`id`
    WHERE
        U.`username` = in_username;

END$$