valentines day gift guide

Women's Yonex Tennis Shoes


Women's Yonex shoes are leading the way in tennis shoe technology. A new technology from Yonex called Power Cushion actually helps to propel you in whatever direction you're moving. In addition to transforming shock into kinetic energy, Yonex tennis shoes also have a sleekness that no other shoe has. Nearly all shoes in this line sport a lot of color, something vibrant tennis players look for. Get rid of your dirty old loafers and pick out a pair of Women's Yonex shoes.
Filters:
query
RESULTSET
query
  ITEM_QOH LOOKUP NEW_SIZE_NAME QOH SCALE_ENTRY_ID SIZE_ORDER SIZ_ALIAS SKU_ID SPIFF STOCK_NUM
CACHED false
EXECUTIONTIME 0
SQL select distinct(b.siz) as siz_alias,max(f.lookup) as lookup, max(b.siz_alias) as new_size_name, max(e.stock_num) as stock_num,max(b.size_order) as size_order, max(a.sku_id) as sku_id,max(a.scale_entry_id) as scale_entry_id,sum(e.qoh) as qoh, max(e.spiff) as spiff, max(e.qoh) as item_qoh from tb_skus a left join tb_size_entries b on (b.scale_entry_id = a.scale_entry_id) left join tb_sku_buckets e on (e.sku_id = a.sku_id) left join tb_sku_lookups f on (f.sku_id = a.sku_id) where a.style_id=0 and e.store_id=1 and b.siz<>'-----' and b.siz<>'----' and b.siz_alias<>'' and e.stock_num<>'HIDE' group by b.siz order by max(a.scale_entry_id)