Course Technology

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 (10917, 10918, 8581, 8582, 8584, 8585, 8586, 9406, 9407, 9408, 9410, 9413, 9414, 9415, 9416, 9418, 9419, 9420, 9421, 9423, 9424, 9425, 852, 17591, 19610, 15809, 15810, 16248, 16523, 16528)) 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,10917,10918,8581,8582,8584,8585,8586,9406,9407,9408,9410,9413,9414,9415,9416,9418,9419,9420,9421,9423,9424,9425,852,17591,19610,15809,15810,16248,16523,16528)
View as Grid List

Items 1-30 of 45

Page
per page
Set Ascending Direction
  1. SKU: COU-00009
    Model: 1435460287
    Condition: New-In-Box
  2. Course Technology David Busch's Nikon D5100 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00009F
    Model: 1435460850
    Condition: New-In-Box
  3. Course Technology Photocine: Digital Filmmaking with DSLRs
    USD $26.97
    Out of stock
    SKU: COU-00008E
    Model: 1435457362
    Condition: New-In-Box
  4. Course Technology David Busch's Compact Field Guide for the Canon EOS 7D
    USD $12.59
    Out of stock
    SKU: COU-00008H
    Model: 1435458789
    Condition: New-In-Box
  5. Course Technology David Busch's Compact Field Guide for the Canon EOS 60D
    USD $26.97
    Out of stock
    SKU: COU-00008P
    Model: 1435459380
    Condition: New-In-Box
  6. Course Technology David Busch's Nikon D7000 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00008S
    Model: 1435459427
    Condition: New-In-Box
  7. SKU: COU-00008V
    Model: 1435459441
    Condition: New-In-Box
  8. Course Technology Best Business Practices for Photographers, 2nd Edition
    USD $31.49
    Out of stock
    SKU: COU-00002
    Model: 1435454294
    Condition: New-In-Box
  9. SKU: COU-00002G
    Model: 1435454330
    Condition: New-In-Box
  10. Course Technology David Busch's Nikon D3s/D3x Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00003
    Model: 1435454347
    Condition: New-In-Box
  11. Course Technology David Busch's Canon EOS 7D Guide to Digital Photography
    USD $26.97
    Out of stock
    SKU: COU-00008
    Model: 1435456914
    Condition: New-In-Box
  12. Course Technology Mastering Digital Nude Photography
    USD $35.97
    Out of stock
    SKU: COU-00060
    Model: 1598630261
    Condition: New-In-Box
  13. Course Technology David Busch's Quick Snap Guide to Photo Gear
    USD $26.97
    Out of stock
    SKU: COU-00100
    Model: 1598634542
    Condition: New-In-Box
  14. SKU: COU-00105
    Model: 1598635298
    Condition: New-In-Box
  15. Course Technology David Busch's Nikon D300 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00110
    Model: 1598635344
    Condition: New-In-Box
  16. Course Technology David Busch's Quick Snap Guide To Lighting
    USD $26.97
    Out of stock
    SKU: COU-00115
    Model: 1598635484
    Condition: New-In-Box
  17. Course Technology Digital Sports Photography, 2nd Edition
    USD $31.47
    Out of stock
    SKU: COU-00120
    Model: 1598635697
    Condition: New-In-Box
  18. Course Technology David Busch's Nikon D60 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00125
    Model: 1598635778
    Condition: New-In-Box
  19. Course Technology David Busch's Nikon D90 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00128
    Model: 1598639056
    Condition: New-In-Box
  20. Course Technology David Busch's Canon EOS 50D Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00135
    Model: 1598639048
    Condition: New-In-Box
  21. Course Technology David Busch's Compact Field Guide for the Nikon D7000
    USD $26.97
    Out of stock
    SKU: COU-00140
    Model: 1598639927
    Condition: New-In-Box
  22. Course Technology Irreverent Photo Tools for Digital Photographers
    USD $26.97
    Out of stock
    SKU: COU-00150
    Model: 1598639951
    Condition: New-In-Box
  23. David Busch's Nikon D300S Guide to Digital SLR Photography
    Course Technology David Busch's Nikon D300S Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00005
    Model: 1435456319
    Condition: New-In-Box
  24. Course Technology David Busch's Olympus OM-D E-M5 Guide to Digital Photography
    USD $26.97
    Out of stock
    SKU: COU-00174
    Model: 9781285429960
    Condition: New-In-Box
  25. Course Technology David Busch's Nikon D810 Guide to Digital SLR Photography
    USD $39.97
    Out of stock
    SKU: COU-00176
    Model: 9781305577275
    Condition: New-In-Box
  26. Course Technology David Busch's Nikon D5200 Guide to Digital SLR Photography
    USD $28.97
    Out of stock
    SKU: COU-00161
    Model: 9781285759838
    Condition: New-In-Box
  27. Course Technology David Busch's Nikon D4 Guide to Digital SLR Photography
    USD $26.97
    Out of stock
    SKU: COU-00162
    Model: 9781285084589
    Condition: New-In-Box
  28. Course Technology David Busch's Compact Field Guide for the Nikon D3200
    USD $12.59
    Out of stock
    SKU: COU-00151
    Model: 9781285424606
    Condition: New-In-Box
  29. Course Technology David Busch's Compact Field Guide for the Nikon D5200
    USD $12.59
    Out of stock
    SKU: COU-00163
    Model: 9781285759876
    Condition: New-In-Box
  30. SKU: COU-00164
    Model: 1285422732
    Condition: New-In-Box
View as Grid List

Items 1-30 of 45

Page
per page
Set Ascending Direction