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

    Products number

    6 mm Inner - 3/4" Inner fitting, BSPP FLAT Brass insert

    6 mm Inner - 3/4" Inner fitting, BSPP FLAT

    8 mm Inner - 1/4" Inner fitting, BSPP FLAT

    8 mm Inner - 5/8" Inner fitting, BSPP FLAT

    8 mm Inner - 3/4" Inner fitting, BSPP FLAT Brass insert

    10 mm Inner - 1/4" Inner fitting, BSPP FLAT

    10 mm Inner - 1/2" Inner fitting, BSPP FLAT

    10 mm Inner - 5/8" Inner fitting, BSPP FLAT

    10 mm Inner - 3/4" Inner fitting, BSPP FLAT Brass insert

    10 mm Inner - 3/4" Inner fitting, BSPP FLAT

    12 mm Inner - 3/8" Inner fitting, BSPP FLAT

    12 mm Inner - 1/2" Inner fitting, BSPP FLAT

    12 mm Inner - 5/8" Inner fitting, BSPP FLAT

    12 mm Inner - 3/4" Inner fitting, BSPP FLAT

    15 mm Inner - 1/2" Inner fitting, BSPP FLAT

    15 mm Inner - 3/4" Inner fitting, BSPP FLAT

    16 mm Inner - 1/2" Inner fitting, BSPP FLAT

    16 mm Inner - 3/4" Inner fitting, BSPP FLAT

    22 mm Inner - 3/4" Inner fitting, BSPP FLAT

      Products number