select id from where lcase(lang)='en'
|1. Fitting/ Threaded||Fitting|
|1. Outer/ Inner||Inner|
|1. Metrical / Imperial||Imperial|
|2. Fitting/ Threaded||Threaded|
|2. Outer/ Inner||Outer|
|2. Thread type||BSPP|
|2. Metrical / Imperial||Imperial|