select rank_id,companyname,magazine_id,companyid,category from companies where visited_company=1 and (company_name_url='transwarp' or companyname='transwarp') order by CHAR_LENGTH(substring(companydesc,400,10)) desc,companyname asc limit 1
  • 1 Transwarp | Top Big Data Solution Company in APAC-2021