SELECT SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS im.invid,im.image_name,im.title_long,im.sku,im.manfid,im.configid,im.refurb,im.price,im.qty,,im.freeship, im.weight,im.productid,im.content_override,,im.catid_goo,im.thumb_date,im.mainImageUrl,im.mainProdUrl FROM inventory_master im INNER JOIN inventory_categories_incl_spex icl ON (icl.invid=im.invid) WHERE AND im.qty>0 AND ((im.price BETWEEN 0.01 AND 1000000)) AND im.manfid IN ( 89 ) AND icl.catlvl='1' ORDER BY CASE WHEN im.onlyvendor = 1 THEN 1000-im.qty WHEN im.rank > 0 THEN 1000+im.rank WHEN im.price > 0 THEN 1001000-im.qty END ASC LIMIT 0,15 Search Results -

Email Required

Please enter a valid email address to continue to the checkout page
 this data will only be used to send order confirmation and tracking

  • Shop
  • Price
  •  Filter ( by price, brand, + )


    Showing 1 - 2 of 2

    ┬ęCopyright 1996-2016
    Atlanta Network Technologies, Inc is not responsible for typographical or photographical errors.
    Prices and specifications are subject to change without notice.