Memory

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (78003, 78004, 78005, 81281, 81282, 82770, 84328, 88121, 90342, 17818, 18360, 20439, 100619, 104651, 104652, 105971, 111132, 46484, 57611, 64408, 64415, 65066, 68811, 128197, 128822, 129982, 129983, 131078, 134144, 134145)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,78003,78004,78005,81281,81282,82770,84328,88121,90342,17818,18360,20439,100619,104651,104652,105971,111132,46484,57611,64408,64415,65066,68811,128197,128822,129982,129983,131078,134144,134145)
View as Grid List

Items 61-90 of 292

per page
Set Ascending Direction
  1. Ultimate 1000x CompactFlash (32GB)
    Transcend Ultimate 1000x CompactFlash (32GB)
    USD $48.00
    Out of stock
    SKU: TRA-00126
    Model: TS32GCF1000
    Condition: New-In-Box
  2. Class 10 SDHC (16GB)
    Transcend Class 10 SDHC (16GB)
    USD $9.99
    Out of stock
    SKU: TRA-00140
    Model: TS16GSDHC10
    Condition: New-In-Box
  3. JetFlash 700 USB Flash Drive (8GB)
    Transcend JetFlash 700 USB Flash Drive (8GB)
    USD $9.99
    Out of stock
    SKU: TRA-00211
    Model: TS8GJF700
    Condition: New-In-Box
  4. Cinema CFast 2.0 VPG-130 Memory Card (128GB)
    Delkin Devices Cinema CFast 2.0 VPG-130 Memory Card (128GB)
    USD $194.99
    Out of stock
    SKU: DEL-20010
    Model: DCFSTV128
    Condition: New-In-Box
  5. Cinema CFast 2.0 Memory Card (256GB)
    Delkin Devices Cinema CFast 2.0 Memory Card (256GB)
    USD $329.99
    Out of stock
    SKU: DEL-20011
    Model: DDCFST560256
    Condition: New-In-Box
  6. Atomos Master Caddy HD (1TB)
    G-Technology Atomos Master Caddy HD (1TB)
    USD $99.95
    SKU: GTEC-05218
    Model: 0G05218
    Condition: New-In-Box
  7. Extreme PRO SDHC UHS-I Memory Card (32GB)
    SanDisk Extreme PRO SDHC UHS-I Memory Card (32GB)
    USD $14.97
    Out of stock
    SKU: SAN-02163
    Model: SDSDXXG-032G-ANCIN
    Condition: New-In-Box
  8. Class 4 SDHC Memory Card (8GB)
    SanDisk Class 4 SDHC Memory Card (8GB)
    USD $9.97
    Out of stock
    SKU: SAN-02033
    Model: SDSDB-008G-A46
    Condition: New-In-Box
  9. Ultra Class 10 microSDXC (128GB)
    SanDisk Ultra Class 10 microSDXC (128GB)
    USD $59.97
    Out of stock
    SKU: SAN-02162
    Model: SDSDQUNC128GAN6MA
    Condition: New-In-Box
  10. SDUC Gold Series Ultra High Speed SD Card (64GB)
    Panasonic SDUC Gold Series Ultra High Speed SD Card (64GB)
    USD $139.99
    Out of stock
    SKU: PAN-00024
    Model: RP-SDUC64GAK
    Condition: New-In-Box
  11. Rugged Mini Disk USB 3.0 (2TB)
    LaCie Rugged Mini Disk USB 3.0 (2TB)
    USD $99.99
    Out of stock
    SKU: LAC-9000298-CP
    Model: 9000298
    Condition: New-In-Box
  12. Connect Station CS100
    Canon Connect Station CS100
    USD $299.99
    Out of stock
    SKU: CAN-40010
    Model: 9899B002
    Condition: New-In-Box
  13. Professional 1000x SDXC UHS-II Memory Card - 2 Pack (256GB)
    SKU: LEX-00299A
    Model: LSD256CRBNA10002
    Condition: New-In-Box
  14. Professional USB 3.0 Multi Card Reader
    Promaster Professional USB 3.0 Multi Card Reader
    USD $49.95
    Out of stock
    SKU: PRO-22179
    Model: 8342
    Condition: New-In-Box
  15. SDHC Velocity (32GB)
    Promaster SDHC Velocity (32GB)
    USD $39.95
    Out of stock
    SKU: PRO-27231
    Model: 6508
    Condition: New-In-Box
  16. Cards not included
    Delkin Devices USB 3.0 Dual Slot SD UHS-II & CF Memory Card Reader
    USD $34.99
    SKU: DEL-10019
    Model: DDREADER-44
    Condition: New-In-Box
  17. Extreme Plus C10 SDHC Memory Card (32GB)
    SanDisk Extreme Plus C10 SDHC Memory Card (32GB)
    USD $39.97
    Out of stock
    SKU: SAN-02126B
    Model: SDSDXSF032GANCIN
    Condition: New-In-Box
  18. Professional 2933x XQD 2.0 Card (128GB)
    Lexar Professional 2933x XQD 2.0 Card (128GB)
    USD $159.97
    Out of stock
    SKU: LEX-00368
    Model: LXQD128GCRBNA2933
    Condition: New-In-Box
  19. G-SPEED Shuttle XL (24TB)
    G-Technology G-SPEED Shuttle XL (24TB)
    USD $2,699.95
    SKU: GTEC-04706
    Model: 0G04706
    Condition: New-In-Box
  20. Ultra USB 3.0 Flash Drive (128GB)
    SanDisk Ultra USB 3.0 Flash Drive (128GB)
    USD $34.95
    Out of stock
    SKU: SAN-07202
    Model: SDCZ48-128G-A46
    Condition: New-In-Box
  21. Extreme 900 Portable SSD (480GB)
    SanDisk Extreme 900 Portable SSD (480GB)
    USD $297.99
    Out of stock
    SKU: SAN-20132
    Model: SDSSDEXT-480G-G25
    Condition: New-In-Box
  22. Ultimate Class 10 SDXC (128GB)
    Transcend Ultimate Class 10 SDXC (128GB)
    USD $44.00
    Out of stock
    SKU: TRA-01100
    Model: TS128GSDXC10
    Condition: New-In-Box
  23. Professional 2000x SDHC UHS-II (U3) with Reader (32GB)
    SKU: LEX-01633
    Model: LSD32GCRBNA2000R
    Condition: New-In-Box
  24. Portable Backup and Editing System (128GB)
    GNARBOX Portable Backup and Editing System (128GB)
    USD $279.99
    Out of stock
    SKU: GNAR-00128
    Model: GNAR128V1
    Condition: New-In-Box
  25. SDHC Class 10 Memory Card (8GB)
    Transcend SDHC Class 10 Memory Card (8GB)
    USD $9.97
    Out of stock
    SKU: TRA-00105
    Model: TS8GSDHC10
    Condition: New-In-Box
  26. Cinema CF 1050X UDMA 7 Memory Card (64GB)
    Delkin Devices Cinema CF 1050X UDMA 7 Memory Card (64GB)
    USD $139.99
    Out of stock
    SKU: DEL-20020
    Model: DDCF1050-64GB
    Condition: New-In-Box
  27. Cinema CF 1050X UDMA 7 Memory Card (128GB)
    Delkin Devices Cinema CF 1050X UDMA 7 Memory Card (128GB)
    USD $119.99
    Out of stock
    SKU: DEL-20022
    Model: DDCF1050-128GB
    Condition: New-In-Box
  28. G-SPEED Shuttle XL with ev Series Bay Adapters (18TB)
    G-Technology G-SPEED Shuttle XL with ev Series Bay Adapters (18TB)
    USD $1,999.95
    SKU: GTEC-04702
    Model: 0G04702
    Condition: New-In-Box
  29. USB 3.0 Dual Slot SD UHS-II Card Reader
    Promaster USB 3.0 Dual Slot SD UHS-II Card Reader
    USD $34.95
    SKU: PRO-22180
    Model: 6691
    Condition: New-In-Box
  30. SDHC Velocity CINE (32GB)
    Promaster SDHC Velocity CINE (32GB)
    USD $39.95
    Out of stock
    SKU: PRO-27310
    Model: 7405
    Condition: New-In-Box
View as Grid List

Items 61-90 of 292

per page
Set Ascending Direction