I am selecting order data from my orders table with that i also need the order product's count which contain specific word

Account TopUp 200,
Account TopUp 500,
Account TopUp 1000,

The order contain multipal product means one order contain both(Account TopUp 200, Account TopUp 500) and other products

I made subquery for this

            (
                    SELECT COUNT(orderprodid)
                    FROM order_products
                    WHERE orderorderid=orderid AND ordprodname like '