SELECT 
  `ORDER_NO` AS `受注番号`,
  `SLIP_COMMENT` AS `備考`,
  ((length(`SLIP_COMMENT`) - length(replace(`SLIP_COMMENT`, ',', '')) + 1)) AS `カウントした商品数`
FROM `ORDERS` ORDER BY `カウントした商品数` DESC, `ORDER_NO` DESC;