select id from where lcase(lang)='en'

    Products number

    Union, L shape, 5/16" Inner - 5/16" Inner fitting

    Union, L shape, 3/8" Inner - 5/16" Inner fitting

    Union, L shape, 3/8" Inner - 3/8" Inner fitting

    Union, Straight, 5/16" Inner - 5/16" Inner fitting

    Union, Straight, 3/8" Inner - 3/8" Inner fitting

    threaded, BSPT, 5/16" Inner - 1/4" Outer fitting

    threaded, MFL, 5/16" Inner - 1/4" Outer fitting

    threaded, MFL, 5/16" Inner - 3/8" Outer fitting

    threaded, BSW, 5/16" Inner - 9/16" Outer fitting

    threaded, BSW, 3/8" Inner - 9/16" Outer fitting

      Products number