AephiaRQ - Ship parts
    Updated 5 hours ago
    WITH ship_parts (symbol, class, power_core_tier, shield_gen_tier, hull_rein_tier, warp_drive_tier, sub_engine_tier, man_thrust_tier, heat_sink_tier, scanner_array_tier, tractor_beam_tier) AS (
    SELECT 'FBLAIR', 1, 2, 2, 2, 2, 3, 2, 2, 1, 1
    UNION ALL
    SELECT 'OPALJ', 1, 2, 2, 2, 3, 3, 2, 2, 1, 1
    UNION ALL
    SELECT 'VZUSSO', 1, 1, 1, 3, 2, 2, 2, 2, 2, 1
    UNION ALL
    SELECT 'OGKARU', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0
    UNION ALL
    SELECT 'FBLEUN', 1, 2, 3, 3, 3, 3, 3, 2, 3, 2
    UNION ALL
    SELECT 'PX4', 1, 1, 1, 2, 3, 2, 2, 2, 2, 1
    UNION ALL
    SELECT 'OPALJJ', 2, 3, 3, 3, 3, 3, 3, 3, 3, 2
    UNION ALL
    SELECT 'FBLLOW', 2, 1, 1, 1, 1, 1, 1, 1, 1, 1
    UNION ALL
    SELECT 'PX5', 2, 1, 1, 1, 2, 1, 1, 1, 1, 1
    UNION ALL
    SELECT 'OGKANR', 2, 1, 1, 1, 1, 1, 2, 1, 1, 1
    UNION ALL
    SELECT 'CALSCD', 2, 1, 1, 1, 1, 1, 1, 2, 1, 1
    UNION ALL
    SELECT 'CALMAX', 2, 1, 1, 1, 1, 1, 1, 2, 1, 1
    UNION ALL
    SELECT 'VZUSAM', 3, 1, 1, 3, 2, 2, 2, 3, 2, 1
    UNION ALL
    SELECT 'CHI', 3, 1, 1, 2, 2, 1, 1, 2, 1, 1
    UNION ALL
    SELECT 'FBLBEA', 3, 1, 1, 1, 1, 2, 1, 1, 1, 1
    UNION ALL
    SELECT 'TUFAFE', 3, 1, 1, 2, 1, 2, 1, 1, 1, 1
    UNION ALL
    SELECT 'CALMED', 3, 1, 1, 1, 1, 1, 1, 2, 1, 1
    UNION ALL
    SELECT 'OGKAMK', 3, 1, 1, 1, 1, 1, 2, 1, 1, 1
    Last run: about 5 hours ago
    SYMBOL
    CLASS
    POWER_CORE_TIER
    SHIELD_GEN_TIER
    HULL_REIN_TIER
    WARP_DRIVE_TIER
    SUB_ENGINE_TIER
    MAN_THRUST_TIER
    HEAT_SINK_TIER
    SCANNER_ARRAY_TIER
    TRACTOR_BEAM_TIER
    1
    FBLAIR1222232211
    2
    OPALJ1222332211
    3
    VZUSSO1113222221
    4
    OGKARU1000000000
    5
    FBLEUN1233333232
    6
    PX41112322221
    7
    OPALJJ2333333332
    8
    FBLLOW2111111111
    9
    PX52111211111
    10
    OGKANR2111112111
    11
    CALSCD2111111211
    12
    CALMAX2111111211
    13
    VZUSAM3113222321
    14
    CHI3112211211
    15
    FBLBEA3111121111
    16
    TUFAFE3112121111
    17
    CALMED3111111211
    18
    OGKAMK3111112111
    19
    PR63112321121
    20
    THRILL3111111211
    59
    2KB
    1s