this is sqlselect * from abstractproduct a, specification s where a.abstractproduct_id=s.product_id and 1 AND upper(a.brand_name) = 'ASUS' order by a.abstractproduct_id desc
Updated On:7-March-2021
ASUS is leading mobile manufacturing company. We have listed all the ASUS mobile phones availble on online with all the upcomping mobiles in this page.
Asus Mobiles price list | Price |
---|---|
Asus Zenfone Max Pro M1 | 7999.000 |
Asus ZenFone Max Pro M2 | 9999.000 |
Asus ZenFone Max M2 | 7999.000 |
Asus Zenfone Go (3rd Gen) | 6110.000 |
Asus Zenfone 3 Deluxe | 50999.000 |
Asus Zenfone 3 Ma | 6999.000 |
Asus Zenfone Go 5.5 | 6499.000 |
Asus ZenFone 5Z | 24999.000 |
Asus ZenFone Max M1 | 6999.000 |