SELECT * from listinoen where sku in (select sku from categorie where cat_en ='planetary with encoder') order by sku asc