SELECT 
  com.company, 
  ccb.company_id, 
  GROUP_CONCAT(
    ccb.certificate_id 
    ORDER BY 
      ccb.position
  ) as certificate_ids 
FROM 
  cscart_companies AS com 
  LEFT JOIN cscart_company_certificate_badges AS ccb ON ccb.company_id = com.company_id 
WHERE 
  ccb.company_id = 98

Query time 0.00038

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}

Result

company company_id certificate_ids