The query seem ok.
Can you test the following query?
select SKU,PRODUCTNAME,PRODUCTVARIANT from tbl_product where SKU in ('ewew','slk')
The query should produce three rows. If it still two that mean that could be data issue on the tbl_product table. It could be extra space on the SKU or something.
If the query return 3 rows that could signal that the splitstring function might be an issue.