this is sqlselect * from abstractproduct a, specification s where a.abstractproduct_id=s.product_id and 1 AND upper(a.brand_name) = 'LG' order by a.abstractproduct_id desc
LG is south courian multination company manufactures Television, Refridgerator and mobile phones . LG comes with good design and high end specifications from mid to high range.
|LG Mobiles price list||Price|
|LG V40 ThinQ||44490.000|