Educational DVDs

Educational DVDs
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 (3244, 3245, 3246, 3247, 3248, 3249, 3250, 3251, 3252, 12182, 12183, 12184, 12185, 12186, 12187, 12188, 12189, 12190, 12191, 12192, 12193, 12194, 12195, 12196, 12197, 12198, 12199, 12200, 12201, 12202)) 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,3244,3245,3246,3247,3248,3249,3250,3251,3252,12182,12183,12184,12185,12186,12187,12188,12189,12190,12191,12192,12193,12194,12195,12196,12197,12198,12199,12200,12201,12202)
View as Grid List

Items 1-30 of 49

Page
per page
Set Ascending Direction
  1. Introduction to the Olympus E-300 EVOLT (DVD)
    Blue Crane Digital Introduction to the Olympus E-300 EVOLT (DVD)
    USD $17.97
    Out of stock
    SKU: OMB-00025
    Model: BC104
    Condition: New-In-Box
  2. Blue Crane Digital Introduction to the Nikon D200 (DVD)
    USD $17.97
    Out of stock
    SKU: OMB-00035
    Model: BC106
    Condition: New-In-Box
  3. Blue Crane Digital Introduction to the Nikon D80 (DVD)
    USD $29.99
    Out of stock
    SKU: OMB-00055
    Model: BC111
    Condition: New-In-Box
  4. Blue Crane Digital DVD Intro To Nikon D300/D300S/D700
    USD $17.97
    Out of stock
    SKU: OMB-00097E
    Model: BC128
    Condition: New-In-Box
  5. SKU: OMB-00097J
    Model: BC131
    Condition: New-In-Box
  6. Understanding the Canon Speedlite 580EX II / 430EX II Training DV
    SKU: OMB-00107
    Model: BC203
    Condition: New-In-Box
  7. Blue Crane Digital Canon EOS 5D: inBrief
    USD $11.97
    Out of stock
    SKU: OMB-00140
    Model: BC508
    Condition: New-In-Box
  8. Blue Crane Digital Nikon D80: inBrief
    USD $11.97
    Out of stock
    SKU: OMB-00150
    Model: BC511
    Condition: New-In-Box
  9. Blue Crane Digital Nikon D40/D40x: inBrief
    USD $11.97
    Out of stock
    SKU: OMB-00160
    Model: BC513
    Condition: New-In-Box
  10. Blue Crane Digital Canon 60D Advanced Topics DVD
    USD $29.99
    Out of stock
    SKU: OMB-00098C
    Model: BC142
    Condition: New-In-Box
  11. Blue Crane Digital Introduction to the Canon 5D
    USD $17.97
    Out of stock
    SKU: OMB-00045
    Model: BC108
    Condition: New-In-Box
  12. Blue Crane Digital inBrief Guide to Nikon D90
    USD $11.97
    Out of stock
    SKU: OMB-00181
    Model: BC519
    Condition: New-In-Box
  13. inBrief Guide to Nikon D60
    Blue Crane Digital inBrief Guide to Nikon D60
    USD $12.99
    Out of stock
    SKU: OMB-00175
    Model: BC517
    Condition: New-In-Box
  14. Blue Crane Digital Understanding the Nikon Speedlight: SB-900, SB-800, SB-600
    USD $17.97
    Out of stock
    SKU: OMB-00106
    Model: BC202
    Condition: New-In-Box
  15. inBrief Guide to Canon EOS 30D
    Blue Crane Digital inBrief Guide to Canon EOS 30D
    USD $11.97
    Out of stock
    SKU: OMB-00115
    Model: BC502
    Condition: New-In-Box
  16. Blue Crane Digital Introduction to the Canon Rebel Xsi DVD
    USD $17.97
    Out of stock
    SKU: OMB-00090
    Model: BC118
    Condition: New-In-Box
  17. Introduction to the Nikon D90, Vol. 1: Basic Controls
    Blue Crane Digital Introduction to the Nikon D90, Vol. 1: Basic Controls
    USD $17.97
    Out of stock
    SKU: OMB-00092
    Model: BC119
    Condition: New-In-Box
  18. Blue Crane Digital Introduction to the Nikon D90, Vol. 2: Advanced Topics
    USD $29.99
    Out of stock
    SKU: OMB-00094
    Model: BC120
    Condition: New-In-Box
  19. Introduction to the Canon EOS 5D Mark II and the 50D Volume 2 Advance
    SKU: OMB-00095E
    Model: BC122
    Condition: New-In-Box
  20. Introduction to the Canon 5D Mark II Digital SLR Camera. Volume 1
    SKU: OMB-00096
    Model: BC123
    Condition: New-In-Box
  21. SKU: OMB-00080
    Model: BC116
    Condition: New-In-Box
  22. Blue Crane Digital Introduction to the Nikon D60 DVD
    USD $17.97
    Out of stock
    SKU: OMB-00085
    Model: BC117
    Condition: New-In-Box
  23. Blue Crane Digital Introduction to the Nikon D5000: Volume 1
    USD $17.97
    Out of stock
    SKU: OMB-00097C
    Model: BC126
    Condition: New-In-Box
  24. Introduction to the Canon 7D: Volume 1
    Blue Crane Digital Introduction to the Canon 7D: Volume 1
    USD $17.97
    Out of stock
    SKU: OMB-00097F
    Model: BC129
    Condition: New-In-Box
  25. Introduction to the Canon 7D: Volume 2
    Blue Crane Digital Introduction to the Canon 7D: Volume 2
    USD $17.97
    Out of stock
    SKU: OMB-00097G
    Model: BC130
    Condition: New-In-Box
  26. Blue Crane Digital Introduction to the Canon T2i / 550D: Volume 2
    USD $29.99
    Out of stock
    SKU: OMB-00097L
    Model: BC133
    Condition: New-In-Box
  27. Introduction to the Nikon D3100 DVD
    Blue Crane Digital Introduction to the Nikon D3100 DVD
    USD $17.97
    Out of stock
    SKU: OMB-00097N
    Model: BC135
    Condition: New-In-Box
  28. Blue Crane Digital Through The Eyes of A Pro: Nikon, Volume 1
    USD $29.99
    Out of stock
    SKU: OMB-00311
    Model: BC311
    Condition: New-In-Box
  29. Blue Crane Digital Through The Eyes of A Pro: Nikon, Volume 2
    USD $29.99
    Out of stock
    SKU: OMB-00312
    Model: BC312
    Condition: New-In-Box
  30. Blue Crane Digital Introduction to the Canon Digital Rebel XTi / 400D DVD
    USD $17.97
    Out of stock
    SKU: OMB-00060
    Model: BC112
    Condition: New-In-Box
View as Grid List

Items 1-30 of 49

Page
per page
Set Ascending Direction